Resource Limit Facility

Edit online

This topic shows detailed information about Accounting - Resource Limit Facility.

This block shows information about the Resource Limit Facility (RLF), which prevents dynamic manipulative SQL statements from exceeding specified time limits.

The following example shows both layouts, the report layout followed by the trace layout.

Accounting - Resource Limit Facility

The field labels shown in the following sample layout of Accounting - Resource Limit Facility are described in the following section. 

Report:

RESOURCE LIMIT TYPE               #OCCUR    AVERAGE CPU SECONDS    HIGHEST CPU SECONDS
------------------------------    ------    -------------------    -------------------
INFINITE LIMIT                         1               5.000000               5.000000


Trace:

---- RESOURCE LIMIT FACILITY --------------------------------------------------------------------------------------------------
TYPE: N/P                               TABLE ID: N/P    SERV.UNITS:      N/P    CPU SECONDS: 0.000000    MAX CPU SEC:      N/P
RESOURCE LIMIT TYPE (TYPE)

The resource limit type. This is taken from QTXAPREC and can be:

New in Db2 V11:

  • 16 - SPECIFIC OR ANY CLIENT

For Db2 V12:

  • 1 - AUTHID/COLLECTION/PKG/LOCATION
  • 2 - AUTH/COLLECT/PKG LOC LOCATION
  • 3 - AUTH/COLLECT/PKG ANY LOCATION
  • 4 - AUTH/COLLECT/LOCATION ANY PKG
  • 5 - AUTH/COLLECT/LOC LOCAT ANY PKG
  • 6 - AUTH/COLLECT ANY PKG/LOCATION
  • 7 - AUTH/PKG/LOCATION ANY COLLECT
  • 8 - AUTH/PKG ANY COLLECT LOC LOCAT
  • 9 - AUTH/PKG ANY COLLECT/LOCATION
  • 10 - AUTH/LOCATION ANY COLLECT/PKG
  • 11 - AUTH ANY COLLECT/PKG LOC LOCAT
  • 12 - AUTH ANY COLLECT/PKG/LOCATION
  • 13 - COLLECT/PKG/LOCATION ANY AUTH
  • 14 - COLLECT/PKG ANY AUTH LOC LOCAT
  • 15 - COLLECT/PKG ANY AUTH/LOCATION
  • 16 - COLLECT/LOCATION ANY AUTH/PKG
  • 17 - COLLECT/LOCALLOC ANY AUTH/PKG
  • 18 - COLLECT ANY AUTH/PKG/LOCATION
  • 19 - PKG/LOCATION ANY AUTH/COLLECT
  • 20 - PKG/LOCALLOC ANY AUTH/COLLECT
  • 21 - PKG ANY AUTH/COLLECT/LOCATION
  • 22 - LOCATION ANY AUTH/COLLECT/PKG
  • 23 - LOCALLOC ANY AUTH/COLLECT/PKG
  • 24 - ANY AUTH/COLLECT/PKG/LOCATION
  • 25 - CLIENT APPL/ID/WKS/IP
  • 26 - CLIENT APPL/ID/WKS ANY IP
  • 27 - CLIENT APPL/ID/IP ANY WKS
  • 28 - CLIENT APPL/ID ANY WKS/IP
  • 29 - CLIENT APPL/WKS/IP ANY ID
  • 30 - CLIENT APPL/WKS ANY ID/IP
  • 31 - CLIENT APPL/IP ANY ID/WKS
  • 32 - CLIENT APPL ANY ID/WKS/IP
  • 33 - CLIENT ID/WKS/IP ANY APPL
  • 34 - CLIENT ID/WKS ANY APPL/IP
  • 35 - CLIENT ID/IP ANY APPL/WRS
  • 36 - CLIENT ID ANY APPL/WKS/IP
  • 37 - CLIENT WKS/IP ANY APPL/ID
  • 38 - CLIENT WKS ANY APPL/ID/IP
  • 39 - CLIENT IP ANY APPL/ID/WKS
  • 40 - CLIENT ANY APPL/ID/WKS/IP
  • 41 - INSTALL ZPARM FOR LIMIT
  • 42 - NO LIMIT - SYSADM/SYSOPR

The following values can be reported for all Db2 versions:

  • 99 - INFINITE LIMIT

Reported when QTXAPREC has any value except NO LIMIT - SYSADM/SYSOPR and QTXAILMT is on.

  • 100 - NO RUN OR ZERO LIMIT.

Reported when QTXANRUN is on.

Field Name: ADRLFTYP

#OCCUR

The number of RLF occurrences.

Field Name: ASRLFOCC

AVERAGE CPU SECONDS

The number of CPU seconds used.

Field Name: ADRLFCPU

HIGHEST CPU SECONDS

The highest CPU seconds used in a successful Db2 internal call rather than in a single SQL call. Because there are usually many Db2 calls for each SQL call, this value could be quite small compared to the total CPU time used in the SQL call.

Only times for successful Db2 calls are used to determine the value of this field.

Field Name: ADRLFMAX

TABLE ID

The identifier of the resource limit specification table.

Field Name: QTXARLID

SERV.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