SMF100_1 record type
The SMF100_1 records contain Db2® for z/OS® statistics data for CICS® Transaction Server for z/OS. These records provide
information about potential problems in Db2 subsystems that
are due to database deadlocks, database timeouts, and suspended database operations.
Data stream definition for SMF100_1 data
For prerequisite requirements for defining SMF data streams, see Copying configuration files to the working directory.
Table 1 indicates the configuration values to use in defining this data stream in the Z Common Data Provider Configuration Tool.
| Type of node in the policy | Required configuration value |
|---|---|
| Data Stream | SMF100_1 To select this data stream in the Configuration Tool: In the
Select data streamwindow, click , and select the SMF100_1 check box. |
| Filter Transform | Not required |
| Subscriber |
For the appropriate values, see Subscriber configuration. Important: When you use the Generic Kafka subscriber protocol, you must select the CSV
format. Key-Value format is not supported for this data stream definition.
|
Annotated fields for SMF100_1 data
| Field | Description |
|---|---|
DB2_SYSTEM_ID |
Db2 system ID, which is also the SMF subsystem ID |
DEADLOCKS |
The number of times that deadlocks were detected |
hostname |
Host name |
LATCH_SUSPENDS |
The number of latch suspensions |
LOCK_SUSPENDS |
The number of times that a lock cannot be obtained, and the unit of work is suspended |
LOCK_TIMEOUTS |
The number of times that a unit of work was suspended for a period of time that exceeds the timeout value |
MVS_SYSTEM_ID |
MVS™ system ID, which is also the SMF system ID |
OTHER_SUSPENDS |
The number of suspensions that are caused by something other than lock or latch |
sourcename |
Source name |
SSID |
Subsystem ID |
sysplex |
Sysplex name |
system |
System name |
TIMESTAMP |
Time stamp |
timezone |
Time zone offset |
TOTAL_SUSPENDS |
The sum of the values of the following fields:
|