SAP ABAP Class CL_DB2_DBH_SUBSYS (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 | 20090323 |
Properties
| Class | CL_DB2_DBH_SUBSYS | |
| 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 | 20090310 | 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_SUBSYS has no interface implemented.
Friends
Class CL_DB2_DBH_SUBSYS has no friend class.
Attributes
Class CL_DB2_DBH_SUBSYS has no attribute.
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CONSTRUCTOR |
Instance method | Public | Constructor | 20090323 | |
| 2 | FILL_EXTRACTOR_DATA |
Instance method | Private | Method | DB2-DBH: Fill extractor date table as expected by EFWK | 20090323 |
| 3 | GEN_EXTRACTOR_STMT |
Instance method | Public | Method | DB2-DBH: Generate select statement for indexspaces | 20090323 |
| 4 | GEN_HEADER_FIELDS |
Instance method | Public | Method | DB2-DBH: Populate header fields for space extractor | 20090323 |
| 5 | GET_NUM_RESTRICTED_OBJECTS |
Instance method | Private | Method | DB2-DBH: Get number of objects in restricted state | 20090323 |
| 6 | TIMESTAMP_IN_INTERVAL |
Static method | Private | Method | DB2-DBH: Check whether t-stamp is in interval ]lo_ts,hi_ts] | 20090323 |
Events
Class CL_DB2_DBH_SUBSYS has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | SUBSYS_DATA_T | Private | See coding | 20090323 | BEGIN OF subsys_data_t,
membnm TYPE string,
coldate TYPE dats,
coltime TYPE tims,
timedelta TYPE timedelta_t,
** Workload (SQL Activity DSC)
* Table DB2QHDTHDDSC
qstctscn TYPE int19,
qstcsort TYPE int19,
qstcexec TYPE int19,
** Workload (SQL Activity SYSW)
* Table DB2QHDSYSW2
qxselectd TYPE int19,
qxinsrtd TYPE int19,
qxupdted TYPE int19,
qxdeletd TYPE int19,
qxmerged TYPE int19,
qxtrtbld TYPE int19,
qxnsmiapd TYPE int19,
qxmrmiapd TYPE int19,
* Table DB2QHDSYSW1
q3stcommd TYPE int19,
q3strdond TYPE int19,
** Locks
* Table DB2QHDSYSW2
qtxatimd TYPE int19,
qtxadead TYPE int19,
qtxalesd TYPE int19,
qtxalexd TYPE int19,
** Package Cache (Statement Cache)
* Table DB2QHDSYSW2
qisedsgd TYPE int19,
qisedsid TYPE int19,
** Logging
* Table DB2QHDLRUR
qnlrurd TYPE int19,
* Table DB2QHDSYSW1
qjstwtbd TYPE int19,
qjstbffld TYPE int19,
** Memory -> DBM1 Storage
* Table DB2QW0225
strgavai TYPE int19,
* Table DB2QHDSYSW2
qisefaild TYPE int19,
qisepage TYPE int19,
qisefree TYPE int19,
qisedbd TYPE int19,
qisedpge TYPE int19,
** Resources
* Table DB2CCHOUR
qoirs TYPE int19,
** Global Times
* Table DB2QHDGLOTIME
thdtinb2d TYPE int19,
thdtcpuind TYPE int19,
thdtsuspind TYPE int19,
thdtnaindbd TYPE int19,
thdtiod TYPE int19,
thdtioed TYPE int19,
thdtlogwd TYPE int19,
thdtlogwed TYPE int19,
thdtothrd TYPE int19,
thdtothred TYPE int19,
thdtothwd TYPE int19,
thdtothwed TYPE int19,
thdtsrvtd TYPE int19,
thdtsrvted TYPE int19,
thdtocstd TYPE int19,
thdtocsted TYPE int19,
thdtslstd TYPE int19,
thdtslsted TYPE int19,
thdtdsstd TYPE int19,
thdtdssted TYPE int19,
thdtothrstd TYPE int19,
thdtothrsed TYPE int19,
thdtarchqd TYPE int19,
thdtarchqed TYPE int19,
thdtlklad TYPE int19,
thdtlklaed TYPE int19,
thdtpglad TYPE int19,
thdtpglaed TYPE int19,
thdtdrlkd TYPE int19,
thdtdrlked TYPE int19,
thdtclreld TYPE int19,
thdtclreled TYPE int19,
thdtnotmd TYPE int19,
thdtnotmed TYPE int19,
thdtglobtmd TYPE int19,
thdtglobted TYPE int19,
** Data Sharing
* Table DB2QHDSYSW1
qtgscslmd TYPE int19,
qtgsflsed TYPE int19,
qtgsiglod TYPE int19,
qtgslslmd TYPE int19,
qtgssglod TYPE int19,
qtgsuslmd TYPE int19,
END OF subsys_data_t
|
||
| 2 | SUBSYS_DATA_TAB_T | Private | See coding | 20090323 | subsys_data_tab_t TYPE STANDARD TABLE OF subsys_data_t
|
Method Signatures
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 | 20090323 | ||
| 2 | Importing |
CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20090323 | ||
| 3 | Importing |
DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20090323 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20090408 |
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 | 20090323 | ||
| 2 | Importing |
SUBSYS_DATA | Call by reference | Type reference (TYPE) | SUBSYS_DATA_TAB_T | 20090323 |
Method FILL_EXTRACTOR_DATA on class CL_DB2_DBH_SUBSYS has no exception.
Method GEN_EXTRACTOR_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 | 20090323 | ||
| 2 | Changing |
SQL_STMT | Call by reference | Type reference (TYPE) | STRING | DB2-DBH: Extractor Select Statement | 20090323 |
Method GEN_EXTRACTOR_STMT on class CL_DB2_DBH_SUBSYS 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) | 20090323 |
Method GEN_HEADER_FIELDS on class CL_DB2_DBH_SUBSYS has no exception.
Method GET_NUM_RESTRICTED_OBJECTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
COUNT | Call by reference | Type reference (TYPE) | DBA_DBH_VALUE | DBA-DBH: Key/Value for Configuration Table | 20090323 | ||
| 2 | Exporting |
DATE | Call by reference | Type reference (TYPE) | DATS | Field of type DATS | 20090323 | ||
| 3 | Exporting |
TIME | Call by reference | Type reference (TYPE) | TIMS | Field of type TIMS | 20090323 |
Method GET_NUM_RESTRICTED_OBJECTS on class CL_DB2_DBH_SUBSYS has no exception.
Method TIMESTAMP_IN_INTERVAL Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
HI_DATE | Call by reference | Type reference (TYPE) | DATS | Field of type DATS | 20090323 | ||
| 2 | Importing |
HI_TIME | Call by reference | Type reference (TYPE) | TIMS | Field of type TIMS | 20090323 | ||
| 3 |  Returning |
IS_IN_INTERVAL | Value transfer | Type reference (TYPE) | ABAP_BOOL | 20090323 | |||
| 4 | Importing |
LO_DATE | Call by reference | Type reference (TYPE) | DATS | Field of type DATS | 20090323 | ||
| 5 | Importing |
LO_TIME | Call by reference | Type reference (TYPE) | TIMS | Field of type TIMS | 20090323 | ||
| 6 | Importing |
TS_DATE | Call by reference | Type reference (TYPE) | DATS | Field of type DATS | 20090323 | ||
| 7 | Importing |
TS_TIME | Call by reference | Type reference (TYPE) | TIMS | Field of type TIMS | 20090323 |
Method TIMESTAMP_IN_INTERVAL on class CL_DB2_DBH_SUBSYS has no exception.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 740 |
