HP 3000 Manuals HP 3000 Manuals
DICTDBM,UTIL
Dictionary Clean Utility
As a result of continued DICTDBM use, a data Dictionary slowly
accumulates superfluous information. This information can be
periodically purged by using the Dictionary Clean Utility (DICTDBM,UTIL).
This utility, which can only be executed by the Dictionary creator,
should be run when:
* DICTDBM has been used heavily for about 6 months, or
* the following message appears after signing onto DICTDBM:
*INFO: DICTIONARY INTERNAL CLEANUP NEEDED (DICT 75)
To preserve the integrity of your Dictionary, ensure that this utility is
only used on the entire data Dictionary which includes the root file and
all data sets.
Before executing this utility, back up the data Dictionary. Also ensure
that the temporary file used by DICTDBM,UTIL (DICTTEMP) is large enough
to accommodate your data. By default, DICTTEMP holds 10,000 records
(divided into 30 extents). These records originate from three data sets:
DESCRIPTION-TEXT, FILE-PATH, and FILE-SORT. Run DICTDBA to determine the
total number of records in these data sets. If the total is >10,000, use
the FILE command to allocate adequate space as shown below:
:FILE DICTTEMP; DISC = your value.
Execute DICTDBM,UTIL by entering the following MPE command:
:RUN DICTDBM.PUB.SYS,UTIL
The utility issues the following message and prompt:
DICTIONARY SHOULD BE STORED OFF BEFORE RUNNING THIS UTILITY.
CONTINUE (Y/N)?>
Enter Y (to initiate cleanup) or N (to terminate utility execution).
When the utility has finished processing, the message END OF PROGRAM is
displayed and the program terminates.
Example
:RUN DICTDBM.PUB.SYS, UTIL How to execute this utility.
<The Dictionary/3000 Clean program banner appears here.>
DICTIONARY SHOULD BE STORED OFF BEFORE RUNNING THIS UTILITY.
CONTINUE (Y/N)?> Y Must respond "Y" or "N";
: no default response occurs.
END OF PROGRAM