HP 3000 Manuals HP 3000 Manuals
Chapter 5 Dictionary/3000 Utilities
OVERVIEW
Dictionary/3000 provides a set of interactive utilities that allow a
Dictionary or database administrator to easily create and maintain
entries in the Dictionary. The Dictionary utilities can be used to
create, maintain or load IMAGE database entries and to create VPLUS forms
file entries in the Dictionary. The utilities can also be used to clean
the Dictionary of superfluous information that may accumulate after
continued DICTDBM use.
Table 5-1 gives a summary of the utilities with a brief description of
their function.
Table 5-1. The Dictionary Utilities
UTILITY FUNCTION
---------------------------------------------------------------------------------------
DICTDBA reports on the usage statistics and checks the internal
(Database Audit) linkages of an IMAGE database.
DICTDBC uses the information in the Dictionary to create a
(Database Creation) schema and root file for an IMAGE database.
DICTDBD loads the existing definition of an IMAGE database into
(Database Definition) the Dictionary using the root file.
DICTDBU copies the data entries of an IMAGE database to disc or
(Database Unload) tape.
DICTDBL loads data entries from tape or disc into the IMAGE
(Database Load) database files.
DICTDBM, UTIL cleans up data Dictionary after several months of
(Data Dictionary Cleanup) DICTDBM use.
DICTVPD loads the existing definition of a VPLUS forms file into
(VPLUS Forms File Definition) the Dictionary.
Dictionary/3000 also provides an initialization utility and two extract
utilities. The initialization utility, DICTINIT, is used to create and
initialize the Dictionary. (For more information on DICTINIT, see
Appendix C.) The extract utilities, DICTPDE and DICTCDE, can be used to
generate PASCAL and COBOL definitions from the entities defined in the
Dictionary. (For more information on DICTPDE, see Chapter 6. For more
information on DICTCDE, see Chapter 7.)
Initiating the Utilities
After logging on, any of the Dictionary utilities can be run. The
utilities in this chapter assume that the Dictionary exists in the PUB
group of your log-on account. If the Dictionary you wish to use exists
in a different MPE group and/or account, you must first identify it by
issuing a file equation before running the utility. The file equation
should be as follows:
FILE DICT.PUB=DICT.group.account
To initiate any of the utilities issue an MPE RUN command, as follows:
RUN utility.PUB.SYS
Changing Output Files
DICTDBM uses the formal file designator TRANOUT to direct output to your
terminal and TRANLIST to direct output to the line printer. The other
utilities use DICTOUT to direct output to your terminal and DICTLIST to
direct output to the line printer. To redirect these output files, use
MPE file equations to redefine the file designators prior to running the
utility.
Using the Utilities to Restructure a Database
It is possible to make changes to the design of an existing IMAGE
database by using the Dictionary utilities. The following steps should
be performed when restructuring a database:
1. As a safety precaution, use the utility program, DBSTORE.PUB. SYS
to store the old database, before performing any of the following
steps.
2. Run the Database Unload utility (DICTDBU) program, copying the
existing contents of a database to a disc file or a tape file.
3. Run the Database Maintenance program (DICTDBM) program and make
the desired changes to the database by using the appropriate
commands. For example, items may need to be moved from one data
set to another or added to the middle of a data set, or data types
or database/data set names may need to be changed, now is the time
to make these changes.
4. Run the HP DBUTIL utility program, purging the old database. (See
the IMAGE/3000 Reference Manual for details on DBUTIL.)
5. Run the Database Creation utility (DICTDBC) program, creating a
new schema file and a new root file for the redesigned database.
6. Run the HP DBUTIL utility program, creating and initializing the
new database. (See the IMAGE/3000 Reference Manual for details on
DBUTIL.)
7. Run the Database Load utility (DICTDBL) program, loading the new
database with the contents of the old database. The Database Load
utility program compares the old schema file with the new schema
file and, if necessary, transforms the data field formats of the
old database to agree with the formats of the new database.