Scalable Database Server, HiRDB Version 8 System Operation Guide

[Contents][Index][Back][Next]

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 type Type name Resource name 1 Resource name 2 Resource information Contents
0001 RDAR RDAREA [Figure] Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00		 RDAREA
0002 TABL Table name [Figure] 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 [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
0007 ROW Table name 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		 Row
0008 NWROW Table name 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		 Row (for controlling WITHOUT LOCK NOWAIT retrieval)
000B TABN Table name [Figure] 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 [Figure] Digits 1-8: Index number
Digits 9-28: Fixed to 00		 Key value (NULL)
000D DKEY Index name [Figure] 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 [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
0102 RRAMB RDAREA name [Figure] Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00		 RDAREA management information
0111 MFCB [Figure] [Figure] Digits 1-8: Page number
Digits 9-12: File number
Digits 13-28: Fixed to 00		 Master directory segment information
0112 MTCB Table name [Figure] Digits 1-8: Table number
Digits 9-28: Fixed to 00		 Master directory table information
0113 MICB Index name [Figure] 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 [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
0132 SBMB RDAREA 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
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 [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
0300 MENT RDAREA 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
0301 LOBID RDAREA name [Figure] 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 [Figure] Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00		 Database condition analysis utility
0602 HOLD RDAREA name [Figure] Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00		 Backup-hold RDAREA
0603 INRP Server 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
0604 RPGP Original RDAREA name [Figure] Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00		 Replica group configuration management information
0900 PLGR [Figure] [Figure] Digits 1-8: Plug-in ID
Digits 9-28: Plug-in's unique resource number		 Plug-in resource number
2002 ROMB [Figure] [Figure] Digits 1-14: SQL object number
Digits 15-28: Fixed to 00		 SQL object management information
2003 SPCH [Figure] [Figure] 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 [Figure] [Figure] Fixed to 'DICTMODUTL'
Extra digits are zero-filled.		 Database structure modification utility
5002 LCBF RDAREA name [Figure] Digits 1-8: RDAREA number
Digits 9-28: Fixed to 00		 [Figure]
5003 EXP1 [Figure] [Figure] Fixed to 'EXPIMPMDL'
Extra digits are zero-filled.		 Database import/export utility
5004 RBAL Table name [Figure] Digits 1-8: Table number
Digits 9-28: Fixed to 00		 Rebalancing utility
5005 RRAMB Server name [Figure] 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

[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.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2007, Hitachi, Ltd.