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

SAP Table DB6PMSM

DB6: Database Manager 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 DB6PMSM (DB6: Database Manager Snapshot) is a standard table in SAP ERP. It belongs to the package STU6.

Technical Information

Table DB6PMSM
Short Text DB6: Database Manager Snapshot
Package STU6
Table Type Transparent Table

Fields for Table DB6PMSM

Field Name Key Description Data Element Type Length Check Table
COMPTIME ✔ DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
PARTITN ✔ Partition Number INT4 10
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
SRT_HP_ALO sort_heap_allocated: Sort Heap Currently Allocated DEC 22
PT_THSORTS post_threshold_sorts: # Sorts Started After Heap Threshold E DEC 22
PPD_SRT_RQ piped_sorts_requested: No of Piped Sorts Requested by RDS to DEC 22
PPD_SRT_AC piped_sorts_accepted: No. of Piped Sorts Accepted by SLS DEC 22
DB2_STRTTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
LAST_RESET DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
REM_CN_IN rem_cons_in: Remote Connects to Target DB2 DEC 22
REM_CN_INE rem_cons_in_exec: Remote Connects to Target Exec. DB2 DEC 22
LOCAL_CONS local_cons: Current Local Connections DEC 22
LOCL_CN_IE local_cons_in_exec: Local Connects Curr. Executed in DB2 DEC 22
CN_LC_DBS con_local_dbases: Local Databases with Current Connects DEC 22
AGT_REG agents_registered: Number of Agents Registered in DB2 DEC 22
AGT_WAI_TK agents_waiting_on_token: No. of Agents Waiting for a Token DEC 22
UOW_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
UOW_SWSTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
STMT_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
STMT_SWSTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
TAB_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
TAB_SWSTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
BP_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
BP_SWSTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
LCK_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
LCK_SW_STM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
SRT_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
SRT_SWSTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
DB2_STATUS db2_status: Status of the DB2 Instance (Active, Quiesced ... CHAR 25
AGT_REG_TP agents_registered_top: agents_registered High Water Mark DEC 22
AGT_WAI_TP agents_waiting_top: agents_waiting High Water Mark DEC 22
COMM_PIMEM comm_private_mem: Committed Private Memory (Bytes) DEC 22
IDEL_AG idle_agents: Number of Unassigned Agents in Pool DEC 22
AGT_FR_PO agents_from_pool: Number of Agents Assigned from Pool DEC 22
AGT_CR_EPO agents_created_empty_pool:# Agents Created due to Pool Empty DEC 22
CRD_AG_TOP coord_agents_top: Coordinating Agents High Water Mark DEC 22
MX_AG_OF max_agent_overflows: # of Attempts Exceeding the MAXAGENTS C DEC 22
AGT_STOLEN agents_stolen: Number of Agents Stolen DEC 22
NUM_SCDBMS num_sec_dbm_structs: Secondary Database Manager Info DEC 22
PROD_NAME DB6: Long identifier DB6LONGID CHAR 32
COMPO_ID DB6: General identifier DB6IDENT CHAR 20
SVC_LEVEL service_level: Service Level CHAR 8
GW_TIT_CN gw_total_cons: DDCS Total Number of Gateway Connections DEC 22
GW_CUR_CN gw_cur_cons: DDCS Current Number of Gateway Connections DEC 22
GW_CN_W_HT gw_cons_wait_host: DDCS # Gateway Conn. Waiting for Host Rep DEC 22
GW_CN_W_CL gw_cons_wait_client: DDCS Gateway Conn. Waiting for Client R DEC 22
PT_THHAJN post_threshold_hash_joins: DDCS #Hash Joins Started After He DEC 22
NUM_GW_CONN_SW num_gw_conn_switches DEC 22
NUM_NODES_INST num_nodes_in_db2_instance DEC 22
SORT_HEAP_TOP sort_heap_top DEC 22
TM_SW dbmon_sw_settings: SQLM_OFF, SQLM_ON CHAR 5
TM_SWSTM DB6: Timestamp (Format: YYYYMMDDHHMMSS) DB6TSTAMP CHAR 14
POST_THRESHOLD_OLAP_FUNCS DEC 22