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.