SAP ABAP Class CL_MSS_DBH_TABLESIZES (MSSQL DBH Extractor : Daily table size)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-MSS (Application Component) Microsoft SQL Server
⤷
SMSS_TOOLS (Package) Utilities for MS SQL Server
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-MSS (Application Component) Microsoft SQL Server⤷
SMSS_TOOLS (Package) Utilities for MS SQL ServerMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_MSS_DBH_EXTRACTOR | MSSQL DBH Extractor superclass | 20090319 |
Properties
| Class | CL_MSS_DBH_TABLESIZES | |
| Short Description | MSSQL DBH Extractor : Daily table size | |
| Super Class | CL_MSS_DBH_EXTRACTOR | MSSQL DBH Extractor superclass |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | SMSS_TOOLS | Utilities for MS SQL Server |
| Created | 20090319 | SAP |
| Last change | 20130531 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_MSS_DBH_TABLESIZES has no forward declaration.
Interfaces
Class CL_MSS_DBH_TABLESIZES has no interface implemented.
Friends
Class CL_MSS_DBH_TABLESIZES has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | COMP_DELT |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of time delta | 20090322 | ||
| 2 | COMP_DELTA_RESERVED |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of reserved kB delta | 20090322 | ||
| 3 | COMP_DELTA_ROW_COUNT |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of row count delta | 20090322 | ||
| 4 | COMP_DELTA_USED |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of used kB delta | 20090322 | ||
| 5 | COMP_DURA |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of duration | 20090322 | ||
| 6 | COMP_INDEXNAME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of index name | 20090322 | ||
| 7 | COMP_RESERVED_KB |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of kB reserved | 20090322 | ||
| 8 | COMP_ROW_COUNT |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of row count | 20090322 | ||
| 9 | COMP_SCHEMA |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of schema name | 20090322 | ||
| 10 | COMP_STATS_DATE |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of statistics date | 20090322 | ||
| 11 | COMP_STATS_TIME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of statistics time | 20091023 | ||
| 12 | COMP_TABLENAME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of table name | 20090322 | ||
| 13 | COMP_USED_KB |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of kB used | 20090322 | ||
| 14 | MSSDELT |
Instance attribute | Protected | Type reference (TYPE) | I | Delta [sec] since previous measurement | 20090322 | ||
| 15 | MSSDURA |
Instance attribute | Protected | Type reference (TYPE) | I | Duration [sec] of current measurement | 20090322 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | COLUMN_DEF |
Instance method | Protected | Method | Define the local HEADER and mapping data | 20090322 |
| 2 | GET_PREVIOUS_TS |
Instance method | Protected | Method | Read the timestamp of the baseline snapshot | 20090322 |
| 3 | GET_RHOST |
Instance method | Private | Method | Get the current NetBIOS hostname | 20100306 |
| 4 | READ_TABSIZES |
Instance method | Protected | Method | Read the table sizes from sap_coll_tabsizes | 20090322 |
Events
Class CL_MSS_DBH_TABLESIZES has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | TABSIZE_L | Protected | See coding | Return line type of sap_coll_tabsizes | 20090322 | BEGIN OF TABSIZE_L ,
SCHEMA(128) TYPE C ,
TABLENAME(128) TYPE C ,
INDEXNAME(128) TYPE C ,
USED_KB(12) TYPE P DECIMALS 0 ,
RESERVED_KB(12) TYPE P DECIMALS 0 ,
ROW_COUNT(12) TYPE P DECIMALS 0 ,
DELTA_USED(12) TYPE P DECIMALS 0 ,
DELTA_RESERVED(12) TYPE P DECIMALS 0 ,
DELTA_ROW_COUNT(12) TYPE P DECIMALS 0 ,
STATS_DATE(22) TYPE C ,
END OF TABSIZE_L
|
|
| 2 | TABSIZE_T | Protected | See coding | Return table type of sap_coll_tabsizes | 20090322 | TABSIZE_T TYPE STANDARD TABLE OF TABSIZE_L
|
Method Signatures
Method COLUMN_DEF 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) | 20090322 |
Method COLUMN_DEF on class CL_MSS_DBH_TABLESIZES has no exception.
Method GET_PREVIOUS_TS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
PREVIOUS_D | Call by reference | Type reference (TYPE) | D | Date | 20090322 | ||
| 2 | Exporting |
PREVIOUS_T | Call by reference | Type reference (TYPE) | T | Time | 20090322 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090322 |
Method GET_RHOST Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
CURRCON | Call by reference | Type reference (TYPE) | MSSCONNDATA | MSSQL multi-connect : Complete connection information | 20100306 | ||
| 2 |  Returning |
RHOST | Value transfer | Type reference (TYPE) | STRING | NetBIOS hostname | 20100306 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20100306 |
Method READ_TABSIZES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
END_TS | Value transfer | Type reference (TYPE) | DBCOLL_L-TIMESTMP | End of extraction interval | 20110624 | ||
| 2 | Exporting |
SIZETAB | Call by reference | Type reference (TYPE) | TABSIZE_T | Return table type of sap_coll_tabsizes | 20090322 | ||
| 3 | Importing |
START_TS | Value transfer | Type reference (TYPE) | DBCOLL_L-TIMESTMP | Begin of extraction interval | 20110624 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090322 |
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 720 |
