SAP ABAP Class CL_DB2_DBH_SPACE (DB2-DBH: Extractor for Tablespace- and Indexspace Statistics)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-DB2 (Application Component) DB2 for z/OS
⤷
STU2 (Package) CCMS for DB2 for OS/390
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-DB2 (Application Component) DB2 for z/OS⤷
STU2 (Package) CCMS for DB2 for OS/390Meta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_DB2_DBH_EXTRACTOR | DB2-DBH: Extractor | 20080409 |
Properties
| Class | CL_DB2_DBH_SPACE | |
| Short Description | DB2-DBH: Extractor for Tablespace- and Indexspace Statistics | |
| Super Class | CL_DB2_DBH_EXTRACTOR | DB2-DBH: Extractor |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | STU2 | CCMS for DB2 for OS/390 |
| Created | 20080312 | SAP |
| Last change | 20110908 | 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_DB2_DBH_SPACE has no interface implemented.
Friends
Class CL_DB2_DBH_SPACE has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | CO_OBJTYPE_IS |
Constant | Private | Type reference (TYPE) | STRING | 'Indexspace' | DB2-DBH: Object type: IS | 20080410 | |
| 2 | CO_OBJTYPE_TS_LOB |
Constant | Private | Type reference (TYPE) | STRING | 'LOB Tablespace' | DB2-DBH: Object type: LOB TS | 20080410 | |
| 3 | CO_OBJTYPE_TS_MT |
Constant | Private | Type reference (TYPE) | STRING | 'Multi Table Tablespace' | DB2-DBH: Object type: Multi Table TS | 20080410 | |
| 4 | CO_OBJTYPE_TS_ST |
Constant | Private | Type reference (TYPE) | STRING | 'Single Table Tablespace' | DB2-DBH: Object type: Single Table TS | 20080410 | |
| 5 | CO_OBJTYPE_TS_XML |
Constant | Private | Type reference (TYPE) | STRING | 'XML Tablespace' | DB2-DBH: Object type: XML TS | 20090831 | |
| 6 | CO_RESIDUAL_IDENTIFIER |
Constant | Private | Type reference (TYPE) | STRING | 'DB2CCMSRESIDUAL' | DB2-DBH: Identifier of residual object (TISNAME) | 20101206 | |
| 7 | CO_TABNAME_DBDB02_IS |
Instance attribute | Private | Type reference (TYPE) | DB2TABNAML | 'DB2DB02IXSIZE' | DB2-DBH: Name of dbdb02 indexspace history table | 20090831 | |
| 8 | CO_TABNAME_DBDB02_TS |
Constant | Private | Type reference (TYPE) | DB2TABNAML | 'DB2DB02TSSIZE' | DB2-DBH: Name of dbdb02 tablespace history table | 20090831 | |
| 9 | CO_TABNAME_SAPCL |
Constant | Private | Type reference (TYPE) | DB2TABNAML | 'DB2QDB02_OBJECT' | DB2-DBH: Name of sapcl space history table | 20090831 | |
| 10 | CO_TOPX |
Constant | Private | Type reference (TYPE) | I | 100 | Number of objects considered at topX-calculation | 20101203 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | APPEND_EXTRACTOR_DATA_LINE |
Instance method | Private | Method | DB2-DBH: Fill extractor date table as expected by EFWK | 20101203 |
| 2 | CALCULATE_TOPX |
Instance method | Private | Method | DB2-DBH: Calculate delta values for extracted data | 20101129 |
| 3 | CONSTRUCTOR |
Instance method | Public | Constructor | 20080409 | |
| 4 | DBDB02_CALCULATE_DELTAS |
Instance method | Private | Method | DB2-DBH: Calculate delta values for extracted data | 20090831 |
| 5 | DBDB02_EXTRACT |
Instance method | Private | Method | DB2-DBH: Extract captured data from old DBDB02xxxx-tables | 20090831 |
| 6 | DBDB02_GEN_EX_STMT_IS |
Instance method | Private | Method | DB2-DBH: Gen. select stmnt (indexspaces; dbdb02-tabs) | 20090831 |
| 7 | DBDB02_GEN_EX_STMT_TS_MT |
Instance method | Private | Method | DB2-DBH: Gen. select stmnt (multi table ts's; dbdb02-tabs) | 20090831 |
| 8 | DBDB02_GEN_EX_STMT_TS_ST_LOB |
Instance method | Private | Method | DB2-DBH: Gen. select stmnt (single table ts's; dbdb02-tabs) | 20090831 |
| 9 | DBDB02_GEN_EX_STMT_TS_ST_NOLOB |
Instance method | Private | Method | DB2-DBH: Gen. select stmnt (single table ts's; dbdb02-tabs) | 20090831 |
| 10 | DBDB02_TABLES_EXIST |
Instance method | Private | Method | DB2-DBH: Check wether new SAPCL tables exist | 20090831 |
| 11 | FILL_EXTRACTOR_DATA |
Instance method | Private | Method | DB2-DBH: Fill extractor date table as expected by EFWK | 20101203 |
| 12 | GEN_HEADER_FIELDS |
Instance method | Private | Method | DB2-DBH: Populate header fields for space extractor | 20080409 |
| 13 | RESIDUAL_OBJECTS_APPEND_REINIT |
Instance method | Private | Method | Append all residual objects to extractor data & reinitialize | 20101207 |
| 14 | RESIDUAL_OBJECT_APPEND_REINIT |
Instance method | Private | Method | Append one residual object to extractor data & reinitialize | 20101207 |
| 15 | RESIDUAL_OBJECT_INIT |
Instance method | Private | Method | Initialize residual object | 20101202 |
| 16 | RESIDUAL_OBJECT_UPDATE |
Instance method | Private | Method | Update residual object | 20101202 |
| 17 | SAPCL_EXTRACT |
Instance method | Private | Method | DB2-DBH: Extract captured data from old DBDB02xxxx-tables | 20090831 |
| 18 | SAPCL_GEN_EX_STMT |
Instance method | Private | Method | DB2-DBH: Gen. select stmnt (all spaces; sapcl-tabs) | 20090831 |
| 19 | SAPCL_TABLES_EXIST |
Instance method | Private | Method | DB2-DBH: Check wether new SAPCL tables exist | 20090831 |
Events
Class CL_DB2_DBH_SPACE has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | DB02_SPACE_DATA_T | Private | See coding | 20080409 | BEGIN OF db02_space_data_t,
tisnam TYPE string,
tistyp TYPE string,
tissty TYPE string,
dbname TYPE string,
tbname TYPE string,
ianame TYPE string,
schema TYPE string,
partno TYPE db2partext,
allsz TYPE db2tssizp,
allszd TYPE db2tssizp,
fresz TYPE db2tsfreep,
freszd TYPE db2tsfreep,
dasdu TYPE db2dasd_usage,
dasdud TYPE db2dasd_usage,
stodat TYPE d,
stotim TYPE t,
tiper TYPE i,
parts TYPE db2numpart,
table_allsz TYPE db2tssizp,
table_allszd TYPE db2tssizp,
space_allsz TYPE db2tssizp,
space_allszd TYPE db2tssizp,
store_in_bi TYPE abap_bool,
END OF db02_space_data_t
|
||
| 2 | DB02_SPACE_DATA_TAB_T | Private | See coding | 20080409 | db02_space_data_tab_t TYPE STANDARD TABLE OF db02_space_data_t
|
||
| 3 | RESIDUAL_OBJECTS_T | Private | See coding | 20101206 | BEGIN OF residual_objects_t,
is TYPE db02_space_data_t,
ts_lob TYPE db02_space_data_t,
ts_mt TYPE db02_space_data_t,
ts_st TYPE db02_space_data_t,
ts_xml TYPE db02_space_data_t,
END OF residual_objects_t
|
Method Signatures
Method APPEND_EXTRACTOR_DATA_LINE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Changing |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20101203 | ||
| 2 |  Importing |
SPACE_DATA_LINE | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_T | 20101203 |
Method APPEND_EXTRACTOR_DATA_LINE on class CL_DB2_DBH_SPACE has no exception.
Method CALCULATE_TOPX Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
SPACE_DATA | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_TAB_T | DBA-DBH: Extracted Data | 20101129 | ||
| 2 | Importing |
TOPX | Call by reference | Type reference (TYPE) | I | Only TOPX tables will be transferred to SolMan BI | 20101130 |
Method CALCULATE_TOPX on class CL_DB2_DBH_SPACE 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 | 20080409 | ||
| 2 | Importing |
CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20080409 | ||
| 3 | Importing |
DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20080409 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20090408 |
Method DBDB02_CALCULATE_DELTAS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
SPACE_DATA | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_TAB_T | DBA-DBH: Extracted Data | 20090831 | ||
| 2 | Changing |
SPACE_DATA_DELTA | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_TAB_T | DBA-DBH: Extracted Data (Delta Calculation) | 20090831 |
Method DBDB02_CALCULATE_DELTAS on class CL_DB2_DBH_SPACE has no exception.
Method DBDB02_EXTRACT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20090831 | ||
| 2 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method DBDB02_GEN_EX_STMT_IS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 | ||
| 2 | Changing |
SQL_STMT | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement | 20090831 | ||
| 3 | Changing |
SQL_STMT_DELTA | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement for Delta-Calculation | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method DBDB02_GEN_EX_STMT_TS_MT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 | ||
| 2 | Changing |
SQL_STMT | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement | 20090831 | ||
| 3 | Changing |
SQL_STMT_DELTA | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement for Delta-Calculation | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method DBDB02_GEN_EX_STMT_TS_ST_LOB Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 | ||
| 2 | Changing |
SQL_STMT | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement | 20090831 | ||
| 3 | Changing |
SQL_STMT_DELTA | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement for Delta-Calculation | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method DBDB02_GEN_EX_STMT_TS_ST_NOLOB Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 | ||
| 2 | Changing |
SQL_STMT | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement | 20090831 | ||
| 3 | Changing |
SQL_STMT_DELTA | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement for Delta-Calculation | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method DBDB02_TABLES_EXIST Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
DBDB02_TABLES_EXIST | Value transfer | Type reference (TYPE) | ABAP_BOOL | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20090831 |
Method FILL_EXTRACTOR_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20101203 | ||
| 2 | Changing |
SPACE_DATA | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_TAB_T | 20101203 |
Method FILL_EXTRACTOR_DATA on class CL_DB2_DBH_SPACE has no exception.
Method GEN_HEADER_FIELDS 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) | 20080409 |
Method GEN_HEADER_FIELDS on class CL_DB2_DBH_SPACE has no exception.
Method RESIDUAL_OBJECTS_APPEND_REINIT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20101207 | ||
| 2 | Changing |
RESIDUAL_OBJECTS | Call by reference | Type reference (TYPE) | RESIDUAL_OBJECTS_T | 20101207 | |||
| 3 | Importing |
SPACE_DATA_LINE | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_T | 20101207 |
Method RESIDUAL_OBJECTS_APPEND_REINIT on class CL_DB2_DBH_SPACE has no exception.
Method RESIDUAL_OBJECT_APPEND_REINIT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20101207 | ||
| 2 | Changing |
RESIDUAL_OBJECT_REF | Call by reference | Object reference (TYPE REF TO) | DB02_SPACE_DATA_T | 20101207 | |||
| 3 | Importing |
SPACE_DATA_LINE | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_T | 20101207 | |||
| 4 | Importing |
TISTYP | Call by reference | Type reference (TYPE) | STRING | 20101221 |
Method RESIDUAL_OBJECT_APPEND_REINIT on class CL_DB2_DBH_SPACE has no exception.
Method RESIDUAL_OBJECT_INIT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
RESIDUAL_OBJECT_REF | Call by reference | Object reference (TYPE REF TO) | DB02_SPACE_DATA_T | 20101206 | |||
| 2 | Importing |
SPACE_DATA_LINE | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_T | 20101221 |
Method RESIDUAL_OBJECT_INIT on class CL_DB2_DBH_SPACE has no exception.
Method RESIDUAL_OBJECT_UPDATE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
RESIDUAL_OBJECT_REF | Call by reference | Object reference (TYPE REF TO) | DB02_SPACE_DATA_T | 20101206 | |||
| 2 | Importing |
SPACE_DATA_LINE | Call by reference | Type reference (TYPE) | DB02_SPACE_DATA_T | 20101202 |
Method RESIDUAL_OBJECT_UPDATE on class CL_DB2_DBH_SPACE has no exception.
Method SAPCL_EXTRACT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
EXTRACTOR_DATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_DATA | DBA-DBH: Extracted Data | 20090831 | ||
| 2 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method SAPCL_GEN_EX_STMT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
REQUIRED_RECORDS | Call by reference | Type reference (TYPE) | DBA_DBH_REQUIRED_RECORDS | DBA-DBH: Required Records | 20090831 | ||
| 2 | Changing |
SQL_STMT | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090831 |
Method SAPCL_TABLES_EXIST Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
SAPCL_TABLES_EXIST | Value transfer | Type reference (TYPE) | ABAP_BOOL | 20090831 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20090831 |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 703 |
