IFCID 311 - Global Temp Table Usage

This topic shows detailed information about Record Trace - IFCID 311 - Global Temp Table Usage.

Record trace - IFCID 311 - Global Temp Table Usage

The field labels shown in the following sample layout of Record Trace - IFCID 311 - Global Temp Table Usage are described in the following section.


TEMP TAB CREATOR  : 'BLANK'    TEMP TAB NAME: TTAB1                PACK LOCATION NAME: 'BLANK'
PROGRAM NAME      : DSNTEP3    CURSOR NAME  : N/A                  PACK COLLECTION ID: DSNTEP3
PACKAGE VERSION   : N/P
CURSOR HOLD STATUS: HO    WORKFILE TYPE: TT       OPERATION: TYPE
---- SERVICEABILITY FIEDS: --------------------------
QW0311CA:                                         QW0311TA:
QW0311CL:  WTTD

TEMP TAB CREATOR

The creator of the global temporary table.

Field Name: QW0311QN

TEMP TABLE NAME

The name of the global temporary table.

Field Name: QW0311TN

PACK LOCATION NAME

The package location name for the query that uses the global temporary table.

Field Name: QW0311LN

PROGRAM NAME

The program name for the query that uses the global temporary table.

Field Name: QW0311PN

CURSOR NAME

The cursor name for fetches. This field is only applicable if the value in WORKFILE TYPE is RC. Otherwise, N/A is printed.

Field Name: QW0311CN

PACK COLLECTION ID

The package collection identifier for the query that uses the global temporary table.

Field Name: QW0311PC

PACK VERSION

The package version for the query that uses the global temporary table.

Field Name: QW311PVF

CURSOR HOLD STATUS

The cursor hold status:

HO: The cursor is held through commit.
'BLANK': The cursor is not held through commit.

Field Name: QW0311HO

WORKFILE TYPE

The work-file type:

TT: Temporary table
C: Cursor on a temporary table
TR: Transition table
CT: Cursor on transition table.

Field Name: QW0311TY

OPERATION

The operation using the global temporary table:

AT: Alter the temporary table.
CI: Create the temporary table instantiation. A work file is created for the temporary table.
OC: Open the cursor on a temporary table.
D: Delete work files for temporary table.
DA: Delete all rows from the temporary table, but leave the work-file structures intact.
CC: Close cursor on the temporary table.

Field Name: QW0311OP

QW0311CA

This field is for IBM service use.

Field Name: QW0311CA

QW0311TA

This field is for IBM service use.

Field Name: QW0311TA