SMF100_1_V2 record type

Edit online

The SMF100_1_V2 records contain Db2® for z/OS® statistics data for CICS® Transaction Server for z/OS. These records provide information about potential problems in the Db2 subsystems that are due to database deadlocks, database timeouts, and suspended database operations. In addition, they provide metrics on SQL calls, such as the number of SQL inserts, updates, and deletes.

Data stream definition for SMF100_1_V2 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.

Table 1. Data stream definition for SMF100_1_V2 data
Type of node in the policy Required configuration value
Data Stream SMF100_1_V2
To select this data stream in the Configuration Tool: In the Select data stream window, click IBM Z Operational Log and Data Analytics > Database > Db2 > Statistical, and select the SMF100_1_V2 checkbox.
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_V2 data

Table 2. Annotated fields for SMF100_1_V2 data
Field Description Corresponding SMF field
DB2_SYSTEM_ID The Db2 system ID, which is also the SMF subsystem ID. SM100SSI
DEADLOCKS The number of times deadlocks were detected. QTXADEA
LATCH_SUSPENDS

Number of latch suspends.

The number of times a lock was not obtained because of a latch conflict, and the unit of work was suspended.

 QTXASLAT
LOCK_SUSPENDS The number of times a lock was not obtained, and the unit of work was suspended. QTXASLOC
LOCK_TIMEOUTS The number of times a unit of work was suspended for a period of time that exceeded the timeout value. QTXATIM
MVS_SYSTEM_ID The MVS system ID, which is also the SMF system ID. SM100SID
OTHER_SUSPENDS

Number of other suspends.

The number of times a lock was not obtained because of a conflict, other than a lock or a latch conflict.

 QTXASOTH
SQL_CLOSE The number of the CLOSE statements that are executed. QXACLOSE
SQL_DELETE The number of the DELETE statements that are executed. QXADELET
SQL_DELETED_ROWS The number of rows that are deleted. QXARWSDELETD
SQL_DESCRIBE The number of the SQL DESCRIBE statements that are issued. QXADESC
SQL_FETCH The number of the FETCH statements that are executed. QXAFETCH
SQL_FETCHED_ROWS The number of rows that are fetched. QXARWSFETCHD
SQL_INSERT The number of the SQL INSERT statements that are issued. QXAINSRT
SQL_INSERTED_ROWS The number of rows that are inserted.  
SQL_MERGE The number of times a MERGE statement was executed. QXAMERGE
SQL_OPEN The number of the OPEN statements that are executed. QXAOPEN
SQL_PREPARE The number of the SQL PREPARE statements that are issued. QXAPREP
SQL_SELECT The number of the SQL SELECT statements that are issued. QXASELECT
SQL_UPDATE The number of the SQL UPDATE statements that are issued. QXAUPDTE
SQL_UPDATED_ROWS The number of rows that are updated. QXARWSUPDTD
SSID Subsystem ID. SM100SSI
TIMESTAMP The time the record was written to the SMF buffer. timestamp
TOTAL_SUSPENDS The total number of suspends, including the lock, latch, and other suspends. QTXASLOC + QTXASLAT + QTXASOTH
UPDATE_NAME SMF100_1_V2 NONE
UPDATE_VERSION The version of the sourceType record. NONE