SAP ABAP Table DB2STATDEC (DB2/390: Buffer Pool Tuning: Table Categorisation)

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	DB2STATDEC	Table Relationship Diagram
Short Description	DB2/390: Buffer Pool Tuning: Table Categorisation

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	TNAME	☐	DB2TABNAME	CHAR18	CHAR	18	0	DB2 table name
2	RNAME	☐	DBSTATSQLT	AS4TAB	CHAR	30	0	Name of the pool or cluster	*
3	DBNAME	☐	DB2DBNAME	D2DBNAME	CHAR	8	0	Database name
4	TSNAME	☐	DB2TSNAME	CHAR8	CHAR	8	0	Name of the tablespace
5	UPDCNT	☐	UPDCNTD	DEC12	DEC	12	0	No. of UPDATE commands
6	DELCNT	☐	DELCNTD	DEC12	DEC	12	0	No. of DELETE attempts
7	INSCNT	☐	INSCNTD	DEC12	DEC	12	0	No. of INSERT attempts
8	FETCHES	☐	DB2FETCHES	DEC12	DEC	12	0	DB2 for OS/390: Number of fetches
9	DIR_FETCH	☐	DIRFETCHD	DEC12	DEC	12	0	Number of FETCHes for direct read commands (SELECT SINGLE)
10	SEQ_FETCH	☐	SEQFETCHD	DEC12	DEC	12	0	Number of FETCHes for sequential read commands
11	SEQ_ROW	☐	SEQROWD	DEC12	DEC	12	0	Number of records read at sequential read operations
12	BUF	☐	DB2CHAR01	DB2CHAR01	CHAR	1	0	Field type char, length 1
13	NPAGES	☐	DB2NPAGESD	DB2DEC12	DEC	12	0	Number of pages on which rows of the table appear
14	BPOOL	☐	DB2BPCURR	DB2BPNAME	CHAR	8	0	Name of the DB2 buffer pool currently used for the TS
15	BPSUG	☐	DB2BPSUG	DB2BPNAME	CHAR	8	0	Suggested DB2 buffer pool
16	RECLENGTH	☐	DB2RECLEN		INT4	10	0	Maximum length (in bytes) of any record in the table
17	EXECUTES	☐	DB2EXECS	DEC12	DEC	12	0	Sum of execution of updates, inserts, deletes and fetches
18	ACCESS_FR	☐	DB2ACCFREQ	DB2NUMC10	NUMC	10	0	DB2 OS/390: Access frequency: max(executes , affected rows)
19	ACCESS_TY	☐	DB2ACCTYPE	DB2CHAR10L	CHAR	10	0	DB2 for OS/390: Access type: random or sequential
20	PERC_CHAN	☐	DB2CHANGES	DB2NUMC05	NUMC	5	0	DB2/390: changes vs. all executions in percent
21	SIZE	☐	DB2SIZE	DB2CHAR06L	CHAR	6	0	DB2 for OS/390: Size category of the table (small, large)
22	CATEGORY	☐	DB2TABCAT	DB2TABCAT	CHAR	2	0	DB2 for OS/390: Table category
23	SIZE_KB	☐	DB2TABSIZE	DEC12	DEC	12	0	DB2 for OS/390: Table size ( pages * reclength / 1024 )
24	CARDF	☐	DB2CARDFD	DB2DEC12	DEC	12	0	Total number of rows in the table

History

Last changed by/on	SAP	20130604
SAP Release Created in	700