dbmgr -util Function: Manage Existing Database

The dbmgr -util function performs management and maintenance operations on a database. It assumes  is not currently running. Invoke it from the directory where the database resides.
capamsc141
The dbmgr -util function performs management and maintenance operations on a database. It assumes 
Privileged Access Manager
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 srcdst] \ [-fast] \ [-free filename] \ [-index filename] \ [-key filename] \ [-load dbascii \ [-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.