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

SAP Table DB6PMSM

DB6: Database Manager Snapshot

Unsere Literaturempfehlung

Kundeneigene Erweiterungen mit ABAP: User-Exits, klassische und neue BAdIs, Switch und Enhancement Framework

Alle Technologien in einem Band! Ob Sie zukunftssichere Erweiterungen programmieren oder mit den Modifikationen in Ihren SAP-Systemen aufräumen möchten – hier erhalten Sie das erforderliche Wissen. Jede Methode wird ausführlich und mit Codebeispielen erläutert: User-Exits, klassische und neue BAdIs, Business Transaction Events, implizite und explizite Erweiterungspunkte u. v. m.

Bei amazon.de ansehen →

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