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
⤷ 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 | ABAP | 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 | CO_CHK_ID_ASEINSTANCE | Constant | Public | Type reference (TYPE) | I | 901 | 20120322 | ||
2 | CO_CHK_ID_ASERESOURCES | Constant | Public | Type reference (TYPE) | I | 917 | 20120712 | ||
3 | CO_CHK_ID_DATACACHE | Constant | Public | Type reference (TYPE) | I | 902 | 20120322 | ||
4 | CO_CHK_ID_DEVICES | Constant | Public | Type reference (TYPE) | I | 903 | 20120322 | ||
5 | CO_CHK_ID_ERRORLOG | Constant | Public | Type reference (TYPE) | I | 904 | 20120322 | ||
6 | CO_CHK_ID_FILESYSTEMS | Constant | Public | Type reference (TYPE) | I | 915 | 20120511 | ||
7 | CO_CHK_ID_FRAMEWORK | Constant | Public | Type reference (TYPE) | I | 905 | 20120322 | ||
8 | CO_CHK_ID_HADR_ERRORLOG | Constant | Public | Type reference (TYPE) | I | 924 | 20130904 | ||
9 | CO_CHK_ID_HADR_PATHS | Constant | Public | Type reference (TYPE) | I | 921 | 20130613 | ||
10 | CO_CHK_ID_HADR_RAT | Constant | Public | Type reference (TYPE) | I | 923 | 20130815 | ||
11 | CO_CHK_ID_HADR_RESOURCES | Constant | Public | Type reference (TYPE) | I | 922 | 20130729 | ||
12 | CO_CHK_ID_INDEXES | Constant | Public | Type reference (TYPE) | I | 906 | 20120322 | ||
13 | CO_CHK_ID_IOCONTROLLERS | Constant | Public | Type reference (TYPE) | I | 918 | 20120905 | ||
14 | CO_CHK_ID_LOCK_EVENTS | Constant | Public | Type reference (TYPE) | I | 907 | 20120322 | ||
15 | CO_CHK_ID_MEMORYUSAGE | Constant | Public | Type reference (TYPE) | I | 919 | 20130315 | ||
16 | CO_CHK_ID_PROCCACHEUSAGE | Constant | Public | Type reference (TYPE) | I | 908 | 20120322 | ||
17 | CO_CHK_ID_SPINLOCKACTIVITY | Constant | Public | Type reference (TYPE) | I | 917 | 20120614 | ||
18 | CO_CHK_ID_STMTCACHE | Constant | Public | Type reference (TYPE) | I | 916 | 20120525 | ||
19 | CO_CHK_ID_STMTCACHEUSAGE | Constant | Public | Type reference (TYPE) | I | 909 | 20120322 | ||
20 | CO_CHK_ID_SYSLOAD | Constant | Public | Type reference (TYPE) | I | 910 | 20120322 | ||
21 | CO_CHK_ID_SYSWAITS | Constant | Public | Type reference (TYPE) | I | 911 | 20120322 | ||
22 | CO_CHK_ID_TABLES | Constant | Public | Type reference (TYPE) | I | 912 | 20120322 | ||
23 | CO_CHK_ID_TEMPDBACTIVITY | Constant | Public | Type reference (TYPE) | I | 913 | 20120322 | ||
24 | CO_CHK_ID_THREADS | Constant | Public | Type reference (TYPE) | I | 914 | 20120322 | ||
25 | CO_CHK_ID_TXNLOGUSAGE | Constant | Public | Type reference (TYPE) | I | 920 | 20130523 | ||
26 | CO_INC_MODE_TIME_UNIT_DAY | Constant | Public | Type reference (TYPE) | STRING | 'dd' | 20100809 | ||
27 | CO_KEY_INC_MODE_DOW | Constant | Public | Type reference (TYPE) | STRING | 'INC_MODE_DOW' | 20100809 | ||
28 | CO_KEY_INC_MODE_THRSD | Constant | Public | Type reference (TYPE) | STRING | 'INC_MODE_THRSD' | 20100809 | ||
29 | CO_OPTIONS_DOW_FRI | Constant | Public | Type reference (TYPE) | STRING | '6' | 20100809 | ||
30 | CO_OPTIONS_DOW_MON | Constant | Public | Type reference (TYPE) | STRING | '2' | 20100809 | ||
31 | CO_OPTIONS_DOW_NONE | Constant | Public | Type reference (TYPE) | STRING | '0' | 20100809 | ||
32 | CO_OPTIONS_DOW_SAT | Constant | Public | Type reference (TYPE) | STRING | '7' | 20100809 | ||
33 | CO_OPTIONS_DOW_SUN | Constant | Public | Type reference (TYPE) | STRING | '1' | 20100809 | ||
34 | CO_OPTIONS_DOW_THR | Constant | Public | Type reference (TYPE) | STRING | '5' | 20100809 | ||
35 | CO_OPTIONS_DOW_TUE | Constant | Public | Type reference (TYPE) | STRING | '3' | 20100809 | ||
36 | CO_OPTIONS_DOW_WED | Constant | Public | Type reference (TYPE) | STRING | '4' | 20100809 | ||
37 | CO_OPTIONS_INC_MODE | Constant | Public | Type reference (TYPE) | I | 200 | 20100809 | ||
38 | CO_OPTIONS_NONTOP_KEEP_DEFAULT | Constant | Public | Type reference (TYPE) | STRING | '14' | 20100809 | ||
39 | CO_OPTIONS_TOP_100 | Constant | Public | Type reference (TYPE) | STRING | '100' | 20100809 | ||
40 | CO_OPTIONS_TOP_50 | Constant | Public | Type reference (TYPE) | STRING | '50' | 20100809 | ||
41 | CO_OPTIONS_TOP_500 | Constant | Public | Type reference (TYPE) | STRING | '500' | 20110218 | ||
42 | CO_OPTIONS_TOP_DEFAULT | Constant | Public | Type reference (TYPE) | STRING | '50' | 20100809 | ||
43 | CO_OPTIONS_TOP_KEY | Constant | Public | Type reference (TYPE) | I | 100 | 20100809 | ||
44 | CO_TABLE_TYPE_PIPE | Constant | Protected | Type reference (TYPE) | STRING | 'PIPE' | 20100809 | ||
45 | CO_TABLE_TYPE_SNAP | Constant | Protected | Type reference (TYPE) | STRING | 'SNAP' | 20100809 | ||
46 | CO_TABLE_TYPE_STG | Constant | Protected | Type reference (TYPE) | STRING | 'STG' | 20100809 | ||
47 | CO_TABLE_TYPE_WORK | Constant | Protected | Type reference (TYPE) | STRING | 'WORK' | 20120716 | ||
48 | HAS_CLEANUP_PHASE | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
49 | HAS_INC_MODE | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | ||
50 | HAS_SNAP_PHASE | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
51 | HAS_STG_PHASE | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
52 | HAS_TOP_PHASE | Instance attribute | Protected | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | ||
53 | INC_MODE_DOW_KEY | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | |||
54 | INC_MODE_FORCE_DOW | Instance attribute | Protected | Type reference (TYPE) | I | 0 | Week Day (1-7), 1 = SUN | 20100809 | |
55 | INC_MODE_THRSD_KEY | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | |||
56 | INC_MODE_TIME_UNIT | Instance attribute | Protected | Type reference (TYPE) | STRING | 20100809 | |||
57 | INSTALLED_VERSION | Instance attribute | Protected | Type reference (TYPE) | STRING | 20100809 | |||
58 | KEEP_DATA_KEY | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | |||
59 | MANAGED_ROUTINE_LIST | Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_MANAGED_ROUTINE_LIST | 20130613 | |||
60 | MANAGED_TABLES_LIST | Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE_LIST | 20100809 | |||
61 | OPTIONS_NONTOP_KEEP_KEY | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | |||
62 | OPTIONS_TOP_KEY | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | |||
63 | OPTIONS_TOP_METRICS | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_TOP_METRIC_TAB | DBA-DBH: BI Relevant Metrics | 20100809 | ||
64 | SP | Instance attribute | Protected | Object reference (TYPE REF TO) | CL_SYB_DBH_STORED_PROCEDURE | 20100809 | |||
65 | SP_ID | Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | 20100809 | |||
66 | SUPPORT_MODE_KEY | Instance attribute | Protected | Type reference (TYPE) | DBA_DBH_VALUE | 20100809 | |||
67 | VERSION_KEY | 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 | Importing | 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 | Importing | HAS_COLLECT_MODE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20120604 | ||
2 | Importing | PREFIX | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE-PREFIX | DB6-DBH: Routine Name (UDF/SP) | 20100809 | ||
3 | Importing | TABNAME | Call by reference | Type reference (TYPE) | DB6_DBH_MANAGED_TABLE-TABNAME | DB6-DBH: Full Qualified Table Name (TABSCHEMA.TABNAME) | 20100809 | ||
4 | Importing | TIME_COLNAME | Call by reference | Type reference (TYPE) | DB6_DBH_COLUMN_NAME | 'SNAPSHOT_TIMESTAMP' | DB6-DBH: Column Name | 20100809 | |
5 | Importing | 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 | Importing | 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 | Importing | BI_SERVER | Call by reference | Type reference (TYPE) | DBA_DBH_BI_SERVER | DBA-DBH: BI Server | 20100809 | ||
2 | Importing | CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20100809 | ||
3 | Importing | DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20100809 | ||
4 | Importing | HAS_CLEANUP_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
5 | Importing | HAS_INC_MODE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | ||
6 | Importing | HAS_SNAP_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
7 | Importing | HAS_STG_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
8 | Importing | HAS_TOP_PHASE | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_FALSE | 20100809 | ||
9 | Importing | INC_MODE_TIME_UNIT | Call by reference | Type reference (TYPE) | STRING | 20100809 | |||
10 | Importing | PREFIX | Call by reference | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | DB6-DBH: Prefix | 20100809 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_DBH_SETUP | 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 | CX_DBA_DBH_COLLECTOR | 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 | CX_DBA_DBH_COLLECTOR | 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 | Returning | RESULT | Value transfer | Type reference (TYPE) | DB6DATETIM | 20100809 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_DBH_COLLECTOR | 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 | Returning | RESULT | Value transfer | Type reference (TYPE) | STRING | 20100809 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_DBH_SETUP | 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 | Importing | DBNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | |||
2 | Importing | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | |||
3 | Importing | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100812 | |||
4 | Importing | TIME_IN_UTC | Call by reference | Type reference (TYPE) | ABAP_BOOL | 20110330 | |||
5 | Returning | TSTAMP | Value transfer | Type reference (TYPE) | DB6TSTAMP | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | 20100812 | ||
6 | Importing | TSTAMP_COLUMN | Call by reference | Type reference (TYPE) | STRING | 20100812 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_ADBC | 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 | Importing | DBNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | |||
2 | Importing | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100812 | |||
3 | Importing | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100812 | |||
4 | Returning | TSTAMP | Value transfer | Type reference (TYPE) | DB6TSTAMP | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | 20100812 | ||
5 | Importing | TSTAMP_COLUMN | Call by reference | Type reference (TYPE) | STRING | 20100812 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_ADBC | 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 | Importing | MSG_LVL | Call by reference | Type reference (TYPE) | DBA_DBH_VALUE | DBA-DBH: Key/Value for Configuration Table | 20100809 | ||
2 | Returning | RESULT | Value transfer | Type reference (TYPE) | I | 20100809 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_DBH_COLLECTOR | 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 | Importing | DBNAME | Call by reference | Type reference (TYPE) | STRING | 20100811 | |||
2 | Returning | RESULT | Value transfer | Type reference (TYPE) | I | 20100809 | |||
3 | Importing | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100809 | |||
4 | Importing | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100811 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_DBH_COLLECTOR | 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 | CX_DBA_DBH_SETUP | 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 | CX_DBA_DBH_SETUP | 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 | CX_DBA_DBH_COLLECTOR | 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 | Importing | 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 | CX_DBA_DBH_COLLECTOR | 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 | Importing | 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 | CX_DBA_DBH_COLLECTOR | DBA-DBH: Collector Exception | 20100809 |
Method TRUNCATE_TABLE Signature
# | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
---|---|---|---|---|---|---|---|---|---|
1 | Importing | REORG_AFTERWARDS | Call by reference | Type reference (TYPE) | ABAP_BOOL | ABAP_TRUE | 20100809 | ||
2 | Importing | TABNAME | Call by reference | Type reference (TYPE) | STRING | 20100809 | |||
3 | Importing | TABOWNER | Call by reference | Type reference (TYPE) | STRING | 20100809 |
# | Exception | Resumable | Description | Created on |
---|---|---|---|---|
1 | CX_DBA_ADBC | DBA Cockpit: ADBC Errors | 20100809 |
Meta Relationship - Used By (full list)
History
Last changed by/on | SAP | 20141121 |
SAP Release Created in | 703 |