SAP ABAP Table DB4WTSTS_P (iSeries: Wait Statistics per Process (Database Jobs))

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB4 (Application Component) DB2 for AS/400
     ⤷ STU4 (Package) CCMS / AS/400

Basic Data

Table Category	INTTAB	Structure
Structure	DB4WTSTS_P	Table Relationship Diagram
Short Description	iSeries: Wait Statistics per Process (Database Jobs)

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	INSTANCE_P	☐	MSNAME	MSNAME	CHAR	20	0	Server Name
2	PID	☐	WPPID	WPPID	CHAR	8	0	Process Identification
3	JOBNUM	☐	QQJNUM	QQJNUM	CHAR	6	0	iSeries: Job Number (Database Monitor)
4	WDB	☐	DB_WAITS	INT4	INT4	10	0	Number of times a process had to wait to obtain a DB lock
5	WNDB	☐	NDB_WAITS	INT4	INT4	10	0	Number of times a process had to wait to obtain a nonDB lock
6	WIM	☐	IM_WAITS	INT4	INT4	10	0	No. of times a process had to wait to obtain an IM lock
7	WDBT	☐	DB_W_TIME	INT4	INT4	10	0	Cumulative time (millisec.) spent on database lock waits
8	WNDBT	☐	NDB_W_TIME	INT4	INT4	10	0	Cumulative time (millisec.) spent on non-DB lock waits
9	WIMT	☐	IM_W_TIME	INT4	INT4	10	0	Cumulative time (millisec.) spent on internal machine waits
10	WDBT_AVG	☐	WDBT_AVG	DEC154_DB4	DEC	15	4	Average process database lock wait time (ms)
11	WNDBT_AVG	☐	WNDBT_AVG	DEC154_DB4	DEC	15	4	Average process non-database lock wait time (ms)
12	WIMT_AVG	☐	WIMT_AVG	DEC154_DB4	DEC	15	4	Average process internal machine lock wait time (ms)

History

Last changed by/on	SAP	20130604
SAP Release Created in