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
CA value WAIT-STMT-TYPE-FLG is based on IBM field QW0337TY
IBM's description WAITER TYPE
The waiter statement information.
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