Resource_type=resource-type-list

    Displays information for each lock held or requested by the
    specified resource type. Only the specific resource types will
    be displayed. This permits, for example, only PAGE or RECORD lock
    types to be selected.

    One or more resouce types can be specified; if more than one
    type is specified, they must be enclosed within parentheses and
    separated by commas.

    The following keywords are allowed with the Resource_type
    qualifier.

    Table 17 RESOURCE_TYPE Keywords

    Internal
    Lock Type
    Name           Keyword(s)

    ACCESS         ACCESS
    ACTIVE         ACTIVE
    AIJDB          AIJDB
    AIJFB          AIJFB
    AIJHWM         AIJHWM, AIJ_HIGH_WATER_MARK
    AIJLOGMSG      AIJ_LOG_MESSAGE
    AIJLOGSHIP     AIJ_LOG_SHIPPING
    AIJOPEN        AIJ_OPEN
    AIJSWITCH      AIJ_SWITCH
    AIJ            AIJ
    AIPQHD         AIP
    ALS            ALS_ACTIVATION
    BCKAIJ         AIJ_BACKUP, BCKAIJ
    BCKAIJ_SPD     AIJ_BACKUP_SUSPEND
    BUGCHK         BUGCHECK
    CHAN           CHAN, FILE_CHANNEL
    CLIENT         CLIENT
    CLOSE          CLOSE
    CLTSEQ         CLTSEQ
    CPT            CORRUPT_PAGE_TABLE, CPT
    DASHBOARD      DASHBOARD_NOTIFY
    DBK_SCOPE      DBKEY_SCOPE
    DBR            DBR_SERIALIZATION
    DB             DATABASE
    FIB            FAST_INCREMENTAL_BACKUP, FIB
    FILID          FILID
    FRZ            FREEZE
    GBL_CKPT       GLOBAL_CHECKPOINT
    GBPT_SLOT      GLOBAL_BPT_SLOT
    KROOT          KROOT
    LAREA          LAREA, LOGICAL_AREA
    LOGFIL         LOGFIL
    MEMBIT         MEMBIT
    MONID          MONID, MONITOR_ID
    MONITOR        MONITOR
    NOWAIT         NOWAIT
    PLN            DBKEY, RECORD, PLN
    PNO            PAGE, PNO
    QUIET          QUIET
    RCACHE         RCACHE
    RCSREQUEST     RCS_REQUEST
    RCSWAITRQST    RCS_WAIT_REQUEST
    REL_AREAS      RELEASE_AREAS
    REL_GRIC_      RELEASE_GRIC_REQUEST
    REQST
    RMUCLIENT      RMU_CLIENT
    ROOT_AREA      DUMMY_ROOT_AREA
    RO_L1          L1_SNAP_TRUNCATION
    RTUPB          RTUPB
    RUJBLK         RUJBLK
    RW_L2          L2_SNAP_TRUNCATION
    SAC            SNAP_AREA_CURSOR
    SEQBLK         SEQBLK
    STAREA         STORAGE_AREA, PAREA
    STATRQST       STATISTICS_REQUEST
    TRM            TERMINATION
    TSNBLK         TSNBLK
    UTILITY        UTILITY

    The RESOURCE_TYPE qualifier is incompatible with the MODE, LIMIT,
    LOCK and PROCESS qualifiers.