dev .wb
SAP Developer Workbench
The best resource for SAP and ABAP Knowhow
Menu

SAP Table DB6PMSA

DB6: Application Snapshot

Recommended Now

Fire TV Stick Lite Essentials Bundle

This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.

Check it out on amazon.com →

The table DB6PMSA (DB6: Application Snapshot) is a standard table in SAP ERP. It belongs to the package STU6.

Technical Information

Table DB6PMSA
Short Text DB6: Application Snapshot
Package STU6
Table Type Transparent Table

Fields for Table DB6PMSA

Field Name Key Description Data Element Type Length Check Table
PARTITN dbpartitionnum INT4 10
AGENT_ID DEC 22
AP_STATUS application status CHAR 50
CODEPG_ID codepage ID DEC 22
NUM_ASS_AG number of associated agents DEC 22
CRD_NODE coordinator node number DEC 22
AUTHORITY_LEVEL CHAR 512
CLI_PID client pid DEC 22
CRD_AG_PID coordinator agent pid DEC 22
STAT_CHGTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
CLI_PLATFO client_platform: Platform of Client Application CHAR 25
CLI_PRTC client_protocol: Communications Protocol of Client CHAR 25
COUNTRY_CD territory code INT4 10
APPL_NAME CHAR 256
APPL_ID CHAR 128
SEQU_NO CHAR 5
AUTH_ID primary auth. ID CHAR 128
SESSION_AUTH_ID session auth. ID CHAR 128
CLI_NAME client_nname CHAR 128
CLI_PRDID client_prdID CHAR 128
IN_DB_ALIA input DB alias CHAR 128
CLI_DBALIA client DB alias CHAR 128
DB_NAME CHAR 128
DB_PATH CHAR 1024
EXEC_ID execution ID CHAR 128
CORR_TOKEN CHAR 128
TPMON_ACC_STR CHAR 200
TPMON_CLIENT_APP CHAR 256
TPMON_CLIENT_UID CHAR 256
TPMON_CLIENT_WKS CHAR 256
WORKLOAD_ID INT4 10
IS_SYSTEM_APPL INT2 5
COMPTIME ✔ DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
CALLERFLAG ✔ Who Has Called this Program CHAR 1
DBMSTRTTME DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
PRGVERS Version of Program Inserted this Row CHAR 20
IPADDRESS IP Address NI_NODEADDR CHAR 45
LCKS_HELD locks_held: Locks Currently Held by Application DEC 22
LCK_WAITS lock_waits: Lock Waits Since Application Connect DEC 22
LCK_W_TM lock_wait_time: Total Time Application Waited for Locks DEC 22
LCK_ESCALS lock_escals: Lock Escalations Since Application Connect DEC 22
X_LCK_ESCA x_lock_escals: X Lock Escalations Since Application Connect DEC 22
DEADLOCKS deadlocks: Deadlocks Since Application Connect DEC 22
UOW_LWTM uow_lock_wait_time: Time UOW Waited for Locks (ms) DEC 22
TOT_SORTS total_sorts: Total Sorts Since Connect DEC 22
TOT_SRT_TM total_sort_time: Elapsed Time Spent in Sorts DEC 22
SRT_OF sort_overflows: Number of Sort Overflows DEC 22
PL_D_LRS pool_data_l_reads: Pool Data Logical Reads Since Connect DEC 22
PL_D_PRS pool_data_p_reads: Pool Data Reads Since First Connect DEC 22
PL_D_WS pool_data_writes: Pool Data Writes Since First Connect DEC 22
PL_I_LRS pool_index_l_reads: Pool Index Logical Reads Since Connect DEC 22
PL_I_PRS pool_index_p_reads: Pool Index Reads Since First Connect DEC 22
PL_I_WS pool_index_writes: Pool Index Writes Since First Connect DEC 22
PL_RD_TM pool_read_time: Buffer Pool Read Time Since First Connect DEC 22
PL_WT_TM pool_write_time: Buffer Pool Write Time Since First Connect DEC 22
CMMT_SQLST commit_sql_stmts: Number of COMMIT SQL Statements Since Conn DEC 22
RBCK_SQLST rollback_sql_stmts: No. of ROLLBACK SQL Stmts Since Connect DEC 22
DYN_SQLST dynamic_sql_stmts: Number of Dynamic SQL Stmts Since Connect DEC 22
STC_SQLST static_sql_stmts: Number of Static SQL Statements Since Conn DEC 22
FAIL_SQLST failed_sql_stmts: Number of Failed SQL Stmts Since Connect DEC 22
SELC_SQLST select_sql_stmts: Number of SQL SELECT Stmts Since Connect DEC 22
DDL_SQLST ddl_sql_stmts: Number of Data Definition Language Statements DEC 22
UID_SQLST uid_sql_stmts: Number of UPDATE/INSERT/DELETE Statements DEC 22
INT_ATRBND int_auto_rebinds: Number of Auto Rebinds Since First Connect DEC 22
INT_RW_DEL int_rows_deleted: No. of Casc. Deletes Since First Connect DEC 22
INT_RW_UPD int_rows_updated: Number of Set Null Deletes Since Connect DEC 22
INT_CMMTS int_commits: Number of Int. COMMITs Since First Connect DEC 22
INT_RB int_rollbacks: Number of Int. ROLLBACKs Since First Connect DEC 22
INT_DL_RB int_deadlock_rollbacks: # of ROLLBACKs due to Deadlck S. Con DEC 22
RW_DELETED rows_deleted: Number of Rows Deleted Since Connect DEC 22
RW_INSRTED rows_inserted: Number of Rows Inserted Since Connect DEC 22
RW_UPDATED rows_updated: Number of Rows Updated Since Connect DEC 22
RW_SELECED rows_selected: Number of Rows Selected Since Connect DEC 22
BIND_PRECC binds_precompiles: # of BINDs/PRECOMPILEs Since First Conn. DEC 22
UOW_LGSPUD uow_log_space_used: Log Space Used in Most Recent UOW DEC 22
UOW_CMPSTA uow_comp_status: Previous UOW Completion Status CHAR 50
PR_UOW_STM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
UOW_STRTTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
UOW_STOPTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
OPN_RM_CR open_rem_curs: Remote Cursors Currently Open DEC 22
OPN_RM_CRB open_rem_curs_blk: Remote Cursors Curr. Open Within Block DEC 22
REJ_CR_BLK rej_curs_blk: Rejected Block Remote Cursor Requests DEC 22
ACC_CU_BLK acc_curs_blk: Acc. Block Remote Cursor Requests DEC 22
AP_CON_TM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
CN_CMPL_TM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
LAST_RESET DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
AP_IDLE_TM appl_idle_time: Application Idle Time (Seconds) DEC 22
PL_D_TE pool_data_to_estore: No. of Pages Copied from BP to ExStor. DEC 22
PL_I_TE pool_index_to_estore: No. of Pages Copied from BP to ExStor. DEC 22
PL_I_FE pool_index_from_estore: No of Pages Copied from ExStor to BP DEC 22
PL_D_FE pool_data_from_estore: No. of Pages Copied from ExStor to BP DEC 22
AUTHO_LVL authority_lvl: User Authorizations DEC 22
SQL_RSCMMT sql_reqs_since_commit: No. of SQL Requests Since Last COMMIT DEC 22
NUM_SCAPS num_sec_appl_structs: Secondary Application Information DEC 22
LCK_TMOUT lock_timeouts: Number of Lock Timeouts Since Connect DEC 22
AGT_UCP_S agent_usr_cpu_time.seconds: Total User CPU Time of Appl. DEC 22
AGT_UPT_MS agent_usr_cpu_time.microsec: Total User CPU Time of Appl. DEC 22
AGT_SCT_S agent_sys_cpu_time.seconds: Total Application System CPU Tim DEC 22
AGT_SPT_MS agent_sys_cpu_time.microsec: Total Appl. System CPU Time DEC 22
INT_RW_INS int_rows_inserted: Number of Rows Inserted for Trigger DEC 22
RW_READ rows_read: Number of Rows Read Since Connection DEC 22
RW_WRITTEN rows_written: Number of Rows Written Since Connection DEC 22
DIRCT_RDS direct_reads: Direct Reads Since Connect DEC 22
DIRCT_WTS direct_writes: Direct Writes Since Connect DEC 22
DIRCT_RRQS direct_read_reqs: Direct Read Requests Since Connect DEC 22
DIRCT_WRQS direct_write_reqs: Direct Write Requests Since Connect DEC 22
DIRCT_RTM direct_read_time: Direct Read Time Since Connect DEC 22
DIRCT_WTM direct_write_time: Direct Write Time Since Connect DEC 22
OPN_LC_CR open_loc_curs: Local Cursors Currently Open DEC 22
OPN_LC_CRB open_loc_curs_blk: Local Cursors Currently Open Within Block DEC 22
PKG_CA_LKU pkg_cache_lookups: Number of Section Lookups DEC 22
PKG_CA_INS pkg_cache_inserts: Number of Sections Inserted into Cache DEC 22
CATCA_LKU cat_cache_lookups: Number of Table Descriptor Lookups DEC 22
CATCA_INS cat_cache_inserts: Number of Table Descriptors Inserted DEC 22
CATCA_OF cat_cache_overflows: Number of Catalog Cache Overflows DEC 22
CATCA_HPFL cat_cache_heap_full: Number of Overflows due to DB Heap Full DEC 22
NUM_AGENTS num_agents: Number of Agents Currently Active DEC 22
AGT_STOLEN agents_stolen: Total Number of Agents Stolen from Appl. DEC 22
ASS_AGT_TP associated_agents_top: # of Agents Associated with this Appl DEC 22
AP_PRIO appl_priority: Priority with Which Application Agents Work DEC 22
AP_PRIO_TY appl_priority_type: Dynamic or Static CHAR 25
PF_WTTM prefetch_wait_time: Time Waited for Prefetch (ms) DEC 22
AP_SEC_LKU appl_section_lookups: Number of Section Lookups DEC 22
AP_SEC_INS appl_section_inserts: Number of Sections Inserted DEC 22
LCK_WTING locks_waiting: Number of Agents Currently Waiting for Locks DEC 22
OB_CN_ADDR DB6: Long identifier DB6LONGID CHAR 32
INBND_CNAD DB6: Long identifier DB6LONGID CHAR 32
OB_CN_PRTC outbound_comm_protocol: Outbound Communications Protocol INT4 10
TOT_HAJN total_hash_joins: Number of Hash Joins DEC 22
TOT_HALOOP total_hash_loops: Number of Hash Loops DEC 22
HAJN_OF hash_join_overflows: Number of Hash Join Overflows DEC 22
HAJN_SM_OF hash_join_small_overflows: Small Hash Join Overflows DEC 22
UOW_ELA_S uow_elapsed_time_s: Unit of Work elapse time sec DEC 22
UOW_ELA_MS uow_elapsed_time_ms: Unit of Work elapse time ms DEC 22
UNREADPFPG unread_prefetch_pages: Unread prefetched pages DEC 22
PL_TD_LRS pool_temp_data_l_reads DEC 22
PL_TD_PRS pool_temp_data_p_reads DEC 22
PL_TI_LRS pool_temp_index_l_reads DEC 22
PL_TI_PRS pool_temp_index_p_reads DEC 22
POOL_XDA_L_READS DEC 22
POOL_XDA_P_READS DEC 22
POOL_XDA_WRITES DEC 22
PL_TEMP_XDA_L_RD DEC 22
PL_TEMP_XDA_P_RD DEC 22
ELPSD_EXC_TIM_MS DEC 22
ELPSD_EXC_TIM_S DEC 22
INACT_STMTHISTSZ DEC 22
LOCK_TIMEOUT_VAL DEC 22
PRV_WS_NUM_OVFL DEC 22
PRV_WS_SCT_INSRT DEC 22
PRV_WS_SCT_LKUP DEC 22
PRV_WS_SIZE_TOP DEC 22
SHR_WS_NUM_OVFL DEC 22
SHR_WS_SCT_INSRT DEC 22
SHR_WS_SCT_LKUP DEC 22
SHR_WS_SIZE_TOP DEC 22
OLAP_FUNC_OVERFLOWS DEC 22
TOTAL_OLAP_FUNCS DEC 22