Data Element list used by SAP ABAP Table DB2STATDEC (DB2/390: Buffer Pool Tuning: Table Categorisation)
SAP ABAP Table 
DB2STATDEC (DB2/390: Buffer Pool Tuning: Table Categorisation) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
DB2ACCFREQ | DB2 OS/390: Access frequency: max(executes , affected rows) | |
| 2 | Data Element |
DB2ACCTYPE | DB2 for OS/390: Access type: random or sequential | |
| 3 | Data Element |
DB2BPCURR | Name of the DB2 buffer pool currently used for the TS | |
| 4 | Data Element |
DB2BPSUG | Suggested DB2 buffer pool | |
| 5 | Data Element |
DB2CARDFD | Total number of rows in the table | |
| 6 | Data Element |
DB2CHANGES | DB2/390: changes vs. all executions in percent | |
| 7 | Data Element |
DB2CHAR01 | Field type char, length 1 | |
| 8 | Data Element |
DB2DBNAME | Database name | |
| 9 | Data Element |
DB2EXECS | Sum of execution of updates, inserts, deletes and fetches | |
| 10 | Data Element |
DB2FETCHES | DB2 for OS/390: Number of fetches | |
| 11 | Data Element |
DB2NPAGESD | Number of pages on which rows of the table appear | |
| 12 | Data Element |
DB2RECLEN | Maximum length (in bytes) of any record in the table | |
| 13 | Data Element |
DB2SIZE | DB2 for OS/390: Size category of the table (small, large) | |
| 14 | Data Element |
DB2TABCAT | DB2 for OS/390: Table category | |
| 15 | Data Element |
DB2TABNAME | DB2 table name | |
| 16 | Data Element |
DB2TABSIZE | DB2 for OS/390: Table size ( pages * reclength / 1024 ) | |
| 17 | Data Element |
DB2TSNAME | Name of the tablespace | |
| 18 | Data Element |
DBSTATSQLT | Name of the pool or cluster | |
| 19 | Data Element |
DELCNTD | No. of DELETE attempts | |
| 20 | Data Element |
DIRFETCHD | Number of FETCHes for direct read commands (SELECT SINGLE) | |
| 21 | Data Element |
INSCNTD | No. of INSERT attempts | |
| 22 | Data Element |
SEQFETCHD | Number of FETCHes for sequential read commands | |
| 23 | Data Element |
SEQROWD | Number of records read at sequential read operations | |
| 24 | Data Element |
UPDCNTD | No. of UPDATE commands |
