IFCID 381 - UDF Detail Record

This topic shows detailed information about Record Trace - IFCID 381 - UDF Detail Record.

IFCID 380 (Stored procedure detail record) and IFCID 381 (UDF detail record) have the same mapping structure.

Both records are written at the beginning and the end of a stored procedure or UDF.

The first data section of IFCID 380 shows fields provided with IFCID 233. The second data section starting with CURRENT TOTAL NESTED CLASS 1 CP TIME shows additional fields for IFCID 380 and IFCID 381.

Record trace - IFCID 381 - UDF Detail Record

The field labels shown in the following sample layout of Record Trace - IFCID 381 - UDF Detail Record are described in the following section.


MTS      SERVER   C9180047463A MTS              BRUNECK                       CLP I498-UDF-run-UDF1.sql
MTS      db2bp.ex DRDA        08:37:02.09533860    549   1 381 UDF            NETWORKID:  G998CD69  LUNAME:  GD02      LUWSEQ:   169
DISTSERV e                           1.41514242                DETAIL RECORD  ACCTKN X'5CD3D6C3C1D34BC4C2F24BF1F2F0F2F0F8F0F8F3F2F2'
!-------------------------------------------------------------------------------------------------------------------------
!LOCATION NAME: PMODA11
!COLLECTION ID: NULLID
!PROGRAM NAME : SQLC2H22
!SCHEMA NAME  : MTS
!ROUTINE NAME : I498_TIMES1000
!VERSION NAME : V1
!ROUTINE TYPE : FUNCTION
!CONSISTENCY TOKEN: X'4141414141464462'  ENTRY/EXIT TYPE:  ENTERING
!NESTING LEVEL:          0
!
!STATEMENT NO :                   210    TYPE         : DYNAMIC                  ROUTINE ID   : X'0000000080000450'
!STATEMENT ID :                   973    CONV INTO HEX: X'00000000000003CD'
!
!CURRENT TOTAL NESTED CLASS 1 CP TIME     :         0.000000 CURRENT TOTAL NESTED CLASS 1 SE TIME     :         0.000000
!CURRENT TOTAL NESTED CLASS 2 CP TIME     :         0.000000 CURRENT TOTAL NESTED CLASS 2 SE TIME     :         0.000000
!CURRENT TOTAL NESTED ELAPSED CLASS 2 TIME:         0.000000

LOCATION NAME

The location name.

Field Name: QW0233LN

COLLECTION ID

The package collection identifier.

Field Name: QW0233PC

PROGRAM NAME

The program name.

Field Name: QW0233PN

SCHEMA NAME

The name of the schema associated with this routine.

Field Name: QW0233SC

ROUTINE NAME

The specific name of the routine.

Field Name: QW0233PR

VERSION NAME

The name of the version.

Field Name: QW0233VER

ROUTINE TYPE

The routine type can have the following values:

PROCEDURE: The routine is a stored procedure
FUNCTION: The routine is a User-Defined Function

Field Name: QW0233TY

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0233TS

ENTRY/EXIT TYPE

The entry or exit event type can have the following values:

ENTERING: The agent is entering a routine.
RETURNED: The agent has returned from a routine.

Field Name: QW0233EX

NESTING LEVEL

The nesting level of the routine.

Field Name: QW0233NL

STATEMENT NO

The statement number of the statement executed.

Field Name: QW0233SN

TYPE

The statement type. Possible values are DYNAMIC or STATIC.

Field Name: QW0233STY

ROUTINE ID

The routine identifier.

Field Name: QW0233RID

STATEMENT ID

The unique identifier of the currently executing statement. It is shown as an integer and in hexadecimal format.

Field Name: QW0233SID

CONV INTO HEX

The unique identifier of the currently executing statement. It is shown as an integer and in hexadecimal format.

Field Name: QW0233SID

CURRENT TOTAL NESTED CLASS 1 CP TIME

The current, total, nested class 1 CP time. This does not include time spent executing on an IBM specialty engine.

Field Name: QW0380_CLS1CP

CURRENT TOTAL NESTED CLASS 1 SE TIME

The current, total, nested class 1 specialty engine time.

Field Name: QW0380_CLS1SE

CURRENT TOTAL NESTED CLASS 2 CP TIME

The current, total, nested class 2 CP time. This is time in the Db2 processing SQL statements. This time also includes in Db2 time needed to connect and disconnect the SP task for non-SQL procedure stored procedures. This does not include time spent executing on an IBM specialty engine.

Field Name: QW0380_CLS2CP

CURRENT TOTAL NESTED CLASS 2 SE TIME

The current, total, nested class 2 specialty engine time. This is the time in Db2 processing SQL statements.

Field Name: QW0380_CLS2SE

CURRENT TOTAL NESTED ELAPSED CLASS 2 TIME

The current, total, nested elapsed class 2 time. This is the time in Db2 processing SQL statements. This time also includes in Db2 time needed to connect and disconnect the SP task for non-SQL procedure stored procedures.

Field Name: QW0380_CLS2ELAP