IFCID 497 - Non Nested Statement ID Record

This topic shows detailed information about Record Trace - IFCID 497 - Non Nested Statement ID Record.

IFCID 497 (Non Nested Statement ID Record), IFCID 498 (UDF Statement ID Record), and IFCID 499 (Stored Procedure Statement ID Record) have the same mapping structure comprising two data sections.

Record trace - IFCID 497 - Non Nested Statement ID Record

The field labels shown in the following sample layout of Record Trace - IFCID 497 - Non Nested Statement ID Record are described in the following section.


MTS      db2bp.ex DRDA        08:37:00.26148762    543   1 497 STMT ID RECORD NETWORKID:  G998CD69  LUNAME:  GD02      LUWSEQ:   168
DISTSERV e                           0.97691653                NON-NESTED     ACCTKN X'5CD3D6C3C1D34BC4C2F24BF1F2F0F2F0F8F0F8F3F2F2'
!-------------------------------------------------------------------------------------------------------------------------
!REASON IFCID WAS EXTERNALIZED:  TRANSACTION/ACCOUNTING INTERVAL IS ENDING
!
!STATEMENT ID :                    52    CONV INTO HEX: X'0000000000000034'      EXECUTIONS   :                     1
!TYPE         :               DYNAMIC
!-------------------------------------------------------------------------------------------------------------------------

REASON IFCID WAS EXTERNALIZED

Identifies the reason why this IFCID was externalized.

Field Name: QW0499RS

STATEMENT ID

The unique statement idenfier. It is shown as an integer and in hexadecimal format.

Field Name: QW0499SID

CONV INTO HEX

The unique statement idenfier. It is shown as an integer and in hexadecimal format.

Field Name: QW0499SID

EXECUTIONS

The number of executions.

Field Name: QW0499NEC

TYPE

The statement type. Possible values are DYNAMIC or STATIC. In addition, the statement type of IFCID 499 can also have the values STATIC CALL or DYNAMIC CALL.

Field Name: QW0499STY