Infodb Command Output--Extent Directory Section
The following is sample output from the extent directory section, which shows all locations used by the database:
----Extent directory-------------------------------------------------------------
Location Flags Physical_path
-----------------------------------------------------------------------------
ii_database ROOT,DATA C:\Program Files\Actian\VectorVW\ingres\data\default\mydb
ii_journal JOURNAL C:\Program Files\Actian\VectorVW\ingres\jnl\default\mydb
ii_checkpoint CHECKPOINT C:\Program Files\Actian\VectorVW\ingres\ckp\default\mydb
ii_dump DUMP C:\Program Files\Actian\VectorVW\ingres\dmp\default\mydb
ii_work WORK C:\Program Files\Actian\VectorVW\ingres\work\default\mydb
Fields are as follows:
Location
Identifies the logical name of the location.
Flags
Indicates the types of database files stored in the location. The possibilities are:
ALIAS—this is a location alias. This means at least one other location points to the same area as this location. This flag is used only for checkpoint and rollforward operations so that locations are neither checkpointed nor rolled forward more than once.
AWORK—this is an auxiliary work file location. Work files (that is, for sorts and temporary tables) are stored in the location.
CHECKPOINT—checkpoint files are stored in the location.
DATA—user data (such as tables, indexes) is stored in the location.
DUMP—dump files are stored in the location.
JOURNAL—journal files are stored in the location.
ROOT—system data (that is, system catalogs) is stored in the location.
WORK—work files (for sorts and temporary tables) are stored in the location.
Physical_path
Identifies the physical path of the location.