SAP ABAP Class CNV_00001_OPT_DATA_PROVIDER (Optimization data provider)

Hierarchy

☛ DMIS (Software Component) DMIS 2011_1
   ⤷ CA-GTF-BS (Application Component) Business Application Support
     ⤷ CNV_BASIS (Package) Conversion: Basis functions

Properties

Class	CNV_00001_OPT_DATA_PROVIDER
Short Description	Optimization data provider
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	CNV_BASIS	Conversion: Basis functions
Created	20100209	SAP
Last change	20141030
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	CNV	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CNV_00001_OPT_DATA_PROVIDER has no interface implemented.

Friends

Class CNV_00001_OPT_DATA_PROVIDER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ACTIVE	Constant	Protected	☐	Type reference (TYPE)	STATUS_IND	'ACTIVE'	Index Status	20100209
2	CNVCONTROL_LOADED	Instance attribute	Protected	☐	Type reference (TYPE)	AS4FLAG		Whether contents of CNVCONTROL were already loaded	20100211
3	CNVINDEX_LOADED	Instance attribute	Protected	☐	Type reference (TYPE)	AS4FLAG		Whether contents of CNVINDEX were already loaded	20100211
4	CONTROL	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_CONTROL_STT		Sorted table of CNVCONTROL	20100211
5	CONTROL_DEFAULT_TABNAME	Constant	Public	☐	Type reference (TYPE)	TABNAME	'_DEFAULT'	Default value for CNVCONTROL	20100211
6	DBSYS_MSSQL	Constant	Protected	☐	Type reference (TYPE)	SYDBSYS	'MSSQL'	Database system - MSSQL	20100225
7	DBSYS_ORACLE	Constant	Protected	☐	Type reference (TYPE)	SYDBSYS	'ORACLE'	Database system - ORACLE	20100209
8	DROP_IND_LOCK_PARAM	Constant	Protected	☐	Type reference (TYPE)	CNV_00001_PARAMS-PARAMNAME	'CNV_DROP_INDEX_&1'	Character field of length 40	20100211
9	FIELDS	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_FIELDS_STT		List of fields	20100209
10	FIELDS_LOADED	Instance attribute	Protected	☐	Type reference (TYPE)	AS4FLAG		Whether tables were already loaded	20100209
11	INDEXES	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_INDEX_STT		List of indexes	20100209
12	INDEXES_LOADED	Instance attribute	Protected	☐	Type reference (TYPE)	AS4FLAG		Whether indexes were already loaded	20100209
13	INDEX_DATA	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_INDEX_DATA_STT		List of index data	20100226
14	JOBS	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_TAB_SCENARIO_HTT		List of table scenarios	20100209
15	JOBS_LOADED	Instance attribute	Protected	☐	Type reference (TYPE)	AS4FLAG		Whether jobs were already loaded	20100209
16	JOBS_SORTED	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_DBTABLEJOB_STT		Job list	20100311
17	LIST	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_INDEX_DATA_TT		List of indices to display	20100209
18	NOACTIVE	Constant	Protected	☐	Type reference (TYPE)	STATUS_IND	'NOT_ACTIVE'	Index Status	20100209
19	ORACLE_SEGMENTS	Instance attribute	Protected	☐	Type reference (TYPE)	TY_T_DBA_SEGMENT		Oracle DBA segments	20100209
20	PACK	Instance attribute	Protected	☐	Type reference (TYPE)	CNVPACK		Conversion: Conversion packages	20100209
21	PACKID	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_PACK		Conversion: Conversion package number	20100209
22	RECR_IND_LOCK_PARAM	Constant	Protected	☐	Type reference (TYPE)	CNV_00001_PARAMS-PARAMNAME	'CNV_RECR_INDEX_&1'	Character field of length 40	20100211
23	SAPRL_700	Constant	Protected	☐	Type reference (TYPE)	SYSAPRL	'700'	System release 7.00	20100225
24	SAPRL_710	Constant	Protected	☐	Type reference (TYPE)	SYSAPRL	'710'	System release 7.10	20100225
25	SAPRL_720	Constant	Protected	☐	Type reference (TYPE)	SYSAPRL	'720'	System release 7.20	20100225
26	TABLES	Instance attribute	Protected	☐	Type reference (TYPE)	CNV_00001_TABLES_STT		List of tables	20100209
27	TABLES_LOADED	Instance attribute	Protected	☐	Type reference (TYPE)	AS4FLAG		Whether tables were already loaded	20100209

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_LOCK_PARAM	Instance method	Protected	Method	Adds lock parameter	20100211
2	CHECK_TABLESPACES	Instance method	Protected	Method	Checks sizes of the tablespaces	20100210
3	CONFIRM_INDEX_SAVE	Instance method	Public	Method	Confirms save process for indexes	20100211
4	CONSTRUCTOR	Instance method	Public	Constructor	Creates a data provider	20100209
5	GET_CONTROL_DATA	Instance method	Public	Method	Returns CNVCONTROL entries	20100311
6	GET_DB_OWNER	Instance method	Protected	Method	Returns DB owner user	20100209
7	GET_ENTRIES_FOR_TABLE	Instance method	Public	Method	Returns tabnames for given dbtable from CNVJOBPROFILE	20100311
8	GET_INDEX_DATA	Instance method	Protected	Method	Returns some index data	20100209
9	GET_INDEX_LIST	Instance method	Public	Method	Returns an index list	20100209
10	GET_NUM_PROCESSES	Instance method	Public	Method	Returns the number of parallelly running processes	20100211
11	GET_PACKID	Instance method	Public	Method	Returns package id	20100209
12	GET_POSSIBLE_INDEX_NAMES	Instance method	Protected	Method	Returns all possible index names	20100225
13	IS_INDEX_DATA_AVAILABLE	Instance method	Public	Method	Returns whether additional index data is available	20100210
14	IS_SELECTION_PARTITIONED	Instance method	Protected	Method	Returns whether selection is partitioned for a given table	20100211
15	LOAD_CNVCONTROL	Instance method	Protected	Method	Loads contents of CNVCONTROL	20100211
16	LOAD_CNVINDEX	Instance method	Protected	Method	Loads contents of CNVINDEX	20100211
17	LOAD_INDEXES	Instance method	Protected	Method	Loads index data	20100209
18	LOAD_JOBS	Instance method	Protected	Method	Loads jobs data	20100209
19	LOAD_TABLES	Instance method	Protected	Method	Loads table data	20100209
20	MSSQL_GET_INDEX_SIZE	Instance method	Protected	Method	Obtains index sizes for MSSQL	20100225
21	ORACLE_GET_DBA_SEGMENTS	Instance method	Protected	Method	Returns talbe with dba segments for oracle databases	20100209
22	REMOVE_LOCK_PARAM	Instance method	Protected	Method	Removes lock parameter	20100211
23	SAVE_CONTROL_DATA	Instance method	Public	Method	Saves entries of CNVCONTROL	20100311
24	SAVE_NUM_PROCESSES	Instance method	Public	Method	Saves number of processes	20100211
25	SELECT_INDEX_FOR_DROP	Instance method	Public	Method	(De)selects index for dropping	20100211
26	TRY_FILL_INDEX_DATA	Instance method	Protected	Method	Tries to fill index data for a given index name	20100210
27	UPDATE_JOBS_AND_INDEXES	Instance method	Protected	Method	Updates the list from CNVJOBPROFILE and CNVINDEX	20100211

Events

Class CNV_00001_OPT_DATA_PROVIDER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_DBA_SEGMENT	Protected	See coding		TY_DBA_SEGMENT	20100209
2	TY_T_DBA_SEGMENT	Protected	See coding		TY_T_DBA_SEGMENT	20100209

Method Signatures

Method ADD_LOCK_PARAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARAMNAME	Call by reference	☐	Type reference (TYPE)	CNV_00001_PARAMS-PARAMNAME		Character field of length 40	20100211
2	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100211

Method ADD_LOCK_PARAM on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method CHECK_TABLESPACES Signature

Method CHECK_TABLESPACES on class CNV_00001_OPT_DATA_PROVIDER has no parameter.
Method CHECK_TABLESPACES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method CONFIRM_INDEX_SAVE Signature

Method CONFIRM_INDEX_SAVE on class CNV_00001_OPT_DATA_PROVIDER has no parameter.
Method CONFIRM_INDEX_SAVE on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PACKID	Call by reference	☐	Type reference (TYPE)	CNV_PACK		Conversion: Conversion package number	20100209

#	Exception	Resumable	Description	Created on
1	PACKAGE_NOT_FOUND	☐	Package not found in the system	20100209

Method GET_CONTROL_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DATA	Call by reference	☐	Type reference (TYPE)	CNV_00001_CONTROL_STT		Sorted table of CNVCONTROL	20100311

Method GET_CONTROL_DATA on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_DB_OWNER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	OWNER	Value transfer	☐	Type reference (TYPE)	CHAR10		DB Owner	20100209

Method GET_DB_OWNER on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_ENTRIES_FOR_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ENTRIES	Call by reference	☐	Type reference (TYPE)	TTTABNAME		Number of Tables	20100311
2	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100311

Method GET_ENTRIES_FOR_TABLE on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_INDEX_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	DBINDEX	Call by reference	☐	Type reference (TYPE)	DBINDEX_D		Database index	20100209
2	Importing	INDEXNAME	Call by reference	☐	Type reference (TYPE)	INDEXID		Unique index ID within a table	20100209
3	Exporting	SIZE	Call by reference	☐	Type reference (TYPE)	CNV_INDEX_SIZE		Size of an index in KByte	20100209
4	Exporting	TABLESPACE	Call by reference	☐	Type reference (TYPE)	ORATSPNAME		Tablespace name for ORACLE	20100209
5	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100209

Method GET_INDEX_DATA on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_INDEX_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	LIST	Call by reference	☐	Type reference (TYPE)	CNV_00001_INDEX_DATA_TT		List of index data	20100209

Method GET_INDEX_LIST on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_NUM_PROCESSES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RET	Value transfer	☐	Type reference (TYPE)	CNV_PMAX		Conversion: maximum number of simultaneous programs	20100211

Method GET_NUM_PROCESSES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_PACKID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PACKID	Value transfer	☐	Type reference (TYPE)	CNV_PACK		Conversion: Conversion package number	20100209

Method GET_PACKID on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method GET_POSSIBLE_INDEX_NAMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DBINDEXES	Value transfer	☐	Type reference (TYPE)	CNV_00001_DBINDEX_TT		Database indexes	20100225
2	Importing	DBINDEXNAME	Value transfer	☐	Type reference (TYPE)	DBINDEX_D		Database index	20100225
3	Importing	INDEXNAME	Value transfer	☐	Type reference (TYPE)	INDEXID		Unique index ID within a table	20100225
4	Importing	TABNAME	Value transfer	☐	Type reference (TYPE)	TABNAME		Table name	20100225

Method GET_POSSIBLE_INDEX_NAMES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method IS_INDEX_DATA_AVAILABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RES	Value transfer	☐	Type reference (TYPE)	AS4FLAG		Flag (X or blank)	20100210

Method IS_INDEX_DATA_AVAILABLE on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method IS_SELECTION_PARTITIONED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RES	Value transfer	☐	Type reference (TYPE)	AS4FLAG		Flag (X or blank)	20100211
2	Importing	SCENARIO	Call by reference	☐	Type reference (TYPE)	CNV_SZENARIO		Generator scenario	20100211
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100211

Method IS_SELECTION_PARTITIONED on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method LOAD_CNVCONTROL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FORCE	Call by reference	☐	Type reference (TYPE)	AS4FLAG	SPACE	whether to force load	20100211

Method LOAD_CNVCONTROL on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method LOAD_CNVINDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FORCE	Call by reference	☐	Type reference (TYPE)	AS4FLAG	SPACE	whether to force load	20100211

Method LOAD_CNVINDEX on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method LOAD_INDEXES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FORCE	Value transfer	☑	Type reference (TYPE)	AS4FLAG	SPACE	whether to force load	20100209

Method LOAD_INDEXES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method LOAD_JOBS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FORCE	Call by reference	☑	Type reference (TYPE)	AS4FLAG	SPACE	whether to force load	20100209

Method LOAD_JOBS on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method LOAD_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FORCE	Call by reference	☑	Type reference (TYPE)	AS4FLAG	SPACE	whether to force load	20100209

Method LOAD_TABLES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method MSSQL_GET_INDEX_SIZE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DBINDEX	Call by reference	☐	Type reference (TYPE)	DBINDEX_D		Database index	20100225
2	Exporting	SIZE	Call by reference	☐	Type reference (TYPE)	CNV_INDEX_SIZE		Size of an index in KByte	20100225
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100225

#	Exception	Resumable	Description	Created on
1	FAILED_TO_GET_SIZE	☐	Failed to obtain index size	20100225
2	RELEASE_UNSUPPORTED	☐	Release not supported	20100225

Method ORACLE_GET_DBA_SEGMENTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SEGMENTS	Call by reference	☐	Type reference (TYPE)	TY_T_DBA_SEGMENT		DBA segments	20100209

Method ORACLE_GET_DBA_SEGMENTS on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method REMOVE_LOCK_PARAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARAMNAME	Call by reference	☐	Type reference (TYPE)	CNV_00001_PARAMS-PARAMNAME		Character field of length 40	20100211
2	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100211

Method REMOVE_LOCK_PARAM on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method SAVE_CONTROL_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA	Call by reference	☐	Type reference (TYPE)	CNV_00001_CONTROL_TT		Standard table of CNVCONTROL	20100311

Method SAVE_CONTROL_DATA on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method SAVE_NUM_PROCESSES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PROC_NUM	Call by reference	☐	Type reference (TYPE)	CNV_PMAX		Conversion: maximum number of simultaneous programs	20100211

Method SAVE_NUM_PROCESSES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method SELECT_INDEX_FOR_DROP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	CHANGED	Value transfer	☐	Type reference (TYPE)	AS4FLAG		Whether something has changed in DB	20100211
2	Importing	DBINDEX	Call by reference	☐	Type reference (TYPE)	DBINDEX_D		Database index	20100211
3	Importing	INDEXNAME	Call by reference	☐	Type reference (TYPE)	INDEXID		Unique index ID within a table	20100211
4	Importing	INDEXSIZE	Call by reference	☑	Type reference (TYPE)	CNV_INDEX_SIZE		Size of an index in KByte	20100211
5	Exporting	RES	Value transfer	☐	Type reference (TYPE)	AS4FLAG		Result	20100211
6	Importing	SELECTED	Call by reference	☐	Type reference (TYPE)	AS4FLAG		Flag (X or blank)	20100211
7	Importing	STATUS	Call by reference	☐	Type reference (TYPE)	STATUS_IND		Index Status	20100211
8	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	TABNAME		Table name	20100211
9	Importing	TABSPACE	Call by reference	☑	Type reference (TYPE)	ORATSPNAME		Tablespace name for ORACLE	20100211

Method SELECT_INDEX_FOR_DROP on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method TRY_FILL_INDEX_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	DBINDEX	Call by reference	☐	Type reference (TYPE)	DBINDEX_D		Database index	20100210
2	Importing	INDEXNAME	Call by reference	☐	Type reference (TYPE)	ANY		Unique index ID within a table	20100210
3	Exporting	SIZE	Call by reference	☐	Type reference (TYPE)	CNV_INDEX_SIZE		Size of an index in KByte	20100210
4	Exporting	SUBRC	Call by reference	☐	Type reference (TYPE)	SYSUBRC		Result	20100210
5	Exporting	TABLESPACE	Call by reference	☐	Type reference (TYPE)	ORATSPNAME		Tablespace name for ORACLE	20100210

Method TRY_FILL_INDEX_DATA on class CNV_00001_OPT_DATA_PROVIDER has no exception.

Method UPDATE_JOBS_AND_INDEXES Signature

Method UPDATE_JOBS_AND_INDEXES on class CNV_00001_OPT_DATA_PROVIDER has no parameter.
Method UPDATE_JOBS_AND_INDEXES on class CNV_00001_OPT_DATA_PROVIDER has no exception.

History

Last changed by/on	SAP	20141030
SAP Release Created in	2006_1_46C