Data Element list used by SAP ABAP Table DB2SWPARM (Summary Structure for System-Wide Parameters)
SAP ABAP Table 
DB2SWPARM (Summary Structure for System-Wide Parameters) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2ARLOGWR | Number of control intervals offloaded to archive log(second) | |
| 2 | Data Element |
DB2DATE | Field type date, YYYYMMDD | |
| 3 | Data Element |
DB2FCONRAT | False contention rate | |
| 4 | Data Element |
DB2GBPFAIL | GBP: Read/Write failures due to storage shortage | |
| 5 | Data Element |
DB2GBPREAD | Group buffer pool: # of pages returned on CF read request | |
| 6 | Data Element |
DB2GBPWRIT | Group buffer pool: # of times a CF write request completed | |
| 7 | Data Element |
DB2GCONRAT | Global contention rate | |
| 8 | Data Element |
DB2LOCKESC | Total number of lock escalations | |
| 9 | Data Element |
DB2LOGLCR | Number of internal log latch contentions per second | |
| 10 | Data Element |
DB2LOGSER | Number of log write I/O requests minus serial requests | |
| 11 | Data Element |
DB2PAGEPR | Page-ins per pages read | |
| 12 | Data Element |
DB2RNDHITR | Random hit ratio | |
| 13 | Data Element |
DB2SWPACMD | Alter Bufferpool/Alter Group Bufferpool commands are issued | |
| 14 | Data Element |
DB2SWPAPG | Maximum active pages across all the active buffer pools | |
| 15 | Data Element |
DB2SWPAPGN | Buffer pool with maximum active pages | |
| 16 | Data Element |
DB2SWPATDT | Date when sampling is taken | |
| 17 | Data Element |
DB2SWPATTM | Time when sampling is taken | |
| 18 | Data Element |
DB2SWPBPNA | Selected buffer pool | |
| 19 | Data Element |
DB2SWPBWRA | Output log buffer writes per active log control interval | |
| 20 | Data Element |
DB2SWPCODS | Percentage of currently open datasets | |
| 21 | Data Element |
DB2SWPCOMM | The number of commits | |
| 22 | Data Element |
DB2SWPCPNT | No. of checkpoints | |
| 23 | Data Element |
DB2SWPCTR | (CT requests - CT not in EDM pool) / CT requests | |
| 24 | Data Element |
DB2SWPDBDR | (DBD requests - DBD not in EDM pool) / DBD requests | |
| 25 | Data Element |
DB2SWPDEFC | Datasets closed because deferred close threshold is reached | |
| 26 | Data Element |
DB2SWPDLCK | No. of deadlocks | |
| 27 | Data Element |
DB2SWPDSIU | Number of datasets currently in use | |
| 28 | Data Element |
DB2SWPEPFL | Total number of failures due to EDM pool being full | |
| 29 | Data Element |
DB2SWPHPC | Hiper pool concerns for any of the active buffer pools | |
| 30 | Data Element |
DB2SWPHPCN | Buffer pool which has hiperpool concerns | |
| 31 | Data Element |
DB2SWPHRTN | Buffer pool which has the minimum hit ratio | |
| 32 | Data Element |
DB2SWPLGWR | Number of bytes in KB written for active log per sec | |
| 33 | Data Element |
DB2SWPLGWW | Number of log write waits | |
| 34 | Data Element |
DB2SWPLOGR | The number of log reads which had to access archive log DSs | |
| 35 | Data Element |
DB2SWPLRTM | Time of last reset | |
| 36 | Data Element |
DB2SWPPGIU | Percentage of EDM pool pages currently in use | |
| 37 | Data Element |
DB2SWPPRED | Degree of parallelism lower than planned | |
| 38 | Data Element |
DB2SWPPTR | (PT requests - PT not in EDM pool) / PT requests | |
| 39 | Data Element |
DB2SWPRIDL | Any of the RID list limits is reached | |
| 40 | Data Element |
DB2SWPROLL | Number of rollbacks | |
| 41 | Data Element |
DB2SWPSHT | Buffer pool shortage in any of the active buffer pools | |
| 42 | Data Element |
DB2SWPSHTN | Buffer pool which has a buffer pool shortage | |
| 43 | Data Element |
DB2SWPSSID | DB2 subsystem ID | |
| 44 | Data Element |
DB2SWPSTRC | Start Trace command was issued | |
| 45 | Data Element |
DB2SWPSUSP | Number of suspensions of all kinds | |
| 46 | Data Element |
DB2SWPTDCL | Total number of Data Control Language statements | |
| 47 | Data Element |
DB2SWPTDDL | Total number of Data Definition Language statements | |
| 48 | Data Element |
DB2SWPTDML | Total number of Data Manipulation Language statements | |
| 49 | Data Element |
DB2SWPTIME | Number of timeouts | |
| 50 | Data Element |
DB2TIME | Field type time, HHMMSS | |
| 51 | Data Element |
DB2TLOPRAT | Locking optimization rate | |
| 52 | Data Element |
DB2XSTDEXP | MAXKEEPD parameter exceeded |
