CICSplex DB2 Task Activity attribute group

The CICSplex DB2 Task Activity attributes report on the task activity for each monitored CICS region. Use the CICSplex DB2 Task Activity attributes in situations to determine if the percentage of waits per DB2 resource control table (RCT) entry is high. These attributes provide data for the DB2 Task Activity table view.

Note: The attributes within the CICSplex DB2 Task Activity group are stored for historical retrieval within the Tivoli Data Warehouse. Selected attributes within this group are candidates for the Tivoli Data Warehouse summarization and pruning features.

Abort Percent Indicates the percentage of DB2 transactions that ended abnormally. The value format is a percentage in the range 0-100.

CICS Region Name Indicates the job name or modify ID of the CICS region being monitored. Each CICS region in a z/OS operating system has a unique name. This name is an alphanumeric string, with a maximum of eight characters, and case-sensitive. CICS region names are always in uppercase characters.

DB2 Entry Name The name of the installed DB2ENTRY that is known to CICS. The value format is an alphanumeric string, maximum eight bytes.

Maximum Active Threads Indicates the maximum active threads per DB2 resource control table (RCT) entry. This attribute does not report values in releases of CICS Transaction Server 1.2 and later. The value format is an integer, maximum 2 bytes, and in the range of 0-32767.

Number of Aborts The peak number of SQL requests that were aborted. The value is in the range of 0 - NOLIMIT.

Number of Calls The peak number of calls to the CICS-DB2 RMI adapter.

Number of Tasks The peak number of tasks to the CICS-DB2 RMI adapter.

Number of Waits The peak number of SQL requests that waited for resources. The value is in the range of 0 - NOLIMIT.

Origin Node Is the combination of z/OS System ID (SMFID) and CICS region name. The value format is an alphanumeric string, maximum 32 bytes, and case-sensitive.

When a situation is true, the system compares the origin node name in the attribute to the names of managed systems assigned to the item. If the origin node name matches the name of a managed system, the status of the item changes accordingly. If the names of the origin node and the managed systems do not match, the status of the item remains unchanged.

System ID Indicates the four-character name that uniquely identifies an active z/OS operating system within a given CICSplex. The value format is an alphanumeric string, maximum four characters, and case-sensitive. z/OS System IDs are always in uppercase characters.

Threads in Use The peak number of threads currently in use for SQL requests. The value is in the range of 0 - NOLIMIT.

Threads in Use HWM The peak number of threads currently in use for SQL requests HWM (high-water-mark). The value is in the range of 0 - NOLIMIT.

Threads in Use Percent Indicates the percentage of DB2 threads in use per DB2 resource control table (RCT) entry. The value format is a percentage in the range 0-100.

Threads in Use Percent HWM Indicates the percentage of the peak number (high water mark) of active threads for the DB2 entry. The value format is a percentage in the range 0-100.

Transaction ID Indicates the ID of the transaction that is using the CICS-DB2 attachment facility. The value format is an alphanumeric string, maximum four characters, and case-sensitive.

Wait Percent Indicates the percentage of waits per DB2 resource control table (RCT) entry. The value format is a percentage in the range 0-100.