Show Information on Databases with infodb
The infodb utility shows administrative details about databases, such as the directory names of data, checkpoint, journal, dump, and work locations. These details are stored in the configuration file.
To use infodb
To get a list of databases, issue the following command at the operating system prompt:
infodb -databases
or
infodb -get_dbname
Issue the following command to see all information from all databases, including the system databases iidbdb and imadb:
infodb
Infodb prints a report for each database in the installation. To restrict the information to a specific database, specify:
infodb dbname
The following is sample output (on Windows) for the test2 database:
==================Tue Jan 31 08:53:07 2023 Database Information=================
Database : (test2,actian) ID : 0x0D531564 Default collation :
Unicode enabled : Yes
Always logged : No
X100 supported : Yes
Database Encryption : No
Default unicode collation : udefault Unicode normalization : NFC
Extents : 5 Last Table Id : 265
Config File Version Id : 0x00100001 Database Version Id : 13
Mode : DDL ALLOWED, ONLINE CHECKPOINT ENABLED
Access : PUBLIC
Status : VALID,X100_EXIST
The Database is not Journaled.
MVCC is enabled in this database.
Journals are not valid from any checkpoint.
----Journal information---------------------------------------------------------
Checkpoint sequence : 0 Journal sequence : 0
Current journal block : 0 Journal block size : 16384
Initial journal size : 4 Target journal size : 512
Last Log Address Journaled : <0:0:0>
----Dump information------------------------------------------------------------
Checkpoint sequence : 0 Dump sequence : 0
Current dump block : 0 Dump block size : 16384
Initial dump size : 4 Target dump size : 512
Last Log Address Dumped : <0:0:0>
----Checkpoint History for Journal----------------------------------------------
Date Ckp_sequence First_jnl Last_jnl valid mode
----------------------------------------------------------------------------
None.
----Checkpoint History for Dump-------------------------------------------------
Date Ckp_sequence First_dmp Last_dmp valid mode
----------------------------------------------------------------------------
None.
----Cluster Journal History-----------------------------------------------------
Node ID Current Journal Current Block Last Log Address
------------------------------------------------------------
None.
----Cluster Dump History-----------------------------------------------------
Node ID Current Dump Current Block Last Log Address
------------------------------------------------------------
None.
----Extent directory------------------------------------------------------------
Location Flags Physical_path
------------------------------------------------------------------
ii_database ROOT,DATA,VWROOT C:\qa1\installs\VectorVX\ingres\data\default\test2
ii_journal JOURNAL C:\qa1\installs\VectorVX\ingres\jnl\default\test2
ii_checkpoint CHECKPOINT C:\qa1\installs\VectorVX\ingres\ckp\default\test2
ii_dump DUMP C:\qa1\installs\VectorVX\ingres\dmp\default\test2
ii_work WORK C:\qa1\installs\VectorVX\ingres\work\default\test2
================================================================================
----Vectorwise directory--------------------------------------------------------
Location Flags Physical_path
------------------------------------------------------------------
ii_database ROOT,DATA,VWROOT C:\qa1\installs\VectorVX\ingres\data\vectorwise\test2
ii_journal JOURNAL C:\qa1\installs\VectorVX\ingres\jnl\vectorwise\test2
ii_checkpoint CHECKPOINT C:\qa1\installs\VectorVX\ingres\ckp\vectorwise\test2
ii_work WORK C:\qa1\installs\VectorVX\ingres\work\vectorwise\test2
================================================================================
For more information, see infodb in the Command Reference.
Infodb can be used to access certain elements of the report:
infodb test2 -get_help
valid infodb -get_item flags:
-get_help -get_dbname
-get_dbowner -get_dbid
-get_dbid_hex -get_collation
. . .
-get_location_dump -get_location_work
-get_location_all
For example:
infodb test2 -get_dbowner -get_dbid
actian
1466958301