Dictionary/3000 Reference Manual (32244-90001)

172 Chapter5
Dictionary/3000 Utilities
DICTDBM,UTIL
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