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 type | Type name | Resource name 1 | Resource name 2 | Resource information | Contents |
---|---|---|---|---|---|
0001 | RDAR | RDAREA | ![]() | Digits 1-8: RDAREA number Digits 9-28: Fixed to 00 | RDAREA |
0002 | TABL | Table name | ![]() | Digits 1-8: Table number Digits 9-16: Generation number Digits 17-28: Fixed to 00 | Table |
0003 | INDX | Index name | RDAREA name | Digits 1-8: Index number Digits 9-16: RDAREA number Digits 17-28: Fixed to 00 | Index |
0004 | PAGE | Table name or index name | RDAREA name | ![]() 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 ![]() 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 |
0007 | ROW | Table name | RDAREA name | ![]() 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 ![]() 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 |
0008 | NWROW | Table name | RDAREA name | ![]() 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 ![]() 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) |
000B | TABN | Table name | ![]() | Digits 1-8: Table number Digits 9-16: Generation number Digits 17-28: Fixed to 00 | Table (during NO WAIT retrieval) |
000C | NKEY | Index name | ![]() | Digits 1-8: Index number Digits 9-28: Fixed to 00 | Key value (NULL) |
000D | DKEY | Index name | ![]() | Digits 1-8: Index number Digits 9-28: 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 to 00 | Logical file |
000F | IXIF | Index name | RDAREA name | Digits 1-8: Index number Digits 9-16: RDAREA number Digits 17-28: Fixed to 00 | Index information file |
0010 | TRWT | Table name | Name of the RDAREA storing the index | Digits 1-8: Table number Digits 9-16: Number of the RDAREA storing the index Digits 17-28: Fixed to 00 | Transaction completion pending |
0011 | SHWT | Table name (**** is output if the system is waiting for RDAREA update completion) | RDAREA name | ![]() 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 ![]() 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 |
0102 | RRAMB | RDAREA name | ![]() | Digits 1-8: RDAREA number Digits 9-28: Fixed to 00 | RDAREA management information |
0111 | MFCB | ![]() | ![]() | Digits 1-8: Page number Digits 9-12: File number Digits 13-28: Fixed to 00 | Master directory segment information |
0112 | MTCB | Table name | ![]() | Digits 1-8: Table number Digits 9-28: Fixed to 00 | Master directory table information |
0113 | MICB | Index name | ![]() | Digits 1-8: Index number Digits 9-28: Fixed to 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 to 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 to 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 to 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 to 00 | RDAREA increment |
0152 | SGMB | RDAREA name | ![]() | Digits 1-8: RDAREA number Digits 9-16: Page number Digits 17-20: File number Digits 21-28: Fixed to 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 to 00 | User LOB RDAREA management information |
0301 | LOBID | RDAREA name | ![]() | Digits 1-8: RDAREA number Digits 9-16: LOB number Digits 17-28: Fixed to 00 | User LOB RDAREA management information |
0601 | RDAS | RDAREA name | ![]() | Digits 1-8: RDAREA number Digits 9-28: Fixed to 00 | Database condition analysis utility |
0602 | HOLD | RDAREA name | ![]() | Digits 1-8: RDAREA number Digits 9-28: Fixed to 00 | Backup-hold RDAREA |
0603 | INRP | Server name | ![]() | 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 |
0604 | RPGP | Original RDAREA name | ![]() | Digits 1-8: RDAREA number Digits 9-28: Fixed to 00 | Replica group configuration management information |
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 to 00 | SQL object management information |
2003 | SPCH | ![]() | ![]() | Fixed to 'SPCH' Extra digits are zero-filled. | SQL object cache |
3001 | PTBL | "****" | "****" | Digits 1-8: Table number Digits 9-28: Fixed to 00 | Pre-processing table |
3001 | AUDL | "****" | "****" | Fixed to AUDL | Audit trail information pool |
3005 | DICT | "****" | "****" | Fixed to 'DICT' Extra digits are zero-filled. | Dictionary table |
3006 | VIEW | "****" | "****" | Digits 1-8: View table number Digits 9-28: Fixed to 00 | View table |
3008 | TBPL | "****" | "****" | Bytes 1-51 are an authorization identifier. Bytes 6-142 are a table identifier. | Table definition information buffer |
3009 | ALAS | "****" | "****" | Bytes 1-51 are an authorization identifier. Bytes 6-142 are a table alias. | Table alias definition information buffer |
3010 | AUTH | "****" | "****" | Bytes 1-14 bytes are an authorization identifier. | User privilege information buffer |
3011 | OBJI | "****" | "****" | Routine object number | Routine object |
3012 | DTYP | "****" | "****" | Fixed to 'DTYP' Extra digits are zero-filled. | Data type definition information |
3013 | RTPL | "****" | "****" | Bytes 1-12 are a routine identifier. Bytes 13-14 are a parameters count. | Routine definition information buffer |
3014 | TPPL | "****" | "****" | Bytes1-51 are an authorization identifier. Bytes 6-142 are a data type identifier. | User-defined type information buffer |
3015 | DICR | "****" | "****" | Fixed to DICR | Dictionary RDAREA modification |
3016 | CONS | "****" | "****" | Fixed to CONSEC | CONNECT-related security definition information |
5001 | DICU | ![]() | ![]() | Fixed to 'DICTMODUTL' Extra digits are 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' Extra digits are zero-filled. | Database import/export 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 to 00 | ZRRAMB updates |
5006 | RCLM | RDAREA name | Table name or index name | Digits 1-8: RDAREA number Digits 9-16: Table number or index number Digits 17-28: Fixed to 00 | Free page release utility |
: Not applicable