Dictionary/3000 Reference Manual (32244-90001)

Chapter 5 147
Dictionary/3000 Utilities
DICTDBA
DICTDBA
Database Audit Utility
The Database Audit utility (DICTDBA) reports on the usage statistics and checks the
linkages for an IMAGE database. The report can include information on synonyms and
chains for master sets and chain statistics for detail sets. DICTDBA also checks for broken
chains.
This utility provides two reports, one at the terminal and one is also printed on the line
printer. The terminal report is a summary report, while the line printer report includes
more detailed information.
With this utility, a database can be audited for synonym information, for chain information
by search items, or for specific information on chain lengths.
The following description explains how to execute the DICTDBA utility program and gives
an explanation of each prompt.
To execute DICTDBA enter the following MPE command:
RUN DICTDBA.PUB.SYS
After an acknowledgment message, a prompt is issued to determine the type of audit
report to be generated as follows:
RUN MODE(SYNONYMS/CHAINS/LINKS)>
Only one of the following report types can be run each time DICTDBA is executed. The
following is a description of each report:
SYNONYMS the report displayed at the terminal shows the master set's name, the type
of master, the number of entries in the master, the capacity of the master,
and the usage percentage of the master. The line printer report
additionally includes the number of entries with synonyms, and the
shortest and longest synonym chain lengths.
CHAINS the terminal report includes the same information as the SYNONYM
report, plus information on each detail set. The line printer report includes
statistics by search item on the number of chains, the shortest and longest
chain length, and the average chain length. If a broken chain is detected, a
warning is given.
LINKS the terminal report includes the same information as the SYNONYM
report, the CHAINS report, plus more specific information for broken
chains. The line printer report additionally includes information on the
forward and backward read counts for the search item. In this mode the
chain entries are physically read to check the integrity of the chains.
Therefore, this report takes appreciably longer to run in this mode.
Enter the type of report chosen. You may enter either the full name of the report as shown
above or the first letter of the report name. If [[RETURN]] is pressed in response to this
prompt, DICTDBA will terminate.