SAP Function Module DB6_PM_SQLCACHESNAP
DB6: SQL Cache Monitor - Get Snapshot for Dynamic SQL (RFC Layer 2)
Unsere Literaturempfehlung
SAP-Änderungs- und Transportmanagement: Architektur und Wartung der SAP-Systemlandschaft
Das Standardwerk zum Änderungs- und Transportmanagement in der 4. Auflage! In diesem Buch finden Sie alle Informationen, die Sie zum Planen, Implementieren und Warten von Systemlandschaften benötigen. Sie lernen die Grundlagen und die Bedienung aller relevanten Werkzeuge und erhalten detaillierte Anleitungen zur Änderungs- und Transportverwaltung. Diese Neuauflage berücksichtigt Neuerungen in den Bereichen SAP NetWeaver AS Java und Development Infrastructure, CTS+, SAP Solution Manager und Enhancement Packages. Bringen Sie ihr Wissen auf den neuesten Stand!
Bei amazon.de ansehen →
The Function Module DB6_PM_SQLCACHESNAP (DB6: SQL Cache Monitor - Get Snapshot for Dynamic SQL (RFC Layer 2)) is a standard Function Module in SAP ERP and is part of the function group SDB6PM within the package STU6.
Technical Information
| Function Module | DB6_PM_SQLCACHESNAP |
| Short Text | DB6: SQL Cache Monitor - Get Snapshot for Dynamic SQL (RFC Layer 2) |
| Function Group | SDB6PM |
| 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 | partition number | |
| 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_DB6PMSQ | LIKE | DB6PMSQ | DB6: Snapshot SQL Cache |
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 |
| HISTORY_INSERT_FAILED | retrieved data could not be inserted to database |
| INVALID_PARAMETER_SET | invalid or missing parameters |
| NODE_INFORMATION_NOT_FOUND | list of DB6 nodes (partitions) not found |
| NO_HISTORY_FOUND | required history records could not be read |