Database: Logging (DB2 UDB for UNIX and
Windows) 
To display information on log files, call the DBA Cockpit.
...
1. In the navigation frame, choose Performance ®Database.
The Database Snapshot appears.
2. Choose Logging.
|
Field |
Description |
|
Log Files |
|
|
Primary |
Number of primary log files. The database configuration parameter LOGPRIMARY determines this value. |
|
Secondary |
Number of secondary log files. The database configuration parameter LOGSECOND determines this value. |
|
Size |
Number of pages in each log file. The database configuration parameter LOGFILSIZ determines this value. Each page has 4 KB. |
|
Total Log |
|
|
Available to Database |
Amount of primary log space in byte in the database that is not being used by uncommitted transactions |
|
Used by Database |
Total amount of primary log space in byte currently used in the database |
|
Maximum Space Used |
Maximum amount of primary log space used in byte |
|
Secondary Log |
|
|
Logs Currently Allocated |
Total number of secondary log files that are currently being used for the database |
|
Maximum Space Used |
Maximum amount of secondary log space used in byte |
|
Log Pages |
|
|
Read |
Number of log pages read from disk |
|
Written |
Number of log pages written to disk |