IQL with SYSVIEW for DB2 for IFCID 337 – LOCK ESCALATION
book
Article ID: 113222
calendar_today
Updated On:
Products
SYSVIEW Performance Management Option for DB2 for z/OS
Issue/Introduction
WAIT-STMT-TYPE-FLG value
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
Resolution
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