Displays database block usage statistics and general status information.

Sample output for PROMON Database Status option

The following shows an example of this option's output.

                       Database version number: 8376
                               Database state: Not modified since last open (2)
                       Database damaged flags: None (0)
                              Integrity flags: None (512)
                  Database block size (bytes): 8192
              Total number of database blocks: 1622
              Database blocks high water mark: 1491
            Free blocks below high water mark: 140
                Record blocks with free space: 2
              Before image block size (bytes): 8192
               Before-image cluster size (kb): 512
               After image block size (bytes): 8192
                      Last transaction number: 6784
                  Highest file number defined: 0
               Database create (multi-volume): 08/03/23 17:45
                    Most recent database open: 08/03/23 17:45
                       Previous database open: 08/03/23 17:45
             Time of last zerostats operation: 08/03/23 17:45
                Local Schema cache time stamp: 08/02/23 18:58
                    Most recent .bi file open: 08/03/23 17:45
                       Previous .bi file open: - -
                  Time since last truncate bi: 1 (seconds)
                      Most recent full backup: - -
                Database changed since backup: Yes
               Most recent incremental backup: - -
                 Sequence of last incremental: 0
                       Database Restrict Mode: Disabled
             Time of last .lg file truncation: - -
                                Database Role: Normal
                              License Edition: Workgroup

       RETURN - repeat, U - continue uninterrupted, Q - quit

Because most of the Database Status option output is self-explanatory, this list describes the following items:

Database state

The state of the database, as set in the database master block:

Database state	Description
1	The database is open
2	The database is not modified since the last open
4	The database is being recovered
8	A database restore is underway
2048	An index repair is underway

Total number of database blocks

The actual database size in disk blocks.

Number of empty blocks

The number of empty blocks in the database. Empty blocks are created when the database outgrows its existing block allocation, and also by record and index deletion. The database engine expands the database by multiple blocks at a time—usually 8 or 16—and most of these are empty at first. Typically, the number of empty blocks increases and decreases as the database grows.

Record blocks with free space

Free space is created when records are deleted and when the database grows into a new block, but does not use the entire block. The database engine reuses empty space with new records when possible, but does not return empty space to the operating system. This space does not affect database performance. However, if you must reclaim this disk space for your system, you can dump and reload the database.

Time since last truncate bi

The time in seconds since the before-image file was truncated. When the BI file is truncated, all modified database blocks are written to disk.

Database Restrict Mode

The operation to allow, while restricting other access. For details about restrict types, see PROUTIL DBRESTRICT qualifier.

License Edition

The license edition information for the database has the following valid values:

• Enterprise
• Workgroup
• Personal

Note: The functional edition of the Advanced Enterprise Edition (AEE) is an Enterprise level database.