SAP ABAP Class CL_RSDB6_MDC_ADV_COLLECT_WKL (Collection of Report Queries in the DB Exit for MDC Advisor)

Hierarchy

☛ SAP_BW (Software Component) SAP Business Warehouse
   ⤷ BW-SYS-DB-DB6 (Application Component) BW DB2 Universal Database
     ⤷ RSDB6_7EHP1 (Package) Development EHP1 / BI 7.01 and BI 7.11

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_RSDB6_MDC_ADV_COLLECT_WKL	Collecting Queries for DB6 MDC Advisor	20080219

Properties

Class	CL_RSDB6_MDC_ADV_COLLECT_WKL
Short Description	Collection of Report Queries in the DB Exit for MDC Advisor
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	RSDB6_7EHP1	Development EHP1 / BI 7.01 and BI 7.11
Created	20080219	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	RSDRS	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	RSDU	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_RSDB6_MDC_ADV_COLLECT_WKL	☐	☐	Collecting Queries for DB6 MDC Advisor	20080219

Friends

Class CL_RSDB6_MDC_ADV_COLLECT_WKL has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	SX_QUERY	Instance attribute	Private	☐	Type reference (TYPE)	RSDRS_SX_QUERY			20080219

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	Constructor	20080219
2	CR_INDEX_TMP_TABLE	Instance method	Private	Method	Creates index for copy of temporary BW tables	20080219
3	CR_TMP_TABLE_COPY	Instance method	Private	Method	Creates copy of temporary BW tables	20080219
4	GET_TABLESPACE_FOR_TABART	Instance method	Private	Method	Getting tablespace for table type	20080219
5	STOP_COLLECTING	Instance method	Private	Method	Stop collecting queries if thresholds are reached	20080219
6	STORE_TMP_TABLES	Instance method	Private	Method	Storing temporary BW tables	20080219
7	STORE_WORKLOAD	Instance method	Private	Method	Storing query workload for MDC advisor	20080219

Events

Class CL_RSDB6_MDC_ADV_COLLECT_WKL has no event.

Types

Class CL_RSDB6_MDC_ADV_COLLECT_WKL has no local type.

Method Signatures

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_RSDB6_MDC_ADV_COLLECT_WKL has no parameter.
Method CONSTRUCTOR on class CL_RSDB6_MDC_ADV_COLLECT_WKL has no exception.

Method CR_INDEX_TMP_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SUBRC	Call by reference	☐	Type reference (TYPE)	SY-SUBRC		Rückgabewert von ABAP-Anweisungen	20080219
2	Importing	I_CON_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Datenbankverbindung	20080219
3	Importing	I_NEWTABLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20080219
4	Importing	I_TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20080219

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20080219

Method CR_TMP_TABLE_COPY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SUBRC	Call by reference	☐	Type reference (TYPE)	SY-SUBRC		Rückgabewert von ABAP-Anweisungen	20080219
2	Importing	I_CON_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Datenbankverbindung	20080219
3	Importing	I_INDEXTBSPACE	Call by reference	☐	Type reference (TYPE)	DB6TSPNAME		DB6: Tabellenbereichsname	20080219
4	Importing	I_NEWTABLNM	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20080219
5	Importing	I_PARALLEL_DEGREE	Call by reference	☐	Type reference (TYPE)	I			20080219
6	Importing	I_REFTABLE	Call by reference	☐	Type reference (TYPE)	TABNAME		Tabellenname	20080219
7	Importing	I_TBSPACE	Call by reference	☐	Type reference (TYPE)	DB6TSPNAME		DB6: Tabellenbereichsname	20080219

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Ausnahmeklasse für SQL Fehler	20080219

Method GET_TABLESPACE_FOR_TABART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_DATA_TABSPACE	Call by reference	☐	Type reference (TYPE)	RSDU_TABSPACE			20080219
2	Exporting	E_INDEX_TABSPACE	Call by reference	☐	Type reference (TYPE)	RSDU_TABSPACE			20080219
3	Importing	I_TABART	Call by reference	☐	Type reference (TYPE)	RSDU_TABART			20080219

Method GET_TABLESPACE_FOR_TABART on class CL_RSDB6_MDC_ADV_COLLECT_WKL has no exception.

Method STOP_COLLECTING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_STATUS	Call by reference	☐	Type reference (TYPE)	STRING			20080219
2	Importing	I_T_STATUS	Call by reference	☐	Type reference (TYPE)	DB6_MDC_ADVISOR_STATUS_TAB			20080219

Method STOP_COLLECTING on class CL_RSDB6_MDC_ADV_COLLECT_WKL has no exception.

Method STORE_TMP_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_EXIST	Call by reference	☐	Type reference (TYPE)	RS_BOOL		Boolean	20080219
2	Changing	C_MODIFY	Call by reference	☐	Type reference (TYPE)	STRING			20080219
3	Changing	C_SUBRC	Call by reference	☐	Type reference (TYPE)	SY-SUBRC		Rückgabewert von ABAP-Anweisungen	20080219
4	Importing	I_ID	Call by reference	☐	Type reference (TYPE)	I			20080219
5	Importing	I_INDEXTBSPACE	Call by reference	☐	Type reference (TYPE)	C			20080219
6	Importing	I_INFOPROVIDER	Call by reference	☐	Type reference (TYPE)	STRING			20080219
7	Importing	I_QUERY	Call by reference	☐	Type reference (TYPE)	STRING			20080219
8	Importing	I_TBSPACE	Call by reference	☐	Type reference (TYPE)	C			20080219

Method STORE_TMP_TABLES on class CL_RSDB6_MDC_ADV_COLLECT_WKL has no exception.

Method STORE_WORKLOAD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_SUBRC	Value transfer	☐	Type reference (TYPE)	SY-SUBRC		Rückgabewert von ABAP-Anweisungen	20080219
2	Importing	I_INFOPROVIDER	Call by reference	☐	Type reference (TYPE)	STRING			20080219
3	Importing	I_QUERY	Call by reference	☐	Type reference (TYPE)	STRING			20080219
4	Importing	I_WKLNM	Call by reference	☐	Type reference (TYPE)	STRING			20081229

Method STORE_WORKLOAD on class CL_RSDB6_MDC_ADV_COLLECT_WKL has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	711