IFCID 003 - Resource Limit Facility

This topic shows detailed information about Record Trace - IFCID 003 - Resource Limit Facility.

RESOURCE LIMIT FACILITY
RES LIMIT SCOPE           5              RLF TABLE ID               01       LIMIT IN CPU 16 MICROSEC              0
RES LIMIT TYPE   INFINITE                LIMIT IN SERVICE UNITS           0  HIGHEST CPU 16 MICROSEC USED       2107
QTXAFLG1 (S) :   X'80'

RES LIMIT SCOPE

Indicates how the resource limit was established. A value of 0 shows that the resource limit facility was not started.

Field Name: QTXAPREC

RLF TABLE ID

The identifier of the resource limit specification table.

Field Name: QTXARLID

LIMIT IN CPU 16 MICROSEC

The CPU time limit, in microseconds, set by the resource limit facility.

Field Name: QTXACLMT

RES LIMIT TYPE

Indicates how the type of resource limit was established: infinite, zero, or limit.

Note: Label QTXAFLG1 presents the first flag byte in hexadecimal:

X'80'

Infinite limit

X'40'

No run or zero limit

Field Name: QTXAFLG1

LIMIT IN SERVICE UNITS

The maximum number of CPU service units to be used. Normally, the value is not 0 if the RES LIMIT TYPE is LIMIT. A value of 0 indicates no limit.

Field Name: QTXASLMT

HIGHEST CPU 16 MICROSEC USED

The highest CPU time used by a single Db2 call, in microseconds. Note that there can be many Db2 calls for one SQL statement.

Field Name: QTXACHUS

QTXAFLG1 (S)

Indicates how the type of resource limit was established: infinite, zero, or limit.

Note: Label QTXAFLG1 presents the first flag byte in hexadecimal:

X'80'

Infinite limit

X'40'

No run or zero limit

Field Name: QTXAFLG1