SAP ABAP Class CL_DB6_SYSCAT (DB6 CCMS: SYSCAT abstraction)

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_SYSCAT
Short Description	DB6 CCMS: SYSCAT abstraction
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	20050727	SAP
Last change	20141121
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)
4	DB6SY	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_DB6_SYSCAT has no interface implemented.

Friends

Class CL_DB6_SYSCAT has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	BP_ON_ALL_PARTITIONS	Constant	Public	☐	Type reference (TYPE)	STRING	'A'		20080625
2	BP_ON_SELECTED_PGRPS	Constant	Public	☐	Type reference (TYPE)	STRING	'S'		20080625
3	BW_METADATA	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_METADATA_DB6		DB6: Implementation of IF CL_SQL_METADATA	20050727
4	CO_AUTHORITY_DBADM	Constant	Public	☐	Type reference (TYPE)	STRING	'DBADM'		20100922
5	CO_AUTHORITY_SECADM	Constant	Public	☐	Type reference (TYPE)	STRING	'SECADM'		20111014
6	CO_AUTHORITY_SQLADM	Constant	Public	☐	Type reference (TYPE)	STRING	'SQLADM'		20100922
7	CO_IDX_COMPRESSED_NO	Constant	Public	☐	Type reference (TYPE)	STRING	'N'		20090622
8	CO_IDX_COMPRESSED_YES	Constant	Public	☐	Type reference (TYPE)	STRING	'Y'		20090622
9	CO_IDX_COMPR_ATTR_NO	Constant	Public	☐	Type reference (TYPE)	STRING	'N'		20090622
10	CO_IDX_COMPR_ATTR_YES	Constant	Public	☐	Type reference (TYPE)	STRING	'Y'		20090622
11	CO_REORGCHK_IX_REORG_NO	Constant	Public	☐	Type reference (TYPE)	STRING	'-----'		20090708
12	CO_REORGCHK_TB_REORG_NO	Constant	Public	☐	Type reference (TYPE)	STRING	'---'		20090708
13	CO_REORG_RECOMMENDED_NO	Constant	Public	☐	Type reference (TYPE)	CHAR1	'-'	Single-Character Flag	20090903
14	CO_REORG_RECOMMENDED_YES	Constant	Public	☐	Type reference (TYPE)	CHAR1	'*'	Single-Character Flag	20090903
15	CO_TABCOMPR_OBJECT_TYPE_DATA	Constant	Public	☐	Type reference (TYPE)	STRING	'DATA'		20090706
16	CO_TABCOMPR_OBJECT_TYPE_XML	Constant	Public	☐	Type reference (TYPE)	STRING	'XML'		20090706
17	CO_TABLEORG_COLUMN_BASED	Constant	Public	☐	Type reference (TYPE)	STRING	'C'		20130405
18	CO_TABLEORG_ROW_BASED	Constant	Public	☐	Type reference (TYPE)	STRING	'R'		20130405
19	CO_TAB_CLUSTERED_ITC	Constant	Public	☐	Type reference (TYPE)	STRING	'T'		20120503
20	CO_TAB_CLUSTERED_MDC	Constant	Public	☐	Type reference (TYPE)	STRING	'Y'		20120503
21	CO_TAB_CLUSTERED_NONE	Constant	Public	☐	Type reference (TYPE)	STRING	SPACE		20120503
22	CO_TAB_COMPR_BOTH	Constant	Public	☐	Type reference (TYPE)	STRING	'B'		20090618
23	CO_TAB_COMPR_NONE	Constant	Public	☐	Type reference (TYPE)	STRING	'N'		20090618
24	CO_TAB_COMPR_ROW	Constant	Public	☐	Type reference (TYPE)	STRING	'R'		20090618
25	CO_TAB_COMPR_VALUE	Constant	Public	☐	Type reference (TYPE)	STRING	'V'		20090618
26	CO_TAB_ROWCOMPMODE_ADAPTIVE	Constant	Public	☐	Type reference (TYPE)	STRING	'A'		20120503
27	CO_TAB_ROWCOMPMODE_NONE	Constant	Public	☐	Type reference (TYPE)	STRING	SPACE		20120503
28	CO_TAB_ROWCOMPMODE_STATIC	Constant	Public	☐	Type reference (TYPE)	STRING	'S'		20120503
29	TSP_INCREASE_SIZE_ABS	Constant	Public	☐	Type reference (TYPE)	STRING	'A'		20080617
30	TSP_INCREASE_SIZE_PERCENT	Constant	Public	☐	Type reference (TYPE)	STRING	'P'		20080617
31	TSP_MGMT_AUTO	Constant	Public	☐	Type reference (TYPE)	STRING	'A'		20080616
32	TSP_MGMT_DMS	Constant	Public	☐	Type reference (TYPE)	STRING	'D'		20080616
33	TSP_MGMT_SMS	Constant	Public	☐	Type reference (TYPE)	STRING	'S'		20080616

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CONSTRUCTOR	Instance method	Public	Constructor	CONSTRUCTOR	20050727
2	CREATE_DB2_ROUTINES	Static method	Public	Method		20060509
3	GET_1ST_PARTITION	Static method	Public	Method		20051221
4	GET_BUFFERPOOLS	Static method	Public	Method		20080616
5	GET_COLUMNS	Instance method	Public	Method		20050727
6	GET_DATA_PARTITIONS	Static method	Public	Method		20090821
7	GET_EXPLAIN_CATALOG_INFO	Static method	Public	Method	get tables from SYSCAT.TABLES	20060623
8	GET_INDEXCNT_IN_TABLESPACE	Static method	Public	Method		20080626
9	GET_INDEX_INFO	Instance method	Public	Method		20050727
10	GET_INSTANCE	Static method	Public	Method		20050727
11	GET_INSTANCE_OWNER	Static method	Public	Method		20111014
12	GET_PARTITIONS	Static method	Public	Method		20080623
13	GET_PARTITION_GROUPS	Static method	Public	Method		20080619
14	GET_PSEUDO_TABLES	Static method	Public	Method		20061208
15	GET_REAL_CARDINALITY	Static method	Public	Method		20090820
16	GET_TABLECNT_IN_TABLESPACE	Static method	Public	Method		20080626
17	GET_TABLESPACES	Static method	Public	Method		20071005
18	GET_TABLESPACE_BP	Static method	Public	Method	get BP name of given tablespace	20051129
19	GET_USER_TABLESPACES	Static method	Public	Method		20080609
20	HAS_COMPRESSIBLE_INDEXES	Static method	Public	Method		20130822
21	IS_BUFFERPOOL_IN_USE	Static method	Public	Method		20081118
22	IS_EXISTING_EVMON	Static method	Public	Method	Returns true is table/view exists	20100722
23	IS_EXISTING_INDEX	Static method	Public	Method		20090512
24	IS_EXISTING_ROLE	Static method	Public	Method		20111125
25	IS_EXISTING_ROUTINE	Static method	Public	Method		20060509
26	IS_EXISTING_TABLE	Static method	Public	Method	Returns true is table/view exists	20090130
27	IS_IN_AUTHORITY	Static method	Public	Method		20100922
28	IS_IN_GROUP	Static method	Public	Method		20090323
29	IS_IN_ROLE	Static method	Public	Method		20100920
30	IS_MDC_TABLE	Static method	Public	Method		20090626
31	IS_PACKAGE_CACHE_METRIC	Static method	Public	Method	checks if metric is part of the package cache metrics	20100112
32	IS_PRIMARY_KEY	Static method	Public	Method		20090708
33	IS_TABLE	Static method	Public	Method	return TRUE if given object is a table and not a view	20050908
34	IS_TABLE_WITH_PROFILE	Static method	Public	Method		20090129
35	IS_VOLATILE_TABLE	Static method	Public	Method		20110621
36	MATERIALIZE_TABLE	Static method	Public	Method		20061211
37	NUM_RANGE_PARTITIONED_TABLES	Static method	Public	Method	get number of range partitioned tables in tablespace	20060719
38	SWITCH_COMPRESSION	Static method	Public	Method		20090709
39	SWITCH_VOLATILE	Static method	Public	Method		20090709

Events

Class CL_DB6_SYSCAT has no event.

Types

Class CL_DB6_SYSCAT 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	DBCNAME	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20050727

Method CONSTRUCTOR on class CL_DB6_SYSCAT has no exception.

Method CREATE_DB2_ROUTINES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20060509

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

Method GET_1ST_PARTITION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PARTITION	Value transfer	☐	Type reference (TYPE)	I			20051221
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20051221

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	Ausnahmeklasse für SQL Fehler	20051221

Method GET_BUFFERPOOLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	BUFFERPOOLS	Value transfer	☐	Type reference (TYPE)	DB6CATBP_TAB		DB6: System Catalog Information of Bufferpools	20080616
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080616

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

Method GET_COLUMNS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	COLUMN_TAB	Value transfer	☐	Type reference (TYPE)	DB6_TABCOL_DESCR_TAB		DB6: Table of DB6_TABCOL_DESCR	20050727
2	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20050727
3	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20050727

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20050727

Method GET_DATA_PARTITIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	DATA_PARTITIONS	Value transfer	☐	Type reference (TYPE)	DB6CATDATAPARTITIONS_TAB		DB6: SYSCAT.DATAPARTITIONS	20090821
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090821
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090821
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090821

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

Method GET_EXPLAIN_CATALOG_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ADVISE_MODE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	forces explain_schema to be set !	20060623
2	Importing	EXPLAIN_SCHEMA	Call by reference	☑	Type reference (TYPE)	DB6SCHEMA		DB6: Schema Name	20060623
3	Importing	IS_EEE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20060623
4	Importing	OBJECT_NAME	Call by reference	☐	Type reference (TYPE)	DB6XPLOBJ-OBJ_NAME		DB6: long table name	20060623
5	Importing	OBJECT_SCHEMA	Call by reference	☐	Type reference (TYPE)	DB6XPLOBJ-OBJ_SCHEMA		DB6: Schema Name	20060623
6	Importing	OBJECT_TYPE	Call by reference	☐	Type reference (TYPE)	DB6XPLOBJ-OBJ_TYPE			20060623
7	Changing	SYSCOLDIST	Call by reference	☐	Type reference (TYPE)	DB6XPLCOLDIST_TAB		DB6: Table of DB6XPLCOLDIST	20070405
8	Changing	SYSCOLGROUPCOLS	Call by reference	☐	Type reference (TYPE)	DB6XPLCOLGROUPCOLS_TAB			20080625
9	Changing	SYSCOLUMNS	Call by reference	☐	Type reference (TYPE)	DB6XPLCOLS_TAB		DB6: Table of DB6XPLCOLS	20060623
10	Changing	SYSINDCOLUSE	Call by reference	☐	Type reference (TYPE)	DB6XPLIXCOLS_TAB		DB6: Table of DB6XPLIXCOLS	20061030
11	Changing	SYSINDEXES	Call by reference	☐	Type reference (TYPE)	DB6XPLINDX_TAB		DB6: Table of DB6XPLINDX	20060623
12	Changing	SYSSTATSVIEWS	Call by reference	☐	Type reference (TYPE)	DB6XPLVIEW_TAB		DB6: Table of DB6XPLTABL	20080630
13	Changing	SYSTABLES	Call by reference	☐	Type reference (TYPE)	DB6XPLTABL_TAB		DB6: structure of SYSCAT.TABLES + syscat.tablesapces-ngname	20060623
14	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20060623

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

Method GET_INDEXCNT_IN_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	INDEXCNT	Value transfer	☐	Type reference (TYPE)	I			20080626
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080626
3	Importing	TSP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		DB6: Tablespace Name	20080626

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

Method GET_INDEX_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INDEX_NAME	Call by reference	☑	Type reference (TYPE)	ADBC_NAME			20050727
2	Returning	INDEX_TAB	Value transfer	☐	Type reference (TYPE)	ADBC_INDEX_DESCR_TAB			20050727
3	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20050727
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	ADBC_NAME			20050727

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

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CONNECTION	Call by reference	☐	Type reference (TYPE)	DBCON-CON_NAME		Logical name for a database connection	20050727
2	Returning	SYSCAT_REF	Value transfer	☐	Object reference (TYPE REF TO)	CL_DB6_SYSCAT		DB6 CCMS: SYSCAT abstraction	20050727

Method GET_INSTANCE on class CL_DB6_SYSCAT has no exception.

Method GET_INSTANCE_OWNER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	INSTANCE_OWNER	Value transfer	☐	Type reference (TYPE)	STRING			20111014
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20111014

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

Method GET_PARTITIONS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	PARTITION_LIST	Value transfer	☐	Type reference (TYPE)	DB6PMCN_TAB		DB6: Configuration Nodes (Partitions)	20080623
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080623

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

Method GET_PARTITION_GROUPS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARTITION	Call by reference	☐	Type reference (TYPE)	I			20080619
2	Returning	PARTITION_GROUPS	Value transfer	☐	Type reference (TYPE)	DB6CATNGRP_LIST		DB6: List of Nodegroups	20080619
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080619

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

Method GET_PSEUDO_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	LIMIT_ROWS	Call by reference	☑	Type reference (TYPE)	I			20061211
2	Returning	PSEUDO_TABLES	Value transfer	☐	Type reference (TYPE)	DB6PSEUDOTAB_TAB		DB6 CCMS: Table of DB6PSEUDOTAB	20061208
3	Importing	SCHEMA	Call by reference	☑	Type reference (TYPE)	CLIKE		DB6: Schema Name	20061211
4	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20061208
5	Importing	TABLE	Call by reference	☑	Type reference (TYPE)	CLIKE		DB6: long table name	20061211

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

Method GET_REAL_CARDINALITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	REAL_CARDINALITY	Value transfer	☐	Type reference (TYPE)	DB6CC_PACKED_INT64			20090820
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090820
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090820
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090820

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

Method GET_TABLECNT_IN_TABLESPACE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080626
2	Returning	TABLECNT	Value transfer	☐	Type reference (TYPE)	I			20080626
3	Importing	TSP_NAME	Call by reference	☐	Type reference (TYPE)	STRING		DB6: Tablespace Name	20080626

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

Method GET_TABLESPACES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARTITION	Call by reference	☐	Type reference (TYPE)	I		Partition Number	20071005
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20071005
3	Returning	TABLESPACES	Value transfer	☐	Type reference (TYPE)	DB6CATTSP_TAB		DB6: Table of DB6CATTSP	20071005
4	Importing	TSP_NAME	Call by reference	☑	Type reference (TYPE)	DB6TSPNAME		DB6: Tablespace Name	20071005

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

Method GET_TABLESPACE_BP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	BPNAME	Value transfer	☐	Type reference (TYPE)	DB6IDENT		DB6: General identifier	20051129
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20060125
3	Importing	TABLESPACE	Call by reference	☐	Type reference (TYPE)	DB6TSPNAME		DB6: General identifier	20051129

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

Method GET_USER_TABLESPACES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARTITION	Call by reference	☐	Type reference (TYPE)	I		Partition Number	20080609
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20080609
3	Returning	TABLESPACES	Value transfer	☐	Type reference (TYPE)	DB6CATTSP_TAB		DB6: Table of DB6CATTSP	20080609

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

Method HAS_COMPRESSIBLE_INDEXES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	HAS_COMPRESSIBLE_INDEXES	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20130822
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20130822
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20130822
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20130822

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐		20130822
2	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20130822

Method IS_BUFFERPOOL_IN_USE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	BP_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20081118
2	Returning	IN_USE	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20081118
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20081118

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

Method IS_EXISTING_EVMON Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	EVMON_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100722
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20100722
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100722

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

Method IS_EXISTING_INDEX Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IDXNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090512
2	Importing	IDXSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090512
3	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090512
4	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090512

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

Method IS_EXISTING_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IS_EXISTING	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20111125
2	Importing	ROLE	Call by reference	☐	Type reference (TYPE)	CLIKE			20111125
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20111125

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

Method IS_EXISTING_ROUTINE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INNAME	Call by reference	☐	Type reference (TYPE)	CLIKE	'INPUT'		20091005
2	Importing	INTYPE	Call by reference	☑	Type reference (TYPE)	CLIKE		DB6: Input Type for Routine	20090513
3	Returning	IS_EXISTING	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20060509
4	Importing	ROUTINE	Call by reference	☐	Type reference (TYPE)	CLIKE			20060509
5	Importing	SCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20060509
6	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20060509

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

Method IS_EXISTING_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090130
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090130
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090130
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090130

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

Method IS_IN_AUTHORITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	AUTHORITY	Call by reference	☐	Type reference (TYPE)	STRING		DB6: Groups to Check	20100922
2	Importing	CON_REF	Value transfer	☑	Object reference (TYPE REF TO)	CL_DBA_DBCON		DBA Cockpit: DBCON administration	20100922
3	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20100922
4	Importing	SYS_REF	Value transfer	☑	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100922
5	Importing	USER_NAME	Call by reference	☑	Type reference (TYPE)	STRING		Database User	20120319

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

Method IS_IN_GROUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_REF	Value transfer	☑	Object reference (TYPE REF TO)	CL_DBA_DBCON		DBA Cockpit: DBCON administration	20090323
2	Importing	GROUPS	Call by reference	☐	Type reference (TYPE)	DBA_TEXT_CHAR_TAB		DB6: Groups to Check	20090323
3	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090323
4	Importing	SYS_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090323

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

Method IS_IN_ROLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CON_REF	Value transfer	☑	Object reference (TYPE REF TO)	CL_DBA_DBCON		DBA Cockpit: DBCON administration	20100920
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20100920
3	Importing	ROLE	Call by reference	☐	Type reference (TYPE)	STRING		DB6: Groups to Check	20100920
4	Importing	SYS_REF	Value transfer	☑	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100920

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

Method IS_MDC_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IS_MDC	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090626
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090626
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090626
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090626

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐		20090626

Method IS_PACKAGE_CACHE_METRIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CONTAINED	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20100112
2	Importing	METRIC_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100112
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100112

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

Method IS_PRIMARY_KEY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IDXNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090708
2	Importing	IDXSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090708
3	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090708
4	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090708

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

Method IS_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ISTABLE	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20050908
2	Importing	SCHEMA_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20050908
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20060125
4	Importing	TABLE_NAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20050908

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	Ausnahmeklasse für SQL Fehler	20050908

Method IS_TABLE_WITH_PROFILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	HAS_PROFILE	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20090129
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090129
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE		DB6: long table name	20090129
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE		DB6: Schema Name	20090129

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

Method IS_VOLATILE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IS_VOLATILE	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20110621
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110621
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE		DB6: long table name	20110621
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE		DB6: Schema Name	20110621

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

Method MATERIALIZE_TABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SCHEMA	Call by reference	☐	Type reference (TYPE)	DB6SCHEMA		DB6: Schema Name	20061211
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20061211
3	Importing	TABLE	Call by reference	☐	Type reference (TYPE)	DB6TABNAML		DB6: long table name	20061211

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

Method NUM_RANGE_PARTITIONED_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	COUNT	Value transfer	☐	Type reference (TYPE)	I			20060719
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20060719
3	Importing	TABLESPACE	Call by reference	☐	Type reference (TYPE)	DB6TSPNAME		DB6: long table name	20060719

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

Method SWITCH_COMPRESSION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COMPRESSION	Call by reference	☐	Type reference (TYPE)	SDBAR-RESNAME		Comment	20090709
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090709
3	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090709
4	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090709

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20090709
2	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20091013

Method SWITCH_VOLATILE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20090709
2	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20090709
3	Importing	TABSCHEMA	Call by reference	☐	Type reference (TYPE)	CLIKE			20090709
4	Importing	VOLATILE	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL			20090709

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

History

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