Was this helpful?
Database Properties Dialog
You can view database properties on the Database Properties dialog. This dialog contains the following pages, depending on the version of the database:
General
Extend Locations
Information
Checkpoint History for Journal
Checkpoint History for Dump
Extents
For more information, see View Database Properties.
General Page Options
This page contains the following fields:
General Options
This section contains the following fields:
Name
Displays the name of the database
Owner
Displays the owner of the database
Access Options
This section contains the following fields:
Private
Displays whether the database is private
Public
Displays whether the database is public
Read-Only
Displays whether the database is read-only
Primary Locations Options
This section contains the following fields:
Checkpoint
Displays the primary checkpoint location. Default is ii_checkpoint.
Data
Displays the primary data location. Default is ii_database.
Dump
Displays the primary dump location. Default is ii_dump.
Journal
Displays the primary work location. Default is ii_work.
Work
Indicates the initial allocation of the current dump file, in blocks. This is the number of blocks initialized when a dump file is created.
Product Catalog Options
This section contains the following fields:
ABF, QBF, RBF, VIFRED
Indicates whether the database contains the product catalogs for Applications-By-Forms, Query-By-Forms, Report-By-Forms, and Visual Forms Editor
DBD
Indicates whether the database contains catalogs for Ingres/DBD
OpenROAD
Indicates whether the database contains the OpenROAD product catalogs
Vision
Indicates whether the database contains the Vision product catalogs
Services Options
This section contains the following fields:
Coordinator
Indicates whether the database is a coordinator database for a distributed database
Unicode Normalization Options
This section contains the following fields:
NFC
Indicates whether the database is Unicode-enabled with Normalization Form C
NFD
Indicates whether the database is Unicode-enabled with Normalization Form D
Extend Locations Page Options
This page lists whether the database uses extended locations. An extended database has additional data, work, and auxiliary locations (sort space is is spread among multiple locations). It contains a grid with the following columns and indicates the type of extension.
Location Name
Lists the logical name of the location (ii_database or ii_work)
Data
Indicates whether data locations are extended
Work
Indicates whether work (defaultable) locations are used for all user sorts on the database
Auxiliary Work
Indicates whether auxiliary work locations are used for the database
Information Page Options
This page lists more general information for a database, including dump and journal settings. It lists the following information:
General Options
This section contains the following fields:
Server
Displays the server the database is located on
ID
Displays the internal ID of the database
Name
Displays the name of the database
Owner
Displays the owner of the database
Database Options
This section contains the following fields:
Access
Indicates the access type for the database
Collation
Indicates the collation setting for the database
Config File Version ID
Indicates the configuration file version ID number
DCB Status
Displays the DCB status for the database
Database Version ID
Displays the database version ID number
Extents
Displays the number of extents for the database
Is Consistent
Indicates whether or not the database is consistent
Last Table ID
Displays the ID of the last table in the database
Service
Displays the service for the database
Status
Displays the status for the database
Unicode Collation
Displays the Unicode collation setting for the database
Unicode Normalization
Displays the Unicode normalization setting for the database
X100 Supported
Indicates whether X100 tables are supported
Dump Options
This section contains the following fields:
Checkpoint sequence
Indicates the dump checkpoint sequence
Current Dump Block
Indicates the current dump block
Dump Block Size
Displays the dump block size
Dump Sequence
Indicates the dump sequence
Initial Dump Size
Indicates the initial dump size
Last Log Address Dumped
Displays the last log address that was dumped
Target Dump Size
Displays the target dump size
Journal Options
This section contains the following fields:
Checkpoint Sequence
Indicates the checkpoint sequence
Current Journal Block
Indicates the current journal block
Initial Journal Size
Displays the initial journal size
Journal Block Size
Displays the journal block size
Journal Sequence
Indicates the journal sequence
Last Log Address Journaled
Displays the last log address journaled
Target Journal Size
Displays the target journal size
Checkpoint History for Journal Page Options
This page lists the checkpoint history for journals. It lists the following information for each checkpoint:
Date
Indicates the date and time the checkpoint operation was done
Sequence
Indicates the sequence number of the checkpoint
First Journal
Indicates the journal sequence number of the first (or oldest) journal file corresponding to the checkpoint
Last Journal
Indicates the journal sequence number of the last (or youngest) journal file corresponding to the checkpoint
Valid
Indicates whether the checkpoint is valid (1 implies valid, 0 implies invalid)
Mode
Indicates whether the checkpoint operation was online or offline. Also displays TABLE if the checkpoint was a table checkpoint.
Checkpoint History for Dump Page Options
This page lists the checkpoint history for dumps. It lists the following information for each checkpoint:
Date
Indicates the date and time the checkpoint operation was done
Sequence
Indicates the sequence number of the checkpoint
First Dump
Indicates the dump sequence number of the first (or oldest) dump corresponding to the checkpoint
Last Dump
Indicates the dump sequence number of the last (or newest) dump corresponding to the checkpoint
Valid
Indicates whether the checkpoint is valid (1 implies valid, 0 implies invalid)
Mode
Indicates whether the checkpoint operation was online or offline. Also displays TABLE if the checkpoint was a table checkpoint.
Extents Page Options
This page lists the following information for each location used by the database:
Location
Identifies the logical name of 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.
Flags
Indicates the types of database files stored in the location
Physical Path
Displays the physical path of the location
Last modified date: 06/06/2024