SAP Function Module DB6_PM_SQLCACHE
DB6: Get Snapshot for Dynamic SQL, SQL Cache Monitor (RFC Layer 1)
Unsere Literaturempfehlung
Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework
Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.
Bei amazon.de ansehen →
The Function Module DB6_PM_SQLCACHE (DB6: Get Snapshot for Dynamic SQL, SQL Cache Monitor (RFC Layer 1)) is a standard Function Module in SAP ERP and is part of the function group SDB6PMST04 within the package STU6.
Technical Information
| Function Module | DB6_PM_SQLCACHE |
| Short Text | DB6: Get Snapshot for Dynamic SQL, SQL Cache Monitor (RFC Layer 1) |
| Function Group | SDB6PMST04 |
| Package | STU6 |
| Module Type | Remote-Enabled |
Importing Parameters
These are the IMPORTING parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| ACTION | TYPE | I | action | |
| CALLERFLAG | LIKE | DB6PMSQ-CALLERFLAG | wo has called this program | |
| COMPTIME | LIKE | DB6PMSQ-COMPTIME | timestamp (YYYYMMDDHHMMSS) | |
| CONNECTION | LIKE | DBCON-CON_NAME | Logical name for a database connection | |
| MAXOBJ | TYPE | I | DB6: max rows to return, if maxobj_active - 'X' | |
| MAXOBJ_ACTIVE | LIKE | DB6PMHT_HD-STATTYPE | DB6: is maxobj relevant | |
| NUM_EXECUT | LIKE | DB6PMSQ-NUM_EXECUT | number of executions | |
| PARTITN | LIKE | DB6PMSQ-PARTITN | prtition nmber | |
| PREPTBEST | LIKE | DB6PMSQ-PREPTBEST | best preparation time (ms) | |
| PREPTWORST | LIKE | DB6PMSQ-PREPTWORST | worst preparation time (ms) | |
| RW_READ | LIKE | DB6PMSQ-RW_READ | rows read | |
| RW_WRITTEN | LIKE | DB6PMSQ-RW_WRITTEN | rows written | |
| STMT_PART | LIKE | DDSHIFACE-VALUE | part of statement | |
| TOTEXECT | LIKE | DB6PMSQ-TOTEXETMS | total execution time (ms) |
Exporting Parameters
This function module does not define any EXPORTING parameters.
Changing Parameters
This function module does not define any CHANGING parameters.
Table Parameters
These are the TABLE parameters of this function module.
| Parameter Name | Type | Associated Type | Default Value | Short Text |
|---|---|---|---|---|
| IT_DB6PMSQC | LIKE | DB6PMSQC | DB6: Snapshot SQL Cache + percentage |
Exceptions
These are the Exceptions of this function module.
| Exception Name | Short Text |
|---|---|
| C_CALL_FAILED | error processing of C call to DB collector RD |
| ERROR_CALCULATING | error while calculating some figures |
| INVALID_PARAMETER_SET | invalid or missing parameters |
| NO_SELDATA_AVAILABLE | no data available fitting the selection criteria |