SMF 100 fields, IFCID 2

QWACNID

(EGNX)

RecovTok

Network ID value from CCB (IFCID 3 only)

QWACRINV

Reas

Reason accounting is invoked (IFCID 3 only)

QXST

SQLcounts

SQL statement counters

Formatted for DB2 11 and preceding only. Number of SQL actions of various types, including all of the counters of QXST_V10 and more.

QXST_V10

SQL 

SQL statement counters

Formatted for DB2 10 and as follows only. Number of statements of each type invoked, including Select, Insert, Update, Delete, Describe, Prepare, Open, Close, Create Table, Create Index, Create Tables, Create Synonym, Create Database, Create Store Group, Create View, Drop Index, Drop Table, Drop Tablespace, Drop Database, Drop Synonym, Drop Store Group, Drop View, Alter Store Group, Fetch, Alter Tablespace, Alter Table, Alter Index, Comment On, Lock Table, Grant, Revoke, Incremental Bind, Label On, Set SQL ID, Create Alias and Drop Alias.