SAP ABAP Class CL_SYB_DBMS_UTILS (SYB: DBMS Utilities)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-SYB (Application Component) Sybase ASE Database Platform
     ⤷ SMSYB (Package) SYBASE Database Monitor

Properties

Class	CL_SYB_DBMS_UTILS
Short Description	SYB: DBMS Utilities
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SMSYB	SYBASE Database Monitor
Created	20100809	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)

Interfaces

Class CL_SYB_DBMS_UTILS has no interface implemented.

Friends

Class CL_SYB_DBMS_UTILS has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	CO_REORG_COMPACT	Constant	Public	☐	Type reference (TYPE)	I	1		20100809
2	CO_REORG_FORWARDED_ROWS	Constant	Public	☐	Type reference (TYPE)	I	3		20100809
3	CO_REORG_REBUILD	Constant	Public	☐	Type reference (TYPE)	I	4		20100809
4	CO_REORG_RECLAIM_SPACE	Constant	Public	☐	Type reference (TYPE)	I	2		20100809
5	CO_STATS_ALL_INDEX_COLS	Constant	Public	☐	Type reference (TYPE)	I	2		20100809
6	CO_STATS_LEADING_INDEX_COLS	Constant	Public	☐	Type reference (TYPE)	I	4		20100809

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_FULL_PATH	Static method	Public	Method		20120119
2	CAST_FMT_TSTAMP_TO_DB6TSTAMP	Static method	Public	Method		20110418
3	CONVERT_PERCENTAGE_TO_INT	Static method	Public	Method	convert string like '200G' to MB integer	20130304
4	CONVERT_SIZESTR_TO_MB	Static method	Public	Method	convert string like '200G' to MB integer	20130108
5	DESCRIBE_QUERY_BIND_PARAMS	Static method	Public	Method		20120110
6	DETERMINE_APPL_DATABASE	Static method	Public	Method		20131031
7	EXEC_DBCC_CMD	Static method	Public	Method		20110615
8	GET_ASE_OPSYS	Static method	Public	Method		20110812
9	GET_BKUP_CONFIG	Static method	Public	Method		20130423
10	GET_CURRENT_DB6TSTAMP	Static method	Public	Method		20101222
11	GET_CURRENT_DB6TSTAMP_UTC	Static method	Public	Method		20130503
12	GET_DB_SERVERS	Static method	Public	Method		20130423
13	GET_MISSING_INDEXSTATS	Static method	Public	Method		20121018
14	GET_OPTSTATS	Static method	Public	Method		20110411
15	GET_SERVER_CONFIG_PARAM	Static method	Public	Method		20110627
16	GET_WAITEVENTINFO	Static method	Public	Method		20110810
17	IS_VALID_PATH_NAME	Static method	Public	Method		20120119
18	KILL_SPID	Static method	Public	Method		20120831
19	PARSE_OPTSTATS_COLSTATS	Static method	Private	Method		20110418
20	PARSE_OPTSTATS_INDSTATS	Static method	Private	Method		20110429
21	PARSE_OPTSTATS_TABSTATS	Static method	Private	Method		20110428
22	REORG	Static method	Public	Method		20100809
23	RESOLVE_CACHED_STMT_TEXT	Static method	Public	Method		20110214
24	UPDATE_STATISTICS	Static method	Public	Method		20100809

Events

Class CL_SYB_DBMS_UTILS has no event.

Types

Class CL_SYB_DBMS_UTILS has no local type.

Method Signatures

Method BUILD_FULL_PATH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FILE	Call by reference	☐	Type reference (TYPE)	STRING			20120119
2	Returning	FULLPATH	Value transfer	☐	Type reference (TYPE)	STRING			20120119
3	Importing	OPSYS	Call by reference	☐	Type reference (TYPE)	SYOPSYS		Operating System of Application Server	20120119
4	Importing	PATH	Call by reference	☐	Type reference (TYPE)	STRING			20120119

Method BUILD_FULL_PATH on class CL_SYB_DBMS_UTILS has no exception.

Method CAST_FMT_TSTAMP_TO_DB6TSTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	DB6TSTAMP	Value transfer	☐	Type reference (TYPE)	DB6TSTAMP		DB6: Timestamp (Format: YYYYMMDDHHMMSS)	20110418
2	Importing	FMT_TSTAMP	Call by reference	☐	Type reference (TYPE)	CLIKE			20110418
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110418

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

Method CONVERT_PERCENTAGE_TO_INT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	INT	Value transfer	☐	Type reference (TYPE)	I			20130304
2	Importing	PERCENTAGE	Call by reference	☐	Type reference (TYPE)	STRING			20130304

Method CONVERT_PERCENTAGE_TO_INT on class CL_SYB_DBMS_UTILS has no exception.

Method CONVERT_SIZESTR_TO_MB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	MB	Value transfer	☐	Type reference (TYPE)	I			20130108
2	Importing	SIZESTR	Call by reference	☐	Type reference (TYPE)	STRING			20130108

Method CONVERT_SIZESTR_TO_MB on class CL_SYB_DBMS_UTILS has no exception.

Method DESCRIBE_QUERY_BIND_PARAMS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DBNAME	Call by reference	☐	Type reference (TYPE)	SYBDBNAME		SYB: DB Name	20120110
2	Returning	PARAMS	Value transfer	☐	Type reference (TYPE)	DBAXPLBINDPARAM_TAB		DBA Explain: Table of DBAXPLBINDPARAM	20120110
3	Importing	STMT	Call by reference	☐	Type reference (TYPE)	STRING			20120110
4	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20120110
5	Importing	USER	Call by reference	☐	Type reference (TYPE)	SYBOBJOWNER		SYB: Object Owner (Index, Table, DB, Partition, ...)	20120110

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20120110
2	CX_DBA_XML_ERROR	☐	DBA Cockpit: XML parser error	20120110

Method DETERMINE_APPL_DATABASE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	APPL_DB	Value transfer	☐	Type reference (TYPE)	SYBDBNAME		SYB: DB Name	20131031
2	Importing	IT_DATABASES	Call by reference	☐	Type reference (TYPE)	DBAIKEYVAL_TAB		DBA: Table of DBAIKEYVAL	20131031

Method DETERMINE_APPL_DATABASE on class CL_SYB_DBMS_UTILS has no exception.

Method EXEC_DBCC_CMD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COMMAND	Call by reference	☐	Type reference (TYPE)	CLIKE			20110615
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	DB6_STRING_TAB		DBA: Simple List of Strings	20110615
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110615

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

Method GET_ASE_OPSYS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	DB_OPSYS	Value transfer	☐	Type reference (TYPE)	SYOPSYS		Operating System of Application Server	20110812
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110812

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

Method GET_BKUP_CONFIG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	BKUPCONFIG	Value transfer	☐	Type reference (TYPE)	DBAIKEYVAL_TAB		DBA: Table of DBAIKEYVAL	20130423
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20130423

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

Method GET_CURRENT_DB6TSTAMP Signature

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

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

Method GET_CURRENT_DB6TSTAMP_UTC Signature

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

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

Method GET_DB_SERVERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ONLY_BKUP_SERVERS	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE	Select only Backup Servers	20130423
2	Returning	SERVERS	Value transfer	☐	Type reference (TYPE)	DBAKEYVAL_TAB		DBA: Table of DBAKEYVAL	20130423
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20130423

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

Method GET_MISSING_INDEXSTATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DBNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20121018
2	Returning	MISSING_STATS	Value transfer	☐	Type reference (TYPE)	SYBMON_TABLE_STATS_TAB		SYB: Table of SYBMON_TABLE_STATS	20121018
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20121018
4	Importing	TABNAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20121018
5	Importing	TABOWNER	Call by reference	☑	Type reference (TYPE)	CLIKE			20121018
6	Importing	TOP_N	Call by reference	☐	Type reference (TYPE)	I	0		20121018

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

Method GET_OPTSTATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	COLSTATS	Call by reference	☐	Type reference (TYPE)	SYB_COLSTATS_TAB		SYB: Table of SYB_COLSTATS	20110411
2	Importing	DBNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20110411
3	Exporting	GROUPSTATS	Call by reference	☐	Type reference (TYPE)	SYB_COLSTATS_TAB		SYB: Table of SYB_COLSTATS	20110427
4	Exporting	INDSTATS	Call by reference	☐	Type reference (TYPE)	SYB_INDSTATS_TAB		SYB: Table of SYB_INDSTATS	20110429
5	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110411
6	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20110411
7	Importing	TABOWNER	Call by reference	☐	Type reference (TYPE)	CLIKE			20110411
8	Exporting	TABSTATS	Call by reference	☐	Type reference (TYPE)	SYB_TABSTATS		SYB: Table level statistics	20110428

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20110415
2	CX_DBA_XML_ERROR	☐	DBA Cockpit: XML parser error	20110415

Method GET_SERVER_CONFIG_PARAM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	PARAM	Call by reference	☐	Type reference (TYPE)	CLIKE			20110627
2	Returning	PARAM_CFG	Value transfer	☐	Type reference (TYPE)	SYBCFG_SERVER		SYB: server configuration	20110627
3	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110627

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

Method GET_WAITEVENTINFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	FORCE_EN	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20110810
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110810
3	Returning	WAITEVENTINFO	Value transfer	☐	Type reference (TYPE)	SYBMON_WAITEVENTINFO_TAB		SYB: Table of SYBMON_WAITEVENTINFO	20110810

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

Method IS_VALID_PATH_NAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	IS_VALID	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20120119
2	Importing	OPSYS	Call by reference	☐	Type reference (TYPE)	SYOPSYS		Operating System of Application Server	20120119
3	Importing	PATH	Call by reference	☐	Type reference (TYPE)	STRING			20120119

Method IS_VALID_PATH_NAME on class CL_SYB_DBMS_UTILS has no exception.

Method KILL_SPID Signature

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

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

Method PARSE_OPTSTATS_COLSTATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	COLSTATS_NODE	Call by reference	☐	Object reference (TYPE REF TO)	IF_IXML_NODE		IF_IXML_NODE	20110418
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110418
3	Returning	WA_COLSTATS	Value transfer	☐	Type reference (TYPE)	SYB_COLSTATS		SYB: Column statistics (density and histogram)	20110418

Method PARSE_OPTSTATS_COLSTATS on class CL_SYB_DBMS_UTILS has no exception.

Method PARSE_OPTSTATS_INDSTATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	INDSTATS_NODE	Call by reference	☐	Object reference (TYPE REF TO)	IF_IXML_NODE		IF_IXML_NODE	20110429
2	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110429
3	Returning	WA_INDSTATS	Value transfer	☐	Type reference (TYPE)	SYB_INDSTATS		SYB: Index level statistics	20110429

Method PARSE_OPTSTATS_INDSTATS on class CL_SYB_DBMS_UTILS has no exception.

Method PARSE_OPTSTATS_TABSTATS 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	20110428
2	Importing	TABSTATS_NODE	Call by reference	☐	Object reference (TYPE REF TO)	IF_IXML_NODE		IF_IXML_NODE	20110428
3	Returning	WA_TABSTATS	Value transfer	☐	Type reference (TYPE)	SYB_TABSTATS			20110428

Method PARSE_OPTSTATS_TABSTATS on class CL_SYB_DBMS_UTILS has no exception.

Method REORG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DBNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100809
2	Importing	MAX_MIN	Call by reference	☐	Type reference (TYPE)	I	0		20100809
3	Importing	PARTITION	Call by reference	☑	Type reference (TYPE)	CLIKE			20100809
4	Importing	REORG_TYPE	Call by reference	☐	Type reference (TYPE)	I			20100809
5	Importing	RESUME	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20100809
6	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100809
7	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100809
8	Importing	TABOWNER	Call by reference	☐	Type reference (TYPE)	CLIKE			20100809

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

Method RESOLVE_CACHED_STMT_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	CONDENSE_TEXT	Call by reference	☐	Type reference (TYPE)	ABAP_BOOL	ABAP_FALSE		20131129
2	Importing	SSQLID	Call by reference	☐	Type reference (TYPE)	SYBMON_CACHEDSTMT-SSQLID		SYB: Big Integer	20110214
3	Returning	STMT_TEXT	Value transfer	☐	Type reference (TYPE)	STRING			20110214
4	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20110214

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

Method UPDATE_STATISTICS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DBNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100809
2	Importing	INDEXNAME	Call by reference	☑	Type reference (TYPE)	CLIKE			20100809
3	Importing	MODE	Call by reference	☐	Type reference (TYPE)	I			20100809
4	Importing	NO_CONSUMERS	Call by reference	☐	Type reference (TYPE)	I	0		20100809
5	Importing	NO_VALUES	Call by reference	☐	Type reference (TYPE)	I	0		20100809
6	Importing	PARTITION	Call by reference	☑	Type reference (TYPE)	CLIKE			20100809
7	Importing	SAMPLING_RATE	Call by reference	☐	Type reference (TYPE)	I	0		20100809
8	Importing	SYS_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20100809
9	Importing	TABNAME	Call by reference	☐	Type reference (TYPE)	CLIKE			20100809
10	Importing	TABOWNER	Call by reference	☐	Type reference (TYPE)	CLIKE			20100809

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

History

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