SAP ABAP Class CL_DBA_ALERTING_EXTRACTOR (DBA: Alert Extractor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB6-CCM (Application Component) CCMS / Database Monitors for DB2 Universal Database
     ⤷ SDBA_ALERT_E2E (Package) DBA Cockpit: Alerting E2E

Meta Relationship - Used By

#	Relationship type	Used by	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_DB4_ALERTING_EXTRACTOR	DB4: Alert Extractor	20121015
2	Inheritance (c INHERITING FROM c_ref)	CL_DB6_ALERTING_EXTRACTOR	DB6: Alert Extractor	20120717
3	Inheritance (c INHERITING FROM c_ref)	CL_HDB_ALERTING_EXTRACTOR	DB6: Alert Extractor	20120717
4	Inheritance (c INHERITING FROM c_ref)	CL_MSS_ALERTING_EXTRACTOR	MSS: Alert Extractor	20130522
5	Inheritance (c INHERITING FROM c_ref)	CL_SYB_ALERTING_EXTRACTOR	DB6: Alert Extractor	20120717

Properties

Class	CL_DBA_ALERTING_EXTRACTOR
Short Description	DBA: Alert Extractor
Super Class
Instantiability of a Class	2	Public
Final	☐

General Data

Message Class
Program status
Category	0
Package	SDBA_ALERT_E2E	DBA Cockpit: Alerting E2E
Created	20120717	SAP
Last change	20140121	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_DBA_ALERTING_EXTRACTOR has no forward declaration.

Interfaces

Class CL_DBA_ALERTING_EXTRACTOR has no interface implemented.

Friends

Class CL_DBA_ALERTING_EXTRACTOR has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ALERT_DEFINITION	Instance attribute	Protected	☐	Object reference (TYPE REF TO)	CL_DBA_ALERTING		DBA: Back-end Alerting	20120717
2	CO_EXIT_METHOD_CALL	Constant	Public	☐	Type reference (TYPE)	STRING	'EXIT_METHOD_CALL'		20120727
3	E_GRANULARITY	Constant	Public	☐	See coding				20130122
4	E_PARAM	Constant	Public	☐	See coding				20120910
5	E_TIME	Constant	Public	☐	See coding				20120910
6	MT_LAST_METRIC	Instance attribute	Protected	☐	Type reference (TYPE)	DBA_ALERT_METRICS		DBA: Database Alert Metrics	20120717

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CALCULATE_TIME_AND_RANGE	Instance method	Public	Method		20120717
2	COLLECT_ALERTS	Instance method	Public	Method		20120717
3	CONSTRUCTOR	Instance method	Public	Constructor		20120717
4	CREATE_ERROR_FOR_QUERIES	Instance method	Private	Method	Create Error For Queries	20120717
5	CREATE_ERROR_FOR_QUERY	Instance method	Private	Method	Create Error for Query	20120717
6	EXTRACT_MAPPING	Instance method	Protected	Method		20121009
7	GET_DATA_FROM_BACKEND	Instance method	Protected	Method		20121017
8	GET_DDIC_OBJECTS_MISSING_IN_DB	Instance method	Public	Method		20130220
9	GET_LAST_VALUE_FOR	Instance method	Public	Method		20120717
10	GET_METRICS	Instance method	Public	Method		20120717
11	INIT_QUERY_CALLS	Instance method	Protected	Method		20120717
12	MAP_BACKWARD	Instance method	Private	Method		20120717
13	PREPARE_MAPPING	Instance method	Private	Method		20120717
14	SET_QUERY_HISTORY	Instance method	Private	Method		20120717

Events

Class CL_DBA_ALERTING_EXTRACTOR has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	MS_MAPPING	Protected	See coding			20121015	begin of ms_mapping, e2e_field type string, backend_field type string, end of ms_mapping
2	MS_QUERY_CALL	Protected	See coding			20121015	begin of ms_query_call, ddic_structure type string, time_range type string, mapping type string, evaluate_value type boolean, top_n type i, order_by type string, aggregation type string, granularity type string, call_id_list type dba_alert_rdi_query_tab, end of ms_query_call
3	MT_MAPPINGS	Protected	See coding			20121015	mt_mappings type hashed table of ms_mapping with unique key e2e_field
4	MT_QUERY_CALLS	Protected	See coding			20121015	mt_query_calls type sorted table of ms_query_call with non-unique key ddic_structure time_range mapping

Method Signatures

Method CALCULATE_TIME_AND_RANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_FROM	Call by reference	☐	Type reference (TYPE)	DB6TSTAMP_STRUCT		DB6: Date/Time Timestamp	20120717
2	Exporting	ES_TO	Call by reference	☐	Type reference (TYPE)	DB6TSTAMP_STRUCT		DB6: Date/Time Timestamp	20120717
3	Exporting	EV_RANGETYPE	Call by reference	☐	Type reference (TYPE)	I			20120717
4	Importing	IR_SYS	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20120717
5	Importing	IV_TIME_FRAME	Call by reference	☐	Type reference (TYPE)	STRING			20120717

Method CALCULATE_TIME_AND_RANGE on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method COLLECT_ALERTS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DDIC	Call by reference	☐	Type reference (TYPE)	STRING			20120717
2	Importing	FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20120717
3	Exporting	RET	Call by reference	☐	Type reference (TYPE)	P			20120717

Method COLLECT_ALERTS on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ALERT_DEFINITION	Call by reference	☐	Object reference (TYPE REF TO)	CL_DBA_ALERTING		DBA: Back-end Alerting	20120717

Method CONSTRUCTOR on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method CREATE_ERROR_FOR_QUERIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_METRICS	Call by reference	☐	Type reference (TYPE)	DBA_ALERT_METRICS		DBA: Database Alert Metrics	20120717
2	Importing	I_ERROR_MSG	Call by reference	☐	Type reference (TYPE)	STRING			20120717
3	Importing	I_ERROR_STATUS	Call by reference	☐	Type reference (TYPE)	I			20120717
4	Importing	I_QUERY_CALL	Call by reference	☐	Type reference (TYPE)	MS_QUERY_CALL			20120717

Method CREATE_ERROR_FOR_QUERIES on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method CREATE_ERROR_FOR_QUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_METRICS	Call by reference	☐	Type reference (TYPE)	DBA_ALERT_METRICS		DBA: Database Alert Metrics	20120717
2	Importing	I_ERROR_MSG	Call by reference	☐	Type reference (TYPE)	STRING			20120717
3	Importing	I_ERROR_STATUS	Call by reference	☐	Type reference (TYPE)	I			20120717
4	Importing	I_METRIC	Call by reference	☑	Type reference (TYPE)	DBA_ALERT_METRIC		DBA: Database Alert Metric	20120717
5	Importing	I_QUERY	Call by reference	☐	Type reference (TYPE)	DBA_ALERT_RDI_QUERY		DBA-RDI: Generic Alert Query for RDI	20120717

Method CREATE_ERROR_FOR_QUERY on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method EXTRACT_MAPPING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MAPPING	Call by reference	☐	Type reference (TYPE)	STRING			20121009
2	Returning	RT_MAPPING	Value transfer	☐	Type reference (TYPE)	MT_MAPPINGS			20121009

Method EXTRACT_MAPPING on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method GET_DATA_FROM_BACKEND Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ER_DATA	Call by reference	☐	Object reference (TYPE REF TO)	DATA			20121017
2	Importing	IR_SYS	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20121017
3	Importing	IS_QUERY_CALL	Call by reference	☐	Type reference (TYPE)	MS_QUERY_CALL			20121017
4	Importing	IT_MAPPING	Call by reference	☐	Type reference (TYPE)	MT_MAPPINGS			20121017

#	Exception	Resumable	Description	Created on
1	CX_DBA_ADBC	☐	DBA Cockpit: ADBC Errors	20121017
2	CX_DBA_RDI	☐	DBA-RDI: General Back-end Error	20121017
3	CX_DBA_ROOT	☐	DBA Cockpit: Root exception class	20121017

Method GET_DDIC_OBJECTS_MISSING_IN_DB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RV_RESULT	Value transfer	☐	Type reference (TYPE)	STRING			20130220

Method GET_DDIC_OBJECTS_MISSING_IN_DB on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method GET_LAST_VALUE_FOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_TABLE	Call by reference	☐	Type reference (TYPE)	DATA			20120717
2	Importing	IV_DDIC_FIELD	Call by reference	☐	Type reference (TYPE)	STRING			20120717
3	Importing	IV_DDIC_STRUCTURE	Call by reference	☐	Type reference (TYPE)	STRING			20120717
4	Importing	IV_MAPPING	Call by reference	☑	Type reference (TYPE)	STRING			20120717
5	Importing	IV_TIME_RANGE	Call by reference	☐	Type reference (TYPE)	STRING			20120717

Method GET_LAST_VALUE_FOR on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method GET_METRICS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_METRIC_REQUESTS	Call by reference	☐	Type reference (TYPE)	DBA_ALERT_RDI_QUERY_TAB		DBA-RDI: Generic Alert Query for RDI	20120717
2	Returning	R_METRICS	Value transfer	☐	Type reference (TYPE)	DBA_ALERT_METRICS		DBA: Database Alert Metrics	20120717

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

Method INIT_QUERY_CALLS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	METRIC_REQUESTS	Call by reference	☐	Type reference (TYPE)	DBA_ALERT_RDI_QUERY_TAB		DBA-RDI: Generic Alert Query for RDI	20120717
2	Exporting	QUERY_CALLS	Call by reference	☐	Type reference (TYPE)	MT_QUERY_CALLS			20120717

Method INIT_QUERY_CALLS on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method MAP_BACKWARD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	DATA	Call by reference	☐	Type reference (TYPE)	DATA			20120717
2	Importing	MAPPINGS	Call by reference	☐	Type reference (TYPE)	MT_MAPPINGS			20120717
3	Changing	METRICS	Call by reference	☐	Type reference (TYPE)	DBA_ALERT_METRICS		DBA: Database Alert Metrics	20120717
4	Importing	QUERY_CALL	Call by reference	☐	Type reference (TYPE)	MS_QUERY_CALL			20120717

Method MAP_BACKWARD on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method PREPARE_MAPPING Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	MAPPINGS	Call by reference	☐	Type reference (TYPE)	MT_MAPPINGS			20120717
2	Importing	QUERY_CALL	Call by reference	☐	Type reference (TYPE)	MS_QUERY_CALL			20120717

Method PREPARE_MAPPING on class CL_DBA_ALERTING_EXTRACTOR has no exception.

Method SET_QUERY_HISTORY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IR_SYS	Call by reference	☐	Object reference (TYPE REF TO)	CL_DB6_SYS		DB6: Remote System Administration	20120717
2	Changing	LR_RDI	Call by reference	☐	Object reference (TYPE REF TO)	CL_DBA_RDI		DBA-RDI-DBH: Back-end Facade	20120717
3	Importing	TIME_FRAME	Call by reference	☐	Type reference (TYPE)	STRING			20120717

Method SET_QUERY_HISTORY on class CL_DBA_ALERTING_EXTRACTOR has no exception.

History

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