IFCID 212 - Drain Data

This topic shows detailed information about Record Trace - IFCID 212 - Drain Data.

This record contains information about requesting and releasing a drain or a pseudo drain. One record is written for each drain or release request on a claim class. Another record is written for a drain that is only waiting for the claimers to release claims and not acquiring a drain lock (pseudo drain).

DBID    CATD3DB1   PSID   CATD3TS2      PARTITION NO.     2    DRAIN REQUEST TYPE: DRAIN     CLAIM CLASS: WRITE
DRAIN LOCK MODE: EXCLUSIVE                DRAIN RESULT:   SUCCESSFUL

DBID

The database identifier of the object of the drain request. This field contains 0 if the request is for a release of all drains.

Field Name: QW0212DB

PSID

The page set identifier of the object of the drain request. This field contains 0 if the request is for a release of all drains.

Field Name: QW0212PS

PARTITION NO.

The partition number of the object of the drain request. This field contains 0 if the request is for a release of all drains or if the table space or index space is non-partitioned (and the drain request is at the page set level rather than the logical partition level).

Field Name: QW0212PT

DRAIN REQUEST TYPE

The drain request type.

Field Name: QW0212RQ

CLAIM CLASS

The claim class.

Field Name: QW0212CC

DRAIN LOCK MODE

The mode of the drain lock requested. This field shows 'BLANK' if the drain is released or no lock is requested.

Field Name: QW0212MO

DRAIN RESULT

The result of the drain request.

Field Name: QW0212RC

REASON IF DRAIN UNSUCCESSFUL

The reason for an unsuccessful drain. This field is only printed if the value in CLAIM RESULT is UNSUCCESSFUL .

Field Name: QW0212RS