IFCID 177 - Package Allocation

This topic shows detailed information about Record Trace - IFCID 177 - Package Allocation.

PACKAGE        NETWORKID:  G91E81D0  LUNAME:  D179      LUWSEQ:     2
ALLOCATION    REQUESTING LOCATION:  9.30.129.208
REQUESTING TIMESTAMP: N/P
AR NAME: gixxer               PRDID: CLNT/SER V8 R1 M4
ACCTKN X'C7F9F1C5F8F1C4F04BC4F1F7F9000F92022652404040'
LOCATION         : DSND81B
COLLECTION ID    : AIXPGMS
PACKAGE ID       : SQLEMBT
CONSISTENCY TOKEN: X'5A4276344E644C54'
VERSION NAME     : N/P
DYNAMICRULES     : RUN
PLAN             : DISTSERV
ISOLATION        : CS
ACQUIRE          : USE
RELEASE          : COMMIT
REOPTIMIZATION   : NO
DEFERPREPARE     : NO
KEEPDYNAMIC      : NO
DBPROTOCOL       : DRDA
OPT_HINT_IDENT   : 'BLANK'
IMMEDWRITE       :  NO

LOCATION

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

Field Name: QW0177LO

COLLECTION ID

The collection name.

Field Name: QW0177CO

PACKAGE ID

The package identifier.

Field Name: QW0177PI

CONSISTENCY TOKEN

The consistency token (timestamp) of the program.

Field Name: QW0177CT

VERSION NAME

The version. This field shows N/P if the record does not contain a valid version.

Field Name: QW0177VN

DYNAMICRULES

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

RUN

Runtime 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 in this field indicates that DYNAMICRULES was not specified.

Field Name: QW0177DY

PLAN

The name of the plan under which the package is running.

Field Name: QW0177PL

ISOLATION

The isolation level of the package:

RR

Repeatable read

CS

Cursor stability

RS

Read stability

UR

Uncommitted read

Field Name: QW0177IS

ACQUIRE

The acquire level of the package.

Field Name: QW0177AQ

RELEASE

The release level of the package.

Field Name: QW0177RL

REOPTIMIZATION

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: QW0177RO

DEFERPREPARE

Indicates whether the preparation of dynamic SQL statements was deferred:

YES

DEFER(PREPARE) was specified to defer the preparation of the dynamic SQL statements that refer to remote objects until run time.

NO

NODEFER(PREPARE) was specified to prepare the dynamic SQL statements at bind time.

Field Name: QW0177DP

KEEPDYNAMIC

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

Field Name: QW0177KD

DBPROTOCOL

Protocol. Possible values are:

DRDA

PRIVATE

Field Name: QW0177PR

OPT_HINT_IDENT

Query optimization hint identifier, the default is blanks.

Field Name: QW0177OH

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: QW0177WI