TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

384 Chapter8
Using the Database Utilities
Utility Program Operation
Utility Program Operation
Database utilities can be run in either job or session mode. With the exception of DBUTIL's
>>SHOW command, DBUTIL, DBSTORE, DBRESTOR, DBUNLOAD, and DBLOAD all require you
to be logged on in the group and account that contains the database root file. Consequently,
these utilities cannot be used with a remote database unless you initiate a remote session
and run the utility as part of that session. The DBUTIL, DBSTORE and DBRESTOR utilities do
not allow you to use the MPE/iX FILE command to equate a database or database-access
file.
CAUTION DBUNLOAD and DBLOAD do allow MPE/iX FILE commands to equate a database
and can redirect the database to a different file. Except in a controlled
environment, you should not use the MPE/iX FILE command to redirect a
database or database-access file to a different file, because that file can be
purged easily.
The DBRECOV utility is not included in the discussion above because it is an exception. With
DBRECOV, MPE/iX FILE commands are permissible and you need not be logged on to the
same group and account as the log file. However, DBRECOV must be invoked on the system
where the database resides.
To execute the DBUTIL >>CREATE command or to change or remove the maintenance word
with the DBUTIL >>SET command, you must log on with the same user name (including
account name) that was used when the Schema Processor created the root file; this verifies
to TurboIMAGE/XL that you are the database creator. To operate the other database
utilities or enter other DBUTIL commands, you need not be the database creator provided
you know the maintenance word. If no maintenance word is defined, only the database
creator can execute the other utilities and the DBUTIL commands that require a
maintenance word. The exception to this rule is that a user with system manager (SM)
capability can use the DBUTIL >>SHOW command on any database without having to supply
the maintenance word.
NOTE To maintain compatibility with earlier versions of DBUTIL, the >>CREATE,
>>ERASE, and >>PURGE commands can also be executed by specifying them as
DBUTIL entry points.
Backup Files
The backup files created by DBSTORE and DBUNLOAD can be written only to magnetic tape
volumes. In the discussion of the utilities that follows, the term volume refers to a
magnetic reel.
Error Messages
Some of the error messages are described with the operating instructions for the utilities.
Appendix A contains a complete listing of the error messages issued by these programs.