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 Type | Type Name | Resource Name 1#1 | Resource Name 2#1 | Resource Information | Description |
---|---|---|---|---|---|
0001 | RDAR | RDAREA name | -- | Digits 1-8: RDAREA number Digits 9-28: Fixed at 00 | RDAREA |
0002 | TABL | Table 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 |
0003 | INDX | Index name | RDAREA name | Digits 1-8: Index number Digits 9-16: RDAREA number Digits 17-28: Fixed at 00 | Index |
0004 | PAGE | Table name or index name | RDAREA name | In 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 |
0007 | ROW | Table name | RDAREA name | In 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 |
0008 | NWROW | Table name | RDAREA name | In 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) |
000B | TABN | Table 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) |
000C | NKEY | Index name | -- | Digits 1-8: Index number Digits 9-28: Fixed at 00 | Key value (NULL) |
000D | DKEY | Index name | -- | Digits 1-8: Index number Digits 9-8: Key value or encoded key value | Key value (non-NULL) |
000E | LFID | RDAREA name | Logical file number | Digits 1-8: RDAREA number Digits 9-16: Logical file number Digits 17-28: Fixed at 00 | Logical file |
000F | IXIF | Index name | RDAREA name | Digits 1-8: Index number Digits 9-16: RDAREA number Digits 17-28: Fixed at 00 | Index information file |
0010 | TRWT | Table name | RDAREA name for index | Digits 1-8: Table number Digits 9-16: RDAREA name for index Digits 17-28: Fixed at 00 | Transaction completion standby |
0011 | SHWT | Table name (if waiting for completion of RDAREA update, **** is output) | RDAREA name | In 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 |
0102 | RRAMB | RDAREA name | -- | Digits 1-8: RDAREA number Digits 9-28: Fixed at 00 | RDAREA management information |
0111 | MFCB | -- | -- | Digits 1-8: Page number Digits 9-12: File number Digits 13-28: Fixed at 00 | Master directory segment information |
0112 | MTCB | Table name | -- | Digits 1-8: Table number Digits 9-28: Fixed at 00 | Master directory table information |
0113 | MICB | Index name | -- | Digits 1-8: Index number Digits 9-28: Fixed at 00 | Master directory index information |
0121 | RATM | Table name | RDAREA name | Digits 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 |
0122 | RAIM | RDAREA 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 |
0132 | SBMB | RDAREA 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 |
0143 | RDLF | RDAREA name | Last file number | Digits 1-8: RDAREA number Digits 9-12: Last file number Digits 13-28: Fixed at 00 | RDAREA extension |
0152 | SGMB | RDAREA 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 |
0300 | MENT | RDAREA 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 |
0301 | LOBID | RDAREA name | -- | Digits 1-8: RDAREA number Digits 9-16: LOB number Digits 17-28: Fixed at 00 | User LOB RDAREA management information |
0502 | TEMP | Server 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 |
0503 | TPID | -- | -- | Digits 1-8: User-specific number Digits 9-28: Fixed at 00 | User-specific ID management (temporary table) |
0601 | RDAS | RDAREA name | -- | Digits 1-8: RDAREA number Digits 9-28: Fixed at 00 | Database condition analysis utility |
0602 | HOLD | RDAREA name | -- | Digits 1-8: RDAREA number Digits 9-28: Fixed at 00 | Backup hold RDAREA |
0603 | INRP | Server 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 |
0604 | RPGP | Original RDAREA name | -- | Limited to UNIX: Digits 1-8: RDAREA number Digits 9-28: Fixed at 00 | Replica group configuration management information |
0605 | MDBS | RDAREA | -- | Digits 1-8: RDAREA number Digits 9-28: Fixed at 00 | Synchronous processing information of in-memory data processing |
0900 | PLGR | -- | -- | Digits 1-8: Plug-in ID Digits 9-28: Plug-in's unique resource number | Plug-in resource number |
2002 | ROMB | -- | -- | Digits 1-14: SQL object number Digits 15-28: Fixed at 00 | SQL object management information |
2003 | SPCH | -- | -- | Fixed to SPCH Remainder is zero-filled. | SQL object cache |
2004 | TRAL | **** | **** | Fixed to TMPRDAREA Remainder is zero-filled. | RDAREA management information for temporary table |
2005 | TRAI | **** | **** | Digits 1-8: RDAREA management block number for temporary table Digits 9-28: Fixed at 00 | RDAREA information for temporary table |
3001 | PTBL | **** | **** | Digits 1-8: Table number Digits 9-28: Fixed to 00 | Preprocessing table |
3005 | DICT | **** | **** | Fixed to DICT Remainder is zero-filled. | Dictionary table |
3006 | VIEW | **** | **** | Digits 1-8: Viewed table number Digits 9-28: Fixed to 00 | Viewed table |
3008 | TBPL | **** | **** | First 5 bytes#2 are an authorization identifier. Bytes 6-14#3 are a table identifier. | Table definition information buffer |
3010 | AUTH | **** | **** | First 14 bytes are an authorization identifier. | User privilege information buffer |
3011 | OBJI | **** | **** | Routine object number | Routine object |
3012 | DTYP | **** | **** | Fixed to DTYP Remainder is zero-filled. | Data type definition information |
3013 | RTPL | **** | **** | First 12 bytes are a routine identifier. Bytes 13-14 are a parameters count. | Routine definition information buffer |
3014 | TPPL | **** | **** | First 5 bytes#2 are an authorization identifier. Bytes 6-14#3 are a data type identifier. | User definition type information buffer |
3015 | DICR | **** | **** | Fixed to DICR Remainder is zero-filled. | Dictionary RDAREA change |
3016 | CONS | **** | **** | Fixed to CONSEC Remainder is zero-filled. | CONNECT-related security definition information |
3017 | SQID | **** | **** | Digits 1-8: Sequence generator number Digits 9-28: Fixed at 00 | Sequence generator |
3018 | SQPL | **** | **** | The first 5 bytes#2 are the authorization identifier. The first 14 bytes#3 are the sequence generator identifier. | Sequence generator definition information |
5001 | DICU | -- | -- | Fixed to DICTMODUTL Remainder is zero-filled. | Database structure modification utility |
5002 | LCBF | RDAREA name | -- | Digits 1-8: RDAREA number Digits 9-28: Fixed to 00 | -- |
5003 | EXP1 | -- | -- | Fixed to EXPIMPMDL Remainder is zero-filled. | Database export/import utility |
5004 | RBAL | Table name | -- | Digits 1-8: Table number Digits 9-28: Fixed to 00 | Rebalancing utility |
5005 | RRAMB | Server name | -- | Digits 1-16: Server name Digits 17-28: Fixed at 00 | ZRRAMB update |
5006 | RCLM | RDAREA name | Table or index name | Digits 1-8: RDAREA number Digits 9-16: Table or index number Digits 17-28: Fixed at 00 | Free page release utility |
--: Not Applicable
first-3-bytes-of-authorization-identifier + last-2-bytes-of-authorization-identifier