search cancel

IQL with SYSVIEW for DB2 for IFCID 337 – LOCK ESCALATION

book

Article ID: 113222

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer 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