6.1 Resource types, resource names, and resource information for lock control errors

The following table lists resource types, resource names, and resource information for lock control errors. For details about how to refer to the resource information, see the HiRDB Version 9 System Operation Guide.

Table 6-1 Resource types, resource names, and resource information for lock control errors

Resource TypeType NameResource Name 1#1Resource Name 2#1Resource InformationDescription
0001RDARRDAREA name--Digits 1-8: RDAREA number
Digits 9-28: Fixed at 00
RDAREA
0002TABLTable name or sequence generator name--In UNIX:
Digits 1-8: Table number or sequence generator number
Digits 9-16: Generation number
Digits 17-28: Fixed at 00
In Windows:
Digits 1-8: Table number or sequence generator number
Digits 9-28: Fixed at 00
Table or sequence generator
0003INDXIndex nameRDAREA nameDigits 1-8: Index number
Digits 9-16: RDAREA number
Digits 17-28: Fixed at 00
Index
0004PAGETable name or index nameRDAREA nameIn HP-UX, Solaris, and AIX:
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 at 00
In Linux and Windows:
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 at 00
Page
0007ROWTable nameRDAREA nameIn HP-UX, Solaris, and AIX:
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 at 00
In Linux and Windows:
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 at 00
Row
0008NWROWTable nameRDAREA nameIn HP-UX, Solaris, and AIX:
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 at 00
In Linux and Windows:
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 at 00
Row (WITHOUT LOCK NOWAIT retrieval control)
000BTABNTable name--In UNIX:
Digits 1-8: Table number
Digits 9-16: Generation number
Digits 17-28: Fixed at 00
In Windows:
Digits 1-8: Table number
Digits 9-28: Fixed at 00
Table (for NO WAIT search)
000CNKEYIndex name--Digits 1-8: Index number
Digits 9-28: Fixed at 00
Key value (NULL)
000DDKEYIndex name--Digits 1-8: Index number
Digits 9-8: 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 at 00
Logical file
000FIXIFIndex nameRDAREA nameDigits 1-8: Index number
Digits 9-16: RDAREA number
Digits 17-28: Fixed at 00
Index information file
0010TRWTTable nameRDAREA name for indexDigits 1-8: Table number
Digits 9-16: RDAREA name for index
Digits 17-28: Fixed at 00
Transaction completion standby
0011SHWTTable name (if waiting for completion of RDAREA update, **** is output)RDAREA nameIn HP-UX, Solaris, and AIX:
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 at 00
In Linux and Windows:
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 at 00
If waiting for completion of RDAREA update, all other than the RDAREA number are 0.
Shared RDAREA transaction settlement pending
0102RRAMBRDAREA name--Digits 1-8: RDAREA number
Digits 9-28: Fixed at 00
RDAREA management information
0111MFCB----Digits 1-8: Page number
Digits 9-12: File number
Digits 13-28: Fixed at 00
Master directory segment information
0112MTCBTable name--Digits 1-8: Table number
Digits 9-28: Fixed at 00
Master directory table information
0113MICBIndex name--Digits 1-8: Index number
Digits 9-28: Fixed at 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 at 00
Dictionary table information or user directory table information
0122RAIMRDAREA name--Digits 1-8: RDAREA number
Digits 9-16: Index number or index management number
Digits 17-28: Fixed at 00
Dictionary index information or user directory index information
0132SBMBRDAREA name--Digits 1-8: RDAREA number
Digits 9-16: Segment number
Digits 17-20: File number
Digits 21-28: Fixed at 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 at 00
RDAREA extension
0152SGMBRDAREA name--Digits 1-8: RDAREA number
Digits 9-16:
Page number
Digits 17-20: File number
Digits 21-28: Fixed at 00
Database copy utility
0300MENTRDAREA name--Digits 1-8: RDAREA number
Digits 9-16: Page number
Digits 17-20: File number
Digits 21-24: Entry number
Digits 25-28: Fixed at 00
User LOB RDAREA management information
0301LOBIDRDAREA name--Digits 1-8: RDAREA number
Digits 9-16: LOB number
Digits 17-28: Fixed at 00
User LOB RDAREA management information
0502TEMPServer name--The first 8 bytes are reserved for the server name. If the server name is less than 8 bytes, the remaining bytes are padded with NULL codes.Temporary table instantiation management information
0503TPID----Digits 1-8: User-specific number
Digits 9-28: Fixed at 00
User-specific ID management (temporary table)
0601RDASRDAREA name--Digits 1-8: RDAREA number
Digits 9-28: Fixed at 00
Database condition analysis utility
0602HOLDRDAREA name--Digits 1-8: RDAREA number
Digits 9-28: Fixed at 00
Backup hold RDAREA
0603INRPServer name--Limited to UNIX:
The first 8 bytes are reserved for the server name. If the server name is less than 8 bytes, the remaining bytes are padded with NULL codes.
Configuration management information for the inner replica facility
0604RPGPOriginal RDAREA name--Limited to UNIX:
Digits 1-8: RDAREA number
Digits 9-28: Fixed at 00
Replica group configuration management information
0605MDBSRDAREA--Digits 1-8: RDAREA number
Digits 9-28: Fixed at 00
Synchronous processing information of in-memory data processing
0900PLGR----Digits 1-8: Plug-in ID
Digits 9-28: Plug-in's unique resource number
Plug-in resource number
2002ROMB----Digits 1-14: SQL object number
Digits 15-28: Fixed at 00
SQL object management information
2003SPCH----Fixed to SPCH
Remainder is zero-filled.
SQL object cache
2004TRAL********Fixed to TMPRDAREA
Remainder is zero-filled.
RDAREA management information for temporary table
2005TRAI********Digits 1-8: RDAREA management block number for temporary table
Digits 9-28: Fixed at 00
RDAREA information for temporary table
3001PTBL********Digits 1-8: Table number
Digits 9-28: Fixed to 00
Preprocessing table
3005DICT********Fixed to DICT
Remainder is zero-filled.
Dictionary table
3006VIEW********Digits 1-8: Viewed table number
Digits 9-28: Fixed to 00
Viewed table
3008TBPL********First 5 bytes#2 are an authorization identifier.
Bytes 6-14#3 are a table identifier.
Table definition information buffer
3010AUTH********First 14 bytes are an authorization identifier.User privilege information buffer
3011OBJI********Routine object numberRoutine object
3012DTYP********Fixed to DTYP
Remainder is zero-filled.
Data type definition information
3013RTPL********First 12 bytes are a routine identifier.
Bytes 13-14 are a parameters count.
Routine definition information buffer
3014TPPL********First 5 bytes#2 are an authorization identifier.
Bytes 6-14#3 are a data type identifier.
User definition type information buffer
3015DICR********Fixed to DICR
Remainder is zero-filled.
Dictionary RDAREA change
3016CONS********Fixed to CONSEC
Remainder is zero-filled.
CONNECT-related security definition information
3017SQID********Digits 1-8: Sequence generator number
Digits 9-28: Fixed at 00
Sequence generator
3018SQPL********The first 5 bytes#2 are the authorization identifier.
The first 14 bytes#3 are the sequence generator identifier.
Sequence generator definition information
5001DICU----Fixed to DICTMODUTL
Remainder is zero-filled.
Database structure modification utility
5002LCBFRDAREA name--Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00
--
5003EXP1----Fixed to EXPIMPMDL
Remainder is zero-filled.
Database export/import utility
5004RBALTable name--Digits 1-8: Table number
Digits 9-28: Fixed to 00
Rebalancing utility
5005RRAMBServer name--Digits 1-16: Server name
Digits 17-28: Fixed at 00
ZRRAMB update
5006RCLMRDAREA nameTable or index nameDigits 1-8: RDAREA number
Digits 9-16: Table or index number
Digits 17-28: Fixed at 00
Free page release utility

--: Not Applicable

Notes
  • The resource type is output in hexadecimal (4 digits)
  • The resource information is output in hexadecimal (28 digits).
  • In UNIX, the RDAREA name that corresponds to the RDAREA number can be determined using the pddbls command.
  • In UNIX, the generation number is displayed if a table has been replicated by the inner replica facility.
#1
If the table name or RDAREA name under Resource Name 1 or Resource Name 2 cannot be displayed, four asterisks (****) are displayed. In this case, use the table number or RDAREA number from the resource information to identify the target resource.
#2
An authorization identifier of 6 or more bytes is 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 output is in ASCII code and 1 byte is output as 2 digits.
#3
Table identifiers, data type identifiers, or sequence generator identifiers that are 10 bytes or more are output in the following format.
first-5-bytes-of-table-identifier, data-type-identifier, or sequence-generator-identifier + last-4-bytes-of-table-identifier, data-type-identifier, or sequence-generator-identifier
For example, if the table identifier is TABLE002498, TABLE2498 is output.
Note that the output is in ASCII code and one byte is expressed as two digits.