SAP ABAP Class CL_DB2_INDEX_INFO (class with table information)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Properties

Class	CL_DB2_INDEX_INFO
Short Description	class with table information
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	STU3	Development Class for Database Monitor
Created	20090615	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

Class CL_DB2_INDEX_INFO has no interface implemented.

Friends

Class CL_DB2_INDEX_INFO has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	DATASETS	Instance attribute	Public	☐	Type reference (TYPE)	DB2DATASETS		dataset detail info for indexes	20091021
2	DB2RELEASE	Static Attribute	Private	☐	Type reference (TYPE)	DB2RELEASE		Version / Release of DB2	20091021
3	DBNAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2DBNAML		DB Name	20091029
4	DETAILS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_IX_DETAILS		DB02: Detail Index Information	20091021
5	GENERAL_DATA	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_IX_GEN		general data for tablespaces	20091021
6	HISTORY	Instance attribute	Public	☐	Type reference (TYPE)	DB_T_TABHIST		DB02 Table History	20091021
7	IX_CREATOR	Instance attribute	Private	☐	Type reference (TYPE)	DB2CREATORL		Index Creator	20091021
8	IX_NAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2IXNAML		index name	20091021
9	LAST_RUN_DATE	Instance attribute	Private	☐	Type reference (TYPE)	DB2DATE		last collection run (date)	20120711
10	LAST_RUN_TIME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TIME		last collection run (time)	20120711
11	PARTITIONS	Instance attribute	Public	☐	Type reference (TYPE)	DB2TBPARTLIST		partition list	20091021
12	PARTITION_DETAILS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_IX_PART_DETAILS		DB02 partition details for tables	20091021
13	REMOTE_DBCON	Instance attribute	Private	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20091021
14	SPACENAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TSNAML		Indexspace Name	20091029
15	STRUCTURE	Instance attribute	Public	☐	Type reference (TYPE)	DB2_T_TABSTRUC		info on table structure	20091021

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	constructor	20091021
2	GET_DATASETS	Instance method	Public	Method	get datasets Information	20091021
3	GET_DB_IXSPACE	Instance method	Private	Method	Get DBName and Indexspace for the Index Object	20091029
4	GET_DB_VERSION	Instance method	Private	Method	get DB Version / Release	20091021
5	GET_DETAILS	Instance method	Public	Method	get detail information	20091021
6	GET_GENERAL_DATA	Instance method	Public	Method	get general data	20091021
7	GET_HISTORY	Instance method	Public	Method	get history information	20091021
8	GET_LAST_RUN	Instance method	Public	Method	get date / time of last collection run	20120711
9	GET_PARTITIONS	Instance method	Public	Method	get partitions information	20091021
10	GET_PARTITION_DETAILS	Instance method	Public	Method	get partition detail information	20091021
11	GET_STRUCTURE	Instance method	Public	Method	get structure info	20091021

Events

Class CL_DB2_INDEX_INFO has no event.

Types

Class CL_DB2_INDEX_INFO has no local type.

Method Signatures

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IXCREATOR	Call by reference	☐	Type reference (TYPE)	DB2CREATORL		DB2 creator name	20091021
2	Importing	IXNAME	Call by reference	☐	Type reference (TYPE)	DB2IXNAML		Index name	20091021
3	Importing	REMOTE_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	CX_DB2_ROOT	☐		20091021

Method GET_DATASETS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	MSG	Call by reference	☐	Type reference (TYPE)	STRING			20091104
2	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_DB_IXSPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091029

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091029
2	INTERNAL_ERROR	☐		20091029

Method GET_DB_VERSION Signature

Method GET_DB_VERSION on class CL_DB2_INDEX_INFO has no parameter.

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_GENERAL_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_HISTORY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EXPANDED	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20091103
2	Importing	FROM_DATE	Call by reference	☐	Type reference (TYPE)	DB2DATE		Field type date, YYYYMMDD	20091021
3	Importing	RANGE	Call by reference	☐	Type reference (TYPE)	DB2HIST_RANGE		Range for History ( daily, weekly, monthly )	20091021
4	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021
5	Importing	TO_DATE	Call by reference	☐	Type reference (TYPE)	DB2DATE		Field type date, YYYYMMDD	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_LAST_RUN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	LAST_DATE	Call by reference	☐	Type reference (TYPE)	DB2DATE		Field type date, YYYYMMDD	20120711
2	Exporting	LAST_TIME	Call by reference	☐	Type reference (TYPE)	DB2TIME		Field type time, HHMMSS	20120711

Method GET_LAST_RUN on class CL_DB2_INDEX_INFO has no exception.

Method GET_PARTITIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_PARTITION_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARTNO	Call by reference	☑	Type reference (TYPE)	INT2			20091021
2	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

Method GET_STRUCTURE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	SQLERR_REF	Call by reference	☐	Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20091021

#	Exception	Resumable	Description	Created on
1	ADBC_SQL_ERROR	☐		20091021
2	INTERNAL_ERROR	☐		20091021

History

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