SAP ABAP Table DB2SWPARM (Summary Structure for System-Wide Parameters)

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	DB2SWPARM	Table Relationship Diagram
Short Description	Summary Structure for System-Wide Parameters

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	HDSUBSYSID	☐	DB2SWPSSID	DB2CHAR04	CHAR	4	0	DB2 subsystem ID
2	HDATDAT	☐	DB2SWPATDT	DB2DATE	DATS	8	0	Date when sampling is taken
3	HDATTIM	☐	DB2SWPATTM	DB2TIME	TIMS	6	0	Time when sampling is taken
4	HDSINCEDAT	☐	DB2DATE	DB2DATE	DATS	8	0	Field type date, YYYYMMDD
5	HDSINCETIM	☐	DB2TIME	DB2TIME	TIMS	6	0	Field type time, HHMMSS
6	HDLRESTIME	☐	DB2SWPLRTM	DB2TIME	TIMS	6	0	Time of last reset
7	BPACTPGNM	☐	DB2SWPAPGN	DB2BPNAME	CHAR	8	0	Buffer pool with maximum active pages
8	BPACTPG	☐	DB2SWPAPG	CHAR8	CHAR	8	0	Maximum active pages across all the active buffer pools
9	BPHITRATNM	☐	DB2SWPHRTN	DB2BPNAME	CHAR	8	0	Buffer pool which has the minimum hit ratio
10	BPHITRAT	☐	DB2RNDHITR	DB2DECPCT	DEC	5	2	Random hit ratio
11	BPSHORTNM	☐	DB2SWPSHTN	DB2BPNAME	CHAR	8	0	Buffer pool which has a buffer pool shortage
12	BPSHORT	☐	DB2SWPSHT	DB2CHAR05	CHAR	5	0	Buffer pool shortage in any of the active buffer pools
13	BPHPCONCNM	☐	DB2SWPHPCN	DB2BPNAME	CHAR	8	0	Buffer pool which has hiperpool concerns
14	BPHPCONC	☐	DB2SWPHPC	DB2CHAR05	CHAR	5	0	Hiper pool concerns for any of the active buffer pools
15	LKDEADLOCK	☐	DB2SWPDLCK	DB2INT4	INT4	10	0	No. of deadlocks
16	LKTIMEOUT	☐	DB2SWPTIME	DB2INT4	INT4	10	0	Number of timeouts
17	LKSUSPENS	☐	DB2SWPSUSP	DB2DEC10V	DEC	10	0	Number of suspensions of all kinds
18	LGLOGREAD	☐	DB2SWPLOGR	DB2NUMC10	NUMC	10	0	The number of log reads which had to access archive log DSs
19	LGLOGWWAIT	☐	DB2SWPLGWW	DB2NUMC10	NUMC	10	0	Number of log write waits
20	LGLOGWRAT	☐	DB2SWPLGWR	DB2CHAR10	CHAR	10	0	Number of bytes in KB written for active log per sec
21	EPFULL	☐	DB2SWPEPFL	DB2INT4	INT4	10	0	Total number of failures due to EDM pool being full
22	EPPGINUSE	☐	DB2SWPPGIU		CHAR	7	0	Percentage of EDM pool pages currently in use
23	OCDEFCLOSE	☐	DB2SWPDEFC	DB2CHAR05	CHAR	5	0	Datasets closed because deferred close threshold is reached
24	OCCUROPEDS	☐	DB2SWPCODS		CHAR	7	0	Percentage of currently open datasets
25	SSCOMMIT	☐	DB2SWPCOMM	DB2DEC10V	DEC	10	0	The number of commits
26	SSROLLBACK	☐	DB2SWPROLL	DB2INT4	INT4	10	0	Number of rollbacks
27	SSCHECKPNT	☐	DB2SWPCPNT	DB2INT4	INT4	10	0	No. of checkpoints
28	SATOTALDML	☐	DB2SWPTDML	DB2DEC21V	DEC	21	0	Total number of Data Manipulation Language statements
29	SATOTALDCL	☐	DB2SWPTDCL	DB2DEC21V	DEC	21	0	Total number of Data Control Language statements
30	SATOTALDDL	☐	DB2SWPTDDL	DB2DEC21V	DEC	21	0	Total number of Data Definition Language statements
31	MCPARALRED	☐	DB2SWPPRED	DB2CHAR05	CHAR	5	0	Degree of parallelism lower than planned
32	MCRIDLIST	☐	DB2SWPRIDL	DB2CHAR05	CHAR	5	0	Any of the RID list limits is reached
33	MCALTERCMD	☐	DB2SWPACMD	DB2CHAR05	CHAR	5	0	Alter Bufferpool/Alter Group Bufferpool commands are issued
34	MCSTARTTRC	☐	DB2SWPSTRC	DB2CHAR05	CHAR	5	0	Start Trace command was issued
35	BPNAME	☐	DB2SWPBPNA	DB2BPNAME	CHAR	8	0	Selected buffer pool
36	LGBUFWRACT	☐	DB2SWPBWRA	DB2CHAR10	CHAR	10	0	Output log buffer writes per active log control interval
37	EPCTREQ	☐	DB2SWPCTR	DB2CHAR10	CHAR	10	0	(CT requests - CT not in EDM pool) / CT requests
38	EPPTREQ	☐	DB2SWPPTR	DB2CHAR10	CHAR	10	0	(PT requests - PT not in EDM pool) / PT requests
39	EPDBDREQ	☐	DB2SWPDBDR	DB2CHAR10	CHAR	10	0	(DBD requests - DBD not in EDM pool) / DBD requests
40	OCDSINUSE	☐	DB2SWPDSIU	DB2NUMC10	NUMC	10	0	Number of datasets currently in use
41	MAXKEEPEX	☐	DB2XSTDEXP	DB2DEC19V	DEC	19	0	MAXKEEPD parameter exceeded
42	GCONTRATE	☐	DB2GCONRAT	DB2CHAR10	CHAR	10	0	Global contention rate
43	FCONTRATE	☐	DB2FCONRAT	DB2CHAR10	CHAR	10	0	False contention rate
44	TLOPTRATE	☐	DB2TLOPRAT	DB2CHAR10	CHAR	10	0	Locking optimization rate
45	LGLOGSER	☐	DB2LOGSER	DB2NUMC10	NUMC	10	0	Number of log write I/O requests minus serial requests
46	LGARLOGWR	☐	DB2ARLOGWR	DB2CHAR10	CHAR	10	0	Number of control intervals offloaded to archive log(second)
47	LGLOGLCR	☐	DB2LOGLCR	DB2CHAR10	CHAR	10	0	Number of internal log latch contentions per second
48	GBPREADMIS	☐	DB2GBPREAD	DB2NUMC10	NUMC	10	0	Group buffer pool: # of pages returned on CF read request
49	GBPWRITHIT	☐	DB2GBPWRIT	DB2NUMC10	NUMC	10	0	Group buffer pool: # of times a CF write request completed
50	GBPSTOFAIL	☐	DB2GBPFAIL	DB2NUMC10	NUMC	10	0	GBP: Read/Write failures due to storage shortage
51	LOCKESCAL	☐	DB2LOCKESC	DB2DEC10V	DEC	10	0	Total number of lock escalations
52	PAGEINS	☐	DB2PAGEPR	DB2DECPCT	DEC	5	2	Page-ins per pages read

History

Last changed by/on	SAP	20110908
SAP Release Created in