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