SAP ABAP Class CL_MSS_DBH_EXTRACTOR (MSSQL DBH Extractor superclass)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
SMSS_TOOLS (Package) Utilities for MS SQL Server
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
SMSS_TOOLS (Package) Utilities for MS SQL ServerMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DBA_DBH_EXTRACTOR | DBA-DBH: Generic Extractor | 20080326 |
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_CONFIGURATION | MSSQL DBH Extractor : SQL Server configuration | 20080329 |
| 2 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_DATABASES | MSSQL DBH Extractor : Databases | 20080328 |
| 3 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_FILES | MSSQL DBH Extractor : Database file performance | 20080328 |
| 4 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_INSTANCE | MSSQL DBH Extractor : Instance data | 20080327 |
| 5 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_LOCKSTATS | MSSQL DBH Extractor : Lock statistics | 20080329 |
| 6 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_TABLESIZES | MSSQL DBH Extractor : Daily table size | 20090319 |
| 7 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_WAITSTATS | MSSQL DBH Extractor : Wait statistics | 20080328 |
Properties
| Class | CL_MSS_DBH_EXTRACTOR | |
| Short Description | MSSQL DBH Extractor superclass | |
| Super Class | CL_DBA_DBH_EXTRACTOR | DBA-DBH: Generic Extractor |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | SMSS_TOOLS | Utilities for MS SQL Server |
| Created | 20080326 | SAP |
| Last change | 20130531 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_MSS_DBH_EXTRACTOR has no forward declaration.
Interfaces
Class CL_MSS_DBH_EXTRACTOR has no interface implemented.
Friends
Class CL_MSS_DBH_EXTRACTOR has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | COMP_AEX |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of extractor name | 20080708 | ||
| 2 | COMP_CNT |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of cube row count | 20080708 | ||
| 3 | COMP_CUSTOM |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of first custom column | 20080327 | ||
| 4 | COMP_DBNAME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of database name | 20080327 | ||
| 5 | COMP_DBREL |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of database release string | 20080708 | ||
| 6 | COMP_HOSTNAME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of host name | 20080327 | ||
| 7 | COMP_RHOST |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of current cluster node hostname | 20080709 | ||
| 8 | COMP_SPHHHOST |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of real host name | 20100304 | ||
| 9 | COMP_TIME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of time column | 20080327 | ||
| 10 | CURRCON |
Instance attribute | Protected | Type reference (TYPE) | MSSCONNDATA | MSSQL multi-connect : Complete connection information | 20080327 | ||
| 11 | LOGOBJECT |
Constant | Protected | Type reference (TYPE) | BAL_S_LOG-OBJECT | 'DBACOCKPIT' | Application log: Object name (Application code) | 20110801 | |
| 12 | LOGSUBOBJECT |
Constant | Protected | Type reference (TYPE) | BAL_S_LOG-SUBOBJECT | 'MSS' | Application Log: Subobject | 20110801 | |
| 13 | LOOKTAB |
Instance attribute | Protected | Type reference (TYPE) | LOOKTAB_T | Text lookup table | 20100305 | ||
| 14 | MAPTAB |
Instance attribute | Protected | Type reference (TYPE) | COLL_BI_T | Standard table of COLL_BI_L | 20080326 | ||
| 15 | RHOST_CNTR |
Constant | Protected | Type reference (TYPE) | COLL_BI_L-CNTR_NAME | 'NetBiosHost' | RHOST counter name | 20080709 | |
| 16 | RHOST_OBJ |
Constant | Protected | Type reference (TYPE) | COLL_BI_L-OBJ_NAME | 'SERVERPROPERTY' | RHOST object name | 20080709 | |
| 17 | SERVER_CNTR |
Constant | Protected | Type reference (TYPE) | COLL_BI_L-CNTR_NAME | 'ServerName' | SQL Server counter name | 20100305 | |
| 18 | SERVER_OBJ |
Constant | Protected | Type reference (TYPE) | COLL_BI_L-OBJ_NAME | 'SERVERPROPERTY' | SQL Server object name | 20100305 | |
| 19 | VERSION_CNTR |
Constant | Protected | Type reference (TYPE) | COLL_BI_L-CNTR_NAME | 'ProductVersion' | DB version counter name | 20100305 | |
| 20 | VERSION_OBJ |
Constant | Protected | Type reference (TYPE) | COLL_BI_L-OBJ_NAME | 'SERVERPROPERTY' | DB version object name | 20100305 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | ADDMAP |
Instance method | Protected | Method | Add a line to the column mapping table MAPTAB | 20080326 |
| 2 | CONSTRUCTOR |
Instance method | Public | Constructor | CONSTRUCTOR | 20080327 |
| 3 | EXECUTE_XTOR |
Instance method | Protected | Method | Class-specific EXTRACTOR implementation | 20110730 |
| 4 | FIXED_COMPS |
Instance method | Protected | Method | Set the global characteristics and key figures | 20080708 |
| 5 | INIT_HEADER |
Instance method | Protected | Method | Initialize the standard dimensions in the header structure | 20080326 |
| 6 | PREPARE_TEXTTAB |
Instance method | Protected | Method | Fill the lookup table with the relevant sap_mon_text entries | 20100305 |
| 7 | READ_COLL |
Instance method | Protected | Method | Read the collector data via sap_coll_DBHex | 20080327 |
Events
Class CL_MSS_DBH_EXTRACTOR has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | COLL_BI_L | Protected | See coding | Mapping between DBCOLL entries and BI technical names | 20080326 | BEGIN OF COLL_BI_L ,
OBJ_NAME TYPE MSSCOLLRESI-OBJ_NAME ,
CNTR_NAME TYPE MSSCOLLRESI-CNTR_NAME ,
INST_NAME TYPE MSSCOLLRESI-INST_NAME ,
BI_NAME TYPE STRING ,
COMPNO TYPE I ,
END OF COLL_BI_L
|
|
| 2 | COLL_BI_T | Protected | See coding | Standard table of COLL_BI_L | 20080326 | COLL_BI_T TYPE STANDARD TABLE OF COLL_BI_L
|
|
| 3 | DBCOLL_L | Protected | See coding | Return line type of sap_coll_DBHex | 20080327 | BEGIN OF DBCOLL_L ,
TIMESTMP(14) TYPE C ,
OBJ_NAME TYPE MSSCOLLRESI-OBJ_NAME ,
CNTR_NAME TYPE MSSCOLLRESI-CNTR_NAME ,
INST_NAME TYPE MSSCOLLRESI-INST_NAME ,
CNTR_VALUE TYPE MSSCOLLRESI-CNTR_VALUE ,
END OF DBCOLL_L
|
|
| 4 | DBCOLL_T | Protected | See coding | Return table type of sap_coll_DBHex | 20080327 | DBCOLL_T TYPE STANDARD TABLE OF DBCOLL_L
|
|
| 5 | LOOKLINE_T | Protected | See coding | Line type for text lookup table | 20100305 | BEGIN OF LOOKLINE_T,
ID TYPE I,
VALUE(255) TYPE C,
END OF LOOKLINE_T
|
|
| 6 | LOOKTAB_T | Protected | See coding | Table type for text lookup table | 20100305 | LOOKTAB_T TYPE STANDARD TABLE OF LOOKLINE_T
|
Method Signatures
Method ADDMAP Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
BI_NAME | Call by reference | Type reference (TYPE) | COLL_BI_L-BI_NAME | Mapping between DBCOLL entries and BI technical names | 20080326 | ||
| 2 | Importing |
CNTR_NAME | Call by reference | Type reference (TYPE) | COLL_BI_L-CNTR_NAME | Mapping between DBCOLL entries and BI technical names | 20080326 | ||
| 3 |  Changing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20080327 | ||
| 4 | Importing |
INST_NAME | Call by reference | Type reference (TYPE) | COLL_BI_L-INST_NAME | SPACE | Mapping between DBCOLL entries and BI technical names | 20080326 | |
| 5 | Importing |
OBJ_NAME | Call by reference | Type reference (TYPE) | COLL_BI_L-OBJ_NAME | Mapping between DBCOLL entries and BI technical names | 20080326 |
Method ADDMAP on class CL_MSS_DBH_EXTRACTOR has no exception.
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 | 20080327 | ||
| 2 | Importing |
CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20080327 | ||
| 3 | Importing |
DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20080327 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20090902 |
Method EXECUTE_XTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20110730 | ||
| 2 | Exporting |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20110730 | ||
| 3 | Changing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20110730 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20110730 |
Method FIXED_COMPS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CURRCON | Call by reference | Type reference (TYPE) | MSSCONNDATA | MSSQL multi-connect : Complete connection information | 20080708 | ||
| 2 | Importing |
TIMESTMP | Call by reference | Type reference (TYPE) | DBCOLL_L-TIMESTMP | Return line type of sap_coll_DBHex | 20080708 | ||
| 3 | Changing |
XDATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20080708 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20080710 |
Method INIT_HEADER Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20080326 |
Method INIT_HEADER on class CL_MSS_DBH_EXTRACTOR has no exception.
Method PREPARE_TEXTTAB Signature
Method PREPARE_TEXTTAB on class CL_MSS_DBH_EXTRACTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20100305 |
Method READ_COLL Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
END_TS | Call by reference | Type reference (TYPE) | DBCOLL_L-TIMESTMP | Interval end time | 20080327 | ||
| 2 | Exporting |
PINFO | Call by reference | Type reference (TYPE) | DBCOLL_T | Return table type of sap_coll_DBHex | 20080327 | ||
| 3 | Importing |
START_TS | Call by reference | Type reference (TYPE) | DBCOLL_L-TIMESTMP | Interval start time | 20080327 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20080327 |
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 711 |
