8.6.4 Resource types and resource information

Table 8-6 shows the resource types and resource information included in the deadlock or timeout information.

Table 8-6 Resource types and resource information

Resource typeType nameResource name 1Resource name 2Resource informationContents
0001RDARRDAREA[Figure]Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
RDAREA
0002TABLTable name[Figure]Digits 1-8: Table number
Digits 9-16: Generation number
Digits 17-28: Fixed to 00
Table
0003INDXIndex nameRDAREA nameDigits 1-8: Index number
Digits 9-16: RDAREA number
Digits 17-28: Fixed to 00
Index
0004PAGETable name or index nameRDAREA name[Figure]For HP-UX, Solaris, and AIX 5L versions
Digits 1-6: RDAREA number
Digits 7-8: File number
Digits 9-16: Page number
Digits 17-24: Table number or index number
Digits 25-28: Fixed to 00
[Figure]For Linux version
Digits 1-2: File number
Digits 3-8: RDAREA number
Digits 9-16: Page number
Digits 17-24: Table number or index number
Digits 25-28: Fixed to 00
Page
0007ROWTable nameRDAREA name[Figure]For HP-UX, Solaris, and AIX 5L versions
Digits 1-6: RDAREA number
Digits 7-8: File number
Digits 9-14: Page number
Digits 15-16: Slot number
Digits 17-24: Table number
Digits 25-28: Fixed to 00
[Figure]For Linux version
Digits 1-2: File number
Digits 3-8: RDAREA number
Digits 9-10: Slot number
Digits 11-16: Page number
Digits 17-24: Table number
Digits 25-28: Fixed to 00
Row
0008NWROWTable nameRDAREA name[Figure]For HP-UX, Solaris, and AIX 5L versions
Digits 1-6: RDAREA number
Digits 7-8: File number
Digits 9-14: Page number
Digits 15-16: Slot number
Digits 17-24: Table number
Digits 25-28: Fixed to 00
[Figure]For Linux version
Digits 1-2: File number
Digits 3-8: RDAREA number
Digits 9-10: Slot number
Digits 11-16: Page number
Digits 17-24: Table number
Digits 25-28: Fixed to 00
Row (for controlling WITHOUT LOCK NOWAIT retrieval)
000BTABNTable name[Figure]Digits 1-8: Table number
Digits 9-16: Generation number
Digits 17-28: Fixed to 00
Table (during NO WAIT retrieval)
000CNKEYIndex name[Figure]Digits 1-8: Index number
Digits 9-28: Fixed to 00
Key value (NULL)
000DDKEYIndex name[Figure]Digits 1-8: Index number
Digits 9-28: Key value or encoded key value
Key value (non-NULL)
000ELFIDRDAREA nameLogical file numberDigits 1-8: RDAREA number
Digits 9-16: Logical file number
Digits 17-28: Fixed to 00
Logical file
000FIXIFIndex nameRDAREA nameDigits 1-8: Index number
Digits 9-16: RDAREA number
Digits 17-28: Fixed to 00
Index information file
0010TRWTTable nameName of the RDAREA storing the indexDigits 1-8: Table number
Digits 9-16: Number of the RDAREA storing the index
Digits 17-28: Fixed to 00
Transaction completion pending
0011SHWTTable name
(**** is output if the system is waiting for RDAREA update completion)
RDAREA name[Figure]For HP-UX, Solaris, and AIX 5L versions
Digits 1-6: RDAREA number
Digits 7-8: File number
Digits 9-14: Page number
Digits 15-16: Slot number
Digits 17-24: Table number
Digits 25-28: Fixed to 00
[Figure]For Linux version
Digits 1-2: File number
Digits 3-8: RDAREA number
Digits 9-10: Slot number
Digits 11-16: Page number
Digits 17-24: Table number
Digits 25-28: Fixed to 00
If the system is waiting for RDAREA update completion, all digits except for the RDAREA number are 0.
Shared RDAREA transaction completion pending
0102RRAMBRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
RDAREA management information
0111MFCB[Figure][Figure]Digits 1-8: Page number
Digits 9-12: File number
Digits 13-28: Fixed to 00
Master directory segment information
0112MTCBTable name[Figure]Digits 1-8: Table number
Digits 9-28: Fixed to 00
Master directory table information
0113MICBIndex name[Figure]Digits 1-8: Index number
Digits 9-28: Fixed to 00
Master directory index information
0121RATMTable nameRDAREA nameDigits 1-8: RDAREA number
Digits 9-16: Table number or table management number
Digits 17-28: Fixed to 00
Dictionary table information or user directory table information
0122RAIMRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-16: Index number or index management number
Digits 17-28: Fixed to 00
Dictionary index information or user directory index information
0132SBMBRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-16: Segment number
Digits 17-20: File number
Digits 21-28: Fixed to 00
Dictionary segment information or user directory segment information
0143RDLFRDAREA nameLast file numberDigits 1-8: RDAREA number
Digits 9-12: Last file number
Digits 13-28: Fixed to 00
RDAREA increment
0152SGMBRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-16: Page number
Digits 17-20: File number
Digits 21-28: Fixed to 00
Database copy utility
0300MENTRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-16: Page number
Digits 17-20: File number
Digits 21-24: Entry number
Digits 25-28: Fixed to 00
User LOB RDAREA management information
0301LOBIDRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-16: LOB number
Digits 17-28: Fixed to 00
User LOB RDAREA management information
0601RDASRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
Database condition analysis utility
0602HOLDRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
Backup-hold RDAREA
0603INRPServer name[Figure]Bytes 1-8 indicate the server name. If the server name does not occupy 8 bytes, the unused bytes are filled with NULLs.Inner replica configuration management information
0604RPGPOriginal RDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
Replica group configuration management information
0900PLGR[Figure][Figure]Digits 1-8: Plug-in ID
Digits 9-28: Plug-in's unique resource number
Plug-in resource number
2002ROMB[Figure][Figure]Digits 1-14: SQL object number
Digits 15-28: Fixed to 00
SQL object management information
2003SPCH[Figure][Figure]Fixed to 'SPCH'
Extra digits are zero-filled.
SQL object cache
3001PTBL"****""****"Digits 1-8: Table number
Digits 9-28: Fixed to 00
Pre-processing table
3001AUDL"****""****"Fixed to AUDLAudit trail information pool
3005DICT"****""****"Fixed to 'DICT'
Extra digits are zero-filled.
Dictionary table
3006VIEW"****""****"Digits 1-8: View table number
Digits 9-28: Fixed to 00
View table
3008TBPL"****""****"Bytes 1-51 are an authorization identifier.
Bytes 6-142 are a table identifier.
Table definition information buffer
3009ALAS"****""****"Bytes 1-51 are an authorization identifier.
Bytes 6-142 are a table alias.
Table alias definition information buffer
3010AUTH"****""****"Bytes 1-14 bytes are an authorization identifier.User privilege information buffer
3011OBJI"****""****"Routine object numberRoutine object
3012DTYP"****""****"Fixed to 'DTYP'
Extra digits are zero-filled.
Data type definition information
3013RTPL"****""****"Bytes 1-12 are a routine identifier.
Bytes 13-14 are a parameters count.
Routine definition information buffer
3014TPPL"****""****"Bytes1-51 are an authorization identifier.
Bytes 6-142 are a data type identifier.
User-defined type information buffer
3015DICR"****""****"Fixed to DICRDictionary RDAREA modification
3016CONS"****""****"Fixed to CONSECCONNECT-related security definition information
5001DICU[Figure][Figure]Fixed to 'DICTMODUTL'
Extra digits are zero-filled.
Database structure modification utility
5002LCBFRDAREA name[Figure]Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
[Figure]
5003EXP1[Figure][Figure]Fixed to 'EXPIMPMDL'
Extra digits are zero-filled.
Database import/export utility
5004RBALTable name[Figure]Digits 1-8: Table number
Digits 9-28: Fixed to 00
Rebalancing utility
5005RRAMBServer name[Figure]Digits 1-16: Server name
Digits 17-28: Fixed to 00
ZRRAMB updates
5006RCLMRDAREA nameTable name or index nameDigits 1-8: RDAREA number
Digits 9-16: Table number or index number
Digits 17-28: Fixed to 00
Free page release utility

[Figure]: Not applicable

Notes
  • The resource type is displayed in hexadecimal (4 digits).
  • The resource information is displayed in hexadecimal (28 digits). For details on interpreting resource information, see 8.6.5 Interpreting resource information.
  • The RDAREA name corresponding to an RDAREA number can be referenced with the pddbls command.
  • The generation number is displayed if the table has been duplicated with the inner replica facility.
1 Authorization identifiers (6 bytes or longer) are output in the following format:
first-3-bytes-of-authorization-identifier + last-2-bytes-of-authorization-identifier
For example, if the authorization identifier is k87m341, k8741 is output.
Note that the information is in ASCII codes and one byte is output as two digits.
2 Table identifiers, table aliases, and data type identifiers (10 bytes or longer) are output in the following format:
first-5-bytes-of-table-identifier-or-table-alias + last-4-bytes-of-table-identifier-or-table-alias
For example, if the table identifier is TABLE002498, TABLE2498 is output.
Note that the information is in ASCII codes, and one byte is output as two digits.