SAP ABAP Table DB2CQDBPC (Buffer Manager Dynamic Pool Attributes)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2CQDBPC	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	QDBPHPSZ	☐	DB2DBPHPSZ		INT4	10	0	The size of the hiperpool
4	QDBPVPSH	☐	DB2DBPVPSH	DB2INT4	INT4	10	0	The sequential steal threshold for the virtual buffer pool
5	QDBPHPSH	☐	DB2DBPHPSH		INT4	10	0	The sequential steal threshold for the hiperpool
6	QDBPDWQT	☐	DB2DBPDWQT	DB2INT4	INT4	10	0	The deferred write threshold for the virtual buffer pool
7	QDBPVDQT	☐	DB2DBPVDQT		INT4	10	0	The vertical deferred write threshold for the virtual BP
8	QDBPCAST	☐	DB2DBPCAST	CHAR6	CHAR	6	0	CASTOUT attribute
9	QDBPPSQT	☐	DB2DBPPSQT	DB2INT4	INT4	10	0	Parallel I/O sequential steal threshold for virtual BP
10	QDBPXSQT	☐	DB2DBPXSQT	DB2INT4	INT4	10	0	Assisting parallel sequential threshold
11	QDBPVPTY	☐	DB2DBPVPTY	DB2CHAR01	CHAR	1	0	Type of virtual buffer pool
12	QDBPVDQB	☐	DB2DBPVDQC		NUMC	5	0	Pool vertical write threshold in number of buffers
13	QDBPPGST	☐	DB2DBPPGST	DB2CHAR04	CHAR	4	0	Page stealing algorithm to be used for the virtual BP

History

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