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.
The infodb command has the following format:
infodb [#c[n]] [#p[n]] [-uusername] [-Ggroupid] [-databases] {-get_<item>|-get_help} {dbname}
#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.
Linux: 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"
#p[n]
Retrieves information about a specific checkpoint for the database when used with one or more [-get_ckp] options. The checkpoint number n must be a valid checkpoint number. If n is omitted, information about the most recent completed checkpoint is displayed.
Linux: In bash shell, you must place this option in quotes; otherwise characters after the # are treated as a comment. For example:
infodb empdata "#p1" -get_ckp_date
Only the following -get_ckp[_option] flags are valid to use with the #p[n] option:
• -get_ckp
• -get_ckp_date
• -get_ckp_status
• -get_ckp_mode
• -get_ckp_first_jnl
• -get_ckp_last_jnl
• -get_ckp_first_dmp
• -get_ckp_last_dmp
Example - The following command retrieves the creation date and validity status of checkpoint 3 for databases mydb and mydb2:
infodb mydb mydb2 "#p3" -get_ckp_date -get_ckp_status
-uusername
-Ggroupid
‑databases
Lists the names of all databases in the current installation if no other arguments are supplied.
‑get_<item>
Retrieves the specified information for the database name. Valid <item> flags are:
• -get_help: Specifies the various options associated with the command.
• -get_dbowner: Specifies the owner (user) of the database.
• -get_dbid_hex: Indicates the database identifier in hexadecimal format.
• -get_unicode_enabled: Specifies whether Unicode support is enabled for the database.
• -get_unicode_normalization: Specifies the Unicode normalization form used by the database.
• -get_last_table_id: Returns the last assigned table identifier.
• -get_readonly: Specifies whether the database is in read-only mode.
• -get_db_version_id: Displays the database version identifier.
• -get_mvcc_enabled: Indicates whether MVCC (Multi-Version Concurrency Control) is enabled.
• -get_ckp_date: Shows the date and time of the last checkpoint.
• -get_ckp_status: Displays the current checkpoint status.
• -get_ckp_last_jnl: Shows the last journal file used in the last checkpoint.
• -get_ckp_last_dmp: Displays the last dump file associated with the last checkpoint.
• -get_location_checkpoint: Displays the location where checkpoint files are stored.
• -get_location_dump: Displays the location of dump files.
• -get_location_all: Displays all the configured storage locations for the database.
• -get_access_type: Displays the database access type.
• -get_dbname: Displays the name of the database.
• -get_dbid: Returns the internal numeric identifier of the database.
• -get_collation: Indicates the default collation setting for the database.
• -get_unicode_collation: Displays the Unicode collation setting in use.
• -get_extents: Provides information about storage extents allocated to the database.
• -get_must_logged: Indicates whether all operations must be logged.
• -get_ddl_allowed: Indicates whether DDL operations are permitted.
• -get_status: Shows the current status of the database.
• -get_ckp: Displays checkpoint configuration details.
• -get_ckp_mode: Indicates the checkpoint mode in use.
• -get_ckp_first_jnl: Shows the first journal file used in the last checkpoint.
• -get_ckp_first_dmp: Displays the first dump file associated with the last checkpoint.
• -get_location_data: Shows the file system location of database data files.
• -get_location_journal: Shows the location of journal (log) files.
• -get_location_work: Shows the working directory location for temporary files.
• -get_x100_support: Indicates whether X100 (vectorized execution engine) support is enabled.
-get_help
Specifies the various options associated with the command.
dbname
If no database is specified, infodb prints a report for each database.