SAP ABAP Function Module /SDF/DLD_SQL_STMT_DB6 (Collection of top n SQL Statements)
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 - OO
Basic Data
| Function Module | /SDF/DLD_SQL_STMT_DB6 | Collection of top n SQL Statements |
| Function Group | /SDF/DB6_COLLEC_1 | New ST-PI collectors for DB6 |
| Program Name | /SDF/SAPLDB6_COLLEC_1 | |
| INCLUDE Name | /SDF/LDB6_COLLEC_1U01 |
Parameters
| Type | Parameter Name | Typing | Associated Type | Default value | Optional | Pass Value | Short text |
|---|---|---|---|---|---|---|---|
 Importing |
TOP_TOTAL_EXEC_TIME | TYPE | I | 10 | |||
| Importing |
TOP_ROWS_READ | TYPE | I | 5 | |||
| Importing |
TOP_SORT_OVERFLOWS | TYPE | I | 5 | |||
| Importing |
TOP_TOTAL_USR_CPU_TIME | TYPE | I | 5 | |||
| Importing |
TOP_ROWS_WRITTEN | TYPE | I | 0 | |||
| Importing |
TOP_ROWS_RETURNED | TYPE | I | 5 | |||
| Importing |
TOP_LOGICAL_READS | TYPE | I | 0 | |||
| Importing |
DBCON | TYPE | DBCON-CON_NAME | Logical name for a database connection | |||
| Importing |
ADDONKEY | TYPE | /SDF/ADDONSTRUC-ADDONKEY | Generic key for any addon data collection | |||
 Tables |
DLD_DB6_GLOBALDATA | TYPE | /SDF/DB6_700_GLOBAL_DATA | Global Package Cache Data for DB6 | |||
| Tables |
DLD_DB6_ENVINFO | TYPE | /SDF/DB6_700_ENV_INFO | General Environment Info | |||
| Tables |
DLD_DB6_STATEMENTS_PKG | TYPE | /SDF/DB6_700_STATEMENTS | SQL Statement KPIs | |||
| Tables |
DLD_DB6_ST04_VIEW | TYPE | /SDF/DB6_700_ST04_VIEW | SQL Statement - DBA Cockpit view | |||
| Tables |
DLD_DB6_ARGUMENT | TYPE | /SDF/DB6_700_XPLARGU | DB6: ST-PI structure of EXPLAIN_ARGUMENT | |||
| Tables |
DLD_DB6_INSTANCE | TYPE | /SDF/DB6_700_XPLINST | DB6: ST-PI structure of EXPLAIN_INSTANCE | |||
| Tables |
DLD_DB6_OBJECT | TYPE | /SDF/DB6_700_XPLOBJ | DB6: ST-PI structure of EXPLAIN_OBJECT | |||
| Tables |
DLD_DB6_OPERATOR | TYPE | /SDF/DB6_700_XPLOPER | DB6: ST-PI structure of EXPLAIN_OPERATOR | |||
| Tables |
DLD_DB6_PREDICATE | TYPE | /SDF/DB6_700_XPLPRED | DB6: ST-PI structure of EXPLAIN_PREDICATE | |||
| Tables |
DLD_DB6_STATEMENT | TYPE | /SDF/DB6_700_XPLSTMT | DB6: ST-PI structure of EXPLAIN_STATEMENT | |||
| Tables |
DLD_DB6_STREAM | TYPE | /SDF/DB6_700_XPLSTRM | DB6: ST-PI structure of EXPLAIN_STREAM | |||
| Tables |
DLD_DB6_SYSTABLES | TYPE | /SDF/DB6_700_XPLTABL | DB6: ST-PI structure of SYSCAT.TABLES | |||
| Tables |
DLD_DB6_SYSINDEXES | TYPE | /SDF/DB6_700_XPLINDX | DB6: ST-PI structure of SYSCAT.INDEXES | |||
| Tables |
DLD_DB6_SYSCOLUMNS | TYPE | /SDF/DB6_700_XPLCOLS | DB6: ST-PI structure on SYSCAT.COLUMNS | |||
| Tables |
DLD_DB6_SYSNODES | TYPE | /SDF/DB6_700_XPLNODE | DB6: ST-PI EXPLAIN: syscat.nodegroups+syscat.nodegroupdef | |||
| Tables |
DLD_DB6_DIAGNOSTICS | TYPE | /SDF/DB6_700_XPLDIAG | DB6: ST-PI EXPLAIN Table EXPLAIN_DIAGNOSTICS | |||
| Tables |
DLD_DB6_SYSINDCOLUSE | TYPE | /SDF/DB6_700_XPLIXCOLS | DB6: ST-PI structure of SYSCAT.INDEXCOLUSE | |||
| Tables |
DLD_DB6_GRAPH | TYPE | /SDF/DB6_700_EXPL_GRAPH | Graphical output of SQL statement | |||
| Tables |
DLD_DB6_TBL_HDR_DDIC | TYPE | /SDF/SQLDSE11TH | SQL Download SE11 Table columns | |||
| Tables |
DLD_DB6_TBL_FIELDS_DDIC | TYPE | /SDF/SQLDSE11TP | SQL Download SE11 Table columns | |||
| Tables |
DLD_DB6_INDX_HDR_DDIC | TYPE | /SDF/SQLDSE11IH | SQL Download SE11 Index header | |||
| Tables |
DLD_DB6_INDX_FIELDS_DDIC | TYPE | /SDF/SQLDSE11IP | SQL Download SE11 Index positions | |||
| Tables |
DLD_DB6_PROGDIR | TYPE | /SDF/DB6_700_PROGDIR | Program information | |||
| Tables |
DLD_DB6_ABAPSOURCE | TYPE | /SDF/DB6_700_ABAPSRC | ABAP Source Code | |||
Processing Type
| Normal Function Module | |
 Remote-Enabled Module |
BaseXML supported |
| Update Module | Start immediately |
| Immediate Start, No Restart | |
| Start Delayed | |
| Coll.run | |
| JAVA Module Callable from ABAP | |
| Remote-Enabled JAVA Module | |
| Module Callable from JAVA |
History
| Last changed by/on | SAP | 20110909 |
| SAP Release Created in | 2008_1_700 |
