Summary of Utility Routines [ TurboIMAGE/XL Database Management System Reference Manual ] MPE/iX 5.0 Documentation
TurboIMAGE/XL Database Management System Reference Manual
Summary of Utility Routines
Here is a brief summary of the utilities, their commands, and their
functions.
Table 8-1. TurboIMAGE/XL Utilities
-----------------------------------------------------------------------------------------------
- Program - Commands - Function -
-----------------------------------------------------------------------------------------------
| DBLOAD | | Loads data entries, which were copied to tape by |
| | | DBUNLOAD, back into the data sets. |
-----------------------------------------------------------------------------------------------
| DBRECOV | | Performs database recovery from log files. |
| | | |
| | CONTROL | Controls various options that affect the execution |
| | | of DBRECOV. Refer to the discussion of DBRECOV in |
| | | this chapter for valid options when executing. |
| | | |
| | EXIT | Terminates DBRECOV without re-executing any |
| | | transactions. |
| | | |
| | FILE | Routes log records to individual user files and |
| | | returns information about recovery. |
| | | |
| | PRINT | Prints information about databases or user files |
| | | specified for recovery. |
| | | |
| | RECOVER | Designates name of database(s) to be roll-forward |
| | | recovered. |
| | | |
| | ROLLBACK | Defines name of database(s) to be roll-back |
| | | recovered. |
| | | |
- - RUN - Initiates recovery process. -
-----------------------------------------------------------------------------------------------
| DBRESTOR | | Copies the database to disk from magnetic tape |
| | | volumes created by DBSTORE, or by the MPE/iX STORE |
| | | or SYSGEN command. |
-----------------------------------------------------------------------------------------------
| DBSTORE | | Copies entire database including root file to |
| | | magnetic tape volumes. |
-----------------------------------------------------------------------------------------------
| DBUNLOAD | | Copies data entries to specially formatted magnetic |
| | | tape volumes; arranges entries in each data set via |
| | | the primary path if the chained entry point is |
| | | used. |
-----------------------------------------------------------------------------------------------
| DBUTIL | | Allows you to perform several database functions, |
| | | such as setting database flags, changing database |
| | | security, creating or purging a database, and |
| | | determining current users and the status of locks. |
-----------------------------------------------------------------------------------------------
Table 8-1. TurboIMAGE/XL Utilities (cont.)
-----------------------------------------------------------------------------------------------
- Program - Commands - Function -
-----------------------------------------------------------------------------------------------
| DBUTIL | ACTIVATE | Prepares a database-access file which is used to |
| (continued) | | access a remote database. |
| | | |
| | CREATE | Creates and initializes a database file for each |
| | | data set. |
| | | |
| | DEACTIVATE | Deactivates a database-access file which is used to |
| | | access a remote database. |
| | | |
| | DISABLE | Disables logging, roll-back recovery, ILR, |
| | | AUTODEFER, HWMPUT, MUSTRECOVER, PREFETCH, access, |
| | | third-party indexing, and dumping options. |
| | | |
| | ENABLE | Enables logging, roll-back recovery, ILR, |
| | | AUTODEFER, HWMPUT, MUSTRECOVER, PREFETCH, access, |
| | | third-party indexing, and dumping options. |
| | | |
| | ERASE | Erases existing data entries from all data sets. |
| | | Used before loading stored data entries back into |
| | | the database. Also disables options, such as |
| | | logging, ILR, roll-back recovery, and third-party |
| | | indexing. |
| | | |
| | EXIT | Terminates DBUTIL program execution. |
| | | |
| | HELP | Lists all DBUTIL commands. |
| | | |
| | MOVE | Moves TurboIMAGE/XL files across devices. |
| | | |
| | PURGE | Purges entire database including root file, data |
| | | sets, and any third-party indexes. Used before |
| | | restoring a stored database and before creating a |
| | | new, restructured database. |
| | | |
| | RELEASE | Suspends MPE/iX security provisions for the root |
| | | file, data sets, and any third-party indexes. |
| | | |
| | SECURE | Restores MPE/iX security provisions suspended by |
| | | RELEASE. |
| | | |
| | SET | Changes or removes the maintenance word or |
| | | password, stores log identifier and password into |
| | | root file, specifies the setting for the critical |
| | | item update (CIUPDATE) option, and changes the |
| | | native language of the database. For databases |
| | | that will be migrated to MPE V, specifies the |
| | | number of buffers to be used. |
| | | |
| | SHOW | Used to display information about a database, such |
| | | as flags, users, and the status of locks. |
| | | |
| | VERIFY | Used to determine whether a database-access file is |
| | | activated or deactivated. |
-----------------------------------------------------------------------------------------------
MPE/iX 5.0 Documentation