SAP ABAP Table SYBDBH_DEADLOCK (SYB: saptools..DBH_DEADLOCKS)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	SYBDBH_DEADLOCK	Table Relationship Diagram
Short Description	SYB: saptools..DBH_DEADLOCKS

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	DEADLOCKID	☐			INT4	10	0
2	HELDAPPLNAME	☐			CHAR	30	0
3	HELDBATCHID	☐			INT4	10	0
4	HELDCLIENTAPPLNAME	☐			CHAR	30	0
5	HELDCLIENTHOSTNAME	☐			CHAR	30	0
6	HELDCLIENTNAME	☐			CHAR	30	0
7	HELDCOMMAND	☐			CHAR	30	0
8	HELDCONTEXTID	☐			INT4	10	0
9	HELDFAMILYID	☐			INT4	10	0
10	HELDHOSTNAME	☐			CHAR	30	0
11	HELDINSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
12	HELDKPID	☐			INT4	10	0
13	HELDLINENUMBER	☐			INT4	10	0
14	HELDLOCKTYPE	☐			CHAR	20	0
15	HELDNUMLOCKS	☐			INT4	10	0
16	HELDPROCDBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
17	HELDPROCDBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
18	HELDPROCEDUREID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
19	HELDPROCEDURENAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
20	HELDSOURCECODEID	☐			CHAR	30	0
21	HELDSTMTNUMBER	☐			INT4	10	0
22	HELDSTMTTEXT	☐			STRG	0	0
23	HELDSTMTTRANISOLEVEL	☐			INT1	3	0
24	HELDSTMTTRANMODE	☐			INT1	3	0
25	HELDTRANNAME	☐			STRG	0	0
26	HELDUSERNAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
27	OBJECTDBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
28	OBJECTDBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
29	OBJECTID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
30	OBJECTNAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
31	PAGENUMBER	☐			INT4	10	0
32	REALHOSTNAME	☐			CHAR	60	0
33	ROWNUMBER	☐			INT4	10	0
34	VICTIMKPID	☐			INT4	10	0
35	WAITAPPLNAME	☐			CHAR	30	0
36	WAITBATCHID	☐			INT4	10	0
37	WAITCLIENTAPPLNAME	☐			CHAR	30	0
38	WAITCLIENTHOSTNAME	☐			CHAR	30	0
39	WAITCLIENTNAME	☐			CHAR	30	0
40	WAITCOMMAND	☐			CHAR	30	0
41	WAITCONTEXTID	☐			INT4	10	0
42	WAITFAMILYID	☐			INT4	10	0
43	WAITHOSTNAME	☐			CHAR	30	0
44	WAITINSTANCEID	☐	SYBINSTID		INT2	5	0	SYB: Instance ID in Cluster Edition
45	WAITKPID	☐			INT4	10	0
46	WAITLINENUMBER	☐			INT4	10	0
47	WAITLOCKTYPE	☐			CHAR	20	0
48	WAITPROCDBID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
49	WAITPROCDBNAME	☐	SYBDBNAME	SYBDBNAME	CHAR	30	0	SYB: DB Name
50	WAITPROCEDUREID	☐	SYBOBJID		INT4	10	0	SYB: Object ID (Index, Table, DB, Partition, ...)
51	WAITPROCEDURENAME	☐	SYBOBJNAME	SYBOBJNAME	CHAR	128	0	SYB: Object Name (Index, Table, Partition, ...)
52	WAITSOURCECODEID	☐			CHAR	30	0
53	WAITSTMTNUMBER	☐			INT4	10	0
54	WAITSTMTTEXT	☐			STRG	0	0
55	WAITSTMTTRANISOLEVEL	☐			INT1	3	0
56	WAITSTMTTRANMODE	☐			INT1	3	0
57	WAITTIME	☐			INT4	10	0
58	WAITTRANNAME	☐			STRG	0	0
59	WAITUSERNAME	☐	SYBOBJOWNER	SYBOBJOWNER	CHAR	128	0	SYB: Object Owner (Index, Table, DB, Partition, ...)
60	RESOLVETIME	☐			STRG	0	0
61	HELDSPID	☐			INT4	10	0
62	WAITSPID	☐			INT4	10	0

History

Last changed by/on	SAP	20110908
SAP Release Created in	731