Db2 SRM Log Manager attributes
Use the Db2 SRM Log Manager attributes to create situations to monitor the Db2 log manager activity.
Active Log CIs Rate The number of active log control intervals (CIs) created per second over the last sampling period.
Archive CIs Offloaded Rate The number of archive log write CIs offloads per second over the last sampling period.
Archive Read Allocation Rate The number of archive log read allocations per second over the last sampling period.
Archive Recording Mode The recording mode for the archive can be either dual or single. It is an alphanumeric text string, with a maximum length of one character.
Archive Write Allocation Rate The number of archive log write allocations per second over the last sampling period.
Begin RBA The lowest Relative Byte Address (RBA) in the log of the primary data set (Db2 11).
BSDS Access Rate The number of BSDS access requests per second over the last sampling period.
Checkpoint Frequency The number of bytes in the output buffer before a checkpoint is performed.
Current RBA The current Relative Byte Address (RBA) in the log of the primary data set (Db2 11).
It is an alphanumeric text string, with a maximum length of 20 characters. For Db2 11, the RBA can consist of up to 10 bytes. For versions prior to Db2 11, the RBA can consist of up to 6 bytes.
Current Relative Byte Address The current Relative Byte Address (RBA) in the log of the primary data set. It is an alphanumeric text string, with a maximum length of 12 characters.
Data Set Size The size of the current logging data set.
Data set Utilization The percentage of the current data that is in use. Valid entry ranges from 0.0 to 100.0.
Delta Active Log CIs The number of active log CIs created during the last sampling period.
Delta Archive CIs Offloaded The number of archive log CIs offloads during the last sampling period.
Delta Archive Read Allocation The number of archive log read allocations during the last sampling period.
Delta Archive Write Allocation The number of archive log write allocations during the last sampling period.
Delta BSDS Access The number of BSDS access requests during the last sampling period.
Delta LookAhead Tape Failed The number of look ahead tape mounts not satisfied during the last sampling period.
Delta LookAhead Tape Performed The number of look ahead tape mounts performed during the last sampling period.
Delta LookAhead Tape Requests The number of look ahead tape mounts attempted during the last sampling period.
Delta Reads Active Archive Log The number of reads from the active archive log during the last sampling period.
Delta Reads Active Log The number of reads from the active log during the last sampling period.
Delta Reads Delayed No Control Unit The number of reads delayed because no tape control unit during the last sampling period.
Delta Reads Delayed Contention The number of reads delayed as a result of the tape contention during the last sampling period.
Delta Reads Output Log Buffer The number of reads from the output log buffer during the last sampling period.
Delta Write Active Buffer The number of write active log buffer during the last sampling period.
Delta Write Delay No Buffer The number of write delays as a result of no buffers during the last sampling period.
Delta Write Force The number of write force requests during the last sampling period.
Delta Write Nowait The number of write NOWAIT requests during the last sampling period.
Delta Write Wait The number of write wait requests during the last sampling period.
End RBA The highest Relative Byte Address (RBA) in the log of the primary data set (Db2 11).
It is an alphanumeric text string, with a maximum length of 20 characters. For Db2 11, the RBA can consist of up to 10 bytes. For versions prior to Db2 11, the RBA can consist of up to 6 bytes.
Filler A placeholder to keep fullword alignment.
High Relative Byte Address The highest Relative Byte Address (RBA) in the log of the primary data set. It is an alphanumeric text string, with a maximum length of 12 characters.
Input Buffer Size The size of the log input buffer.
Interval Time The number of seconds since last sample.
Log Recording Mode The recording mode for the log, which can be either dual or single. It is an alphanumeric text string, with a maximum length of one character.
Logs Available The number of log data sets that are currently available.
Logs Defined The number of log data sets that have been defined.
Look Ahead Tape Failed Rate The number of look ahead tape mounts not satisfied per second over the last sampling period.
Look Ahead Tape Performed Rate The number of look ahead tape mounts performed per second over the last sampling period.
Look Ahead Tape Requests Rate The number of look ahead tape mount attempts per second over the last sampling period.
Low Relative Byte Address The lowest Relative Byte Address (RBA) in the log of the primary data set. It is an alphanumeric text string, with a maximum length of 12 characters.
Next Checkpoint The number of bytes before next checkpoint is to be performed.
Originating System ID The managed system name of the agent. It is an alphanumeric text string, with a maximum of 32 characters; for example, DB91:SYS1:DB2.
Output Buffersize The size of the log output buffer.
Percent Logs Available The percentage of active log data sets that are currently available.
Primary Data Set Name The current name of the log of the primary data set. It is an alphanumeric text string, with a maximum length of four characters.
Read Active Archive Log Rate The number of reads per second from the active archive log over the last sampling period.
Read Active Archive Log Rate The number of reads from the active log per second over the last sampling period.
Read Output Log Buffer Rate The number of reads from the output log buffer per second over the last sampling period.
Reads Delayed Contention Rate The number of reads delayed because the tape contention per second over the last sampling period.
Reads Delayed NoCU Rate The number of reads delayed as a result of no tape control unit per second over the last sampling period.
Secondary Data Set Name The current name of the log of the secondary data set. It is an alphanumeric text string, with a maximum length of four characters.
Time Stamp The date and time, as set on the monitored system, indicating the instance when the agent collects information.
Total Active Log CIs The total number of active log CIs created.
Total Archive CIs Offloaded The total number archive log CIs offloads.
Total Archive Read Allocation The total number of archive log read allocations.
Total Archive Write Allocation The total number of archive log write allocations.
Total BSDS Access The total number of BSDS access requests.
Total Look Ahead Tape Failed The total number of look ahead tape mounts not satisfied.
Total Look Ahead Tape Performed The total number of look ahead tape mounts performed.
Total Look Ahead Tape Requests The total number of look ahead tape mounts attempted.
Total Reads Active Archive Log The total number of reads from the active archive log.
Total Reads Active Log The total number of reads from the active log.
Total Reads Delayed Contention The total number of reads delayed as a result of tape contention.
Total Reads Delayed No Control Unit The total number of reads delayed as a result of no tape control unit.
Total Reads Output Log Buffer The total number of reads from the output log buffer.
Total Write Active Buffer The total number of write active log buffers.
Total Write Delay No Buffer The total number of writes delayed as a result of no buffer.
Total Write Force The total number of write force requests.
Total Write Nowait The total number of write nowait requests.
Total Write Wait The total number of write wait requests.
Write Active Buffer Rate The number of write active log buffers per second over the last sampling period.
Write Delay No Buffer Rate The number of write delays per second as a result of no buffer over the last sampling period.
Write Force Rate The number of write force requests per second over the last sampling period.
Write Nowait Rate The number of write nowait requests per second over the last sampling period.
Write Threshold Write threshold.
Write Wait Rate The number of write wait requests per second over the last sampling period.