SAP ABAP Class CL_DB6_DESIGN_ADVISOR (DB6: abstraction of DB2 Design Advisor)

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)

Properties

Class	CL_DB6_DESIGN_ADVISOR
Short Description	DB6: abstraction of DB2 Design Advisor
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU6	DB6: Performance-Monitor (UNIX/Windows)
Created	20050627	SAP
Last change	20110908	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	ADBC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
3	DB6CC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_DB6_DESIGN_ADVISOR has no interface implemented.

Friends

Class CL_DB6_DESIGN_ADVISOR has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	E_EXPLAIN_TIME	Instance attribute	Private	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050728
2	E_QUERYNO	Instance attribute	Private	☐	Type reference (TYPE)	DB6PMADVIX-QUERYNO			20050728
3	INSTANCE	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_DESIGN_ADVISOR		DB6: abstraction of DB2 Design Advisor	20050627
4	RENAMED_INDEXES	Instance attribute	Private	☐	Type reference (TYPE)	DB6PMADVIX_TAB		DB6 CCMS: Table of DB6PMADVIX	20090316
5	R_EXPLAIN_TIME	Instance attribute	Private	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050728
6	R_QUERYNO	Instance attribute	Private	☐	Type reference (TYPE)	DB6PMADVIX-QUERYNO			20050728
7	SYSCAT	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_SYSCAT		DB6 CCMS: SYSCAT abstraction	20050727
8	SYS_REF	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		CL_DB6_TREE_NAVIGATOR	20080603

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CLEAR_ADVISE_EXPLAIN_TABLES	Instance method	Private	Method	clear all advise index related explain tables	20050728
2	CONSTRUCTOR	Instance method	Public	Constructor	do not use! use GET_INSTANCE instead	20050627
3	DELETE_RECOMMENDED_INDEXES	Instance method	Public	Method	deletes all recommended indexes from ADVISE_INDEX	20050805
4	EVALUATE_INDEX	Instance method	Public	Method	get advice for single statement	20050712
5	GENERATE_INDEX_NAME	Instance method	Public	Method	generate a SAP specific index name	20050727
6	GET_ADVISE_INDEX	Instance method	Private	Method	get all registered deadlocks (DLMON_DEADLOCK)	20050711
7	GET_ADVISE_WORKLOAD	Instance method	Public	Method	get all registered deadlocks (DLMON_DEADLOCK)	20080616
8	GET_EXPLAIN_TIME_FOR_STMT	Instance method	Public	Method	search for stmt in EXPLAIN_STATEMENT and return explain_time	20080619
9	GET_INSTANCE	Static method	Public	Method		20050627
10	GET_REFERED_TABLES	Instance method	Public	Method	get tables refered by last advisor run	20051010
11	INSERT_USERDEFINED_INDEXES	Instance method	Private	Method	insert user-defined indexes into ADVISE_INDEX	20050804
12	RECOMMEND_INDEX	Instance method	Public	Method	get advice for single statement	20050712
13	REPLACE_INDEX_NAME	Instance method	Private	Method	replace advisor index name with SAP recommended index name	20050727
14	TRUNCATE_ADVISE_EXPLAIN_TABLES	Instance method	Private	Method	truncate all advise / explain tables	20080616
15	UPDATE_INDEX_NAME	Instance method	Private	Method	create SAP index names in ADVISE_INDEX	20050727

Events

Class CL_DB6_DESIGN_ADVISOR has no event.

Types

Class CL_DB6_DESIGN_ADVISOR has no local type.

Method Signatures

Method CLEAR_ADVISE_EXPLAIN_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXCL_XPLTIME	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050728

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐		20050802
2	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20050728

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SYSTEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS			20080603

Method CONSTRUCTOR on class CL_DB6_DESIGN_ADVISOR has no exception.

Method DELETE_RECOMMENDED_INDEXES Signature

Method DELETE_RECOMMENDED_INDEXES on class CL_DB6_DESIGN_ADVISOR has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐	DBA Cockpit: Error calling DB2 UDB Design Advisor	20051202
2	CX_DBA_ADBC	☐	DBA Cockpit: ADBC-Fehler	20051202

Method EVALUATE_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EXPLAIN_TIME	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050802
2	Importing	INDEX_TAB	Call by reference	☐	Type reference (TYPE)	DB6CC_DB6PMADVIX_TAB			20050804
3	Exporting	QUERYNO	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-QUERYNO			20050802
4	Exporting	REEXPLAIN	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL		Re-EXPLAIN if no EXPLAIN_TIME is returned	20050815
5	Importing	STMT	Call by reference	☐	Type reference (TYPE)	STRING			20050712

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐	DBA Cockpit: Error calling DB2 UDB Design Advisor	20050802
2	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20050720

Method GENERATE_INDEX_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	IID	Call by reference	☐	Type reference (TYPE)	I			20050808
2	Exporting	INDEXNAME	Value transfer	☐	Type reference (TYPE)	DB6TABNAML		DB6: Table Name	20050727
3	Importing	SCHEMA	Call by reference	☐	Type reference (TYPE)	DB6TABNAML		DB6: Table Name	20050727
4	Importing	TABLE	Call by reference	☐	Type reference (TYPE)	DB6TABNAML		DB6: Table Name	20050727
5	Importing	VIRT_INDEXES	Call by reference	☑	Type reference (TYPE)	DB6CC_DB6PMADVIX_GUI_TAB			20050804

Method GENERATE_INDEX_NAME on class CL_DB6_DESIGN_ADVISOR has no exception.

Method GET_ADVISE_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ADVISE_TAB	Value transfer	☐	Type reference (TYPE)	DB6CC_DB6PMADVIX_TAB			20050711
2	Importing	EXPLAIN_TIME	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050727
3	Importing	VIRT_INDEXES	Call by reference	☐	Type reference (TYPE)	DB6CC_DB6PMADVIX_GUI_TAB			20050815

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐		20050802

Method GET_ADVISE_WORKLOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ADVISE_WORKLOAD	Value transfer	☐	Type reference (TYPE)	DB6PMADVWL_TAB		DB6: Table of DB6PMADVWL	20080616

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐		20080616

Method GET_EXPLAIN_TIME_FOR_STMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	EXPLAIN_TIME	Value transfer	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20080619
2	Importing	STATEMENT_NO	Call by reference	☐	Type reference (TYPE)	DB6PMADVWL-STATEMENT_NO			20080619
3	Importing	WORKLOAD_NAME	Call by reference	☐	Type reference (TYPE)	DB6PMADVWL-WORKLOAD_NAME			20080619

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20080619

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ADVISOR	Value transfer	☐	Object reference (TYPE REF TO)	CL_DB6_DESIGN_ADVISOR		DB6: abstraction of DB2 Design Advisor	20050627
2	Importing	SYSTEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS			20080603

Method GET_INSTANCE on class CL_DB6_DESIGN_ADVISOR has no exception.

Method GET_REFERED_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	TABLE_LIST	Value transfer	☐	Type reference (TYPE)	DB6CC_TABLE_LIST			20051014

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC-Fehler	20051010

Method INSERT_USERDEFINED_INDEXES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INDEX_TAB	Call by reference	☐	Type reference (TYPE)	DB6CC_DB6PMADVIX_TAB			20050804

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐	DBA Cockpit: Error calling DB2 UDB Design Advisor	20050804
2	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20050804

Method RECOMMEND_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ADVISE_PROTOCOL	Call by reference	☐	Type reference (TYPE)	DB6CC_EXEC_PROTOCOL			20080603
2	Exporting	ADVISE_TAB	Value transfer	☐	Type reference (TYPE)	DB6CC_DB6PMADVIX_TAB			20050712
3	Exporting	EXPLAIN_TIME	Value transfer	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050727
4	Exporting	QUERYNO	Value transfer	☐	Type reference (TYPE)	DB6PMADVIX-QUERYNO			20050727
5	Exporting	REEXPLAIN	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20050815
6	Importing	STMT	Call by reference	☐	Type reference (TYPE)	STRING			20050712
7	Importing	VIRT_INDEXES	Call by reference	☑	Type reference (TYPE)	DB6CC_DB6PMADVIX_GUI_TAB			20050815

#	Exception	Resumable	Description	Created on
1	CX_DB6_DESIGN_ADVISOR	☐	DBA Cockpit: Error calling DB2 UDB Design Advisor	20050802
2	CX_DB6_RDI	☐	DB6: Data Collector Errors	20080603
3	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20050720

Method REPLACE_INDEX_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXPLAIN_TIME	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050727
2	Changing	LINE	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX		DB6 CCMS: ADVISE_INDEX explain table structure	20050727
3	Importing	VIRT_INDEXES	Call by reference	☐	Type reference (TYPE)	DB6CC_DB6PMADVIX_GUI_TAB			20050815

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20050727

Method TRUNCATE_ADVISE_EXPLAIN_TABLES Signature

Method TRUNCATE_ADVISE_EXPLAIN_TABLES on class CL_DB6_DESIGN_ADVISOR has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20080616

Method UPDATE_INDEX_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXPLAIN_TIME	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-EXPLAIN_TIME			20050727
2	Importing	OLD_IXNAME	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX-NAME			20050727
3	Importing	UPDATE_LINE	Call by reference	☐	Type reference (TYPE)	DB6PMADVIX		DB6 CCMS: ADVISE_INDEX explain table structure	20050727

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20050727

History

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