SAP ABAP Class CL_DB6_ACTION_MDC_ADVISOR (GUI MDC Advisor Call (BW))
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 20071213
2 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DB6_MDC_ADVISOR_CONSTANTS Constants for DB6 MDC Advisor 20071217
3 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DBA_ACTION_COMMAND_CONFIRM DBA Cockpit: Controller I/F for Confirmation of Actions 20091125
4 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DBA_ACTION_CONTROLLER_ALV DBA Cockpit: Access to ALV object 20091117
5 Interface implementation (CLASS c. INTERFACES i_ref)  IF_DBA_ACTION_CONTROLLER_TREE DBA Cockpit: Interface for Tree 20091117
Properties
Class CL_DB6_ACTION_MDC_ADVISOR  
Short Description GUI MDC Advisor Call (BW)    
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 20071213   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)
Interfaces
# Interface Abstract Final Description Created on
1 IF_DB6_MDC_ADVISOR_CONSTANTS Constants for DB6 MDC Advisor 20071217
2 IF_DBA_ACTION_COMMAND_CONFIRM DBA Cockpit: Controller I/F for Confirmation of Actions 20091125
3 IF_DBA_ACTION_CONTROLLER_ALV DBA Cockpit: Access to ALV object 20091117
4 IF_DBA_ACTION_CONTROLLER_TREE DBA Cockpit: Interface for Tree 20091117
Friends
Class CL_DB6_ACTION_MDC_ADVISOR has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 ANALYZED_INFOPROVIDERS Instance attribute Private Type reference (TYPE) DB6_MDC_ADVISOR_RESULT_TAB Analyzed InfoProviders 20091019
2 BACKEND_CLASS Constant Private Type reference (TYPE) STRING 'CL_RSDB6_MDC_ADVISOR' Backend Class 20091125
3 DELETE_NODES Instance attribute Private Type reference (TYPE) ABAP_BOOL ABAP_FALSE delete nodes 20091019
4 INPUT_ALV Instance attribute Private Object reference (TYPE REF TO) CL_DB6_ALV DB6: simple ALV abstraction 20071214
5 INPUT_TABLE Instance attribute Private Type reference (TYPE) DB6_MDC_ADVISOR_STATUS_TAB DB6 MDC Advisor Status Table 20071214
6 MDC_ADVISOR Static Attribute Private Object reference (TYPE REF TO) IF_DB6_MDC_ADVISOR DB6 MDC Advisor Backend Interface 20071214
7 MDC_ADVISOR_JOBS Instance attribute Private Type reference (TYPE) DB6_MDC_ADVISOR_BGJOB_TAB mdc advisor background jobs 20081017
8 MDC_DIMENSIONS Instance attribute Private Type reference (TYPE) DB6_MDC_ADVISOR_DIMENSION_TAB Result of MDC Advisor 20091019
9 MDC_TREE Instance attribute Private Object reference (TYPE REF TO) CL_DB6_COLUMN_TREE DB6: simple column tree abstraction 20071214
10 NAV_REF Instance attribute Private Attribute reference (LIKE) 20071217
11 PARTTIM_TABLE Instance attribute Private Type reference (TYPE) DB6_MDC_ADVISOR_PARTTIM_TAB DB6 MDC Advisor PARTTIM Table 20071214
12 TREECOL_DIM Instance attribute Private Type reference (TYPE) STRING 'MDCDIMENSION' 20071214
13 TREECOL_IMPROVEMENT Instance attribute Private Type reference (TYPE) STRING 'ESTIMATEDIMPROVEMENT' 20071214
14 TREECOL_IP Instance attribute Private Type reference (TYPE) STRING 'INFOPROVIDER' 20071214
15 TREECOL_ORDNUM Instance attribute Private Type reference (TYPE) STRING 'STATNUM' 20071214
16 TREECOL_SPACE Instance attribute Private Type reference (TYPE) STRING 'ESTIMATEDSPACEINCREASE' 20071214
17 VIEW_DATA Instance attribute Private Type reference (TYPE) DB6_VIEW_MDC_ADV DB6 MDC Advisor: View for data change between GUI and code. 20071214
Methods
# Method Level Visibility Method type Description Created on
1 ADD_INFOPROVIDER Instance method Private Method add InfoProvider 20091120
2 CHANGE_THRESHOLD Instance method Private Method change query and temporary table threshold 20091119
3 COUNT_WORKLOAD Instance method Private Method Counts number of collected queries = workload 20071217
4 CREATE_IP_NODE Instance method Private Method Creates Node for InfoProvider 20071217
5 CREATE_IP_NODES Instance method Private Method Create parent InfoProvider Nodes 20071217
6 CREATE_MDC_NODE Instance method Private Method Creates node with MDC advisement 20071217
7 CREATE_TABLESPACE Instance method Private Method creates tablespace 20071217
8 DELETE_INFOPROVIDER Instance method Private Method Deletes InfoProviders shown on the screen 20071217
9 GET_CURRENT_SYSTEM_TIME Instance method Private Method Converts timestamp to human readable time value 20071217
10 GET_MDC_ADVISOR_DIMENSIONS Instance method Private Method Selects the advised MDC Dimensions 20071217
11 GET_MDC_ADVISOR_REF Static method Public Method get reference to MDC Advisor Class 20091124
12 GET_MDC_ADVISOR_RESULTS Instance method Private Method Gets the MDC Advisor results 20071217
13 GET_MDC_PARTTIM Instance method Private Method gets possible parttim MDC dimensions 20071217
14 GET_SELECTED_INPUT_IP Instance method Private Method Gets InfoProvider selected on the input screen 20071217
15 GET_SELECTED_RESULT_NODES Instance method Private Method get selected result nodes 20091019
16 GET_THRESHOLD Instance method Private Method Gets MDC Advisor thresholds 20071217
17 HANDLE_DELETE_RESULTS Instance method Private Method Handle delete results 20091125
18 HANDLE_START_COLLECTION Instance method Private Method handle start of query collection 20091125
19 HANDLE_STOP_COLLECTION Instance method Private Method handle stop of query collection 20091125
20 SCHEDULE_ADVISE_JOB Instance method Private Method Schedules MDC Advisor Call 20080117
21 SET_GRID_ATTRIBUTES_INPUT_TAB Instance method Private Method Set fields of Input ALV 20071217
22 SET_THRESHOLD Instance method Private Method Set MDC Advisor Thresholds 20071217
23 SET_TREE_COLUMNS Instance method Private Method 20071217
24 START_RECLUSTERING Instance method Private Method Start MDC Reclustering 20091019
25 UPDATE_ALV Instance method Private Method update ALVs in the screen 20071217
26 UPDATE_STATUS_TAB Instance method Private Method set InfoProviders for those the workload should be collected 20071217
Events
Class CL_DB6_ACTION_MDC_ADVISOR has no event.
Types
Class CL_DB6_ACTION_MDC_ADVISOR has no local type.
Method Signatures

Method ADD_INFOPROVIDER Signature

Method ADD_INFOPROVIDER on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method ADD_INFOPROVIDER on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method CHANGE_THRESHOLD Signature

Method CHANGE_THRESHOLD on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method CHANGE_THRESHOLD on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method COUNT_WORKLOAD Signature

Method COUNT_WORKLOAD on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
# Exception Resumable Description Created on
1 CX_DB6_MDC_ADVISOR Error handling MDC Advisor Call 20071217

Method CREATE_IP_NODE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing ADV_RESULT Call by reference Type reference (TYPE) DB6_MDC_ADVISOR_RESULT DB6 MDC Advisor: Result Structure 20071217
2 Importing MDC_DIMENSIONS Call by reference Type reference (TYPE) DB6_MDC_ADVISOR_DIMENSION_TAB DB6 MDC Advisor Dimension Table 20071217
3 Changing NODECNT Call by reference Type reference (TYPE) I 20071217
4 Importing PARENT_KEY Call by reference Type reference (TYPE) TV_NODEKEY Tree Control: Node Key 20081017

Method CREATE_IP_NODE on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method CREATE_IP_NODES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing NODECNT Call by reference Type reference (TYPE) I 20071217
# Exception Resumable Description Created on
1 CX_DB6_MDC_ADVISOR Error handling MDC Advisor Call 20081017

Method CREATE_MDC_NODE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing MDC_DIMENSION Call by reference Type reference (TYPE) DB6_MDC_ADVISOR_DIMENSION DB6 MDC Advisor: proposed MDC Dimensions 20071217
2 Changing NODECNT Call by reference Type reference (TYPE) I 20071217
3 Importing PARENT_KEY Call by reference Type reference (TYPE) TV_NODEKEY Tree Control: Node Key 20071217

Method CREATE_MDC_NODE on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method CREATE_TABLESPACE Signature

Method CREATE_TABLESPACE on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method CREATE_TABLESPACE on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method DELETE_INFOPROVIDER Signature

Method DELETE_INFOPROVIDER on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method DELETE_INFOPROVIDER on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_CURRENT_SYSTEM_TIME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning TIME Value transfer Type reference (TYPE) STRING 20071217

Method GET_CURRENT_SYSTEM_TIME on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_MDC_ADVISOR_DIMENSIONS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning MDC_DIMENSIONS Value transfer Type reference (TYPE) DB6_MDC_ADVISOR_DIMENSION_TAB DB6 MDC Advisor Dimension Table 20071217

Method GET_MDC_ADVISOR_DIMENSIONS on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_MDC_ADVISOR_REF Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning MDC_REF Value transfer Object reference (TYPE REF TO) IF_DB6_MDC_ADVISOR GUI MDC Advisor Call (BW) 20091124

Method GET_MDC_ADVISOR_REF on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_MDC_ADVISOR_RESULTS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning MDC_ADV_RESULTS Value transfer Type reference (TYPE) DB6_MDC_ADVISOR_RESULT_TAB DB6 MDC Advisor Result Table 20071217

Method GET_MDC_ADVISOR_RESULTS on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_MDC_PARTTIM Signature

Method GET_MDC_PARTTIM on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method GET_MDC_PARTTIM on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_SELECTED_INPUT_IP Signature

Method GET_SELECTED_INPUT_IP on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method GET_SELECTED_INPUT_IP on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_SELECTED_RESULT_NODES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting MDC_RESULT Call by reference Type reference (TYPE) DB6_MDC_ADVISOR_RESULT_TAB DB6 MDC Advisor Result Table 20091019
2 Importing NODE_KEY Call by reference Type reference (TYPE) I 20091019

Method GET_SELECTED_RESULT_NODES on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method GET_THRESHOLD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting QUERY_THRESHOLD Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20071217
2 Exporting TMPT_THRESHOLD Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20071217

Method GET_THRESHOLD on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method HANDLE_DELETE_RESULTS Signature

Method HANDLE_DELETE_RESULTS on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method HANDLE_DELETE_RESULTS on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method HANDLE_START_COLLECTION Signature

Method HANDLE_START_COLLECTION on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method HANDLE_START_COLLECTION on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method HANDLE_STOP_COLLECTION Signature

Method HANDLE_STOP_COLLECTION on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method HANDLE_STOP_COLLECTION on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method SCHEDULE_ADVISE_JOB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing INPUT_TABLE Call by reference Type reference (TYPE) DB6_MDC_ADVISOR_STATUS_TAB DB6 MDC Advisor Status Table 20080117

Method SCHEDULE_ADVISE_JOB on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method SET_GRID_ATTRIBUTES_INPUT_TAB Signature

Method SET_GRID_ATTRIBUTES_INPUT_TAB on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method SET_GRID_ATTRIBUTES_INPUT_TAB on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method SET_THRESHOLD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing QUERY_THRESHOLD Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20071217
2 Importing TMPT_THRESHOLD Call by reference Type reference (TYPE) INT2 2 byte integer (signed) 20071217

Method SET_THRESHOLD on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method SET_TREE_COLUMNS Signature

Method SET_TREE_COLUMNS on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method SET_TREE_COLUMNS on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method START_RECLUSTERING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing MDC_RESULT Call by reference Type reference (TYPE) DB6_MDC_ADVISOR_RESULT_TAB DB6 MDC Advisor Result Table 20091019

Method START_RECLUSTERING on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method UPDATE_ALV Signature

Method UPDATE_ALV on class CL_DB6_ACTION_MDC_ADVISOR has no parameter.
Method UPDATE_ALV on class CL_DB6_ACTION_MDC_ADVISOR has no exception.

Method UPDATE_STATUS_TAB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing COLLECTING Call by reference Type reference (TYPE) STRING 20071217
# Exception Resumable Description Created on
1 CX_DB6_MDC_ADVISOR Error handling MDC Advisor Call 20081017
History
Last changed by/on SAP  20130531 
SAP Release Created in 711