The following table shows the resource types and resource information included in the deadlock or timeout information.

Table 8-8 Resource types and resource information

Resource type	Type name	Resource name 1#1	Resource name 2#1	Resource information	Contents
0001	RDAR	RDAREA name	--	Digits 1-8: RDAREA number Digits 9-28: Fixed to 00	RDAREA
0002	TABL	Table name or sequence generator name	--	Digits 1-8: Table number or sequence generator number Digits 9-16: Generation number Digits 17-28: Fixed to 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 to 00	Index
0004	PAGE	Table name or index name	RDAREA name	For HP-UX, Solaris, and AIX editions 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 For Linux edition 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	For HP-UX, Solaris, and AIX editions 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 For Linux edition 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	For HP-UX, Solaris, and AIX editions 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 For Linux editions 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 NOWAIT 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	For HP-UX, Solaris, and AIX editions 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 For Linux edition 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
0502	TEMP	Server name	--	The first 8 bytes indicate a server name. If the server name is shorter than 8 bytes, the remainder is filled with NULL values.	Temporary table instantiation management information
0503	TPID	--	--	Digits 1-8: User-specific number Digits 9-28: Fixed to 00	User-specific ID management (temporary table)
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
0605	MDBS	RDAREA name	--	Digits 1-8: RDAREA number Digits 9-28: Fixed to 00	In-memory data processing synchronization 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
2004	TRAL	"****"	"****"	Fixed to TMPRDAREA Extra digits are zero-filled.	Management information for temporary table RDAREA
2005	TRAI	"****"	"****"	Digits 1-8: Management block number of temporary table RDAREA Digits 9-28: Fixed to 00	Information on temporary table RDAREA
3001	PTBL	"****"	"****"	Digits 1-8: Table number Digits 9-28: Fixed to 00	Pre-processing table
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-5#2 are an authorization identifier. Bytes 6-14#3 are a table identifier.	Table 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-5#2 are an authorization identifier. Bytes 6-14#3 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
3017	SQID	"****"	"****"	Digits 1-8: Sequence generator number#4 Digits 9-28: Fixed to 00	Sequence generator
3018	SQPL	"****"	"****"	The first 5 bytes#2 indicate an authorization identifier. Bytes 6-14#3 indicate a sequence generator identifier.	Sequence generator 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

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

If the table name, sequence generator name, or RDAREA name of resource name 1 or resource name 2 cannot be displayed, asterisks (****) are displayed. In this case, identify the target resource based on the table number, sequence generator number, or RDAREA number in the resource information.

#2

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 code and one byte is output as two digits.

#3

Table identifiers, data type identifiers, and sequence generator identifiers (10 bytes or longer) are output in the following format:

first 5 bytes of table identifier or data type identifier or sequence generator identifier + last 4 bytes of table identifier or data type identifier or sequence generator identifier

For example, if the table identifier is TABLE002498, TABLE2498 is output.

Note that the information is in ASCII code, and one byte is output as two digits.

#4:

For the sequence generator number, see the SEQUENCE_ID column in the dictionary table SQL_SEQUENCES.