SAP ABAP Class /SDF/CL_DB6_SQL_WL (SQL Workload)
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_WL | |
| Short Description | SQL Workload | |
| 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_WL has no forward declaration.
Interfaces
Class /SDF/CL_DB6_SQL_WL has no interface implemented.
Friends
Class /SDF/CL_DB6_SQL_WL has no friend class.
Attributes
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CONSTRUCTOR |
Instance method | Public | Constructor | CONSTRUCTOR | 20110118 |
| 2 | CREATE_HASH_FUNCTION |
Instance method | Public | Method | Create Hash Key Function on DB | 20110118 |
| 3 | CREATE_WL_FROM_SYSTEM |
Instance method | Public | Method | Create a SQL statement workload from system | 20110118 |
| 4 | CREATE_WL_FROM_SYSTEM_ADDON |
Instance method | Public | Method | Create a SQL statement workload from system | 20120316 |
| 5 | CREATE_WL_FROM_SYSTEM_XTRA |
Instance method | Public | Method | Get new WL from user selection | 20120723 |
| 6 | DROP_HASH_FUNCTION |
Instance method | Public | Method | Drop the created Hash Key Function on DB | 20111228 |
| 7 | EXECUTE_WL_COLLECTION |
Instance method | Public | Method | Execute Workload Collection | 20110118 |
| 8 | EXECUTE_WL_COLLECTION_ADDON |
Instance method | Public | Method | Execute Workload Collection | 20120316 |
| 9 | GET_METRICS |
Instance method | Public | Method | 20110118 | |
| 10 | RETRIEVE_ENV_INFO |
Instance method | Public | Method | Get DB2 environment info | 20110118 |
| 11 | RETRIEVE_TOTALS |
Instance method | Public | Method | Get the total of some KPIs for % calculation of workload | 20110118 |
| 12 | SET_CONNECTION_NAME |
Instance method | Public | Method | Set sytem connection | 20110126 |
| 13 | SET_WL_PARAM |
Instance method | Public | Method | Set parameters for workload collection | 20110118 |
Events
Class /SDF/CL_DB6_SQL_WL has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | _S_ENV_INFO | Public | See coding | 20110118 | 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(26) TYPE c,
stmt_id 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 | _S_SOURCE | Public | See coding | 20110119 | BEGIN OF _s_source,
stmt_id TYPE char32,
stmt_text TYPE string,
abap_source(40) TYPE c,
abap_line(8) TYPE c,
END OF _s_source
|
||
| 5 | _S_STATEMENTS | Public | See coding | 20110118 | BEGIN OF _s_statements,
stmt_id TYPE char32,
stmt_num TYPE i,
stmt_text TYPE string,
sql_stmt_ref TYPE REF TO /sdf/cl_db6_sql_stmt,
sql_expl_ref TYPE REF TO /sdf/cl_db6_sql_expl,
snapshot_timestamp(26) TYPE c,
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,
abap_source(40) TYPE c,
abap_line(8) TYPE c,
analysis_id(26) TYPE c,
total_exec_time_millisec(12) TYPE p DECIMALS 0, "Calculated in
"milliseconds
total_exec_time_pc(12) TYPE p DECIMALS 2, "Calc. in %
average_exec_time_millisec(12) TYPE p DECIMALS 0, "Calculated in
"milliseconds
buffer_quality_pc(12) TYPE p DECIMALS 2, "Calc. in %
total_usr_cpu_time_millisec(12) TYPE p DECIMALS 0, "Calculated in
"milliseconds
total_sys_cpu_time_millisec(12) TYPE p DECIMALS 0, "Calculated in
"milliseconds
rows_read_pc(12) TYPE p DECIMALS 2, "Calc. in %
rows_written_pc(12) TYPE p DECIMALS 2, "Calc. in %
stats_fabricate_time(12) TYPE p DECIMALS 2,
sync_runstats_time(12) TYPE p DECIMALS 2,
rows_returned(12) TYPE p DECIMALS 0,
rows_returned_pc(12) TYPE p DECIMALS 2, "Calc. in %
END OF _s_statements
|
||
| 6 | _S_TOTALS | Public | See coding | 20110118 | BEGIN OF _s_totals,
stmt_key TYPE char32,
num_executions(12) TYPE p DECIMALS 0,
total_exec_time_millisec(12) TYPE p DECIMALS 0,
total_usr_cpu_time_millisec(12) TYPE p DECIMALS 0,
total_sys_cpu_time_millisec(12) TYPE p DECIMALS 0,
rows_written(12) TYPE p DECIMALS 0,
rows_read(12) TYPE p DECIMALS 0,
pool_data_l_reads(12) TYPE p DECIMALS 0,
pool_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_data_l_reads(12) TYPE p DECIMALS 0,
pool_temp_data_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,
sort_overflows(12) TYPE p DECIMALS 0,
total_sort_time(12) TYPE p DECIMALS 0,
analysis_id(26) TYPE c,
rows_returned(12) TYPE p DECIMALS 0,
END OF _s_totals
|
||
| 7 | _T_ENV_INFO | Public | See coding | 20110118 | _t_env_info TYPE STANDARD TABLE OF _s_env_info
|
||
| 8 | _T_ERRORS | Public | See coding | 20110118 | _t_errors TYPE STANDARD TABLE OF _s_errors
|
||
| 9 | _T_METRICS | Public | See coding | 20110118 | _t_metrics TYPE STANDARD TABLE OF _s_metrics
|
||
| 10 | _T_SOURCE | Public | See coding | 20110119 | _t_source TYPE STANDARD TABLE OF _s_source
|
||
| 11 | _T_STATEMENTS | Public | See coding | 20110118 | _t_statements TYPE STANDARD TABLE OF _s_statements
|
||
| 12 | _T_TOTALS | Public | See coding | 20110118 | _t_totals TYPE STANDARD TABLE OF _s_totals
|
Method Signatures
Method CONSTRUCTOR Signature
Method CONSTRUCTOR on class /SDF/CL_DB6_SQL_WL has no parameter.
Method CONSTRUCTOR on class /SDF/CL_DB6_SQL_WL has no exception.
Method CREATE_HASH_FUNCTION Signature
Method CREATE_HASH_FUNCTION on class /SDF/CL_DB6_SQL_WL has no parameter.
Method CREATE_HASH_FUNCTION on class /SDF/CL_DB6_SQL_WL has no exception.
Method CREATE_WL_FROM_SYSTEM Signature
Method CREATE_WL_FROM_SYSTEM on class /SDF/CL_DB6_SQL_WL has no parameter.
Method CREATE_WL_FROM_SYSTEM on class /SDF/CL_DB6_SQL_WL has no exception.
Method CREATE_WL_FROM_SYSTEM_ADDON Signature
Method CREATE_WL_FROM_SYSTEM_ADDON on class /SDF/CL_DB6_SQL_WL has no parameter.
Method CREATE_WL_FROM_SYSTEM_ADDON on class /SDF/CL_DB6_SQL_WL has no exception.
Method CREATE_WL_FROM_SYSTEM_XTRA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_ADDON_STMTKEY | Call by reference | Type reference (TYPE) | ANY | 20120723 |
Method CREATE_WL_FROM_SYSTEM_XTRA on class /SDF/CL_DB6_SQL_WL has no exception.
Method DROP_HASH_FUNCTION Signature
Method DROP_HASH_FUNCTION on class /SDF/CL_DB6_SQL_WL has no parameter.
Method DROP_HASH_FUNCTION on class /SDF/CL_DB6_SQL_WL has no exception.
Method EXECUTE_WL_COLLECTION Signature
Method EXECUTE_WL_COLLECTION on class /SDF/CL_DB6_SQL_WL has no parameter.
Method EXECUTE_WL_COLLECTION on class /SDF/CL_DB6_SQL_WL has no exception.
Method EXECUTE_WL_COLLECTION_ADDON Signature
Method EXECUTE_WL_COLLECTION_ADDON on class /SDF/CL_DB6_SQL_WL has no parameter.
Method EXECUTE_WL_COLLECTION_ADDON on class /SDF/CL_DB6_SQL_WL has no exception.
Method GET_METRICS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
R_T_METRICS | Value transfer | Object reference (TYPE REF TO) | DATA | 20110118 |
Method GET_METRICS on class /SDF/CL_DB6_SQL_WL has no exception.
Method RETRIEVE_ENV_INFO Signature
Method RETRIEVE_ENV_INFO on class /SDF/CL_DB6_SQL_WL has no parameter.
Method RETRIEVE_ENV_INFO on class /SDF/CL_DB6_SQL_WL has no exception.
Method RETRIEVE_TOTALS Signature
Method RETRIEVE_TOTALS on class /SDF/CL_DB6_SQL_WL has no parameter.
Method RETRIEVE_TOTALS on class /SDF/CL_DB6_SQL_WL has no exception.
Method SET_CONNECTION_NAME 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-CON_NAME | Logical name for a database connection | 20110126 |
Method SET_CONNECTION_NAME on class /SDF/CL_DB6_SQL_WL has no exception.
Method SET_WL_PARAM Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_TOP_LOGICAL_READS | Call by reference | Type reference (TYPE) | I | 0 | 20110118 | ||
| 2 | Importing |
I_TOP_ROWS_READ | Call by reference | Type reference (TYPE) | I | 0 | 20110118 | ||
| 3 | Importing |
I_TOP_ROWS_RETURNED | Call by reference | Type reference (TYPE) | I | 0 | 20110914 | ||
| 4 | Importing |
I_TOP_ROWS_WRITTEN | Call by reference | Type reference (TYPE) | I | 0 | 20110118 | ||
| 5 | Importing |
I_TOP_SORT_OVERFLOWS | Call by reference | Type reference (TYPE) | I | 0 | 20110118 | ||
| 6 | Importing |
I_TOP_TOTAL_EXEC_TIME | Call by reference | Type reference (TYPE) | I | 20 | 20110118 | ||
| 7 | Importing |
I_TOP_TOTAL_USR_CPU_TIME | Call by reference | Type reference (TYPE) | I | 0 | 20110118 |
Method SET_WL_PARAM on class /SDF/CL_DB6_SQL_WL has no exception.
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 2008_1_700 |
