How to convert the CICS task ID from hex to decimal using Sysview for DB2 for z/OS

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

In a Sysview PMO for Db2 for z/OS (IDB2) Insight Query Language (IQL) request, is there a way to convert the CICS Task ID from hex to decimal when
printing a message on the MVS console?

Resolution

The "PF" parameter in IDB2 is available for users to specify the print format of the field. To print as decimal, use "N" value, such as:
CICS-TASKID (PF=Nx) where "x" is the field column width

For example, the hex value for the CICS Task ID field is BC63, specifying:
CICS-TASKID (PF=N5) would print as 48227