SAP ABAP Class CL_DB6_DBH_PKG_CACHE (DB6-DBH: WLM Threshold Violations)
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)
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Inheritance (c INHERITING FROM c_ref)  CL_DB6_DBH_COLLECTOR DB6-DBH: Extractor 20100304
Properties
Class CL_DB6_DBH_PKG_CACHE  
Short Description DB6-DBH: WLM Threshold Violations    
Super Class CL_DB6_DBH_COLLECTOR DB6-DBH: Extractor 
Instantiability of a Class 2  Public 
Final    
General Data
Message Class    
Program status     
Category 0   
Package STU6   DB6: Performance-Monitor (UNIX/Windows) 
Created 20090325   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_DB6_DBH_PKG_CACHE has no forward declaration.
Interfaces
Class CL_DB6_DBH_PKG_CACHE has no interface implemented.
Friends
Class CL_DB6_DBH_PKG_CACHE has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 ALL_METRICS_OPTION_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20110126
2 CO_ALL_METRICS_OPTION Instance attribute Public Type reference (TYPE) I 3 20110126
3 CO_EXPLAIN_OPTION Instance attribute Public Type reference (TYPE) I 1 20100409
4 CO_GROUP_SIMILAR_STMTS_OPTION Instance attribute Public Type reference (TYPE) I 2 20100409
5 EXPLAIN_OPTION_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100409
6 GROUP_SIMILAR_OPTION_KEY Instance attribute Private Type reference (TYPE) DBA_DBH_VALUE DBA-DBH: Key/Value for Configuration Table 20100409
Methods
# Method Level Visibility Method type Description Created on
1 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20090325
2 GEN_ADD_STMT_HASH_VALUE Instance method Private Method 20110119
3 GEN_ADJUST_UNMODIFIED_SNAPDATA Instance method Private Method cleanup old snapshot data 20100408
4 GEN_CLEANUP_SNAPSHOT_DATA Instance method Private Method cleanup old snapshot data 20100331
5 GEN_CLEANUP_STAGING_DATA Instance method Private Method cleanup old snapshot data 20110331
6 GEN_COLLECT_SECTION_METRICS Instance method Private Method 20100330
7 GEN_GET_SECTION_EXPLAIN Instance method Private Method cleanup old snapshot data 20100409
8 GEN_GET_STMT_AND_SECTION_DET Instance method Private Method 20100331
9 GEN_RANK_AND_STAGE_TOPN Instance method Private Method 20100331
10 GEN_SET_REMOVAL_TIME_RANGE Instance method Private Method cleanup old snapshot data 20100408
11 GET_ACTIVE_DETAIL_LEVEL Instance method Private Method 20100409
12 GET_RANKED_METRICS Instance method Private Method 20100226
Events
Class CL_DB6_DBH_PKG_CACHE has no event.
Types
Class CL_DB6_DBH_PKG_CACHE 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 BI_SERVER Call by reference Type reference (TYPE) DBA_DBH_BI_SERVER DBA-DBH: BI Server 20090325
2 Importing CONFIGSTRING Call by reference Type reference (TYPE) DBA_DBH_CONFIG_STRING DBA-DBH: Configuration String 20090325
3 Importing DBCNAME Call by reference Type reference (TYPE) DBCON_NAME Logical name for a database connection 20090325
4 Importing PREFIX Call by reference Type reference (TYPE) DB6_DBH_ROUTINE_NAME DB6-DBH: Prefix 20090325
# Exception Resumable Description Created on
1 CX_DBA_DBH_SETUP DBA-DBH: Setup Corrupted 20090325

Method GEN_ADD_STMT_HASH_VALUE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20110119

Method GEN_ADD_STMT_HASH_VALUE on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_ADJUST_UNMODIFIED_SNAPDATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100408

Method GEN_ADJUST_UNMODIFIED_SNAPDATA on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_CLEANUP_SNAPSHOT_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100331

Method GEN_CLEANUP_SNAPSHOT_DATA on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_CLEANUP_STAGING_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20110331

Method GEN_CLEANUP_STAGING_DATA on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_COLLECT_SECTION_METRICS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100330

Method GEN_COLLECT_SECTION_METRICS on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_GET_SECTION_EXPLAIN Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100409

Method GEN_GET_SECTION_EXPLAIN on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_GET_STMT_AND_SECTION_DET Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100331

Method GEN_GET_STMT_AND_SECTION_DET on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_RANK_AND_STAGE_TOPN Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100331

Method GEN_RANK_AND_STAGE_TOPN on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GEN_SET_REMOVAL_TIME_RANGE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing SP Call by reference Object reference (TYPE REF TO) CL_DB6_DBH_STORED_PROCEDURE DB6-DBH: Stored Procedure Helper 20100408

Method GEN_SET_REMOVAL_TIME_RANGE on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GET_ACTIVE_DETAIL_LEVEL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing OPTION_KEY Call by reference Type reference (TYPE) I 20100409
2 Returning VALUE Value transfer Type reference (TYPE) STRING 20100409

Method GET_ACTIVE_DETAIL_LEVEL on class CL_DB6_DBH_PKG_CACHE has no exception.

Method GET_RANKED_METRICS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning METRICS_TAB Value transfer Type reference (TYPE) DBAKEYVAL_TAB DBA Cockpit: Table of DBAKEYVAL 20100226

Method GET_RANKED_METRICS on class CL_DB6_DBH_PKG_CACHE has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 720