How display OWNING-STMT-TYPE which is hexadecimal value ?
search cancel

How display OWNING-STMT-TYPE which is hexadecimal value ?

book

Article ID: 122790

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

displaying OWNING-STMT-TYPE as a hexadecimal value

How to display OWNING-STMT-TYPE which is hexadecimal value ?
% OWNING-STMT-TYPE (PF=N1) % OWNING-STMT-TYPE (PF=N6) work not fine.

Environment

z/osĀ  DB2

Resolution

Try PF=H2


from the docs
H - Hexadecimal The field is printed in hex format. The field column width is the number of hex digits. For example: (PF=H8) would print as 000007A8