Nonstop Database, HiRDB Version 9 Messages

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

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

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.

[Contents][Back][Next]

[Trademarks]

All Rights Reserved. Copyright (C) 2011, 2014, Hitachi, Ltd.