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.
| 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 |
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) |
This function module does not define any EXPORTING parameters.
This function module does not define any CHANGING 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 |
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 |