Viewing Database Information

How To

The database information page displays database information statistics from the SYSINFO table. Database information items and their corresponding SYSINFO.INFO values are summarized in Table.

Database Information Items

Description

Time of the counter of SYSINFO being started

The last time and date that data in the SYSINFO table was reset. The SYSINFO table gets reset when one of the counters overflows, or the SET SYSINFO CLEAR command is used. (SYSINFO_RESET_TIME)

Total size of DCCA

Total memory size of the Database Communication and Control Area (DCCA). Refer to the Database Administrators Guide for detailed descriptions of the DCCA. (DCCA_SIZE)

Available size of DCCA

Amount of memory available in the DCCA. (FREE_DCCA_SIZE)

DDB Mode

Distributed Database Mode. (DDB_MODE)

Backup Mode

Indicates whether incremental backups can be performed. It also indicates whether the incremental backup will include BLOB files, 1 means to backup the data file only, and 2 means to backup both data and BLOB files. (BACKUP_MODE)

User File Object Mode

Shows if user file objects have been enabled. A value of 1 means user file objects are enabled. (USER_FO_MODE)

Read-Only Mode

Shows if the database has been started in read-only mode. A value of 1 means he database has been started in read-only mode. (READ_ONLY_MODE)

Blob Frame Size (Bytes)

The size of each BLOB frame in bytes. (FRAME_SIZE)

Time of database creation

The date and time the database was created. (CREATE_DB_TIME)

Time of database start

The date and time the database was last started. (START_DB_TIME)

DBMaker version

The version number of the DBMaker engine. (VERSION)

Database file version

The version number of the database (FILE_VERSION)

Time of database startup with force new journal

The date and time the database was last started in new journal mode. (FORCE_NEW_JNL_TIME)

Time of turning the journal on

The most recent date and time the journal was started. (END_NO_JNL_TIME)

Time of turning the journal off

The most recent date and time the journal was stopped. (START_NO_JNL_TIME)

Table: Database Information Items


Related topic:

Monitoring Database Status