2. Using Ingres Commands : infodb Command--Display Database Information
 
Share this page                  
infodb Command--Display Database Information
The infodb command displays a variety of information on a database, including its status, the location of its files (from the configuration file aaaaaaaa.cnf), and a history of checkpoints and journaling.
To use this command, you must be a privileged user or the DBA of the specified database. If you are a privileged user, you can use the -u flag to impersonate another user. On VMS, to use this command against a database in a group level installation, you must be a privileged user (VMS CMKRNL, SYSPRV, and PHY_IO privileges).
The infodb command has the following format:
infodb [‑databases][dbname[/server_class]][#c[n]]
[-uusername][-Ggroupid] [-help]
‑databases
Lists the names of all databases in the current installation if no other arguments are supplied.
dbname
Indicates the name of the database, and if required, the server_class, as described in Standard Flags and Parameters.
If no database is specified, infodb prints a report for each database.
#c[n]
Lists the objects included in a specific checkpoint for the database. The relevant checkpoint file must exist in the dump location for the database. The checkpoint number n must be a valid checkpoint number. If n is omitted, information about the most recent completed checkpoint is displayed.
UNIX: In bash shell, you must place this option in quotes; otherwise characters after the # will be treated as a comment. For example:
infodb empdata "#c1"
-uusername
Specifies the effective user for the session, as described in Standard Flags and Parameters.
-Ggroupid
Specifies a group identifier, as described in Standard Flags and Parameters.
On VMS, enclose this parameter in double quotation marks ("‑Ggroupid").
-help
Displays command syntax online.