IFCID 030 - EDM Request End

This topic shows detailed information about Record Trace - IFCID 030 - EDM Request End.

EDM REQUEST< -- NETWORKID:  DEIBMIPS  LUNAME:  IPSAU851  LUWSEQ:     1
 END           EDMID       CT    PLAN    HSRTEP2L
               RDS  X'FFFFFFFE'  SEQNO          2  CT CALLS         1
EDM REQUEST< -- 'BLANK'
 END           NETWORKID:  DEIBMIPS  LUNAME:  IPSAU851  LUWSEQ:     1
               EDMID       CT    PLAN    HSRTEP2L
               RDS  X'00000001'  SEQNO          2  CT CALLS         1
EDM REQUEST< -- 'BLANK'
 END           NETWORKID:  DEIBMIPS  LUNAME:  IPSAU851  LUWSEQ:     1
               EDMID       PT
EDM REQUEST--> NETWORKID:  DEIBMIPS  LUNAME:  IPUAQB61  LUWSEQ:     1
 END           EDMID       DY                                        
               SCHEMA NAME     =   SCHEMA1                                  
               HASH ID X'00000000000000000000000000000000'           
               COPY ID     0  DPS QUERY ID                      0    
               RELEASE BOUND X'00'   RECORDS READ       0                                

LOCATION    N/P
COLLECTION  HSRTEP2VL1XXXXXXXXX2XXXXXXXXX3XXXXXXXXX4X
XXXXXXXX5XXXXXXXXX6XXXXXXXXX7XXXXXXXXX8XX
XXXXXXX9XXXXXXXXX0XXXXXXXXX1XXXXXXXXX2XXX
XXXXZ
PACKAGE ID  DSN@EP2L@@@@@@@@@@
CONSISTENCY TOKEN  X'0000000000000000'
RDS  X'00000000'  SEQNO          0  PT CALLS         1
QW0030SV  X'0000'

EDMID

The type of request:

DB

Database descriptor

DY

SYSDYNQRY table

CT

Cursor table

PT

Package table

Field Name: QW0030ID

DBID

The database ID. Deduced from the Db2 fields QW0030DB, QW0105DN, or QW0107DN.

When present, the database name is shown, otherwise the decimal identifier from QW0030DB is shown, or N/A when this value is 0.

Field Name: RT0030DB

DB CALLS

The number of calls to the data manager for the DBD.

Field Name: QW0030DC

PLAN

The plan name for the CT or XT request.

Field Name: QW0030PL

RDS

The RDS identifier number for CT. Special cases are:

x'00000001'

SKCT header

x'FFFFFFFE'

SKCT directory

Field Name: QW0030RN

RDS

The RDS identifier number for PT. Special cases are:

x'00000001'

SKCT header

x'FFFFFFFE'

SKCT directory

Field Name: QW0030KN

SEQNO

The sequence number within the RDS number. This is QW0030SN for CT or QW0030GN for PT.

Field Name: RT0030SN

CT CALLS

The number of calls to the data manager for CT.

Field Name: QW0030CC

LOCATION

The name of the package location. This field shows "BLANK" if the local location name is not defined.

Field Name: QW0030LN

COLLCTN

The collection identifier of the package.

Field Name: QW0030CI

PCKG ID

The package identifier.

Field Name: QW0030PI

CONSISTENCY TOKEN

The consistency token of the package.

Field Name: QW0030CT

PT CALLS

The number of calls to the data manager for PT.

Field Name: QW0030GC

SCHEMA NAME

The name of the schema.

Field Name: QW0030SC

HASH ID

The hash ID.

Field Name: QW0030QH

COPY ID

The Copy ID.

Field Name: QW0030CP

DPS QUERY ID

The identifier of the stabilized dynamic query.

Field Name: QW0030QD

RELEASE BOUND

The release bound.

Field Name: QW0030RB

RECORDS READ

The number of records read.

Field Name: QW0030QC