SAP ABAP Table DB2QDBPC (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	DB2QDBPC	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	☐	DB2CDBPNM	CHAR8	CHAR	8	0	Name of buffer pool
2	QDBPVPSZ	☐	DB2CDBPVPZ	DB2NUMC10	NUMC	10	0	The size of the virtual buffer pool
3	QDBPHPSZ	☐	DB2CDBPHPZ	DB2NUMC10	NUMC	10	0	The size of the hiperpool
4	QDBPVPSH	☐	DB2CDBPVPH	DB2NUMC10	NUMC	10	0	The sequential steal threshold for the virtual buffer pool
5	QDBPHPSH	☐	DB2CDBPHPH	DB2NUMC10	NUMC	10	0	The sequential steal threshold for the hiperpool
6	QDBPDWQT	☐	DB2CDBPDWQ	DB2NUMC10	NUMC	10	0	The deferred write threshold for the virtual buffer pool
7	QDBPVDQT	☐	DB2CDBPVDQ	DB2NUMC10	NUMC	10	0	The vertical deferred write threshold for the virtual BP
8	QDBPCAST	☐	DB2CDBPCAS	CHAR6	CHAR	6	0	CASTOUT attribute
9	QDBPPSQT	☐	DB2CDBPPSQ	DB2NUMC10	NUMC	10	0	Parallel I/O sequential steal threshold for virtual BP
10	QDBPXSQT	☐	DB2CDBPXSQ	DB2NUMC10	NUMC	10	0	Assisting parallel sequential threshold
11	QDBPVPTY	☐	DB2CDBPVPT	DB2CHAR01	CHAR	1	0	Type of virtual buffer pool
12	QDBPVDQB	☐	DB2CDBPVDB	DB2NUMC05	NUMC	5	0	Pool vertical write threshold in number of buffers
13	QDBPPGST	☐	DB2CDBPPGS	DB2CHAR04	CHAR	4	0	Page stealing algorithm to be used for the virtual BP

History

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