SAP ABAP Class CL_SQLM_SNAPSHOT_SVC (Service for Snapshots)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DWB-TOO-RTA (Application Component) Runtime Analysis
     ⤷ SQLM_ADMIN (Package) SQL Monitor: Administration

Properties

Class	CL_SQLM_SNAPSHOT_SVC
Short Description	Service for Snapshots
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SQLM_ADMIN	SQL Monitor: Administration
Created	20130729	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_SQLM_SNAPSHOT_SVC has no forward declaration.

Interfaces

Class CL_SQLM_SNAPSHOT_SVC has no interface implemented.

Friends

Class CL_SQLM_SNAPSHOT_SVC has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	INJECTED_PACKAGE_PROVIDER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	LIF_SQLM_RAW_DATA_PROVIDER			20130802
2	SNAPSHOT_PROVIDER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	LIF_SNAPSHOT_PROVIDER			20130730
3	SQLM_ADMIN	Instance attribute	Private	☐	Object reference (TYPE REF TO)	LIF_SQLM_ADMIN			20130730

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	COMPUTE_ALIASNAME	Static method	Private	Method		20130731
2	CONVERT_RAW_DATA_TO_SNP_FORMAT	Instance method	Private	Method		20130731
3	CONVERT_REQ_DATA_TO_SNP_FORMAT	Instance method	Private	Method		20130816
4	CONVERT_TIMESTAMP	Instance method	Private	Method		20130731
5	CONVERT_VIEW_DATA_TO_TABLES	Instance method	Private	Method		20130731
6	CRC64	Static method	Private	Method		20130731
7	CREATE_INSTANCE	Static method	Public	Method		20130730
8	CREATE_SNAPSHOT	Instance method	Public	Method		20130730
9	CREATE_SNAPSHOT_ADMIN	Instance method	Private	Method		20130731
10	DELETE_SNAPSHOTS	Instance method	Public	Method		20130730
11	FETCH_DATA_FROM_PROVIDER	Instance method	Private	Method		20130731
12	GET_AVAILABLE_SNAPSHOTS	Instance method	Public	Method		20130730
13	GET_FULL_DESCRIPTION	Instance method	Private	Method		20130802
14	GET_RAW_DATA_PROVIDER	Instance method	Private	Method		20130731
15	GET_SNAPSHOT_INFO_FROM_ID	Instance method	Public	Method		20130802
16	GET_SNAPSHOT_RANGE	Instance method	Private	Method		20130731

Events

Class CL_SQLM_SNAPSHOT_SVC has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	N10	Private	See coding			20130731	n10 type n length 10
2	TY_RECORDS	Public	See coding			20130913	ty_records type standard table of sqlmhcvditm with default key
3	TY_REQUEST_DATA	Public	See coding			20130816	ty_request_data type standard table of sqlmsq with non-unique key snapshotid roottype rootname
4	TY_SNAPSHOTRANGE	Public	See coding			20130731	ty_snapshotrange type range of sqlmsnapshotid
5	TY_SNAPSHOTS	Public	See coding			20130730	ty_snapshots type standard table of sqlmsa with default key
6	TY_SNAPSHOT_IDS	Public	See coding			20130730	ty_snapshot_ids type standard table of sqlmsa-snapshotid
7	TY_SNP_DATASET	Public	See coding			20130731	begin of ty_snp_dataset, sqlmst type standard table of sqlmst with non-unique key snapshotid tablename, sqlmsm type standard table of sqlmsm with non-unique key snapshotid tablename tablename0, sqlmshci type standard table of sqlmshci with non-unique key snapshotid progname progkind proctype procname procline hashcode, sqlmshcd type standard table of sqlmshcd with non-unique key snapshotid progname progkind proctype procname procline hashcode runlevel roottype rootname stmtkind tablename, end of ty_snp_dataset
8	TY_VIEWDATA	Private	See coding			20130731	ty_viewdata type standard table of sqlmshcvditm

Method Signatures

Method COMPUTE_ALIASNAME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	ALIASNAME	Value transfer	☐	Type reference (TYPE)	SQLMTABLENAME			20130731
2	Importing	TABLENAMES	Call by reference	☐	Type reference (TYPE)	SQLMTABLENAMES			20130731

Method COMPUTE_ALIASNAME on class CL_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	Importing	I_RAW_DATA	Call by reference	☐	Type reference (TYPE)	CL_SQLM_SNAPSHOT_SVC=>TY_RECORDS			20130731
2	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SQLMSNAPSHOTID			20130731
3	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	TY_SNP_DATASET			20130731

Method CONVERT_RAW_DATA_TO_SNP_FORMAT on class CL_SQLM_SNAPSHOT_SVC has no exception.

Method CONVERT_REQ_DATA_TO_SNP_FORMAT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	RECORDS	Call by reference	☐	Type reference (TYPE)	SQLMREQRECORDS			20130816
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	TY_REQUEST_DATA			20130816
3	Importing	SNAPSHOTID	Call by reference	☐	Type reference (TYPE)	SQLMSNAPSHOTID			20130816

Method CONVERT_REQ_DATA_TO_SNP_FORMAT on class CL_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			20130731
2	Returning	R_TIMESTAMP_SHORT	Value transfer	☐	Type reference (TYPE)	TIMESTAMP			20130731

Method CONVERT_TIMESTAMP on class CL_SQLM_SNAPSHOT_SVC has no exception.

Method CONVERT_VIEW_DATA_TO_TABLES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_VIEWDATATAB	Call by reference	☐	Type reference (TYPE)	TY_VIEWDATA			20130731
2	Returning	R_RESULT	Value transfer	☐	Type reference (TYPE)	CL_SQLM_SNAPSHOT_SVC=>TY_SNP_DATASET			20130731

Method CONVERT_VIEW_DATA_TO_TABLES on class CL_SQLM_SNAPSHOT_SVC has no exception.

Method CRC64 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CRC64	Value transfer	☐	Type reference (TYPE)	N10			20130731
2	Importing	TABLENAME	Call by reference	☐	Type reference (TYPE)	SQLMTABLENAMES			20130731

Method CRC64 on class CL_SQLM_SNAPSHOT_SVC has no exception.

Method CREATE_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	INSTANCE	Value transfer	☐	Object reference (TYPE REF TO)	CL_SQLM_SNAPSHOT_SVC			20130730

Method CREATE_INSTANCE on class CL_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)	SQLMSNAPSHOTDESC			20130730
2	Importing	I_DEVCLASSES	Call by reference	☑	Type reference (TYPE)	SQLMDEVCLASSESRANGE			20130730
3	Importing	I_FILE_HEADER	Call by reference	☑	Type reference (TYPE)	CL_SQLM_IO_SVC=>TYP_STR_EXPORT_HEADER_1_1			20130730
4	Importing	I_OBJNAMES	Call by reference	☑	Type reference (TYPE)	SQLMOBJNAMESRANGE			20130730
5	Importing	I_OBJTYPES	Call by reference	☑	Type reference (TYPE)	SQLMOBJTYPESRANGE			20130730
6	Importing	I_TOP_STMT_NR	Call by reference	☑	Type reference (TYPE)	I			20130730
7	Importing	I_TOP_STMT_ORDER	Call by reference	☑	Type reference (TYPE)	CHAR1			20130730
8	Importing	I_ZIP_OBJ	Call by reference	☑	Object reference (TYPE REF TO)	CL_ABAP_ZIP			20130730
9	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SQLMSNAPSHOTID			20130730

#	Exception	Resumable	Description	Created on
1	CX_SQLM_FAILURE	☐		20130730

Method CREATE_SNAPSHOT_ADMIN 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)	SQLMSNAPSHOTDESC			20130731
2	Importing	I_EXPORTEDAT	Call by reference	☐	Type reference (TYPE)	TIMESTAMPL			20130731
3	Importing	I_EXPORTEDBY	Call by reference	☐	Type reference (TYPE)	SY-UNAME			20130731
4	Importing	I_NO_EXPORT_INFO	Call by reference	☐	Type reference (TYPE)	BOOLE_D			20130802
5	Importing	I_ORIGINSYS	Call by reference	☐	Type reference (TYPE)	SYSYSID			20130731
6	Importing	I_RECORDCNT	Call by reference	☐	Type reference (TYPE)	SQLMSA-RECORDCNT			20130802
7	Importing	I_SNAPSHOTID	Call by reference	☐	Type reference (TYPE)	SQLMSA-SNAPSHOTID			20130731
8	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SQLMSA			20130731

Method CREATE_SNAPSHOT_ADMIN on class CL_SQLM_SNAPSHOT_SVC has no exception.

Method DELETE_SNAPSHOTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	SNAPSHOTS	Call by reference	☐	Type reference (TYPE)	TY_SNAPSHOT_IDS			20130730

#	Exception	Resumable	Description	Created on
1	CX_SQLM_FAILURE	☐		20130730

Method FETCH_DATA_FROM_PROVIDER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_RAW_DATA_PROVIDER	Call by reference	☐	Object reference (TYPE REF TO)	LIF_SQLM_RAW_DATA_PROVIDER			20130731
2	Importing	I_SNAPSHOT_ID	Call by reference	☐	Type reference (TYPE)	SQLMSNAPSHOTID			20130731
3	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SQLMSA-RECORDCNT			20130802

#	Exception	Resumable	Description	Created on
1	CX_SQLM_FAILURE	☐		20130731

Method GET_AVAILABLE_SNAPSHOTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SNAPSHOTS	Value transfer	☐	Type reference (TYPE)	TY_SNAPSHOTS			20130730

#	Exception	Resumable	Description	Created on
1	CX_SQLM_FAILURE	☐		20130730

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)	SQLMSA-DESCRIPTION			20130802
2	Importing	I_SYSTEM_ID	Call by reference	☐	Type reference (TYPE)	SYSYSID			20130802
3	Importing	I_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	TIMESTAMP			20130802
4	Returning	R_FULL_DESCRIPTION	Value transfer	☐	Type reference (TYPE)	SQLMSA-DESCRIPTION			20130802

Method GET_FULL_DESCRIPTION on class CL_SQLM_SNAPSHOT_SVC has no exception.

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			20130731
2	Importing	I_FILE_HEADER	Call by reference	☑	Type reference (TYPE)	CL_SQLM_IO_SVC=>TYP_STR_EXPORT_HEADER_1_1			20130731
3	Importing	I_OBJNAMES	Call by reference	☑	Type reference (TYPE)	SQLMOBJNAMESRANGE			20130731
4	Importing	I_OBJTYPES	Call by reference	☑	Type reference (TYPE)	SQLMOBJTYPESRANGE			20130731
5	Importing	I_TOP_STMT_NR	Call by reference	☑	Type reference (TYPE)	I			20130731
6	Importing	I_TOP_STMT_ORDER	Call by reference	☑	Type reference (TYPE)	CHAR1			20130731
7	Importing	I_ZIP_OBJ	Call by reference	☑	Object reference (TYPE REF TO)	CL_ABAP_ZIP			20130731
8	Returning	R_PACKAGE_PROVIDER	Value transfer	☐	Object reference (TYPE REF TO)	LIF_SQLM_RAW_DATA_PROVIDER			20130731

#	Exception	Resumable	Description	Created on
1	CX_SQLM_FAILURE	☐		20130731

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)	SQLMSNAPSHOTID			20130802
2	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	SQLMSA			20130802

#	Exception	Resumable	Description	Created on
1	CX_SQLM_FAILURE	☐		20130802

Method GET_SNAPSHOT_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RESULT	Value transfer	☐	Type reference (TYPE)	TY_SNAPSHOTRANGE			20130731
2	Importing	SNAPSHOTS	Call by reference	☐	Type reference (TYPE)	TY_SNAPSHOT_IDS			20130731

Method GET_SNAPSHOT_RANGE on class CL_SQLM_SNAPSHOT_SVC has no exception.

History

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