Progress
Database Administration
Guide and Reference


PROMON Database Status Option

Displays database block usage statistics and general status information. Figure 19–10 shows an example of this option’s output.

                      Database version number: 1085 
                               Database state: Open (1) 
                       Database damaged flags: None (0) 
                              Integrity flags: Executing with -r (4) 
                  Database block size (bytes): 1024 
              Total number of database blocks: 208 
              Database blocks high water mark: 208 
            Free blocks below high water mark: 0 
                Record blocks with free space: 0 
              Before image block size (bytes): 1024 
               Before-image cluster size (kb): 128 
               After image block size (bytes): 1024 
                        Last transaction number: 17923 
                    Highest file number defined: 10 
                         Database Character Set: ISO 8859-1 
                        Database Collation Name: Basic 
                 Database create (multi-volume): - - 
                      Most recent database open: 6/12/01 15:38 
                         Previous database open: 6/10/01 8:31 
       RETURN - show remaining, U - continue uninterrupted, Q - quit: 
                Local Schema cache time stamp: 02/15/02 21:41 
                    Most recent .bi file open: 02/17/02 17:01 
                       Previous .bi file open: - - 
                  Time since last truncate bi: 0 (seconds) 
                      Most recent full backup: 02/15/02 21:43 
                Database changed since backup: No 
               Most recent incremental backup: - - 
                 Sequence of last incremental: 0 
       RETURN - repeat, U - continue uninterrupted, Q - quit 

Figure 19–10: Sample Output For PROMON Database Status Option

DISPLAY FIELDS

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

Database state

One of the following values, set in the database master block:

Database State
Description
1
The database is open.
2
The database is closed, used on disk.
3
The database is being recovered.

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. Progress 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. Progress reuses empty space with new records when possible, but does not return empty space to the operating system. This space does not affect Progress 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 (BI) file was truncated. When the BI file is truncated, all modified database blocks are written to disk.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095