SAP ABAP Table DB4WTSTS_I (iSeries: Wait Statistics Cumulated per Instance)

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_I	Table Relationship Diagram
Short Description	iSeries: Wait Statistics Cumulated per Instance

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	☐	MSNAME	MSNAME	CHAR	20	0	Server Name
2	.INCLUDE	☐				0	0	Wait Statistics for DB2 UDB for iSeries
3	WDB	☐	WDB_SUM	INT4	INT4	10	0	Cumulative number of process waits for database locks
4	WNDB	☐	WNDB_SUM	INT4	INT4	10	0	Cumulative number of process waits for non-database locks
5	WIM	☐	WIM_SUM	INT4	INT4	10	0	Cumulative no. of process waits for internal machine locks
6	WDBT	☐	WDBT_SUM	DEC150_DB4	DEC	15	0	Total cumulative time spent on DB lock waits (all processes)
7	WNDBT	☐	WNDBT_SUM	DEC150_DB4	DEC	15	0	Total cumulative time spent on non-database lock waits
8	WIMT	☐	WIMT_SUM	DEC150_DB4	DEC	15	0	Total cumulative time spent on internal machine waits
9	WDBT_AVG	☐	WDBT_S_AVG	DEC154_DB4	DEC	15	4	Average of total cumulative database lock wait time
10	WNDBT_AVG	☐	WNDBT_S_AG	DEC154_DB4	DEC	15	4	Average of total cumulative non-database lock wait time
11	WIMT_AVG	☐	WIMT_S_AVG	DEC154_DB4	DEC	15	4	Average of total cumulative internal machine lock wait time

History

Last changed by/on	SAP	20130604
SAP Release Created in