IFCID 065 - Open Cursor

This topic shows detailed information about Record Trace - IFCID 065 - Open Cursor.

Record trace - IFCID 065 - Open Cursor

The field labels shown in the following sample layout of Record Trace - IFCID 065 - Open Cursor are described in the following section. 


CURSOR        LOCATION NAME        : PMO5D851
PKG COLLECTION ID    : HSRTEP2VL1XXXXXXXXX2XXXXXXXXX3
XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6
XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9
XXXXXXXXX0XXXXXXXXX1XXXXXXXXX2
XXXXXXXZ
PROGRAM NAME         : DSN@EP2L
CONSISTENCY TOKEN    : X'172A1C98193C380E'
STATEMENT NUMBER     :       1611
STATEMENT TYPE       : X'91'
CURSOR NAME          : C1
QUERY COMMAND ID     : ----
QUERY INSTANCE ID    : ----
ISOLATION            : RR
REOPTIMIZATION       : NO
CURSOR SCROLLABILITY : NON-SCROLL
CURSOR SENSITIVITY   : UNSPECIFIED
CUR RESULT TABLE TYPE: UNSPECIFIED
CURSOR CLOSE COMMIT  : NO IMPLICIT COMMIT
LOCATION NAME

The location name.

Field Name: QW0065LN

PKG COLLECTION ID

The package collection identifier.

Field Name: QW0065PC

PROGRAM NAME

The program name.

Field Name: QW0065PN

CONSISTENCY TOKEN

The consistency token.

Field Name: QW0065TS

STATEMENT NUMBER

The statement number.

Field Name: QW0065SN

STATEMENT TYPE

The statement type. X'91' indicates OPEN.

Field Name: QW0065ST

CURSOR NAME

The name of the cursor used by the OPEN cursor statement.

Field Name: QW0065CN

QUERY COMMAND ID

The ID of the query command.

Field Name: QW0065CID

QUERY INSTANCE ID

The ID of the query instance.

Field Name: QW0065QID

ISOLATION
The isolation level:
RR
Repeatable read
CS
Cursor stability
RS
Read stability
UR
Uncommitted read
XR
Repeatable read with X lock
XS
Read stability with X lock

Field Name: QW0065I

REOPTIMIZATION

Indicates whether the access path of the SQL statement was reoptimized at run time.

Field Name: QW0065RO

CURSOR SCROLLABILITY
Identifies the cursor scrollability. It can be one of the following:
  • Scroll
  • None-scroll

Field Name: QW0065SC

CURSOR SENSITIVITY
Identifies the cursor sensitivity. It can be one of the following:
  • Sensitive
  • Insensitive
  • Unspecified

Field Name: QW0065SV

CUR RESULT TABLE TYPE
Identifies the type of the cursor result table. It can be one of the following:
  • Static
  • Dynamic
  • Unspecified

Field Name: QW0065RT

CURSOR CLOSE COMMIT
The cursor attribute implicit commit, which closed the cursor. Possible values are:
  • IMPLICIT COMMIT
  • NO IMPLICIT COMMIT
  • N/A
Otherwise the values are shown in hexadecimal.

Field Name: QW0065TY