HP 3000 Manuals

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