SAP ABAP Table DB2_VIEW_TIO_DET (view data structure for timeouts details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2_VIEW_TIO_DET	Table Relationship Diagram
Short Description	view data structure for timeouts details

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	TREE_TAB	☐	DB2TIOUT_TREE		STRU	0	0
2	NAME	☐			STRG	0	0
3	TIODATE	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
4	TIOTIME	☐	DB2CHAR16	DB2CHAR16	CHAR	16	0	Field type char, length 16
5	DBNAME	☐	DB2DBOWNER	DB2CHAR16	CHAR	16	0	The name of the DB2 database
6	RSID	☐	DB2PARTNR	DB2CHAR03	CHAR	3	0	Row ID or partition number, depending on resource type
7	LOCKTYPE	☐	DB2RESTYPE	CHAR20	CHAR	20	0	The type of resource held by a lock
8	WPTYPE	☐	DB2PROCTYP		CHAR	11	0	process type
9	WPNUMBER	☐			NUMC	3	0
10	WPID	☐			NUMC	10	0
11	SQLTEXT	☐	DB2QSTSTMT		CHAR	255	0	Statement text
12	SQLID	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
13	SAPSID	☐			CHAR	3	0
14	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program
15	ENDUSER	☐			CHAR	14	0
16	AGGREGATE	☐			STRG	0	0
17	IS_AGGREGATE	☐	INT4	INT4	INT4	10	0	Natural number
18	MEMBER	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
19	NODE_KEY	☐			INT4	10	0
20	ORIGINTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
21	MSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
22	FLAG	☐			STRG	0	0
23	TIHWID	☐			INT4	10	0
24	TIOUTRS	☐	DB2TIOUTRS		STRU	0	0
25	.INCLUDE	☐				0	0	RFC - Timeout Resources
26	LOTRSSSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
27	LOTRSLUUV	☐	DB2INSTNO	DB2RAW12	RAW	12	0	Instance number (unique value)
28	LOTRSDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
29	LOTRSTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
30	LOTRSMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
31	LOTRSPLAN	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
32	LOTRSAID	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
33	LOTRSCN	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
34	LOTRSCV	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
35	LOTRSEUID	☐	DB2LEUID	CHAR128	CHAR	128	0	DB2/390: End user ID (in DB2 sense)
36	LOTRSEUTX	☐	DB2LEUTX	DB2CHAR32	CHAR	32	0	End user transaction name
37	LOTRSEUWN	☐	DB2LEUWN	DB2CHAR18	CHAR	18	0	End user workstation name
38	LOTRSACCT	☐			CHAR	200	0
39	LOTRSDSGN	☐	DB2DSGN	DB2CHAR08	CHAR	8	0	DB2/390: Data sharing group
40	LOTRSMMEMN	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
41	LOTRSNU	☐	DB2NUMH	DB2NUMC10	NUMC	10	0	Number of holders
42	LOTRSFR	☐	DB2RESTYPE	CHAR20	CHAR	20	0	The type of resource held by a lock
43	LOTRSKD	☐	DB2DBOWNER	DB2CHAR16	CHAR	16	0	The name of the DB2 database
44	LOTRSKP	☐	DB2PAGES2	DB2CHAR18	CHAR	18	0	Object name
45	LOTRSK1	☐	DB2PAGENR	DB2CHAR10	CHAR	10	0	Page number
46	LOTRSK2	☐	DB2PARTNR	DB2CHAR03	CHAR	3	0	Row ID or partition number, depending on resource type
47	LOTRSWU	☐	DB2SWU	DB2CHAR06	CHAR	6	0	IRLM function request (LOCK, UNLOCK, or CHANGE)
48	LOTRSWS	☐	DB2LOCKMS	DB2CHAR03	CHAR	3	0	The mode of the lock held on the resource
49	LOTRSWD	☐	DB2SWD	DB2CHAR12	CHAR	12	0	Lock duration of the thread holding the resource
50	LOTRSWF	☐	DB2RSWF	DB2RAW1	RAW	1	0	Conditional / Unconditional
51	LOTRSTI	☐	DB2WP4TOUT	DB2INT4	INT4	10	0	Maximum time DB2 waits for the release of a locked resource
52	LOTRSTC	☐	DB2W0196TC	DB2INT4	INT4	10	0	Timeout intervals that can occur before agent is timed out
53	LOTRSSTID	☐	DB2RSSTID	DB2INT4	INT4	10	0
54	RZ20	☐			CHAR	10	0
55	E2E	☐			CHAR	10	0
56	HWPTYPE	☐	DB2PROCTYP		CHAR	11	0	process type
57	HWPNUMBER	☐	DB2PROCID		NUMC	19	0	process ID
58	HWPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
59	HASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
60	MEMBER	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
61	WAITERSQL	☐	DB2QSTSTMT		CHAR	255	0	Statement text
62	WSQLTOKN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
63	WSQLSTNM	☐	DB2QSTSTNM	DB2RAW16	RAW	16	0	DB2 statement name
64	CONNNAME	☐			CHAR	30	0
65	SAPSID	☐			CHAR	3	0
66	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program
67	TXCODE	☐	DB2TXNAME		CHAR	80	0	transaction / thread name
68	ENDUSER	☐			CHAR	14	0
69	J2EESERV	☐			CHAR	20	0
70	TIOUTHW	☐	DB2TIOUTHW		STRU	0	0
71	.INCLUDE	☐				0	0	RFC - Timeout Waiter and Holder
72	LOTHWSSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
73	LOTHWLUUV	☐	DB2INSTNO	DB2RAW12	RAW	12	0	Instance number (unique value)
74	LOTHWDATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
75	LOTHWTIME	☐	TIMS	TIME	TIMS	6	0	Field of type TIMS
76	LOTHWMSEC	☐	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
77	LOTHWCNT	☐	DB2UCNT		INT4	10	0	DB2/390: Unique counter
78	LOTHWHW	☐	DB2W0196HW	DB2CHAR01	CHAR	1	0	H=Holder, W = Waiter, and R = Retained
79	LOTHWHP	☐	DB2WHCPLAN	CHAR128	CHAR	128	0	DB2 plan name
80	LOTHWHB	☐	DB2WHCAID	CHAR128	CHAR	128	0	The authorization ID under which the transaction is running
81	LOTHWHN	☐	DB2WHCCN	DB2CHAR08	CHAR	8	0	The connection ID of the thread
82	LOTHWHR	☐	DB2WHCCV	DB2CHAR16	CHAR	16	0	The correlation ID of the thread (IP address)
83	LOTHWHC	☐	DB2LEUID	CHAR128	CHAR	128	0	DB2/390: End user ID (in DB2 sense)
84	LOTHWHJ	☐	DB2LEUTX	DB2CHAR32	CHAR	32	0	End user transaction name
85	LOTHWHK	☐	DB2LEUWN	DB2CHAR18	CHAR	18	0	End user workstation name
86	LOTHWACCT	☐			CHAR	200	0
87	LOTHWHLUUV	☐	DB2CHAR12	DB2CHAR12	CHAR	12	0	Field type char, length 12
88	LOTHWHT	☐	DBW0196HT		INT4	10	0	Holder token
89	LOTHWHI	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
90	LOTHWHS	☐	DB2LOCKMS	DB2CHAR03	CHAR	3	0	The mode of the lock held on the resource
91	LOTHWHD	☐	DB2SWD	DB2CHAR12	CHAR	12	0	Lock duration of the thread holding the resource
92	LOTHWHF	☐	DB2RAW1	DB2RAW1	RAW	1	0	RFC - raw 1
93	LOTHWSTID	☐	DB2HWSTID	DB2INT4	INT4	10	0
94	RZ20	☐			CHAR	10	0
95	E2E	☐			CHAR	10	0
96	WPTYPE	☐	DB2WPTYE	DB2CHAR05	CHAR	5	0	Corresponding R/3 work process type
97	WPNUMBER	☐	DB2WPNUM	DB2NUMC10	NUMC	10	0	Work process number
98	WPID	☐	DB2WPID	DB2NUMC10	NUMC	10	0	Work process ID
99	ASHOST	☐	DB2ASHOST	DB2CHAR32	CHAR	32	0	Application server host name
100	MEMBER	☐	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
101	HOLDERSQL	☐	DB2QSTSTMT		CHAR	255	0	Statement text
102	HSQLTOKN	☐	DB2QSTTOKN	DB2INT4	INT4	10	0	Statement ID
103	HSQLSTNM	☐	DB2QSTSTNM	DB2RAW16	RAW	16	0	DB2 statement name
104	CONNNAME	☐			CHAR	30	0
105	SAPSID	☐			CHAR	3	0
106	ABAPREP	☐	SYREPID	PROGRAMM	CHAR	40	0	ABAP Program: Current Main Program
107	TXCODE	☐			CHAR	20	0
108	ENDUSER	☐			CHAR	14	0
109	J2EESERV	☐			CHAR	20	0

History

Last changed by/on	SAP	20141013
SAP Release Created in	740