2. Creating Databases : Show Information on Databases with Infodb
 
Share this page                  
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
Issue the following command at the operating system prompt:
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) from the Extent directory section, which shows all locations used by the demodb database:
==============Thu Oct 08 11:07:50 2009 Database Information===================
Database : (demodb,mrm) ID : 0x49231C4D
 
Extent directory-------------------------------------------------------------
 
Location     Flags      Physical_path
-----------------------------------------------------------------------------
ii_database  ROOT,DATA C:\Program Files\Ingres\IngresII\ingres\data\default\demodb
ii_journal   JOURNAL   C:\Program Files\Ingres\IngresII\ingres\jnl\default\demodb
ii_checkpointCHECKPOINTC:\Program Files\Ingres\IngresII\ingres\ckp\default\demodb
ii_dump      DUMP      C:\Program Files\Ingres\IngresII\ingres\dmp\default\demodb
ii_work WORK      C:\Program Files\Ingres\IngresII\ingres\work\default\demodb
For a complete description, see infodb Command in the Command Reference Guide.