HP 3000 Manuals HP 3000 Manuals
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 acknowledgement 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.
The following prompts are then issued to identify the database to be
audited:
BASE>
BASE PASSWORD>
MODE>
Enter the name of the database in response to the BASE prompt, and enter
a password that grants read access to the entire database in response to
the PASSWORD prompt. If an incorrect password is entered, the prompt is
reissued. Pressing [[RETURN]] in response to the prompt for BASE
terminates the utility.
Enter the access mode to be used to open and read the database in
response to the MODE prompt. If [[RETURN]] is pressed in response to
this prompt, the database will be accessed in the default mode, which is
5. (See the IMAGE Reference Manual for details on "Access Modes" .)
Note that when DICTDBA is run, the database will be locked on the data
set level, unless the database is opened in modes 3, 7, 8.
DICTDBA will then begin to execute the report.
The following examples show how to execute DICTDBA and briefly explain
the responses given to the prompts.
Example
The following is an example of a SYNONYM report:
:RUN DICTDBA.PUB.SYS Executes the audit utility.
<The Dictionary/3000 DB Auditor program banner appears here.>
RUN MODE(SYNONYMS/CHAINS/LINKS)> S Select S for SYNONYM run mode.
BASE> SHPMGT Name of database to be audited.
BASE PASSWORD> Password is not displayed; MANAGER
was used.
MODE> [[RETURN]] entered; opens database in
default access mode 5.
The Terminal SYNONYMS report is generated as follows:
PRODUCT-MASTER M: 22/101 [21%] Set name; set type; current number
of entries/set capacity; capacity
usage percentage.
PO-MASTER A: 0/311 [0%]
ITEM-MASTER M: 44/311 [14%]
END OF PROGRAM
The Line printer SYNONYMS report is generated as follows:
RUN MODE: SYNONYMS Identifies run mode selected.
BASE: SHPMGT.PUB.HOWE Identifies the selected base.
PRODUCT-MASTER M: 22/101 [21%] Same information as terminal
report.
NUMBER OF ENTRIES WITH SYNONYMS: 0 [0%]
PO-MASTER A: 0/311 [0%]
SET IS EMPTY
ITEM-MASTER M: 44/311 [14%]
NUMBER OF ENTRIES WITH SYNONYMS: 1 [2%] Detail information on
SHORTEST SYNONYM CHAIN LENGTH: 1 synonym and chain;
LONGEST SYNONYM CHAIN LENGTH: 1 synonym % = (synonym count
100)/entry count, in this
case (1x100)/44 = 2%.
END OF AUDIT RUN
The following is an example of a CHAINS report.
:RUN DICTDBA.PUB.SYS How to execute the utility.
<The Dictionary/3000 DB Auditor program banner appears here.>
RUN MODE(SYNONYMS/CHAINS/LINKS)> C Select C for CHAINS run mode.
BASE> SHPMGT Name of base to be audited.
BASE PASSWORD> Password is not displayed;
MANAGER was used.
MODE> [[RETURN]] entered; opens database
in default access mode 5.
The Terminal CHAINS report is generated as follows:
PRODUCT-MASTER M: 22/101 [21%] Set name; set type; current number
of entries/set capacity; capacity
usage percentage.
PO-MASTER A: 0/311 [0%]
ITEM-MASTER M: 44/311 [14%]
EXPLODE D: 397/1023 [38%] DETAIL data set information
included for CHAINS run mode.
ITEM-DETAIL D: 0/507 [0%]
COSTING D: 0/1008 [0%]
END OF PROGRAM
The Line printer CHAINS report is generated as follows:
RUN MODE: CHAINS Identifies run mode selected.
BASE: SHPMGT.PUB.HOWE Identifies the selected base.
PRODUCT-MASTER M: 22/101 [21%] Same information as terminal
report.
NUMBER OF ENTRIES WITH SYNONYMS: 0 [0%]
PO-MASTER A: 0/311 [0%]
SET IS EMPTY
ITEM-MASTER M: 44/311 [14%]
NUMBER OF ENTRIES WITH SYNONYMS: 1 [2%] Synonym chain information
SHORTEST SYNONYM CHAIN LENGTH: 1 for master set.
LONGEST SYNONYM CHAIN LENGTH: 1
EXPLODE D: 397/1023 [38%]
SEARCH ITEM: PRODUCT-NO Information at the search item
level for detail data set.
NUMBER OF CHAINS: 22 Chain information begins.
SHORTEST CHAIN LENGTH: 18
LONGEST CHAIN LENGTH: 19
AVERAGE CHAIN LENGTH: 18
SEARCH ITEM: ITEM-NO
NUMBER OF CHAINS: 44
SHORTEST CHAIN LENGTH: 2
LONGEST CHAIN LENGTH: 24
AVERAGE CHAIN LENGTH: 9
ITEM-DETAIL D: 0/507 [0%]
SET IS EMPTY
COSTING D: 0/1008 [0%]
SET IS EMPTY
END OF AUDIT RUN
The following is an example of a LINKS report.
:RUN DICTDBA.PUB.SYS How to execute the audit utility.
<The Dictionary/3000 DB Auditor program banner appears here.>
RUN MODE(SYNONYMS/CHAINS/LINKS)> L Select mode L for LINKS.
BASE> SHPMGT Name of base to be audited.
BASE PASSWORD> Password is not displayed;
MANAGER was used.
MODE> [[RETURN]] entered; opens database
in default access mode 5.
The Terminal LINKS report is generated as follows:
PRODUCT-MASTER M: 22/101 [21%] Set name; set type; current number
of entries/set capacity; capacity
usage percentage.
PO-MASTER A: 0/311 [0%]
ITEM-MASTER M: 44/311 [14%]
EXPLODE D: 397/1023 [38%]
ITEM-DETAIL D: 0/507 [0%]
COSTING D: 0/1008 [0%]
END OF PROGRAM
The Line printer LINKS report is generated as follows:
RUN MODE: LINKS Identifies run mode selected.
BASE: SHPMGT.PUB.HOWE Name of base to be audited.
PRODUCT-MASTER M: 22/101 (21%) Same information as terminal
report.
NUMBER OF ENTRIES WITH SYNONYMS: 0 (0%)
FORWARD SERIAL READ COUNT: 22
REVERSE SERIAL READ COUNT: 22
PO-MASTER A: 0/311 (0%)
SET IS EMPTY
ITEM-MASTER M: 44/311 (14%)
NUMBER OF ENTRIES WITH SYNONYMS: 1 (2%) Synonym information for
SHORTEST SYNONYM CHAIN LENGTH: 1 the master set.
LONGEST SYNONYM CHAIN LENGTH: 1
FORWARD SERIAL READ COUNT: 44
REVERSE SERIAL READ COUNT: 44
EXPLODE D: 397/1023 (38%)
FORWARD SERIAL READ COUNT: 397
REVERSE SERIAL READ COUNT: 397
SEARCH ITEM: PRODUCT-NO Detail information by search item.
NUMBER OF CHAINS: 22
SHORTEST CHAIN LENGTH: 18
LONGEST CHAIN LENGTH: 19
AVERAGE CHAIN LENGTH: 18
FORWARD CHAIN READ COUNT: 397
REVERSE CHAIN READ COUNT: 397
SEARCH ITEM: ITEM-NO Second search item in the set.
NUMBER OF CHAINS: 44
SHORTEST CHAIN LENGTH: 2
LONGEST CHAIN LENGTH: 24
AVERAGE CHAIN LENGTH: 9
FORWARD CHAIN READ COUNT: 397
REVERSE CHAIN READ COUNT: 397
ITEM-DETAIL D: 0/507 (0%)
SET IS EMPTY
COSTING D: 0/1008 (0%)
SET IS EMPTY
END OF AUDIT RUN