DB6PMSD SAP (DB6: Database Snapshot) Structure details

Dictionary Type: Structure
Description: DB6: Database Snapshot




ABAP Code to SELECT data from DB6PMSD
Related tables to DB6PMSD
Access table DB6PMSD




Structure field list including key, data, relationships and ABAP select examples

DB6PMSD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB6: Database Snapshot" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DB6PMSD TYPE DB6PMSD.

The DB6PMSD table consists of various fields, each holding specific information or linking keys about DB6: Database Snapshot data available in SAP. These include PARTITN (Partition Number), CALLERFLAG (Who Has Called this Program), DBMSTRTTME (DB6: Timestamp (Format: YYYYMMDDHHMMSS)), PRGVERS (Version of Program Inserted this Row).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP DB6PMSD structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
COMPTIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
PARTITN Partition Number0
CALLERFLAG Who Has Called this Program0
DBMSTRTTMEDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
PRGVERS Version of Program Inserted this Row0
IN_DB_ALIADB6: General identifier DB6IDENTCHAR20
DB_NAMEDB6: General identifier DB6IDENTCHAR20
DB_PATHDB6: File Path DB6PATHCHAR255DB6PATH
LCKS_HELD locks_held: Locks Currently Held0
LCK_WAITS lock_waits: Lock Waits Since First Connect0
LCK_W_TM lock_wait_time: Total Time Database Waited for Locks0
LCK_LSTIU lock_list_in_use: Total Lock List Memory in Use0
DEADLOCKS deadlocks: Deadlocks Since First DB Connect0
LCK_ESCALS lock_escals: Lock Escalations Since First DB Connect0
X_LCK_ESCA x_lock_escals: X Lock Escalations Since First DB Connect0
LCK_WTING locks_waiting: Agents Currently Waiting for Locks0
SRT_HP_ALO sort_heap_allocated: Total Sort Heap Allocated0
TOT_SORTS total_sorts: Number of Sorts Since First Connect0
TOT_SRT_TM total_sort_time: Elapsed Time Spent in Sorts0
SRT_OF sort_overflows: Number of Sort Overflows0
ACTIV_SORT active_sorts: Sorts Currently Active0
PL_D_LRS pool_data_l_reads: Pool Data Logical Reads Since Connect0
PL_D_PRS pool_data_p_reads: Pool Data Reads Since First Connect0
PL_D_WS pool_data_writes: Pool Data Writes Since First Connect0
PL_I_LRS pool_index_l_reads: Pool Index Logical Reads Since Connect0
PL_I_PRS pool_index_p_reads: Pool Index Reads Since First Connect0
PL_I_WS pool_index_writes: Pool Index Writes Since First Connect0
PL_RD_TM pool_read_time: Buffer Pool Read Time Since First Connect0
PL_WT_TM pool_write_time: Buffer Pool Write Time Since First Connect0
FLS_CLOSED files_closed: Files Closed Since First DB Connect0
CMMT_SQLST commit_sql_stmts: Number of COMMIT SQL Statements Since Conn0
RBCK_SQLST rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect0
DYN_SQLST dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect0
STC_SQLST static_sql_stmts: Number of Static SQL Statements Since Conn0
FAIL_SQLST failed_sql_stmts: Number of Failed SQL Stmts Since Connect0
SELC_SQLST select_sql_stmts: Number of SQL SELECT Stmts Since Connect0
DDL_SQLST ddl_sql_stmts: Number of Data Definition Language Statements0
UID_SQLST uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements0
INT_ATRBND int_auto_rebinds: Number of Auto Rebinds Since First Connect0
INT_RW_DEL int_rows_deleted: No. of Casc. Deletes Since First Connect0
INT_RW_UPD int_rows_updated: Number of Set Null Deletes Since Connect0
INT_CMMTS int_commits: Number of Int. COMMITs Since First Connect0
INT_RB int_rollbacks: Number of Int. ROLLBACKs Since First Connect0
INT_DL_RB int_deadlock_rollbacks: # of ROLLBACKs due to Deadlock Since0
RW_DELETED rows_deleted: Number of Rows Deleted Since Connect0
RW_INSRTED rows_inserted: Number of Rows Inserted Since Connect0
RW_UPDATED rows_updated: Number of Rows Updated Since Connect0
RW_SELECED rows_selected: Number of Rows Selected Since Connect0
BIND_PRECC binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.0
DB_CN_TMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
LAST_RESETDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
LAST_BKUPDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
TOTAL_CONS total_cons: Connects Since First DB Connect0
APL_CUR_CO appls_cur_cons: Applications Currently Connected0
APL_IN_DB2 appls_in_db2: Applications Executing in DB20
SEC_LGUSTP sec_log_used_top: Maximum Secondary Log Space Used0
TOT_LGUTOP tot_log_used_top: Maximum Total Log Space Used0
SEC_LGALLO sec_logs_allocated: Number of Secondary Logs Allocated0
NUM_SCDBS num_sec_dbase_structs: Secondary Database Information0
PL_A_IRS pool_async_index_reads: Asynchronous Pool Index Reads0
PL_D_TE pool_data_to_estore: No. of Pages Copied from BP to ExStor.0
PL_I_TE pool_index_to_estore: No. of Pages Copied from BP to ExStor.0
PL_I_FE pool_index_from_estore: No of Pages Copied from ExStor to BP0
PL_D_FEI pool_data_from_estorei: No of Pages Copied from ExStor to BP0
DB_STATUS db_status: Status of the Database0
LCK_TMOUT lock_timeouts: Number of Lock Timeouts Since First Connect0
CN_TOP connections_top: High Water Mark for Current Connections0
DB_HP_TOP db_heap_top: High Water Mark for Database Heap (Bytes)0
PL_A_DRS pool_async_data_reads: Asynchronous Pool Data Reads0
PL_A_DWS pool_async_data_writes: Asynchronous Pool Data Writes0
PL_A_IWS pool_async_index_writes: Asynchronous Pool Index Writes0
PL_A_RTM pool_async_read_time: Total Asynchronous Read Time0
PL_A_WTM pool_async_write_time: Total Asynchronous Write Time0
PL_A_DRRQ pool_async_data_read_reqs: No. of Asynchronous Read Requests0
PL_LSNGCL pool_lsn_gap_clns: LSN Gap Cleaner Triggers0
PL_DPSCL pool_drty_pg_steal_clns: Dirty Page Steal Cleaner Trig.0
PL_DPTCL pool_drty_pg_thrsh_clns: Dirty List Threshold Cleaner Trig.0
DIRCT_RDS direct_reads: Direct Reads Since First Connect0
DIRCT_WTS direct_writes: Direct Writes Since First Connect0
DIRCT_RRQS direct_read_reqs: Direct Read Requests0
DIRCT_WRQS direct_write_reqs: Direct Write Requests0
DIRCT_RTM direct_read_time: Direct Read Time Since First Connect0
DIRCT_WTM direct_write_time: Direct Write Time Since First Connect0
INT_RW_INS int_rows_inserted: Number of Rows Inserted for Trigger0
LOG_READS log_reads: Number of Log Pages Read Since First Connect0
LOG_WRITES log_writes: Number of Log Pages Read Since First Connect0
PKG_CA_LKU pkg_cache_lookups: Number of Section Lookups0
PKG_CA_INS pkg_cache_inserts: Number of Sections Inserted into Cache0
CATCA_LKU cat_cache_lookups: Number of Table Descriptor Lookups0
CATCA_INS cat_cache_inserts: Number of Table Descriptors Inserted0
CATCA_OF cat_cache_overflows: Number of Catalog Cache Overflows0
CATCA_HPFL cat_cache_heap_full: Number of Overflows due to DB Heap Full0
CAT_NODE catalog_node: Catalog Node Number0
TOT_SEC_CN total_sec_cons: Secondary Connects Since First Connect0
NUM_ASS_AG num_assoc_agents: Current Number of Agents Associated0
AGENTS_TOP agents_top: Maximum Number of Agents Associated at Once0
CRD_AG_TOP coord_agents_top: Max. No. of Coord. Agents Connected to DB0
DB_LOCAT db_location: Local or Remote to Application Snapshot0
SERV_PLATF server_platform: Operating System on Which DBM Runs0
CAT_ND_NMEDB6: Long identifier DB6LONGIDCHAR32
PF_WTTM prefetch_wait_time: Time Waited for Prefetch (ms)0
AP_SEC_LKU appl_section_lookups: Number of Section Lookups0
AP_SEC_INS appl_section_inserts: Number of Sections Inserted0
TOT_HAJN total_hash_joins: Number of Hash Joins0
TOT_HALOOP total_hash_loops: Number of Hash Loops0
HAJN_OF hash_join_overflows: Number of Hash Join Overflows0
HAJN_SM_OF hash_join_small_overflows: Small Hash Join Overflows0
TOT_LGUSED total_log_used: Log Space Used by Database0
TOT_LGAVL total_log_available: Log Space Available in Database0
UNREADPFPG unread_prefetch_pages: Unread prefetched pages0
PKG_NUM_OV pkg_cache_num_overflows: Package Cache Number Overflows0
PKG_SZ_TOP pkg_cache_size_top: Package Cache Size Top0
PL_TD_LRS pool_temp_data_l_reads0
PL_TD_PRS pool_temp_data_p_reads0
PL_TI_LRS pool_temp_index_l_reads0
PL_TI_PRS pool_temp_index_p_reads0
PL_A_IRRQ pool_async_indec_read_reqs0
CATCASZTOP cat_cache_size_top0
LOGREADTS 0
LOGREADTNS 0
LOGWRITS log_writes: Number of Log Pages Read Since First Connect0
LOGWRITNS 0
NUMLOGWRIO 0
NUMLOGRDIO 0
NUMLOGPPIO 0
NUMLOGBFUL 0
NUMLOGDFND 0
LOGREDOREC 0
LOGHELDDTY 0
ACTIVE_HASH_JOIN 0
DBNAME 0
PL_ASYNC_XDA_RDS 0
PL_ASYNC_XDA_RRQ 0
PL_ASYNC_XDA_WRT 0
PL_TEMP_XDA_L_RD 0
PL_TEMP_XDA_P_RD 0
POOL_XDA_L_READS 0
POOL_XDA_P_READS 0
POOL_XDA_WRITES 0
POST_SHRTHRS_HAJ 0
POST_SHRTHRS_SRT 0
SMALLEST_LOG_AVL 0
APPL_ID_OLDEST_X appl_id_oldest_xact0
ELPSD_EXC_TIM_MS elapsed_exec_time_ms0
ELPSD_EXC_TIM_S elapsed_exec_time_s0
NUM_DB_STORPATHS num_db_storage_paths0
NUM_INDOUBT_TRAN num_indoubt_trans0
PL_NO_VICTIM_BUF pool_no_victim_buffer0
ROWS_READ rows_read0
PRV_WS_NUM_OVFL priv_workspace_num_overflows0
PRV_WS_SCT_INSRT priv_workspace_section_inserts0
PRV_WS_SCT_LKUP priv_workspace_section_lookups0
PRV_WS_SIZE_TOP priv_workspace_size_top0
SHR_WS_NUM_OVFL shr_workspace_num_overflows0
SHR_WS_SCT_INSRT shr_workspace_section_inserts0
SHR_WS_SCT_LKUP shr_workspace_section_lookups0
SHR_WS_SIZE_TOP shr_workspace_size_top0
SORT_SHRHEAP_ALL sort_shrheap_allocated0
SORT_SHRHEAP_TOP sort_shrheap_top0
ACTIVE_OLAP_FUNCS 0
ASYNC_RUNSTATS 0
NUM_THRESHOLD_VIOLATIONS 0
OLAP_FUNC_OVERFLOWS 0
STATS_CACHE_SIZE 0
STATS_FABRICATE_TIME 0
STATS_FABRICATIONS 0
SYNC_RUNSTATS 0
SYNC_RUNSTATS_TIME 0
POOL_COL_L_READS 0
POOL_COL_P_READS 0
POOL_TEMP_COL_L_READS 0
POOL_TEMP_COL_P_READS 0
POOL_COL_WRITES 0

Key field Non-key field



How do I retrieve data from SAP structure DB6PMSD using ABAP code?

As DB6PMSD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB6PMSD as there is no data to select.

How to access SAP table DB6PMSD

Within an ECC or HANA version of SAP you can also view further information about DB6PMSD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!