DB6PMSQ_DBS - DB6: Temporary database store for SQL Cache
DB6: Temporary database store for SQL Cache information is stored in SAP table DB6PMSQ_DBS.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".
Fields for table DB6PMSQ_DBS
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | DBA Cockpit: System Identification | X | DBA_SYSID | CHAR | 8 | |
| COMPTIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | X | DB6TSTAMP | CHAR | 14 | |
| PARTITN | Partition Number | X | INT4 | 4 | ||
| ARTIF_KEY | artif_key: Artificial Key for Uniqueness | X | INT4 | 4 | ||
| CALLERFLAG | Who Has Called this Program | X | CHAR | 1 | ||
| DBMSTRTTME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | ||
| PRGVERS | Version of Program Inserted this Row | CHAR | 20 | |||
| NUM_EXECUT | num_executions: Number of Executions | DEC | 12 | |||
| NUM_COMPIL | num_compilations: Number of Compilations | DEC | 12 | |||
| PREPTWORST | prep_time_worst: Worst Preparation Time (ms) | DEC | 12 | |||
| PREPTBEST | prep_time_best: Best Preparation Time (ms) | DEC | 12 | |||
| INT_RW_DEL | int_rows_deleted: Rows Deleted | DEC | 12 | |||
| INT_RW_INS | int_rows_inserted: Rows Inserted | DEC | 12 | |||
| RW_READ | rows_read: Rows Read | DEC | 12 | |||
| INT_RW_UPD | int_rows_updated: Rows Updated | DEC | 12 | |||
| RW_WRITTEN | rows_written: Rows Written | DEC | 12 | |||
| STMT_SORTS | stmt_sorts: Statement Sorts | DEC | 12 | |||
| TOTEXETS | total_exec_time_s: Total Execution Time (sec) | DEC | 12 | |||
| TOTEXETMS | total_exec_time_ms: Total Execution Time (ms) | DEC | 12 | |||
| TOTUSRCTS | tot_u_cpu_time_s: Total User CPU Time (sec) | DEC | 12 | |||
| TOTUSRCTMS | tot_u_cpu_time_ms: Total User CPU Time (ms) | DEC | 12 | |||
| TOTSYSCTS | tot_s_cpu_time_s: Total System CPU Time (sec) | DEC | 12 | |||
| TOTSYSCTMS | tot_s_cpu_time_ms: Total System CPU Time (ms) | DEC | 12 | |||
| DB_NAME | DB6: General identifier | DB6IDENT | CHAR | 20 | ||
| PL_D_LRS | pool_data_l_reads | DEC | 12 | |||
| PL_D_PRS | pool_data_p_reads | DEC | 12 | |||
| PL_I_LRS | pool_index_l_reads | DEC | 12 | |||
| PL_I_PRS | pool_index_p_reads | DEC | 12 | |||
| PL_TD_LRS | pool_temp_data_l_reads | DEC | 12 | |||
| PL_TD_PRS | pool_temp_data_p_reads | DEC | 12 | |||
| PL_TI_LRS | pool_temp_index_l_reads | DEC | 12 | |||
| PL_TI_PRS | pool_temp_index_p_reads | DEC | 12 | |||
| SORT_OVERFLOWS | sort_overflows | DEC | 12 | |||
| TOTAL_SORT_TIME | total_sort_time | DEC | 12 | |||
| PL_XDA_LRS | pool_xda_l_reads | DEC | 12 | |||
| PL_XDA_PRS | pool_xda_p_reads | DEC | 12 | |||
| PL_TEMP_XDA_LRS | pool_temp_xda_l_reads | DEC | 12 | |||
| PL_TEMP_XDA_PRS | pool_temp_Xda_p_reads | DEC | 12 | |||
| STATS_FABRICATE_ | DEC | 12 | ||||
| SYNC_RUNSTATS_TI | DEC | 12 | ||||
| ROWS_RETURNED | DEC | 12 | ||||
| STMT_PKGCACHE_ID | DEC | 12 | ||||
| INSERT_TIMESTAMP | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | DB6TSTAMP | CHAR | 14 | ||
| STMT_LEN | stmt_txtln: Length Field of LCHR stmt_txt | INT2 | 2 | |||
| STMT_TEXT | stmt_text: SQL Statement | LCHR | 32000 |