dbmgr -util Function—Manage Existing Database

Reference Guide › Utilities › dbmgr Utility › dbmgr -util Function—Manage Existing Database

dbmgr -util Function—Manage Existing Database

The dbmgr ‑util function performs management and maintenance operations on a database. It assumes CA ControlMinder is not currently running. Invoke it from the directory where the database resides.

The ‑util option is used to manage and manipulate the local database specified by the parameter filename. Database files have the extension .dat and must be DBIO files. Database index files (files with the extension .001) cannot be used with the ‑util option.

This command has the following format:

dbmgr {‑util|‑u} [-h] \

[-all filename] \
[-build filename] \
[-check] \
[-close] \
[-dump filename] \
[-dup src dst] \
[-fast] \
[-free filename] \
[-index filename] \
[-key filename] \
[-load db ascii \
[-scan filename] \
[-scana filename] \
[-stat filename] \
[-verify] \
[-f fileName]

-util-u: Executes the database management and maintenance functions of the dbmgr utility.
‑all filename: Performs all index checks; same as specifying the -index and -free options.
‑build filename: Builds indexes of a DBIO based on data records.
‑check: (UNIX only). Performs a fast sanity and consistency check on all index entries for all database files.
‑close: Closes the database if it is open.
‑dump filename: Dumps the data file as ASCII on the standard output device.
‑dup src dst: Duplicates the DBIO file based on the file header.
‑f fileName: Directs output to the specified file, instead of the standard output device.
‑fast: Performs a fast sanity check on all index entries for all the database files.
‑free filename: Checks for a free index.
‑index filename: Checks the consistency of the index.
‑key filename: Sequentially scans an index file.
‑load db ascii: Loads an ASCII file and converts it into a DBIO file.
‑scan filename: Scans the database sequentially.
‑scana filename: Scans the database sequentially, including deleted records.
‑stat filename: Lists the header information of the database file.
‑verify: (UNIX only). Verifies that certain predefined objects exist in the database; for example, SEOS, ADMIN, and UACC for all classes.