DB6PMSA SAP (DB6: Application Snapshot) Structure details

Dictionary Type: Structure
Description: DB6: Application Snapshot




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




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

DB6PMSA 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: Application 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_DB6PMSA TYPE DB6PMSA.

The DB6PMSA table consists of various fields, each holding specific information or linking keys about DB6: Application Snapshot data available in SAP. These include PARTITN (dbpartitionnum), AGENT_ID (), AP_STATUS (application status), CODEPG_ID (codepage ID).. 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 DB6PMSA 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
PARTITN dbpartitionnum0
AGENT_ID 0
AP_STATUS application status0
CODEPG_ID codepage ID0
NUM_ASS_AG number of associated agents0
CRD_NODE coordinator node number0
AP_STATUS application status0
CODEPG_ID codepage ID0
AUTHORITY_LEVEL 0
CLI_PID client pid0
STAT_CHGTMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
APPL_NAMEDB6: General identifier DB6IDENTCHAR20
CRD_AG_PID coordinator agent pid0
IPADDRESSIP Address NI_NODEADDRCHAR45IPADDNI_NODEADDR
STAT_CHGTMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
APPL_ID 0
CLI_PLATFO client_platform: Platform of Client Application0
SEQU_NO 0
CLI_PRTC client_protocol: Communications Protocol of Client0
AUTH_IDDB6: General identifier primary auth. IDDB6IDENTCHAR20
COUNTRY_CD territory code0
CLI_NAMEDB6: General identifier client_nnameDB6IDENTCHAR20
APPL_NAME 0
APPL_ID 0
CLI_PRDIDDB6: General identifier client_prdIDDB6IDENTCHAR20
SEQU_NO 0
IN_DB_ALIADB6: General identifier input DB aliasDB6IDENTCHAR20
AUTH_ID primary auth. ID0
CLI_DBALIADB6: General identifier client DB aliasDB6IDENTCHAR20
DB_NAMEDB6: General identifier DB6IDENTCHAR20
SESSION_AUTH_ID session auth. ID0
DB_PATHDB6: File Path DB6PATHCHAR255DB6PATH
CLI_NAME client_nname0
CLI_PRDID client_prdID0
LCKS_HELD locks_held: Locks Currently Held by Application0
LCK_WAITS lock_waits: Lock Waits Since Application Connect0
IN_DB_ALIA input DB alias0
LCK_W_TM lock_wait_time: Total Time Application Waited for Locks0
CLI_DBALIA client DB alias0
DB_NAME 0
LCK_ESCALS lock_escals: Lock Escalations Since Application Connect0
DB_PATH 0
X_LCK_ESCA x_lock_escals: X Lock Escalations Since Application Connect0
EXEC_ID execution ID0
DEADLOCKS deadlocks: Deadlocks Since Application Connect0
UOW_LWTM uow_lock_wait_time: Time UOW Waited for Locks (ms)0
CORR_TOKEN 0
TOT_SORTS total_sorts: Total Sorts Since Connect0
TPMON_ACC_STR 0
TOT_SRT_TM total_sort_time: Elapsed Time Spent in Sorts0
TPMON_CLIENT_APP 0
SRT_OF sort_overflows: Number of Sort Overflows0
TPMON_CLIENT_UID 0
PL_D_LRS pool_data_l_reads: Pool Data Logical Reads Since Connect0
TPMON_CLIENT_WKS 0
PL_D_PRS pool_data_p_reads: Pool Data Reads Since First Connect0
WORKLOAD_ID 0
PL_D_WS pool_data_writes: Pool Data Writes Since First Connect0
IS_SYSTEM_APPL 0
COMPTIMEDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
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
CALLERFLAG Who Has Called this Program0
PL_I_WS pool_index_writes: Pool Index Writes Since First Connect0
DBMSTRTTMEDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
PRGVERS Version of Program Inserted this Row0
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
IPADDRESSIP Address NI_NODEADDRCHAR45IPADDNI_NODEADDR
LCKS_HELD locks_held: Locks Currently Held by Application0
CMMT_SQLST commit_sql_stmts: Number of COMMIT SQL Statements Since Conn0
LCK_WAITS lock_waits: Lock Waits Since Application Connect0
RBCK_SQLST rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect0
LCK_W_TM lock_wait_time: Total Time Application Waited for Locks0
DYN_SQLST dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect0
STC_SQLST static_sql_stmts: Number of Static SQL Statements Since Conn0
LCK_ESCALS lock_escals: Lock Escalations Since Application Connect0
FAIL_SQLST failed_sql_stmts: Number of Failed SQL Stmts Since Connect0
X_LCK_ESCA x_lock_escals: X Lock Escalations Since Application Connect0
DEADLOCKS deadlocks: Deadlocks Since Application Connect0
SELC_SQLST select_sql_stmts: Number of SQL SELECT Stmts Since Connect0
UOW_LWTM uow_lock_wait_time: Time UOW Waited for Locks (ms)0
DDL_SQLST ddl_sql_stmts: Number of Data Definition Language Statements0
TOT_SORTS total_sorts: Total Sorts Since Connect0
UID_SQLST uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements0
INT_ATRBND int_auto_rebinds: Number of Auto Rebinds Since First Connect0
TOT_SRT_TM total_sort_time: Elapsed Time Spent in Sorts0
SRT_OF sort_overflows: Number of Sort Overflows0
INT_RW_DEL int_rows_deleted: No. of Casc. Deletes Since First Connect0
PL_D_LRS pool_data_l_reads: Pool Data Logical Reads Since Connect0
INT_RW_UPD int_rows_updated: Number of Set Null Deletes Since Connect0
PL_D_PRS pool_data_p_reads: Pool Data Reads Since First Connect0
INT_CMMTS int_commits: Number of Int. COMMITs Since First Connect0
INT_RB int_rollbacks: Number of Int. ROLLBACKs 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
INT_DL_RB int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con0
PL_I_PRS pool_index_p_reads: Pool Index Reads Since First Connect0
RW_DELETED rows_deleted: Number of Rows Deleted Since Connect0
PL_I_WS pool_index_writes: Pool Index Writes Since First Connect0
RW_INSRTED rows_inserted: Number of Rows Inserted Since Connect0
PL_RD_TM pool_read_time: Buffer Pool Read Time Since First Connect0
RW_UPDATED rows_updated: Number of Rows Updated Since Connect0
PL_WT_TM pool_write_time: Buffer Pool Write Time Since First Connect0
RW_SELECED rows_selected: Number of Rows Selected Since Connect0
BIND_PRECC binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.0
CMMT_SQLST commit_sql_stmts: Number of COMMIT SQL Statements Since Conn0
RBCK_SQLST rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect0
UOW_LGSPUD uow_log_space_used: Log Space Used in Most Recent UOW0
DYN_SQLST dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect0
UOW_CMPSTA uow_comp_status: Previous UOW Completion Status0
STC_SQLST static_sql_stmts: Number of Static SQL Statements Since Conn0
PR_UOW_STMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
FAIL_SQLST failed_sql_stmts: Number of Failed SQL Stmts Since Connect0
UOW_STRTTMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
SELC_SQLST select_sql_stmts: Number of SQL SELECT Stmts Since Connect0
UOW_STOPTMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
DDL_SQLST ddl_sql_stmts: Number of Data Definition Language Statements0
OPN_RM_CR open_rem_curs: Remote Cursors Currently Open0
UID_SQLST uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements0
OPN_RM_CRB open_rem_curs_blk: Remote Cursors Curr. Open Within Block0
INT_ATRBND int_auto_rebinds: Number of Auto Rebinds Since First Connect0
REJ_CR_BLK rej_curs_blk: Rejected Block Remote Cursor Requests0
ACC_CU_BLK acc_curs_blk: Acc. Block Remote Cursor Requests0
INT_RW_DEL int_rows_deleted: No. of Casc. Deletes Since First Connect0
AP_CON_TMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
INT_RW_UPD int_rows_updated: Number of Set Null Deletes Since Connect0
INT_CMMTS int_commits: Number of Int. COMMITs Since First Connect0
CN_CMPL_TMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
INT_RB int_rollbacks: Number of Int. ROLLBACKs Since First Connect0
LAST_RESETDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
INT_DL_RB int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con0
AP_IDLE_TM appl_idle_time: Application Idle Time (Seconds)0
PL_D_TE pool_data_to_estore: No. of Pages Copied from BP to ExStor.0
RW_DELETED rows_deleted: Number of Rows Deleted Since Connect0
PL_I_TE pool_index_to_estore: No. of Pages Copied from BP to ExStor.0
RW_INSRTED rows_inserted: Number of Rows Inserted Since Connect0
PL_I_FE pool_index_from_estore: No of Pages Copied from ExStor to BP0
RW_UPDATED rows_updated: Number of Rows Updated Since Connect0
PL_D_FE pool_data_from_estore: No. of Pages Copied from ExStor to BP0
RW_SELECED rows_selected: Number of Rows Selected Since Connect0
AUTHO_LVL authority_lvl: User Authorizations0
BIND_PRECC binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn.0
SQL_RSCMMT sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT0
UOW_LGSPUD uow_log_space_used: Log Space Used in Most Recent UOW0
NUM_SCAPS num_sec_appl_structs: Secondary Application Information0
UOW_CMPSTA uow_comp_status: Previous UOW Completion Status0
LCK_TMOUT lock_timeouts: Number of Lock Timeouts Since Connect0
PR_UOW_STMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
AGT_UCP_S agent_usr_cpu_time.seconds: Total User CPU Time of Appl.0
UOW_STRTTMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
AGT_UPT_MS agent_usr_cpu_time.microsec: Total User CPU Time of Appl.0
UOW_STOPTMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
AGT_SCT_S agent_sys_cpu_time.seconds: Total Application System CPU Tim0
OPN_RM_CR open_rem_curs: Remote Cursors Currently Open0
AGT_SPT_MS agent_sys_cpu_time.microsec: Total Appl. System CPU Time0
OPN_RM_CRB open_rem_curs_blk: Remote Cursors Curr. Open Within Block0
INT_RW_INS int_rows_inserted: Number of Rows Inserted for Trigger0
REJ_CR_BLK rej_curs_blk: Rejected Block Remote Cursor Requests0
RW_READ rows_read: Number of Rows Read Since Connection0
ACC_CU_BLK acc_curs_blk: Acc. Block Remote Cursor Requests0
AP_CON_TMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
RW_WRITTEN rows_written: Number of Rows Written Since Connection0
DIRCT_RDS direct_reads: Direct Reads Since Connect0
CN_CMPL_TMDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
DIRCT_WTS direct_writes: Direct Writes Since Connect0
LAST_RESETDB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMPCHAR14
AP_IDLE_TM appl_idle_time: Application Idle Time (Seconds)0
DIRCT_RRQS direct_read_reqs: Direct Read Requests Since Connect0
PL_D_TE pool_data_to_estore: No. of Pages Copied from BP to ExStor.0
DIRCT_WRQS direct_write_reqs: Direct Write Requests Since Connect0
PL_I_TE pool_index_to_estore: No. of Pages Copied from BP to ExStor.0
DIRCT_RTM direct_read_time: Direct Read Time Since Connect0
PL_I_FE pool_index_from_estore: No of Pages Copied from ExStor to BP0
DIRCT_WTM direct_write_time: Direct Write Time Since Connect0
PL_D_FE pool_data_from_estore: No. of Pages Copied from ExStor to BP0
OPN_LC_CR open_loc_curs: Local Cursors Currently Open0
AUTHO_LVL authority_lvl: User Authorizations0
OPN_LC_CRB open_loc_curs_blk: Local Cursors Currently Open Within Block0
EXEC_IDDB6: General identifier execution IDDB6IDENTCHAR20
SQL_RSCMMT sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT0
NUM_SCAPS num_sec_appl_structs: Secondary Application Information0
CORR_TOKENDB6: Long identifier DB6LONGIDCHAR32
CLI_PID client pid0
LCK_TMOUT lock_timeouts: Number of Lock Timeouts Since Connect0
AGT_UCP_S agent_usr_cpu_time.seconds: Total User CPU Time of Appl.0
CLI_PLATFO client_platform: Platform of Client Application0
CLI_PRTC client_protocol: Communications Protocol of Client0
AGT_UPT_MS agent_usr_cpu_time.microsec: Total User CPU Time of Appl.0
AGT_SCT_S agent_sys_cpu_time.seconds: Total Application System CPU Tim0
COUNTRY_CD territory code0
AGT_SPT_MS agent_sys_cpu_time.microsec: Total Appl. System CPU Time0
PKG_CA_LKU pkg_cache_lookups: Number of Section Lookups0
INT_RW_INS int_rows_inserted: Number of Rows Inserted for Trigger0
PKG_CA_INS pkg_cache_inserts: Number of Sections Inserted into Cache0
RW_READ rows_read: Number of Rows Read Since Connection0
CATCA_LKU cat_cache_lookups: Number of Table Descriptor Lookups0
CATCA_INS cat_cache_inserts: Number of Table Descriptors Inserted0
RW_WRITTEN rows_written: Number of Rows Written Since Connection0
CATCA_OF cat_cache_overflows: Number of Catalog Cache Overflows0
DIRCT_RDS direct_reads: Direct Reads Since Connect0
DIRCT_WTS direct_writes: Direct Writes Since Connect0
CATCA_HPFL cat_cache_heap_full: Number of Overflows due to DB Heap Full0
CRD_NODE coordinator node number0
DIRCT_RRQS direct_read_reqs: Direct Read Requests Since Connect0
DIRCT_WRQS direct_write_reqs: Direct Write Requests Since Connect0
NUM_ASS_AG number of associated agents0
DIRCT_RTM direct_read_time: Direct Read Time Since Connect0
NUM_AGENTS num_agents: Number of Agents Currently Active0
DIRCT_WTM direct_write_time: Direct Write Time Since Connect0
AGT_STOLEN agents_stolen: Total Number of Agents Stolen from Appl.0
OPN_LC_CR open_loc_curs: Local Cursors Currently Open0
ASS_AGT_TP associated_agents_top: # of Agents Associated with this Appl0
AP_PRIO appl_priority: Priority with Which Application Agents Work0
OPN_LC_CRB open_loc_curs_blk: Local Cursors Currently Open Within Block0
AP_PRIO_TY appl_priority_type: Dynamic or Static0
PKG_CA_LKU pkg_cache_lookups: Number of Section Lookups0
PF_WTTM prefetch_wait_time: Time Waited for Prefetch (ms)0
PKG_CA_INS pkg_cache_inserts: Number of Sections Inserted into Cache0
CATCA_LKU cat_cache_lookups: Number of Table Descriptor Lookups0
CRD_AG_PID coordinator agent pid0
CATCA_INS cat_cache_inserts: Number of Table Descriptors Inserted0
AP_SEC_LKU appl_section_lookups: Number of Section Lookups0
CATCA_OF cat_cache_overflows: Number of Catalog Cache Overflows0
AP_SEC_INS appl_section_inserts: Number of Sections Inserted0
LCK_WTING locks_waiting: Number of Agents Currently Waiting for Locks0
CATCA_HPFL cat_cache_heap_full: Number of Overflows due to DB Heap Full0
NUM_AGENTS num_agents: Number of Agents Currently Active0
OB_CN_ADDRDB6: Long identifier DB6LONGIDCHAR32
AGT_STOLEN agents_stolen: Total Number of Agents Stolen from Appl.0
INBND_CNADDB6: Long identifier DB6LONGIDCHAR32
ASS_AGT_TP associated_agents_top: # of Agents Associated with this Appl0
OB_CN_PRTC outbound_comm_protocol: Outbound Communications Protocol0
AP_PRIO appl_priority: Priority with Which Application Agents Work0
TOT_HAJN total_hash_joins: Number of Hash Joins0
AP_PRIO_TY appl_priority_type: Dynamic or Static0
TOT_HALOOP total_hash_loops: Number of Hash Loops0
HAJN_OF hash_join_overflows: Number of Hash Join Overflows0
PF_WTTM prefetch_wait_time: Time Waited for Prefetch (ms)0
AP_SEC_LKU appl_section_lookups: Number of Section Lookups0
HAJN_SM_OF hash_join_small_overflows: Small Hash Join Overflows0
UOW_ELA_S uow_elapsed_time_s: Unit of Work elapse time sec0
AP_SEC_INS appl_section_inserts: Number of Sections Inserted0
LCK_WTING locks_waiting: Number of Agents Currently Waiting for Locks0
UOW_ELA_MS uow_elapsed_time_ms: Unit of Work elapse time ms0
OB_CN_ADDRDB6: Long identifier DB6LONGIDCHAR32
UNREADPFPG unread_prefetch_pages: Unread prefetched pages0
PL_TD_LRS pool_temp_data_l_reads0
INBND_CNADDB6: Long identifier DB6LONGIDCHAR32
PL_TD_PRS pool_temp_data_p_reads0
OB_CN_PRTC outbound_comm_protocol: Outbound Communications Protocol0
TOT_HAJN total_hash_joins: Number of Hash Joins0
PL_TI_LRS pool_temp_index_l_reads0
PL_TI_PRS pool_temp_index_p_reads0
TOT_HALOOP total_hash_loops: Number of Hash Loops0
HAJN_OF hash_join_overflows: Number of Hash Join Overflows0
POOL_XDA_L_READS 0
HAJN_SM_OF hash_join_small_overflows: Small Hash Join Overflows0
POOL_XDA_P_READS 0
UOW_ELA_S uow_elapsed_time_s: Unit of Work elapse time sec0
POOL_XDA_WRITES 0
UOW_ELA_MS uow_elapsed_time_ms: Unit of Work elapse time ms0
PL_TEMP_XDA_L_RD 0
UNREADPFPG unread_prefetch_pages: Unread prefetched pages0
PL_TEMP_XDA_P_RD 0
PL_TD_LRS pool_temp_data_l_reads0
ELPSD_EXC_TIM_MS 0
PL_TD_PRS pool_temp_data_p_reads0
ELPSD_EXC_TIM_S 0
PL_TI_LRS pool_temp_index_l_reads0
INACT_STMTHISTSZ 0
PL_TI_PRS pool_temp_index_p_reads0
LOCK_TIMEOUT_VAL 0
PRV_WS_NUM_OVFL 0
POOL_XDA_L_READS 0
POOL_XDA_P_READS 0
PRV_WS_SCT_INSRT 0
POOL_XDA_WRITES 0
PRV_WS_SCT_LKUP 0
PRV_WS_SIZE_TOP 0
PL_TEMP_XDA_L_RD 0
SHR_WS_NUM_OVFL 0
PL_TEMP_XDA_P_RD 0
ELPSD_EXC_TIM_MS 0
SHR_WS_SCT_INSRT 0
ELPSD_EXC_TIM_S 0
SHR_WS_SCT_LKUP 0
SHR_WS_SIZE_TOP 0
INACT_STMTHISTSZ 0
SESSION_AUTH_ID session auth. ID0
LOCK_TIMEOUT_VAL 0
TPMON_ACC_STR 0
PRV_WS_NUM_OVFL 0
PRV_WS_SCT_INSRT 0
TPMON_CLIENT_APP 0
PRV_WS_SCT_LKUP 0
TPMON_CLIENT_UID 0
PRV_WS_SIZE_TOP 0
TPMON_CLIENT_WKS 0
AUTHORITY_LEVEL 0
SHR_WS_NUM_OVFL 0
SHR_WS_SCT_INSRT 0
SHR_WS_SCT_LKUP 0
SHR_WS_SIZE_TOP 0
OLAP_FUNC_OVERFLOWS 0
TOTAL_OLAP_FUNCS 0

Key field Non-key field



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

As DB6PMSA 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 DB6PMSA as there is no data to select.

How to access SAP table DB6PMSA

Within an ECC or HANA version of SAP you can also view further information about DB6PMSA 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!