Log Manager Statistics Detail

This panel provides detailed information about the logging and archiving activity of the Db2 log manager during a selected report interval.


 ________________ ZHLGD    VTM     O2       V550./C SE11 07/31/13 20:45:53   2 
>       Help PF1      Back PF3      Up PF7      Down PF8                       
>                                                                              
>                   Enter a selection letter on the top line.                  
>                                                                              
> A-SUBSYSTEM SUPPORT      B-BIND              C-BUFFER POOL    D-GROUP BP     
> E-DISTRIBUTED DATABASE   F-EDM POOL          *-LOG MANAGER    H-OPEN/CLOSE   
> I-SQL/RID/PARALLEL/PROC  J-LOCK/CLAIM/DRAIN  K-GLOBAL LOCK    L-DB2 COMMANDS 
> M-THREAD HISTORY                                                             
===============================================================================
>                         LOG MANAGER STATISTICS DETAIL                        
 HLGD                                                                          
+ Collection Interval:   1 min                           Start:  07/31 20:43   
+ Report Interval:       1 min   Combine Level:  NONE      End:  07/31 20:44   
+                                                                              
+ High Used Log Record RBA = 00000000000202C64D4A                              
+ Number of Bytes Used     =                 1518                              
+                                                                              
+                                           INTERVAL  /MINUTE  /THREAD  /COMMIT
+                                           QUANTITY  (    1)  (    1)  (    0)
+                                           --------  -------  -------  -------
+ Reads from Output Buffers                        0      .00      .00      .00
+ Reads from Active Log                            0      .00      .00      .00
+ Reads from Archive Log                           0      .00      .00      .00
+ Reads Delayed - Tape Contention                  0      .00      .00      .00
+ Reads Delayed - No Tape Unit                     0      .00      .00      .00
+ Look-Ahead TapeMounts Attempted                  0      .00      .00      .00
+ Look-Ahead TapeMounts Performed                  0      .00      .00      .00
+                                                                              
+ Write NOWAIT Requests                            0      .00      .00      .00
+ Write FORCE Requests                            15    15.00    15.00      .00
+ Write Delayed - No Buffer                        0      .00      .00      .00
+                                                                              
+ Write Active Log Buffers                        15    15.00    15.00      .00
+ Active Log CIs Created                           0      .00      .00      .00
+ Archive Log Read Allocations                     0      .00      .00      .00
+ Archive Log Write Allocations                    0      .00      .00      .00
+ Archive Log CIs Offloaded                        0      .00      .00      .00
+ BSDS Access Requests                             0      .00      .00      .00
+ Checkpoints                                      0      .00      .00      .00
+ IFI Abends                                       0      .00      .00      .00
+ IFI Unrecog Func                                 0      .00      .00      .00
+ IFI Command Reqs                                 1     1.00     1.00      .00 
+ IFI READA Reqs                                   2     2.00     2.00      .00 
+ IFI READS Reqs                                   5     5.00     5.00      .00 
+ IFI WRITE Reqs                                   0      .00      .00      .00 
+ Data Capture Invoked                             0      .00      .00      .00 
+ Data Capture READS                               0      .00      .00      .00 
+ Data Capture Rec Returned                        0      .00      .00      .00 
+ Data Capture Row Returned                        0      .00      .00      .00 
+ Data Capture Desc Returned                       0      .00      .00      .00 
+ Data Capture Desc Performed                      0      .00      .00      .00 
+ Data Capture Table Returned                      0      .00      .00      .00 
+ Rollup (Threshold)                               0      .00      .00      .00 
+ Rollup (Storage)                                 0      .00      .00      .00 
+ Rollup (Stallness)                               0      .00      .00      .00 
+ Rollup (Non Qual)                                0      .00      .00      .00 
===============================================================================

Navigation

For additional information about

related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

Fields

Collection Interval

The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.

Start

The start time of the interval currently displayed.

Report Interval

This field determines the report interval. It is set on the Near-Term History Report Option panel.

Combine Level

This field reflects the selected combine level. If Combine Level is NONE, the report interval is the same as the collection interval. Possible values:

HOURLY: Data will be reported in hourly intervals.
NONE: Data will be reported in the time unit specified by the collection interval.

End

The end time of the interval currently displayed.

High Used Log Record RBA

The relative byte address (RBA) of the record that was being logged at the end of the interval.

Number of Bytes Used

The number of bytes of the log data set that were used during the interval.

For each of the following fields, the following statistics are provided:

INTERVAL QUANTITY: The amount of activities that occur during the interval.
/MINUTE: Rate per minute. The number under /MINUTE (in parentheses) is the number of minutes in the interval.
/THREAD: Rate per thread. The number under /THREAD (in parentheses) is the number of Create Threads during the interval.
/COMMIT: Rate per Commit. The number under /COMMIT (in parentheses) is the number of Commit requests (including abort requests) during the interval.

Reads from Output Buffers: The Reads that were satisfied from the output buffers.
Reads from Active Log: The Reads that were satisfied from the active log.
Reads from Archive Log: The Reads that were satisfied from the archive log.
Reads Delayed - Tape Contention: The number of reads delayed because a tape volume was already in use.
Reads Delayed - No Tape Unit: Number of archive log reads that were delayed because of unavailable tape units, or because the maximum amount of read parallelism is being used (not likely).
Look-Ahead Tape Mounts Attempted: Number of look-ahead tape mounts attempted.
Look-Ahead Tape Mounts Performed: Number of successful look-ahead tape mounts.
Write NOWAIT Requests: The times Db2 externalized log records asynchronously.
Write FORCE Requests: The times Db2 externalized log records synchronously.
Write Delayed - No Buffer: Db2 attempts to place log records in the output buffer when no log buffer could be found.
Write Active Log Buffers: Calls to the log write routine.
Active Log CIs Created: Active log control intervals created.
Archive Log Read Allocations: Archive read allocations, which reflect archive log open/close activity.
Archive Log Write Allocations: Archive write allocations, which reflect archive log open/close activity.
Archive Log CIs Offloaded: Number of active log control intervals offloaded to archive data sets.
BSDS Access Requests: Calls to the bootstrap data set access routine.
Checkpoints: The number of checkpoints Db2 takes since startup.
IFI Abends: The count of IFI abends.
IFI Unrecog Func: The count of IFI unrecognized functions.
IFI Command Reqs: The count of IFI command requests.
IFI READA Reqs: The count of IFI READA requests.
IFI READS Reqs: The count of IFI READS requests.
IFI WRITE Reqs: The count of IFI WRITE requests.
Data Capture Invoked: The number of log records retrieved for which data capture processing is invoked.
Data Capture READS: The number of data capture log reads for processing IFI requests for IFCID 0185.
Data Capture Rec Returned: The number of data capture log records returned.
Data Capture Row Returned: The number of data capture data rows returned.
Data Capture Desc Returned: The number of data capture data descriptions returned.
Data Capture Desc Performed: The number of data capture describes performed.
Data Capture Table Returned: The number of data capture tables returned.
Rollup (Threshold): The number of rollup accounting records that are written because the rollup threshold is exceeded.
Rollup (Storage): The number of rollup accounting records that are written because the rollup accounting storage threshold is exceeded.
Rollup (Stallness): The number of rollup accounting records that are written because the staleness threshold is exceeded.
Rollup (Non Qual): The number of records that failed to qualify for accounting rollup because all rollup key fields are NULL, or NULL values are not permitted.