Dictionary/3000 Reference Manual (32244-90001)

146 Chapter5
Dictionary/3000 Utilities
Overview
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.