IQL with SYSVIEW for DB2 for IFCID 337 – LOCK ESCALATION

Document ID : KB000113222
Last Modified Date : 20/09/2018
Show Technical Document Details
Introduction:
WAIT-STMT-TYPE-FLG value
Question:
we are writing a IQL with SYSVIEW for DB2 for IFCID 337 – LOCK ESCALATION REPORT
And we are getting 'Unkown' a result of one of the records ,
We checked the value that is in the SMF and it is x'00' and there is no mapping for it in the example IQL
Environment:
z/os db2
Answer:
CA value WAIT-STMT-TYPE-FLG is based on IBM field QW0337TY
IBM's description WAITER TYPE
The waiter statement information.
Possible values:
STATIC The statement is of type static.
DYNAMIC The statement is of type dynamic.
NONE (NO ID, NO TYPE) No statement ID, no type.
Field Name: QW0337TY

So it seems fine that you might get an UNKNOWN value. Just chnge your Code to say NONE from UNKNOWN