IFCID 053 - SQL Describe/Commit/Rollback/Remote Statement

This topic shows detailed information about Record Trace - IFCID 053 - SQL Describe/Commit/Rollback/Remote Statement.

If this event is not recognized, UNRECOG CMD is printed.

The following data is printed in the DATA column:

Record trace - IFCID 053 - SQL Describe/Commit/Rollback/Remote Statement

The field labels shown in the following sample layout of Record Trace - IFCID 053 - SQL Describe/Commit/Rollback/Remote Statement are described in the following section.


LOCATION NAME         : OMPDBZ4                                                                                           
PKG COLLECTION ID     : DSNTIA10                                                                                          
PROGRAM NAME          : DSNTIAD                                                                                         
CONSISTENCY TOKEN     : X'18B61ACB02FABE19'                                       SECTION NUMBER     : 1                                         
STATEMENT NUMBER      :            1989  QUERY COMMAND ID :  X'0000000000000000'  QUERY INSTANCE ID:  X'0000000000000000' 
SQL REQUEST TYPE      :               0  EXPANSION REASON :  X'0000000000000000'
                                                                     SQLCODE :        -805       SQLSTATE:    51002       
SQLCAID: SQLCA         SQLCABC          136                          SQLERRP : DSNXEPM           SQLEXT  :    51002       
SQLERRD1        -100   SQLERRD2           0   SQLERRD3           0   SQLWARN0:     SQLWARN1:     SQLWARN2:    SQLWARN3:   
SQLERRD4          -1   SQLERRD5           0   SQLERRD6           0   SQLWARN4:     SQLWARN5:     SQLWARN6:    SQLWARN7:   
                                                                     SQLWARN8:     SQLWARN9:     SQLWARNA:                
SQLERRM: PMODBE1.NULLID.SYSSH200.5359534C564C3031 DISTSERV 04                                                             
......................................................................................................................... 
DATA TYPE       INDX ROW PROC           2 ROW EXAM          1 STG1-QUAL          1 STG2-QUAL         0 ROW INSRT         0
ROW UPDTE          0 ROW DELET          0 PAGES            17 RI SCAN            0 RI DELET          0                    
DATA TYPE       SEQD ROW PROC           2 ROW EXAM          2 STG1-QUAL          0 STG2-QUAL         0 ROW INSRT         0
ROW UPDTE          0 ROW DELET          0 PAGES             2 RI SCAN            0 RI DELET          0

LOCATION NAME

The location name.

Field Name: QW0053LN

PKG COLLECTION ID

The package collection identifier.

Field Name: QW0053PC

PROGRAM NAME

The name of the program.

Field Name: QW0053PN

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0053TS

SECTION NUMBER

The section number of the Relational Data system Input parameter list (RDI).

Field Name: QW0053SECTN

STATEMENT NUMBER

The number of the statement executed.

Field Name: QW0053SN

QUERY COMMAND ID

The ID of the query command.

Field Name: QW0053QID

QUERY INSTANCE ID

The ID of the query instance.

Field Name: QW0053CID

SQL REQUEST TYPE

The type of SQL request.

Field Name: QW0053TOS

EXPANSION REASON

The reason for the expansion. It can have the following values:

GET_ARCHIVE: Expansion caused by built-in SYSIBMADM.GET_ARCHIVE global variable.
TEMPORAL BUSINESS_TIME: Expansion caused by the current temporal BUSINESS_TIME special register.
TEMPORAL SYSTEM_TIME: Expansion caused by the current temporal SYSTEM_TIME special register.
TEMPORAL SYSTEM_TIME & BUSINESS_TIME: Expansion caused by the current temporal SYSTEM_TIME & current temporal BUSINESS_TIME special registers.
NO EXPANSION: The query does not contain any expansion.

Field Name: QW0053ER

SQLCA CONTENTS

This section contains the SQLCA fields. It is only printed if the value in the ENTRY/EXIT TYPE field is RETURNED.

Field Name: QW0053SQ

DATA TYPE

The scan type identification:

INDX: Index scan
SEQD: Sequential data scan
SEQW: Sequential data work-file scan

Field Name: QW0053ID

ROW PROC

The number of rows processed.

Field Name: QW0053RP

ROW EXAM

The number of rows examined. If DATA TYPE shows INDX, this number is the number of index entries (not rows) scanned.

Field Name: QW0053LA

STG1-QUAL

The number of rows qualified at stage 1.

Field Name: QW0053DQ

STG2-QUAL

The number of rows qualified at stage 2.

Field Name: QW0053RQ

ROW INSRT

The number of rows inserted.

Field Name: QW0053IN

ROW UPDTE

The number of rows updated.

Field Name: QW0053UP

ROW DELET

The number of rows deleted. If the delete was a mass delete, the indicator MASS is printed.

Field Name: QW0053DE

PAGES

The number of get page requests issued by the data manager to the buffer manager. Note that for an index scan the value includes the number of index pages scanned.

Field Name: QW0053PS

RI SCAN

The number of additional pages scanned for referential integrity.

Field Name: QW0053PR

RI DELET

The number of additional rows deleted for referential integrity.

Field Name: QW0053DR