SAP ABAP Class CL_SWLT_SQLM_SNAPSHOT_SVC (Snapshot services)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO (Application Component) Workbench Tools: Editors, Painters, Modelers
     ⤷ SWLT (Package) SQL Performance Tuning Worklist

Properties

Class	CL_SWLT_SQLM_SNAPSHOT_SVC
Short Description	Snapshot services
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	SWLT	SQL Performance Tuning Worklist
Created	20121129	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_SWLT_SQLM_SNAPSHOT_SVC has no forward declaration.

Interfaces

Class CL_SWLT_SQLM_SNAPSHOT_SVC has no interface implemented.

Friends

Class CL_SWLT_SQLM_SNAPSHOT_SVC has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	SWLT_SERVICE	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_SWLT_SERVICE			20130712

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_REMOTE_SQLM_AVAILABILITY	Static method	Private	Method		20130225
2	CLASS_CONSTRUCTOR	Static method	Public	Constructor		20130712
3	CONVERT_RAW_DATA_TO_SNP_FORMAT	Static method	Private	Method		20130221
4	CONVERT_TIMESTAMP	Static method	Private	Method		20130226
5	CREATE_HEADER	Static method	Private	Method		20121207
6	CREATE_SNAPSHOT	Static method	Public	Method		20121129
7	CREATE_SNAPSHOT_FROM_RAW_DATA	Static method	Public	Method		20130117
8	DELETE_SNAPSHOT	Static method	Public	Method		20121129
9	DELETE_SNAPSHOTS	Static method	Public	Method		20130625
10	DELETE_SNAPSHOTS_OLDER_THAN	Static method	Public	Method		20121207
11	GET_AVAILABLE_SNAPSHOTS	Static method	Public	Method		20130115
12	GET_FULL_DESCRIPTION	Static method	Private	Method		20130704
13	GET_NEWEST_SNAPSHOT_ID	Static method	Public	Method		20121129
14	GET_NEWEST_SNAPSHOT_INFO	Static method	Public	Method		20121213
15	GET_RAW_DATA_PROVIDER	Static method	Private	Method		20130228
16	GET_SNAPSHOT_INFO_FROM_ID	Static method	Public	Method		20130115
17	GET_SYSTEM_ID	Static method	Private	Method		20121207
18	GET_TABLE_NAMES_INVOLVED	Static method	Public	Method		20121218

Events

#	Event	Type	Visibility	Description	Created on
1	TOP_N_IGNORED	Static Event (1)	Public (2)		20130417

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TY_SNAPSHOTS_H	Public	See coding			20130115	ty_snapshots_h TYPE STANDARD TABLE OF swlt_sqlm_h WITH DEFAULT KEY
2	TY_S_SQLM_DATA	Private	Type reference (TYPE)	SWLT_SQLM_D		20121207
3	TY_S_SQLM_HEADER	Private	Type reference (TYPE)	SWLT_SQLM_H		20121207
4	TY_T_SQLM_DATA	Private	See coding			20121207	ty_t_sqlm_data TYPE STANDARD TABLE OF swlt_sqlm_d WITH DEFAULT KEY
5	TY_T_SQLM_HEADERS	Private	See coding			20121207	ty_t_sqlm_headers TYPE STANDARD TABLE OF swlt_sqlm_h WITH DEFAULT KEY

Method Signatures

Method CHECK_REMOTE_SQLM_AVAILABILITY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_RFC_DESTINATION	Call by reference	☐	Type reference (TYPE)	RFCDEST			20130225

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130225

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_SWLT_SQLM_SNAPSHOT_SVC has no parameter.
Method CLASS_CONSTRUCTOR on class CL_SWLT_SQLM_SNAPSHOT_SVC has no exception.

Method CONVERT_RAW_DATA_TO_SNP_FORMAT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	E_SQLM_DATA	Value transfer	☐	Type reference (TYPE)	TY_T_SQLM_DATA			20130221
2	Importing	I_RAW_DATA	Call by reference	☐	Type reference (TYPE)	SQLMRECORDS			20130221
3	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20130221

Method CONVERT_RAW_DATA_TO_SNP_FORMAT on class CL_SWLT_SQLM_SNAPSHOT_SVC has no exception.

Method CONVERT_TIMESTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TIMESTAMP_LONG	Call by reference	☐	Type reference (TYPE)	TIMESTAMPL			20130226
2	Returning	R_TIMESTAMP_SHORT	Value transfer	☐	Type reference (TYPE)	SWLT_D_CREATED_ON			20130226

Method CONVERT_TIMESTAMP on class CL_SWLT_SQLM_SNAPSHOT_SVC has no exception.

Method CREATE_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DESCRIPTION	Call by reference	☑	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_DESCR			20130419
2	Importing	I_FILE_HEADER	Call by reference	☑	Type reference (TYPE)	CL_SWLT_IO_SVC=>TYP_STR_EXPORT_HEADER_1_1			20130418
3	Importing	I_NR_OF_RECORDS	Call by reference	☐	Type reference (TYPE)	I			20130422
4	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SWLT_D_ID			20121207
5	Importing	I_SYSTEM_ID	Call by reference	☐	Type reference (TYPE)	SYSYSID			20121207

Method CREATE_HEADER on class CL_SWLT_SQLM_SNAPSHOT_SVC has no exception.

Method CREATE_SNAPSHOT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DESCRIPTION	Call by reference	☑	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_DESCR			20130419
2	Importing	I_DEVCLASSES	Call by reference	☑	Type reference (TYPE)	SQLMDEVCLASSESRANGE			20130222
3	Importing	I_FILE_HEADER	Call by reference	☑	Type reference (TYPE)	CL_SWLT_IO_SVC=>TYP_STR_EXPORT_HEADER_1_1			20130312
4	Importing	I_OBJNAMES	Call by reference	☑	Type reference (TYPE)	SQLMOBJNAMESRANGE			20130222
5	Importing	I_OBJTYPES	Call by reference	☑	Type reference (TYPE)	SQLMOBJTYPESRANGE			20130222
6	Importing	I_RFC_DESTINATION	Call by reference	☑	Type reference (TYPE)	RFCDEST			20121207
7	Importing	I_TOP_STMT_NR	Call by reference	☑	Type reference (TYPE)	I			20130222
8	Importing	I_TOP_STMT_ORDER	Call by reference	☑	Type reference (TYPE)	CHAR1			20130222
9	Importing	I_ZIP_OBJ	Call by reference	☑	Object reference (TYPE REF TO)	CL_ABAP_ZIP			20130312
10	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20121129

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130102

Method CREATE_SNAPSHOT_FROM_RAW_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_RAW_DATA	Call by reference	☐	Type reference (TYPE)	SQLMRECORDS			20130117
2	Importing	I_SYSTEM_ID	Call by reference	☐	Type reference (TYPE)	SYSYSID			20130117
3	Importing	I_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	TIMESTAMPL			20130419
4	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20130117

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130117

Method DELETE_SNAPSHOT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20121129

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Method DELETE_SNAPSHOTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SNAPSHOTS	Call by reference	☐	Type reference (TYPE)	SWLT_T_RTM_SNAPSHOT_IDS			20130625

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130625

Method DELETE_SNAPSHOTS_OLDER_THAN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	TIMESTAMPL			20121207
2	Returning	R_NUMBER_OF_DELETED_SNAPSHOTS	Value transfer	☐	Type reference (TYPE)	I			20130131

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Method GET_AVAILABLE_SNAPSHOTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ONLY_NEWEST_PER_SYSTEM	Call by reference	☑	Type reference (TYPE)	XFLAG			20130115
2	Returning	R_SNAPSHOTS	Value transfer	☐	Type reference (TYPE)	TY_SNAPSHOTS_H			20130115

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130708

Method GET_FULL_DESCRIPTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DESCR_WITH_VARS	Call by reference	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_DESCR			20130704
2	Importing	I_SYSTEM_ID	Call by reference	☐	Type reference (TYPE)	SYSYSID			20130704
3	Importing	I_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	TIMESTAMPL			20130704
4	Returning	R_FULL_DESCRIPTION	Value transfer	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_DESCR			20130704

Method GET_FULL_DESCRIPTION on class CL_SWLT_SQLM_SNAPSHOT_SVC has no exception.

Method GET_NEWEST_SNAPSHOT_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SYSTEM_ID	Call by reference	☑	Type reference (TYPE)	SYSYSID			20121129
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20121129

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Method GET_NEWEST_SNAPSHOT_INFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SYSTEM_ID	Value transfer	☐	Type reference (TYPE)	SYSYSID	'*'		20121213
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SWLT_SQLM_H			20121213

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Method GET_RAW_DATA_PROVIDER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DEVCLASSES	Call by reference	☑	Type reference (TYPE)	SQLMDEVCLASSESRANGE			20130228
2	Importing	I_FILE_HEADER	Call by reference	☑	Type reference (TYPE)	CL_SWLT_IO_SVC=>TYP_STR_EXPORT_HEADER_1_1			20130311
3	Importing	I_OBJNAMES	Call by reference	☑	Type reference (TYPE)	SQLMOBJNAMESRANGE			20130228
4	Importing	I_OBJTYPES	Call by reference	☑	Type reference (TYPE)	SQLMOBJTYPESRANGE			20130228
5	Importing	I_RFC_DESTINATION	Call by reference	☑	Type reference (TYPE)	RFCDEST			20130228
6	Importing	I_TOP_STMT_NR	Call by reference	☑	Type reference (TYPE)	I			20130228
7	Importing	I_TOP_STMT_ORDER	Call by reference	☑	Type reference (TYPE)	CHAR1			20130228
8	Importing	I_ZIP_OBJ	Call by reference	☑	Object reference (TYPE REF TO)	CL_ABAP_ZIP			20130311
9	Returning	R_PACKAGE_PROVIDER	Value transfer	☐	Object reference (TYPE REF TO)	LIF_SQLM_RAW_DATA_PROVIDER			20130228

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130228

Method GET_SNAPSHOT_INFO_FROM_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20130115
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SWLT_SQLM_H			20130115

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130708

Method GET_SYSTEM_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_RFC_DESTINATION	Call by reference	☐	Type reference (TYPE)	RFCDEST			20121207
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SYSYSID			20121207

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130102

Method GET_TABLE_NAMES_INVOLVED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SWLT_D_RTM_SNAPSHOT_ID			20121218
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SWLT_T_TABLE_NAMES			20121218

#	Exception	Resumable	Description	Created on
1	CX_SWLT_FAILURE	☐		20130103

Event Signatures

Event TOP_N_IGNORED Signature
Event TOP_N_IGNORED on class CL_SWLT_SQLM_SNAPSHOT_SVC has no parameter.

History

Last changed by/on	SAP	20140121
SAP Release Created in	740