SAP ABAP Class CL_DB6_ACTION_BP_MAINTENANCE (DB6: Bufferpool Maintenance)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-DB-DB6 (Application Component) DB2 Universal Database for UNIX / NT
     STU6 (Package) DB6: Performance-Monitor (UNIX/Windows)
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_DB6_ACTION_CONTROLLER DB6: Abstract Action Controller 20051223
2 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DBA_ACTION_CONTROLLER_ALV DBA Cockpit: Access to ALV object 20081117
3 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DBA_ACTION_CONTROLLER_CHG DBA Cockpit: Administration Basics 20090323
4 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DBA_ACTION_CONTROLLER_QUAC DBA Cockpit: Controller I/F for Quick Activities 20081118
Properties
Class CL_DB6_ACTION_BP_MAINTENANCE  
Short Description DB6: Bufferpool Maintenance    
Super Class CL_DB6_ACTION_CONTROLLER DB6: Abstract Action Controller 
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU6   DB6: Performance-Monitor (UNIX/Windows) 
Created 20051223   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
2 DB6CC Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 DB6SY Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
# Interface Abstract Final Description Created on
1 IF_DBA_ACTION_CONTROLLER_ALV DBA Cockpit: Access to ALV object 20081117
2 IF_DBA_ACTION_CONTROLLER_CHG DBA Cockpit: Administration Basics 20090323
3 IF_DBA_ACTION_CONTROLLER_QUAC DBA Cockpit: Controller I/F for Quick Activities 20081118
Friends
Class CL_DB6_ACTION_BP_MAINTENANCE has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 ALL_NODES Instance attribute Private See coding DB6: Partition Name for Listbox Element 20051227
2 BUFFERPOOLNODES Instance attribute Private See coding DB6: System Catalog table BUFFERPOOLNODES 20051227
3 BUFFERPOOLS Instance attribute Private See coding DB6: System Catalog Information of Bufferpools 20051227
4 CMD_ALTER_IMM Constant Public Type reference (TYPE) SYUCOMM 'ALTERIMM' Function Code that Triggered PAI 20090924
5 CMD_CREATE_IMM Constant Public Type reference (TYPE) SYUCOMM 'CREATEIMM' Function Code that Triggered PAI 20090924
6 CMD_NODEGROUP Constant Public Type reference (TYPE) SYUCOMM 'NODEGROUP' Function Code that Triggered PAI 20090924
7 CMD_PAGESIZE Constant Public Type reference (TYPE) SYUCOMM 'PAGESIZE' Function Code that Triggered PAI 20090924
8 CMD_REMOVE_EXCEPTION Constant Public Type reference (TYPE) SYUCOMM 'REM_EXCP_BUT' Function Code that Triggered PAI 20091109
9 CMD_SIZE Constant Public Type reference (TYPE) SYUCOMM 'SIZE' Function Code that Triggered PAI 20090923
10 CMD_START_WITH Constant Public Type reference (TYPE) SYUCOMM 'STARTWITH' Function Code that Triggered PAI 20090924
11 CMD_USE_EXT Constant Public Type reference (TYPE) SYUCOMM 'USEEXT' Function Code that Triggered PAI 20090924
12 DBCFG_TAB Instance attribute Private Type reference (TYPE) DB6PMCD_PAR_TAB DB6: Table of DB6PMCD_PAR 20081118
13 EXECUTED_COMMAND Instance attribute Private Type reference (TYPE) SYUCOMM Function Code that Triggered PAI 20081118
14 EXECUTED_SQL_STMTS Instance attribute Private Type reference (TYPE) DB6_EDITOR_LIST DB6: Table of DB6_EDITOR_LINE 20081118
15 KEYWORD Instance attribute Private Type reference (TYPE) DB6_KEYWORD DB6: Keyword (DB2 UDB release dependend naming conventions) 20081118
16 NAV_REF Instance attribute Private Attribute reference (LIKE) 20051223
17 ORI_BUFFERPOOL Instance attribute Private Type reference (TYPE) DB6CATBP DB6: System Catalog Information of Bufferpools 20081118
18 ORI_BUFFERPOOLNODES Instance attribute Private Type reference (TYPE) DB6ADMBPND_TAB DB6: Table of DB6ADMBPND 20081118
19 ORI_NODEGROUPS Instance attribute Private Type reference (TYPE) DB6ADMNGRP_TAB DB6: Table of DB6ADMNGRP 20081118
20 PARTGROUPS Instance attribute Private See coding DB6: System Catalog Information of Nodegroups 20051227
21 PARTGRP_ALV Instance attribute Private Object reference (TYPE REF TO) CL_DB6_ALV DB6: simple ALV abstraction 20051223
22 PART_ALV Instance attribute Private Object reference (TYPE REF TO) CL_DB6_ALV DB6: simple ALV abstraction 20051223
23 SQL_COMMANDS Instance attribute Private Type reference (TYPE) DB6_EDITOR_LIST DB6: Table of DB6_EDITOR_LINE 20081118
24 TABLESPACES Instance attribute Private See coding DB6: System Catalog Information of Tablespaces 20051227
25 TRANSFERRED_FIXED_NPAGES Instance attribute Private Type reference (TYPE) I 20090923
26 TSP_ALV Instance attribute Private Object reference (TYPE REF TO) CL_DB6_ALV DB6: simple ALV abstraction 20051223
27 VIEW_DATA Instance attribute Private Type reference (TYPE) DB6_VIEW_BP_MAINTENANCE DB6: View Data for BP Maintenance Controller 20051223
Methods
# Method Level Visibility Method type Description Created on
1 BUILD_ALTER_CLAUSE Instance method Private Method build ALTER BUFFERPOOL clause 20051227
2 BUILD_ALTER_PARTGROUP Instance method Private Method build ALTER BUFFERPOOL ADD DATABASE PARTITION GROUP 20051227
3 BUILD_ALTER_SIZE Instance method Private Method build ALTER BUFFERPOOL SIZE clause 20051227
4 BUILD_ALTER_STMT Instance method Private Method build ALTER BUFFERPOOL stmt 20051227
5 BUILD_BLOCKSIZE_CLAUSE Instance method Private Method build BLOCKSIZE clause 20051227
6 BUILD_CREATE_SIZE Instance method Private Method build SIZE clause 20090924
7 BUILD_CREATE_STMT Instance method Private Method build CREATE BUFFERPOOL statement 20051227
8 BUILD_EXCEPT_CLAUSE Instance method Private Method build EXCEPT ON NODES clause 20051227
9 BUILD_EXTENDED_CLAUSE Instance method Private Method build EXTENDED clause 20051227
10 BUILD_NUMBLOCKPAGES_CLAUSE Instance method Private Method build NUMBLOCKPAGES clause 20051227
11 BUILD_PAGESIZE_CLAUSE Instance method Private Method build PAGESIZE clause 20051227
12 BUILD_PARTGROUPS_CLAUSE Instance method Private Method build partition group clause 20051227
13 BUILD_SQL_STMT Instance method Private Method build CREATE/DELETE/ALTER statements to maintain BP 20051227
14 CHECK_BLOCKPAGES Instance method Private Method check NUMBLOCKPAGES parameter against bufferpool size 20051227
15 CHECK_BLOCK_IO Instance method Private Method 20051227
16 CHECK_BUFFERPOOL Instance method Private Method 20051227
17 CHECK_FOR_CHANGES Instance method Private Method 20051227
18 CHECK_INPUT Instance method Private Method check user input 20060220
19 CHECK_NPAGES Instance method Private Method 20051227
20 CHECK_PARTITIONS Instance method Private Method 20091109
21 CHECK_PARTITION_GROUPS Instance method Private Method 20091111
22 CHECK_SIZE Instance method Private Method check size of buffer pools in ALV 20060221
23 CHECK_STMM_ACTIVE Instance method Private Method check size of buffer pools in ALV 20060330
24 DISPLAY_PARTGROUP Instance method Private Method jump into partition group detail screen 20051227
25 DISPLAY_TABLESPACE Instance method Private Method jump to tablespace details 20051227
26 EXEC_SQL_COMMAND Instance method Private Method execute generated SQL statement 20051227
27 GET_SYSCAT_TABLES Instance method Private Method load needed SYSCAT informations 20060112
28 IMPORT_INPUT_DATA Instance method Private Method import and convert input data 20060220
29 REFRESH_CUR_BUFFERPOOLNODES Instance method Private Method re-synchronize cur_bufferpoolnodes with SYSCAT information 20060413
30 SET_BUFFERPOOLNODES Instance method Private Method set list of bufferpool nodes depending on selected nodegroup 20051227
31 SET_GRID_ATTRIBUTES_PART Instance method Private Method set grid attributes for partitions ALV 20051227
32 SET_GRID_ATTRIBUTES_PARTGRP Instance method Private Method set grid attributes for partition groups ALV 20051227
33 SET_GRID_ATTRIBUTES_TSP Instance method Private Method set grid attributes for tablespaces ALV 20051227
34 SET_STYLE_FOR_BUFFERPOOL_NODES Instance method Private Method 20090924
35 SWITCH_CHECKBOX_EXCP Instance method Private Method 20091109
36 SWITCH_CHECKBOX_PGRP Instance method Private Method 20051227
37 SWITCH_RADIOBUTTON_PGRP Instance method Private Method 20051227
38 SWITCH_SIZE Instance method Private Method 20090923
Events
Class CL_DB6_ACTION_BP_MAINTENANCE has no event.
Types
Class CL_DB6_ACTION_BP_MAINTENANCE has no local type.
Method Signatures

Method BUILD_ALTER_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_ALTER_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_ALTER_PARTGROUP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_ALTER_PARTGROUP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_ALTER_SIZE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_ALTER_SIZE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_ALTER_STMT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_ALTER_STMT on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_BLOCKSIZE_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_BLOCKSIZE_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_CREATE_SIZE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20090924

Method BUILD_CREATE_SIZE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_CREATE_STMT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_CREATE_STMT on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_EXCEPT_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_EXCEPT_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_EXTENDED_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_EXTENDED_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_NUMBLOCKPAGES_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_NUMBLOCKPAGES_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_PAGESIZE_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_PAGESIZE_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_PARTGROUPS_CLAUSE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_PARTGROUPS_CLAUSE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method BUILD_SQL_STMT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning TEXT Value transfer Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method BUILD_SQL_STMT on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_BLOCKPAGES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing BLOCKPAGE_QUOTA Call by reference Type reference (TYPE) I 20060109
2 Changing BP Call by reference Type reference (TYPE) DB6CATBP DB6: System Catalog Information of Bufferpools 20060109
3 Importing BUFFERPOOLNODE Call by reference Type reference (TYPE) DB6ADMBPND DB6: System Catalog table BUFFERPOOLNODES 20051227

Method CHECK_BLOCKPAGES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_BLOCK_IO Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20060221

Method CHECK_BLOCK_IO on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_BUFFERPOOL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20060220

Method CHECK_BUFFERPOOL on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_FOR_CHANGES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning CHANGED Value transfer Type reference (TYPE) ABAP_BOOL 20051227

Method CHECK_FOR_CHANGES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_INPUT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20060220

Method CHECK_INPUT on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_NPAGES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20060221

Method CHECK_NPAGES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_PARTITIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20091109

Method CHECK_PARTITIONS on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_PARTITION_GROUPS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20091111

Method CHECK_PARTITION_GROUPS on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_SIZE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20060221

Method CHECK_SIZE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method CHECK_STMM_ACTIVE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning VALID Value transfer Type reference (TYPE) ABAP_BOOL 20060330

Method CHECK_STMM_ACTIVE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method DISPLAY_PARTGROUP Signature

Method DISPLAY_PARTGROUP on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method DISPLAY_PARTGROUP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method DISPLAY_TABLESPACE Signature

Method DISPLAY_TABLESPACE on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method DISPLAY_TABLESPACE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method EXEC_SQL_COMMAND Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing TEXT Call by reference Type reference (TYPE) DB6CC_EDITOR_LIST 20051227

Method EXEC_SQL_COMMAND on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method GET_SYSCAT_TABLES Signature

Method GET_SYSCAT_TABLES on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method GET_SYSCAT_TABLES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method IMPORT_INPUT_DATA Signature

Method IMPORT_INPUT_DATA on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method IMPORT_INPUT_DATA on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method REFRESH_CUR_BUFFERPOOLNODES Signature

Method REFRESH_CUR_BUFFERPOOLNODES on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method REFRESH_CUR_BUFFERPOOLNODES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SET_BUFFERPOOLNODES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing NPAGES Call by reference Type reference (TYPE) P 30 Characters 20051227

Method SET_BUFFERPOOLNODES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SET_GRID_ATTRIBUTES_PART Signature

Method SET_GRID_ATTRIBUTES_PART on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SET_GRID_ATTRIBUTES_PART on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SET_GRID_ATTRIBUTES_PARTGRP Signature

Method SET_GRID_ATTRIBUTES_PARTGRP on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SET_GRID_ATTRIBUTES_PARTGRP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SET_GRID_ATTRIBUTES_TSP Signature

Method SET_GRID_ATTRIBUTES_TSP on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SET_GRID_ATTRIBUTES_TSP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SET_STYLE_FOR_BUFFERPOOL_NODES Signature

Method SET_STYLE_FOR_BUFFERPOOL_NODES on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SET_STYLE_FOR_BUFFERPOOL_NODES on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SWITCH_CHECKBOX_EXCP Signature

Method SWITCH_CHECKBOX_EXCP on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SWITCH_CHECKBOX_EXCP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SWITCH_CHECKBOX_PGRP Signature

Method SWITCH_CHECKBOX_PGRP on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SWITCH_CHECKBOX_PGRP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SWITCH_RADIOBUTTON_PGRP Signature

Method SWITCH_RADIOBUTTON_PGRP on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SWITCH_RADIOBUTTON_PGRP on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.

Method SWITCH_SIZE Signature

Method SWITCH_SIZE on class CL_DB6_ACTION_BP_MAINTENANCE has no parameter.
Method SWITCH_SIZE on class CL_DB6_ACTION_BP_MAINTENANCE has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 710