SAP ABAP Class CL_SYB_DBH_COLLECTOR (SYB-DBH: Collector)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-SYB (Application Component) Sybase ASE Database Platform
⤷
SMSYB (Package) SYBASE Database Monitor
⤷
⤷
Meta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_SYB_DBH_EXTRACTOR | SYB-DBH: Extractor | 20100809 |
Meta Relationship - Used By
Properties
| Class | CL_SYB_DBH_COLLECTOR | |
| Short Description | SYB-DBH: Collector | |
| Super Class | CL_SYB_DBH_EXTRACTOR | SYB-DBH: Extractor |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | SMSYB | SYBASE Database Monitor |
| Created | 20100809 | SAP |
| Last change | 20141121 | |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 | Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class CL_SYB_DBH_COLLECTOR has no interface implemented.
Friends
Class CL_SYB_DBH_COLLECTOR has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Constant | Public | Type reference (TYPE) | I | 901 | 20120322 | |||
| 2 | Constant | Public | Type reference (TYPE) | I | 917 | 20120712 | |||
| 3 | Constant | Public | Type reference (TYPE) | I | 902 | 20120322 | |||
| 4 | Constant | Public | Type reference (TYPE) | I | 903 | 20120322 | |||
| 5 | Constant | Public | Type reference (TYPE) | I | 904 | 20120322 | |||
| 6 | Constant | Public | Type reference (TYPE) | I | 915 | 20120511 | |||
| 7 | Constant | Public | Type reference (TYPE) | I | 905 | 20120322 | |||
| 8 | Constant | Public | Type reference (TYPE) | I | 924 | 20130904 | |||
| 9 | Constant | Public | Type reference (TYPE) | I | 921 | 20130613 | |||
| 10 | Constant | Public | Type reference (TYPE) | I | 923 | 20130815 | |||
| 11 | Constant | Public | Type reference (TYPE) | I | 922 | 20130729 | |||
| 12 | Constant | Public | Type reference (TYPE) | I | 906 | 20120322 | |||
| 13 | Constant | Public | Type reference (TYPE) | I | 918 | 20120905 | |||
| 14 | Constant | Public | Type reference (TYPE) | I | 907 | 20120322 | |||
| 15 | Constant | Public | Type reference (TYPE) | I | 919 | 20130315 | |||
| 16 | Constant | Public | Type reference (TYPE) | I | 908 | 20120322 | |||
| 17 | Constant | Public | Type reference (TYPE) | I | 917 | 20120614 | |||
| 18 | Constant | Public | Type reference (TYPE) | I | 916 | 20120525 | |||
| 19 | Constant | Public | Type reference (TYPE) | I | 909 | 20120322 | |||
| 20 | Constant | Public | Type reference (TYPE) | I | 910 | 20120322 | |||
| 21 | Constant | Public | Type reference (TYPE) | I | 911 | 20120322 | |||
| 22 | Constant | Public | Type reference (TYPE) | I | 912 | 20120322 | |||
| 23 | Constant | Public | Type reference (TYPE) | I | 913 | 20120322 | |||
| 24 | Constant | Public | Type reference (TYPE) | I | 914 | 20120322 | |||
| 25 | Constant | Public | Type reference (TYPE) | I | 920 | 20130523 | |||
| 26 | Constant | Public | Type reference (TYPE) | STRING | 'dd' | 20100809 | |||
| 27 | Constant | Public | Type reference (TYPE) | STRING | 'INC_MODE_DOW' | 20100809 | |||
| 28 | Constant | Public | Type reference (TYPE) | STRING | 'INC_MODE_THRSD' | 20100809 | |||
| 29 | Constant | Public | Type reference (TYPE) | STRING | '6' | 20100809 | |||
| 30 | Constant | Public | Type reference (TYPE) | STRING | '2' | 20100809 | |||
| 31 | Constant | Public | Type reference (TYPE) | STRING | '0' | 20100809 | |||
| 32 | Constant | Public | Type reference (TYPE) | STRING | '7' | 20100809 | |||
| 33 | Constant | Public | Type reference (TYPE) | STRING | '1' | 20100809 | |||
| 34 | Constant | Public | Type reference (TYPE) | STRING | '5' | 20100809 | |||
| 35 | Constant | Public | Type reference (TYPE) | STRING | '3' | 20100809 | |||
| 36 | Constant | Public | Type reference (TYPE) | STRING | '4' | 20100809 | |||
| 37 | Constant | Public | Type reference (TYPE) | I | 200 | 20100809 | |||
| 38 | Constant | Public | Type reference (TYPE) | STRING | '14' | 20100809 | |||
| 39 | Constant | Public | Type reference (TYPE) | STRING | '100' | 20100809 | |||
| 40 | Constant | Public | Type reference (TYPE) | STRING | '50' | 20100809 | |||
| 41 | Constant | Public | Type reference (TYPE) | STRING | '500' | 20110218 | |||
| 42 | Constant | Public | Type reference (TYPE) | STRING | '50' | 20100809 | |||
| 43 | Constant | Public | Type reference (TYPE) | I | 100 | 20100809 | |||
| 44 | Constant | Protected | Type reference (TYPE) | STRING | 'PIPE' | 20100809 | |||
| 45 | Constant | Protected | Type reference (TYPE) | STRING | 'SNAP' | 20100809 | |||
| 46 | Constant | Protected | Type reference (TYPE) | STRING | 'STG' | 20100809 | |||
| 47 | Constant | Protected | Type reference (TYPE) | STRING | 'WORK' | 20120716 | |||
| 48 | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 49 | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | |||
| 50 | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 51 | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 52 | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | |||
| 53 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | ||||
| 54 | Instance attribute | Protected | Type reference (TYPE) | I | 0 | Week Day (1-7), 1 = SUN | 20100809 | ||
| 55 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | ||||
| 56 | Instance attribute | Protected | Type reference (TYPE) | STRING | 20100809 | ||||
| 57 | Instance attribute | Protected | Type reference (TYPE) | STRING | 20100809 | ||||
| 58 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | ||||
| 59 | Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_MANAGED_ROUTINE_LIST | 20130613 | ||||
| 60 | Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE_LIST | 20100809 | ||||
| 61 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | ||||
| 62 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | ||||
| 63 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_TOP_METRIC_TAB | DBA-DBH: BI Relevant Metrics | 20100809 | |||
| 64 | Instance attribute | Protected | Object reference (TYPE REF TO) | CL_SYB_DBH_STORED_PROCEDURE | 20100809 | ||||
| 65 | Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | 20100809 | ||||
| 66 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | ||||
| 67 | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 |
Methods
Events
Class CL_SYB_DBH_COLLECTOR has no event.
Types
Class CL_SYB_DBH_COLLECTOR has no local type.
Method Signatures
Method ADD_MANAGED_ROUTINE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ROUTINENAME | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_ROUTINE-ROUTINENAME | DB6-DBH: Full Qualified Routin Name | 20130613 |
Method ADD_MANAGED_ROUTINE on class CL_SYB_DBH_COLLECTOR has no exception.
Method ADD_MANAGED_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | HAS_COLLECT_MODE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20120604 | |||
| 2 | PREFIX | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE-PREFIX | DB6-DBH: Routine Name (UDF/SP) | 20100809 | |||
| 3 | TABNAME | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE-TABNAME | DB6-DBH: Full Qualified Table Name (TABSCHEMA.TABNAME) | 20100809 | |||
| 4 | TIME_COLNAME | Call by reference | Type reference (TYPE) | DB6_DBH_COLUMN_NAME | 'SNAPSHOT_TIMESTAMP' | DB6-DBH: Column Name | 20100809 | ||
| 5 | TIME_MASTER | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE-TIME_MASTER | ABAP_FALSE | DB6-DBH: Marks Special Table for First/Last Timestamp Usage | 20100809 | ||
| 6 | TYPE | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE-TYPE | DB6-DBH: EVMON/SNAP/STG | 20100809 |
Method ADD_MANAGED_TABLE on class CL_SYB_DBH_COLLECTOR has no exception.
Method CONSTRUCTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | BI_SERVER | Call by reference | Type reference (TYPE) | DBA_DBH_BI_SERVER | DBA-DBH: BI Server | 20100809 | |||
| 2 | CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20100809 | |||
| 3 | DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20100809 | |||
| 4 | HAS_CLEANUP_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 5 | HAS_INC_MODE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | |||
| 6 | HAS_SNAP_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 7 | HAS_STG_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 8 | HAS_TOP_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | |||
| 9 | INC_MODE_TIME_UNIT | Call by reference | Type reference (TYPE) | STRING | 20100809 | ||||
| 10 | PREFIX | Call by reference | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | DB6-DBH: Prefix | 20100809 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Setup Corrupted | 20100809 |
Method GEN_PHASE_CLEANUP Signature
Method GEN_PHASE_CLEANUP on class CL_SYB_DBH_COLLECTOR has no parameter.
Method GEN_PHASE_CLEANUP on class CL_SYB_DBH_COLLECTOR has no exception.
Method GEN_PHASE_LOCK_CHECK Signature
Method GEN_PHASE_LOCK_CHECK on class CL_SYB_DBH_COLLECTOR has no parameter.
Method GEN_PHASE_LOCK_CHECK on class CL_SYB_DBH_COLLECTOR has no exception.
Method GEN_PHASE_SNAPSHOT Signature
Method GEN_PHASE_SNAPSHOT on class CL_SYB_DBH_COLLECTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method GEN_PHASE_STAGING Signature
Method GEN_PHASE_STAGING on class CL_SYB_DBH_COLLECTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method GEN_PHASE_TOP Signature
Method GEN_PHASE_TOP on class CL_SYB_DBH_COLLECTOR has no parameter.
Method GEN_PHASE_TOP on class CL_SYB_DBH_COLLECTOR has no exception.
Method GET_FWK_MSG_BEGIN_TIME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | RESULT | Value transfer | Type reference (TYPE) | DB6DATETIM | 20100809 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method GET_INSTALLED_VERSION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | RESULT | Value transfer | Type reference (TYPE) | STRING | 20100809 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Setup Corrupted | 20100809 |
Method GET_MAX_TIMESTAMP Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DBNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | ||||
| 2 | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | ||||
| 3 | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100812 | ||||
| 4 | TIME_IN_UTC | Call by reference | Type reference (TYPE) | ABAP_BOOL | 20110330 | ||||
| 5 | TSTAMP | Value transfer | Type reference (TYPE) | DB6TSTAMP | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | 20100812 | |||
| 6 | TSTAMP_COLUMN | Call by reference | Type reference (TYPE) | STRING | 20100812 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | Exception Class for SQL Error | 20100812 |
Method GET_MIN_TIMESTAMP Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DBNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | ||||
| 2 | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | ||||
| 3 | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100812 | ||||
| 4 | TSTAMP | Value transfer | Type reference (TYPE) | DB6TSTAMP | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | 20100812 | |||
| 5 | TSTAMP_COLUMN | Call by reference | Type reference (TYPE) | STRING | 20100812 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | Exception Class for SQL Error | 20100812 |
Method GET_NUM_LOG_MESSAGES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | MSG_LVL | Call by reference | Type reference (TYPE) | DBA_DBH_VALUE | DBA-DBH: Key/Value for Configuration Table | 20100809 | |||
| 2 | RESULT | Value transfer | Type reference (TYPE) | I | 20100809 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method GET_TABLE_PSIZE_KB Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DBNAME | Call by reference | Type reference (TYPE) | STRING | 20100811 | ||||
| 2 | RESULT | Value transfer | Type reference (TYPE) | I | 20100809 | ||||
| 3 | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100809 | ||||
| 4 | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100811 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method INIT_OPTIONS_INC Signature
Method INIT_OPTIONS_INC on class CL_SYB_DBH_COLLECTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Setup Corrupted | 20100809 |
Method INIT_OPTIONS_TOP Signature
Method INIT_OPTIONS_TOP on class CL_SYB_DBH_COLLECTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Setup Corrupted | 20100809 |
Method INIT_STORED_PROCEDURE Signature
Method INIT_STORED_PROCEDURE on class CL_SYB_DBH_COLLECTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method PRUNE_JS_LOG Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SP_ID | Call by reference | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | DB6-DBH: Routine Name (UDF/SP) | 20120612 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20120612 |
Method PRUNE_MESSAGE_LOG Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SP_ID | Call by reference | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | DB6-DBH: Routine Name (UDF/SP) | 20100809 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA-DBH: Collector Exception | 20100809 |
Method TRUNCATE_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | REORG_AFTERWARDS | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | |||
| 2 | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100809 | ||||
| 3 | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100809 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | DBA Cockpit: ADBC Errors | 20100809 |
Meta Relationship - Used By (full list)
History
| Last changed by/on | SAP | 20141121 |
| SAP Release Created in | 703 |