Log Database Display Screen

The Log Database Display screen appears when you select Databases from the Log Info Menu screen.

This screen can be used to monitor logging activity by database.

The screen contains an entry for each active database. Information includes the number of transaction begins and ends, and the number of log file write requests. The status of a database can also be determined. For a list of valid status values, see Logging System Header Screen Status Field Values.

The Log Database Display shows the following information:

• DB Name

  The database name.

• Status

  The database status. Valid values are as follows:

  • CKPDB_PEND

    Online backup for this database is about to start.

  • CLOSEDB_PEND

    This database is about to be closed; the last user in the database is exiting.

  • EBACKUP

    Online backup

  • FAST_COMMIT

    This database is running with Fast Commit.

  • FBACKUP

    Online backup

  • JOURNAL

    This database has journaling enabled.

  • NOTDB

    The entry is not a database.

  • OPENDB_PEND

    This database is about to be opened for the first user of the database.

  • PURGE

    This database is closed and the archiver is archiving transactions.

• TX Cnt

  The number of currently open transactions. This is the difference between the Begin and End columns.

• Begin

  The number of transaction begins that have occurred so far.

• End

  The number of transaction ends that have occurred so far.

• Read

  The number of log file read requests that have been made so far. It is unusual for this value to be greater than 0 for any entry except the $recovery entry. Log file reads are usually done during transaction rollout and during journaling by the archiver.

• Write

  The number of log file write requests made.

Log Database Display Menu Items

The Log Database Display has the following menu items:

• Refresh

  Queries the logging system for logging information. Process, database and transaction information are obtained together to ensure a consistent snapshot of the logging system.

• More_Info

  Displays additional information for the selected database, including the database location and journal window. For more information on this screen, see Log Database Display More_Info Screen.

• Find

  Searches any column in the scrolling area. To initiate the search, tab to the desired column and select Find. If you are searching a text column, Find locates all occurrences in the column.

• Help

  Displays help screens.

• End

  Returns to the Log Info Menu screen.

• Quit

  Exits IPM.

Log Database Display More_Info Screen

When the More_Info menu item is selected from the Log Database Display screen, a pop-up screen containing additional fields for the specified database is displayed.

The pop-up screen has the following fields:

• ID

  The internal database ID for this database

• Owner

  The DBA for this database

• Force

  The number of times log file forces occurred for this database

• Wait

  The number of times transactions in this database had to wait to use the logging system

• Location

  The database location

• Jnl Window

  The range of log file addresses where there are transactions for this database that must be journaled. This field implies that journaling is enabled for this database.

• Start Backup

  The log file address where on-line backup for this database begins