SAP ABAP Table DB2QW199 (DB2 IFI 199 - Data sets statistics)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QW199	Table Relationship Diagram
Short Description	DB2 IFI 199 - Data sets statistics

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	CLGUID	☑	DB2CLGUID	SMAPGUID	CHAR	32	0
2	USERID	☑	DB2USERID	DB2SINT	INT2	5	0
3	DSSDATE	☑	DATS	DATS	DATS	8	0	Field of type DATS
4	DSSTIME	☑	TIMS	TIME	TIMS	6	0	Field of type TIMS
5	DSSMSEC	☑	DB2EVTTMS	DB2CHAR06	CHAR	6	0	Event time stamp (milliseconds)
6	DSSDBNAME	☑	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
7	DSSTSNAME	☑	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
8	QW0199DN	☑	DB20199DN	DB2SINT	INT2	5	0	Partition or piece number
9	DSSMEMB	☑	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
10	DB2PSTYPE	☐	DB2PSTYPE	DB2CHAR5	CHAR	5	0	Type of pageset
11	DB2GBPDEP	☐	DB2GBPDEP	DB2CHAR03	CHAR	3	0	Group bufferpool dependence
12	DB2SYNCIO	☐	DB2SYNCIO	DB2DEC10_2	DEC	8	2	Synchronous I/O per minute (pages)
13	DB2APGAIO	☐	DB2APGAIO	DB2DEC10_2	DEC	8	2	Avg. number of pages read or written per asynchronous I/O
14	DB2AIOMIN	☐	DB2AIOMIN	DB2DEC10_2	DEC	8	2	Asyncronous I/Os per minute (pages)
15	DB2CASHPG	☐	DB2CASHPG	DB2DECPCT	DEC	5	2	Cached pages
16	DB2CHANPG	☐	DB2CHANPG	DB2DECPCT	DEC	5	2	Changed pages
17	DB2HPCAPG	☐	DB2HPCAPG	DB2DEC4_2	DEC	4	2	Percentage of buffers in the HP containing pages of the PS
18	DB2DBPNM	☐	DB2DBPNM	CHAR8	CHAR	8	0	Name of buffer pool
19	QW0199TS	☐	DB20199TS	DB2CHAR08	CHAR	8	0	Start timestamp for collection of dataset values
20	QW0199DB	☐	DB20199DB	DB2SINT	INT2	5	0	Database ID
21	QW0199OB	☐	DB20199OB	DB2SINT	INT2	5	0	Pageset OBID
22	QW0199BP	☐	DB20199BP	DB2INT4	INT4	10	0	Buffer pool ID
23	QW0199DS	☐	DB20199DS	DB2CHAR01	CHAR	1	0	DSS Flags
24	QW0199SV	☐	DB20199SV	DB2INT4	INT4	10	0	Average synchronous I/O delay
25	QW0199SX	☐	DB20199SX	DB2INT4	INT4	10	0	Maximum synchronous I/O delay
26	QW0199SP	☐	DB20199SP	DB2INT4	INT4	10	0	Total number of pages read or written synchronously
27	QW0199AD	☐	DB20199AD	DB2INT4	INT4	10	0	Average asynchronous I/O delay
28	QW0199AX	☐	DB20199AX	DB2INT4	INT4	10	0	Maximum asynchronous I/O delay
29	QW0199AP	☐	DB20199AP	DB2INT4	INT4	10	0	Total number of pages read or written asynchronously
30	QW0199AC	☐	DB20199AC	DB2INT4	INT4	10	0	Total number of asynchronous I/Os
31	QW0199VP	☐	DB20199VP	DB2INT4	INT4	10	0	Number of pages cached in virtual pool
32	QW0199VD	☐	DB20199VD	DB2INT4	INT4	10	0	Number of changed pages cached in virtual pool
33	QW0199HP	☐	DB20199HP	DB2INT4	INT4	10	0	Number of pages cached in hiperpool
34	S199AP	☐	DB2199AP	DB2DEC10_2	DEC	8	2	Total asynchronous I/O minute (count)
35	QWP1DTIM	☐	DB2WP1DTIM	DB2SINT	INT2	5	0	Time Interval Before DB2 Resets Data Set Statistics (Min.)

History

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