SAP ABAP Class /SDF/CL_DB6_SQL_STMT (SQL Statement Detailed KPIs)
Hierarchy
☛
ST-PI (Software Component) SAP Solution Tools Plug-In
⤷
SV-SMG-SDD (Application Component) Service Data Download
⤷
/SDF/DB6_INFR_7X (Package) Data Collectors for DB6 - OO
ST-PI (Software Component) SAP Solution Tools Plug-In⤷
SV-SMG-SDD (Application Component) Service Data Download⤷
/SDF/DB6_INFR_7X (Package) Data Collectors for DB6 - OOProperties
| Class | /SDF/CL_DB6_SQL_STMT | |
| Short Description | SQL Statement Detailed KPIs | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | /SDF/DB6_INFR_7X | Data Collectors for DB6 - OO |
| Created | 20110118 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class /SDF/CL_DB6_SQL_STMT has no forward declaration.
Interfaces
Class /SDF/CL_DB6_SQL_STMT has no interface implemented.
Friends
Class /SDF/CL_DB6_SQL_STMT has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | CONNECTION |
Instance attribute | Public | Type reference (TYPE) | DBCON-CON_NAME | Logical name for a database connection | 20110128 | ||
| 2 | DBPARTITIONNUM |
Instance attribute | Public | Type reference (TYPE) | I | 20110118 | |||
| 3 | DB_CON |
Instance attribute | Protected | Type reference (TYPE) | DBCON-CON_NAME | Logical name for a database connection | 20110118 | ||
| 4 | DB_FIXPACK |
Instance attribute | Public | Type reference (TYPE) | I | 20110118 | |||
| 5 | DB_RELEASE |
Instance attribute | Public | See coding | 20110118 | ||||
| 6 | INT_ROWS_DELETED |
Instance attribute | Public | See coding | 20110118 | ||||
| 7 | INT_ROWS_INSERTED |
Instance attribute | Public | See coding | 20110118 | ||||
| 8 | INT_ROWS_UPDATED |
Instance attribute | Public | See coding | 20110118 | ||||
| 9 | NUM_COMPILATIONS |
Instance attribute | Public | See coding | 20110118 | ||||
| 10 | NUM_EXECUTIONS |
Instance attribute | Public | See coding | 20110118 | ||||
| 11 | POOL_DATA_L_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 12 | POOL_DATA_P_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 13 | POOL_INDEX_L_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 14 | POOL_INDEX_P_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 15 | POOL_TEMP_DATA_L_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 16 | POOL_TEMP_DATA_P_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 17 | POOL_TEMP_INDEX_L_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 18 | POOL_TEMP_INDEX_P_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 19 | POOL_TEMP_XDA_L_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 20 | POOL_TEMP_XDA_P_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 21 | POOL_XDA_L_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 22 | POOL_XDA_P_READS |
Instance attribute | Public | See coding | 20110118 | ||||
| 23 | PREP_TIME_BEST |
Instance attribute | Public | See coding | 20110118 | ||||
| 24 | PREP_TIME_WORST |
Instance attribute | Public | See coding | 20110118 | ||||
| 25 | ROWS_READ |
Instance attribute | Public | See coding | 20110118 | ||||
| 26 | ROWS_RETURNED |
Instance attribute | Public | See coding | 20110914 | ||||
| 27 | ROWS_WRITTEN |
Instance attribute | Public | See coding | 20110118 | ||||
| 28 | SNAPSHOT_TIMESTAMP |
Instance attribute | Public | Type reference (TYPE) | CHAR32 | 20110118 | |||
| 29 | SORT_OVERFLOWS |
Instance attribute | Public | See coding | 20110118 | ||||
| 30 | STATS_FABRICATE_TIME |
Instance attribute | Public | See coding | 20110123 | ||||
| 31 | STMT_ID |
Instance attribute | Public | Type reference (TYPE) | CHAR32 | Character field, length 32 | 20110118 | ||
| 32 | STMT_SORTS |
Instance attribute | Public | See coding | 20110118 | ||||
| 33 | STMT_TEXT |
Instance attribute | Public | Type reference (TYPE) | STRING | 20110118 | |||
| 34 | SYNC_RUNSTATS_TIME |
Instance attribute | Public | See coding | 20110123 | ||||
| 35 | TOTAL_EXEC_TIME |
Instance attribute | Public | See coding | 20110118 | ||||
| 36 | TOTAL_EXEC_TIME_MS |
Instance attribute | Public | See coding | 20110118 | ||||
| 37 | TOTAL_SORT_TIME |
Instance attribute | Public | See coding | 20110118 | ||||
| 38 | TOTAL_SYS_CPU_TIME |
Instance attribute | Public | See coding | 20110118 | ||||
| 39 | TOTAL_SYS_CPU_TIME_MS |
Instance attribute | Public | See coding | 20110118 | ||||
| 40 | TOTAL_USR_CPU_TIME |
Instance attribute | Public | See coding | 20110118 | ||||
| 41 | TOTAL_USR_CPU_TIME_MS |
Instance attribute | Public | See coding | 20110118 | ||||
| 42 | T_ENV_INFO |
Instance attribute | Public | Type reference (TYPE) | _T_ENV_INFO | 20110123 | |||
| 43 | T_METRICS |
Instance attribute | Public | Type reference (TYPE) | _T_METRICS | 20110118 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CONSTRUCTOR |
Instance method | Public | Constructor | CONSTRUCTOR | 20110118 |
| 2 | GET_STATEMENT_FROM_HIST |
Instance method | Public | Method | Get Statement from History Table | 20110118 |
| 3 | GET_STATEMENT_FROM_PKG |
Instance method | Public | Method | Get Statement Snapshot directly from Package Cache | 20110118 |
| 4 | RETRIEVE_ENV_INFO |
Instance method | Public | Method | Get DB2 environment info | 20110123 |
Events
Class /SDF/CL_DB6_SQL_STMT has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | _S_ENV_INFO | Public | See coding | 20110123 | BEGIN OF _s_env_info,
num_dbpartitions TYPE i,
inst_name TYPE c LENGTH 128,
inst_ptr_size TYPE i,
service_level TYPE c LENGTH 128,
bld_level TYPE c LENGTH 128,
ptf TYPE c LENGTH 128,
fixpack_num TYPE i,
END OF _s_env_info
|
||
| 2 | _S_ERRORS | Public | See coding | 20110118 | BEGIN OF _s_errors, " for error handling
sql_code TYPE i,
sql_msg(250) TYPE c,
END OF _s_errors
|
||
| 3 | _S_METRICS | Public | See coding | 20110118 | BEGIN OF _s_metrics,
snapshot_timestamp TYPE char32,
num_executions(12) TYPE p DECIMALS 0,
total_exec_time(12) TYPE p DECIMALS 0,
total_exec_time_ms(12) TYPE p DECIMALS 0,
rows_read(12) TYPE p DECIMALS 0,
num_compilations(12) TYPE p DECIMALS 0,
prep_time_worst(12) TYPE p DECIMALS 0,
prep_time_best(12) TYPE p DECIMALS 0,
int_rows_deleted(12) TYPE p DECIMALS 0,
int_rows_inserted(12) TYPE p DECIMALS 0,
int_rows_updated(12) TYPE p DECIMALS 0,
rows_written(12) TYPE p DECIMALS 0,
stmt_sorts(12) TYPE p DECIMALS 0,
sort_overflows(12) TYPE p DECIMALS 0,
total_sort_time(12) TYPE p DECIMALS 0,
pool_data_l_reads(12) TYPE p DECIMALS 0,
pool_data_p_reads(12) TYPE p DECIMALS 0,
pool_temp_data_l_reads(12) TYPE p DECIMALS 0,
pool_temp_data_p_reads(12) TYPE p DECIMALS 0,
pool_index_l_reads(12) TYPE p DECIMALS 0,
pool_index_p_reads(12) TYPE p DECIMALS 0,
pool_temp_index_l_reads(12) TYPE p DECIMALS 0,
pool_temp_index_p_reads(12) TYPE p DECIMALS 0,
pool_xda_l_reads(12) TYPE p DECIMALS 0,
pool_xda_p_reads(12) TYPE p DECIMALS 0,
pool_temp_xda_l_reads(12) TYPE p DECIMALS 0,
pool_temp_xda_p_reads(12) TYPE p DECIMALS 0,
total_usr_cpu_time(12) TYPE p DECIMALS 0,
total_usr_cpu_time_ms(12) TYPE p DECIMALS 0,
total_sys_cpu_time(12) TYPE p DECIMALS 0,
total_sys_cpu_time_ms(12) TYPE p DECIMALS 0,
dbpartitionnum TYPE i,
stats_fabricate_time(12) TYPE p DECIMALS 2,
sync_runstats_time(12) TYPE p DECIMALS 2,
rows_returned(12) TYPE p DECIMALS 0,
END OF _s_metrics
|
||
| 4 | _T_ENV_INFO | Public | See coding | 20110123 | _t_env_info TYPE STANDARD TABLE OF _s_env_info
|
||
| 5 | _T_ERRORS | Public | See coding | 20110118 | _t_errors TYPE STANDARD TABLE OF _s_errors
|
||
| 6 | _T_METRICS | Public | See coding | 20110118 | _t_metrics TYPE STANDARD TABLE OF _s_metrics
|
Method Signatures
Method CONSTRUCTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_CONNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20110201 | ||
| 2 | Importing |
I_HIST_TAB | Call by reference | Type reference (TYPE) | CHAR32 | History Table Name | 20110118 | ||
| 3 | Importing |
I_NUM_EXECUTIONS | Call by reference | Type reference (TYPE) | DB6DEC22S | DB6: signed decimal for integer64 data | 20110118 | ||
| 4 | Importing |
I_STMTID | Call by reference | Type reference (TYPE) | CHAR32 | Character field, length 32 | 20110118 | ||
| 5 | Importing |
I_STMT_TEXT | Call by reference | Type reference (TYPE) | STRING | 20110118 |
Method CONSTRUCTOR on class /SDF/CL_DB6_SQL_STMT has no exception.
Method GET_STATEMENT_FROM_HIST Signature
Method GET_STATEMENT_FROM_HIST on class /SDF/CL_DB6_SQL_STMT has no parameter.
Method GET_STATEMENT_FROM_HIST on class /SDF/CL_DB6_SQL_STMT has no exception.
Method GET_STATEMENT_FROM_PKG Signature
Method GET_STATEMENT_FROM_PKG on class /SDF/CL_DB6_SQL_STMT has no parameter.
Method GET_STATEMENT_FROM_PKG on class /SDF/CL_DB6_SQL_STMT has no exception.
Method RETRIEVE_ENV_INFO Signature
Method RETRIEVE_ENV_INFO on class /SDF/CL_DB6_SQL_STMT has no parameter.
Method RETRIEVE_ENV_INFO on class /SDF/CL_DB6_SQL_STMT has no exception.
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 2008_1_700 |
