SAP ABAP Class CL_DB2_TABLESPACE_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_TABLESPACE_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_TABLESPACE_INFO has no interface implemented.

Friends

Class CL_DB2_TABLESPACE_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		datasets	20091021
2	DB2RELEASE	Static Attribute	Private	☐	Type reference (TYPE)	DB2RELEASE		DB2 Version / Release	20091021
3	DETAILS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_TS_DETAILS		ts details	20091021
4	GENERAL_DATA	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_TS_GEN		general TS Data	20091021
5	HISTORY	Instance attribute	Public	☐	Type reference (TYPE)	DB_T_TABHIST		history	20091021
6	LAST_RUN_DATE	Instance attribute	Private	☐	Type reference (TYPE)	DB2DATE		last collection run (date)	20120711
7	LAST_RUN_TIME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TIME		last collection run (time)	20120711
8	PARTITIONS	Instance attribute	Public	☐	Type reference (TYPE)	DB2TBPARTLIST		partitions	20091021
9	PARTITION_DETAILS	Instance attribute	Public	☐	Type reference (TYPE)	DB2_DB02_TAB_PART_DETAILS		partition details	20091021
10	REMOTE_DBCON	Instance attribute	Private	☐	Type reference (TYPE)	DBCON-CON_NAME		remote dbcon	20091021
11	TABLES	Instance attribute	Public	☐	Type reference (TYPE)	DB2_T_TABLES		tables	20091021
12	TS_DBNAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2DBNAML		TS Creator	20091021
13	TS_NAME	Instance attribute	Private	☐	Type reference (TYPE)	DB2TSNAML		Name of the tablespace	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_VERSION	Instance method	Private	Method	get DB Version / Release	20091021
4	GET_DETAILS	Instance method	Public	Method	get detail information	20091021
5	GET_GENERAL_DATA	Instance method	Public	Method	get general data	20091021
6	GET_HISTORY	Instance method	Public	Method	get history information	20091021
7	GET_LAST_RUN	Instance method	Public	Method	get date / time of last collection run	20120711
8	GET_PARTITIONS	Instance method	Public	Method	get partitions information	20091021
9	GET_PARTITION_DETAILS	Instance method	Public	Method	get partition detail information	20091021
10	GET_TABLES	Instance method	Public	Method	get tables information	20091021

Events

Class CL_DB2_TABLESPACE_INFO has no event.

Types

Class CL_DB2_TABLESPACE_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	REMOTE_DBCON	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20091021
2	Importing	TS_DBNAME	Call by reference	☐	Type reference (TYPE)	DB2DBNAML		DB2 creator name	20091021
3	Importing	TS_NAME	Call by reference	☐	Type reference (TYPE)	DB2TSNAML		Name of the tablespace	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_VERSION Signature

Method GET_DB_VERSION on class CL_DB2_TABLESPACE_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_TABLESPACE_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		2 byte integer (signed)	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_TABLES 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	740