SAP ABAP Table DB2QDBP (Buffer Manager Dynamic Pool Attributes)

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	DB2QDBP	Table Relationship Diagram
Short Description	Buffer Manager Dynamic Pool Attributes

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	QDBPNM	☐	DB2DBPNM	CHAR8	CHAR	8	0	Name of buffer pool
2	QDBPVPSZ	☐	DB2DBPVPSZ		INT4	10	0	The size of the virtual buffer pool
3	QDBPVPSH	☐	DB2DBPVPSH	DB2INT4	INT4	10	0	The sequential steal threshold for the virtual buffer pool
4	QDBPDWQT	☐	DB2DBPDWQT	DB2INT4	INT4	10	0	The deferred write threshold for the virtual buffer pool
5	QDBPVDQT	☐	DB2DBPVDQT		INT4	10	0	The vertical deferred write threshold for the virtual BP
6	QDBPPSQT	☐	DB2DBPPSQT	DB2INT4	INT4	10	0	Parallel I/O sequential steal threshold for virtual BP
7	QDBPXSQT	☐	DB2DBPXSQT	DB2INT4	INT4	10	0	Assisting parallel sequential threshold
8	QDBPVPTY	☐	DB2DBPVPTY	DB2CHAR01	CHAR	1	0	Type of virtual buffer pool
9	QDBPVDQB	☐	DB2DBPVDQB	DB2INT2V	INT2	5	0	Pool vertical write threshold in number of buffers
10	QDBPPGST	☐	DB2DBPPGST	DB2CHAR04	CHAR	4	0	Page stealing algorithm to be used for the virtual BP
11	QDBPPFIX	☐			CHAR	3	0
12	QDBPFRAM	☐			CHAR	2	0
13	QDBPVPMI	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
14	QDBPVPMA	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
15	QDBPASIZ	☐			CHAR	3	0

History

Last changed by/on	SAP	20140117
SAP Release Created in