Displays general database status information.

PROMON Database Status display

The following shows a sample Database Status display.

03/14/23            Status: database
09:33:25 

Database was started at:          03/14/23 09:33
It has been up for:               0:00:18
Database state:                   Not modified since last open (2)
Database damaged flags:           None 
Integrity flags:                  Executing with (512) 
Most recent database open:        03/14/23 09:33
Previous database open:           03/14/23 09:33
Time of last zerostats operation: 03/14/23 09:33
Local cache file time stamp:      03/14/23 15:28
Database block size:              8192 bytes
Number of blocks allocated:       1622 (12344      kb)
Empty blocks:                     135 (8 %)
Free blocks:                      138 (9 %)
RM Blocks with Free Space:        7 (0%)
Last transaction id:              8193
Highest table number defined:     0
Database version number:          143
Shared memory version number:     6414606
Database Restrict Mode:           Disabled
Time of last .lg file truncation: -
OpenEdge version name:            12.8.0.0.1013

The display shown above contains the following fields:

  • Database state — The current operating mode of the database. The table below describes the possible database states.
    Table 1. Database states
    State Description
    Open The database is open
    Not modified since last open The database is closed
    Recovery The database is performing crash recovery
    Index repair The PROUTIL IDXBUILD utility is running to rebuild indexes
    Restore The database is being restored
  • Database damaged flags — The state of the database. The table below lists the possible flags.
    Table 2. Database damaged flags
    State Description
    None Normal
    Opened with -F Crash recovery skipped; the database might be damaged
    Crashed with -i Crashed without integrity; the database is damaged
    Crashed with -r Crashed with buffered I/O; the database might be damaged
  • Integrity flags — The integrity mode in which the database is running. The table below lists the possible flags.
    Table 3. Integrity flags
    State Description
    None Normal
    Executing with -i A crash in this state will damage the database
    Executing with -r A crash in this state might damage the database
  • Most recent database open — The date and time when the broker for this database started.
  • Previous database open — The date and time when the database previously started.
  • Local cache file time stamp — The time stamp used to check the validity of the schema cache file. See the description of the Schema Cache File (-cache) parameter in Database Startup Parameters for more information.
  • Database block size — The database block size in bytes.
  • Number of blocks allocated — The total number of blocks allocated to the database.
  • RM Blocks with free space — The total number of blocks in the RM chain.
  • Highest table number defined — The number of tables defined in the database.
  • Database version number — Identifies the structures of all database-related data that is resident on disk. This number is used to match different executable versions with the correct database structures.
  • Shared memory version number — Identifies the version of all data structures that are resident in shared memory and used by the database manager. This number is used to ensure that all executables accessing shared memory agree on what data is kept in shared memory and how that data is accessed. The shared-memory version number changes more frequently than the database version number.
  • Database Restrict Mode — Identifies whether the database is in a restricted access mode. For details about restriction types, see PROUTIL DBRESTRICT qualifier.
  • Time of last .lg file truncation — The date and time of last truncation of the log file. For more information, see the description of the Log file truncate time (-lgTruncateTime) startup parameter.
  • OpenEdge version name — Identifies the OpenEdge version information. For example, 12.8.0.0.1013, where:
    • 12.8 is the release number.
    • 0 is the update number.
    • 0 is a constant value that is no longer used in the current release model.
    • 1013 is the build number.