SMF DB2 fields of IFCID 63

QW0063LL

(Integer)

Len

Length of SQL statement in SMF record plus 2

This field might be used to determine if the SQL statement has been truncated. The maximum length SQL statement in IFCID 63 is 5000 bytes, so a value for QW0063LL of 5002 indicates likely truncation. Further, a value greater than 1502 or 2502 respectively indicates that  QW0063ST_1500 or QW0063ST_2500 has been truncated.

QW0063SI ¹

(Integer)

StmtID

Statement identifier

QW0063ST

(EGNX)

Sql

request

Statement requested to be parsed

Host variables in SQL statements are represented as : H. The SQL statement is truncated after 5000 bytes.

QW0063ST_1023

(EGNX)

Sql

cs1

QW0063ST truncated to 1023 bytes

QW0063ST_1500

(EGNX)

Sql

QW0063ST truncated to 1500 bytes

QW0063ST_2500

(EGNX)

Sql

QW0063ST truncated to 2500 bytes

QW0063TY ¹

StmtType

Type of statement, represented as 80 for dynamic or 40 for static

QW0063TYD ¹

(Mapped Integer)

StmtType

Type of statement, represented as Dynamic or Static