SAP ABAP Class CL_DB4_DBH_EXTRACTOR (DB4-DBH: Extractor)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB4 (Application Component) DB2 for AS/400
⤷
STU4 (Package) CCMS / AS/400
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB4 (Application Component) DB2 for AS/400⤷
STU4 (Package) CCMS / AS/400Meta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DBA_DBH_EXTRACTOR | DBA-DBH: Generic Extractor | 20110405 |
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_CPU | DB4 DBH Extractor : CPU Utilization | 20110701 |
| 2 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_DATABASE | DB4 DBH Extractor : Database Activity | 20120906 |
| 3 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_DISKS | DB4 DBH Extractor : Disks | 20110701 |
| 4 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_JOURNALS | DB4 DBH Extractor : Journals | 20110701 |
| 5 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_LOCKS | DB4 DBH Extractor : Lock Waits | 20110701 |
| 6 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_MEMORY | DB4 DBH Extractor : Memory | 20110405 |
| 7 | Inheritance (c INHERITING FROM c_ref) | CL_DB4_DBH_TABLES | DB4 DBH Extractor : Tables | 20110701 |
Properties
| Class | CL_DB4_DBH_EXTRACTOR | |
| Short Description | DB4-DBH: Extractor | |
| 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 | STU4 | CCMS / AS/400 |
| Created | 20110405 | SAP |
| Last change | 20130531 | SAP |
| 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_DB4_DBH_EXTRACTOR has no interface implemented.
Friends
Class CL_DB4_DBH_EXTRACTOR has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ADMINDATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'ADMINDATA' | DB4-DBH: Tablename for Admindata | 20110405 | |
| 2 | BI_TOP |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'SESSION/BI_TOP' | DB4-DBH: Tablename for Top N Objects | 20120502 | |
| 3 | CON_REF |
Instance attribute | Protected | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20120427 | ||
| 4 | CPU_DATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'CPU_DATA' | DB4-DBH: Tablename for CPU Data | 20110405 | |
| 5 | DBOBJECTS |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'DBOBJECTS' | DB4-DBH: Tablename for DB-Objects | 20110405 | |
| 6 | DISK_DATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'DISK_DATA' | DB4-DBH: Tablename for Disk Data | 20110405 | |
| 7 | EXTRACTION_SCHEMA |
Instance attribute | Protected | Type reference (TYPE) | STRING | DB4-DBH: DB Performance Collector Schema | 20110701 | ||
| 8 | EXTRACTION_TABLE |
Instance attribute | Protected | Type reference (TYPE) | STRING | DB4-DBH: Tablename for Performance Data | 20110405 | ||
| 9 | EXTRACTOR_NAME |
Instance attribute | Protected | Type reference (TYPE) | STRING | DBA-DBH: Collector/Extractor Class | 20110405 | ||
| 10 | IPLDATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'IPLDATA' | DB4-DBH: Tablename for IPL Data | 20120118 | |
| 11 | POOL_DATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'POOL_DATA' | DB4-DBH: Tablename for Pool Data | 20110405 | |
| 12 | PREFIX |
Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | '' | DB6-DBH: Namespace Prefix | 20110405 | |
| 13 | SNAP_INFO |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'SESSION/SNAP_INFO' | DB4-DBH: Tablename for Snap Info | 20110405 | |
| 14 | SQL_SUMMARY |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'SQL_SUMMARY' | DB4-DBH: Tablename for SQL Summary | 20120907 | |
| 15 | TABLEDATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'TABLEDATA' | DB4-DBH: Tablename for Tabledata | 20110405 | |
| 16 | TOP_N |
Instance attribute | Protected | Type reference (TYPE) | STRING | '0' | DB4-DBH: Extracting Top N rows | 20120504 | |
| 17 | WAIT_DATA |
Instance attribute | Protected | Type reference (TYPE) | STRING | 'WAIT_DATA' | DB4-DBH: Tablename for Wait Data | 20110405 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | BUILD_SELECT |
Instance method | Protected | Method | Build SELECT list of SQL statement | 20110405 |
| 2 | CLEANUP |
Instance method | Protected | Method | Cleanup after extraction | 20110405 |
| 3 | CONSTRUCTOR |
Instance method | Public | Constructor | CONSTRUCTOR | 20110405 |
| 4 | GEN_EXTRACTOR_STMT |
Instance method | Protected | Method | Generate extractor SQL statement | 20110405 |
| 5 | GET_CHARACTERISTICS |
Instance method | Protected | Method | Fill Select list with characteristics | 20110405 |
| 6 | GET_KEYFIGURES |
Instance method | Protected | Method | Fill Select list with keyfigures | 20110405 |
| 7 | GET_SNAP_INFO |
Instance method | Protected | Method | Read the timestamps of data to extract | 20110405 |
| 8 | INIT_HEADER |
Instance method | Protected | Method | Initialize the header structure | 20110405 |
| 9 | READ_COLL |
Instance method | Protected | Method | Read the collector data | 20110405 |
| 10 | SET_EXTRACTION_SCHEMA |
Instance method | Private | Method | Sets the name of the library that contains the monitor data | 20111221 |
Events
Class CL_DB4_DBH_EXTRACTOR has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | SEL_L | Protected | See coding | DBH-DB4: Select list item | 20110405 | BEGIN OF SEL_L,
position TYPE i, "number in header
iobjnm TYPE string, "name of infoobject
selvalue TYPE string, "constant/formula/fieldname to select
retalias TYPE string, "return alias
END OF SEL_L
|
|
| 2 | SEL_T | Protected | See coding | DBH-DB4: Table of Select list items | 20110405 | SEL_T TYPE STANDARD TABLE OF SEL_L
WITH DEFAULT KEY INITIAL SIZE 0
|
Method Signatures
Method BUILD_SELECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20110405 | ||
| 2 |  Returning |
STMT_LINE | Value transfer | Type reference (TYPE) | STRING | DB4-DBH: Extractor Select Statement | 20110405 | ||
| 3 | Importing |
T_SEL | Call by reference | Type reference (TYPE) | SEL_T | DBH-DB4: Table of Select list items | 20110405 |
Method BUILD_SELECT on class CL_DB4_DBH_EXTRACTOR has no exception.
Method CLEANUP Signature
Method CLEANUP on class CL_DB4_DBH_EXTRACTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20110405 |
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 | 20110405 | ||
| 2 | Importing |
CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20110405 | ||
| 3 | Importing |
DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110405 | ||
| 4 | Importing |
EXTRACTION_TABLE | Call by reference | Type reference (TYPE) | STRING | Tablename for Performance Data | 20110405 | ||
| 5 | Importing |
PREFIX | Call by reference | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | DB6-DBH: Prefix | 20110405 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20110405 |
Method GEN_EXTRACTOR_STMT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20110405 | ||
| 2 | Returning |
SQL_STMT | Value transfer | Type reference (TYPE) | STRING | DB4-DBH: Extractor Select Statement | 20110405 | ||
| 3 | Importing |
T_SEL | Call by reference | Type reference (TYPE) | SEL_T | DBH-DB4: Table of Select list items | 20110405 |
Method GEN_EXTRACTOR_STMT on class CL_DB4_DBH_EXTRACTOR has no exception.
Method GET_CHARACTERISTICS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Changing |
T_SEL | Call by reference | Type reference (TYPE) | SEL_T | DBH-DB4: Table of Select list items | 20110405 |
Method GET_CHARACTERISTICS on class CL_DB4_DBH_EXTRACTOR has no exception.
Method GET_KEYFIGURES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
T_SEL | Call by reference | Type reference (TYPE) | SEL_T | DBH-DB4: Table of Select list items | 20110405 |
Method GET_KEYFIGURES on class CL_DB4_DBH_EXTRACTOR has no exception.
Method GET_SNAP_INFO Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
DEBUG | Call by reference | Type reference (TYPE) | C | 20120522 | |||
| 2 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20110405 | ||
| 3 |  Exporting |
ROWS_CNT | Call by reference | Type reference (TYPE) | I | Number of Rows in SNAP_INFO | 20110405 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20110405 |
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) | 20110405 | ||
| 2 | Importing |
T_SEL | Call by reference | Type reference (TYPE) | SEL_T | DBH-DB4: Table of Select list items | 20110405 |
Method INIT_HEADER on class CL_DB4_DBH_EXTRACTOR has no exception.
Method READ_COLL 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 | 20110405 | ||
| 2 | Importing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20110405 | ||
| 3 | Importing |
T_SEL | Call by reference | Type reference (TYPE) | SEL_T | DBH-DB4: Table of Select list items | 20110405 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20110405 |
Method SET_EXTRACTION_SCHEMA Signature
Method SET_EXTRACTION_SCHEMA on class CL_DB4_DBH_EXTRACTOR has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20120706 |
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 740 |
