IFCID 112 - Thread Allocate

This topic shows detailed information about Record Trace - IFCID 112 - Thread Allocate.

Record trace - IFCID 112 - Thread Allocate

The field labels shown in the following sample layout of Record Trace - IFCID 112 - Thread Allocate are described in the following section.


THREAD     --> NETWORKID:  DEIBMIPS  LUNAME:  IPSAU851  LUWSEQ:     1
ALLOCATE      PLAN NAME   : DSNBIND      ACQUIRE: ALLOCATION
ISOLATION   : CS           RELEASE: DEALLOCATION
DYNAMICRULES: RUN          REOPT  : NO
KEEPDYNAMIC :  NO          PREPARE: NO
DBPROTOCOL  : PRIVATE
HINTID      : 'BLANK'
IMMEDWRITE  :  NO

PLAN NAME

The plan name for the thread.

Field Name: QW0112PN

ACQUIRE

Indicates when to acquire locks:

ALLOCATION: Acquire the locks when the plan is allocated.
USE: Acquire the locks when the application first accesses them.

Field Name: QW0112Q

ISOLATION

The isolation level:

RR: Repeatable read
CS: Cursor stability
RS: Read stability
UR: Uncommitted read

Field Name: QW0112I

RELEASE

Indicates when to release locks:

COMMIT: Release locks at commit time.
DEALLOCATION: Release locks at deallocation time.

Field Name: QW0112R

DYNAMICRULES

The value of the DYNAMICRULES option on the BIND/REBIND command:

RUN: Run-time rules apply to a dynamic SQL statement for authorization checking and object qualification at run time.
BIND: Bind-time rules apply to a dynamic SQL statement for authorization checking and object qualification at run time.
N/P: DYNAMICRULES was not specified.

Field Name: QW0112DY

REOPT

Indicates whether reoptimization was requested:

YES: REOPT(VARS) was specified to reoptimize the access path of the SQL statement at run time.
NO: NOREOPT(VARS) was specified to optimize the access path of the SQL statement only at bind time.

Field Name: QW0112RO

KEEPDYNAMIC

Indicates whether Db2 keeps (KEEPDYNAMIC(YES)) or discards (KEEPDYNAMIC(NO)) prepared SQL statements at commit points.

Field Name: QW0112KD

DBPROTOCOL

Database protocol option. Possible values are:

DRDA
PRIVATE

Field Name: QW0112PR

PREPARE

Indicates whether preparation of dynamic SQL statements was deferred. Possible values are:

YES: Dynamic SQL statement preparation was deferred.
NO: Dynamic SQL statements were prepared immediately.

Field Name: QW0112DP

HINTID

Query optimization hint identifier, the default is blanks.

Field Name: QW0112OH

IMMEDWRITE

Indicates how Db2 updates group buffer pool dependent pages. This is only valid in a data-sharing environment.

Group buffer pool dependent pages can be written out to DASD or SYSTEM pagesets. Values shown are:

NO: Db2 uses normal write activity for updates, this is the default. Pages are written out at, or before phase 2 commit, or at the end of an abort for transactions that have rolled back.
PH1: Pages are written out at, or before phase 1 commit.
If a transaction subsequently rolls back, the pages are updated in the group buffer pool at the end of the rollback, and are written out at the end of the abort.
YES: Pages are written out to the coupling facility as soon as the buffer update commits. Pages are written out regardless of whether the update occurs during forward progress or rollback of the transaction.
This option can affect Db2 performance due to coupling facility overhead.
N/P: The Db2 subsystem is not part of a data sharing group.

Field Name: QW0112WI