The package STU6 (DB6: Performance-Monitor (UNIX/Windows)) is a standard package in SAP ERP. It belongs to the parent package BASIS.
| Package | STU6 |
| Short Text | DB6: Performance-Monitor (UNIX/Windows) |
| Parent Package | BASIS |
SAP Package STU6 contains 19 function groups.
| DB6X | DB6: Function Module Explain |
|---|---|
| DB6XDWN | DB6: Download explain, statistics, etc |
| SDB6ADM | DB6: CCMS administration functions |
| SDB6AL | DB6: Alert Monitoring Transactions |
| SDB6CAL | DB6: DBA Planning Calendar |
| SDB6CAT | DB6: System catalog access |
| SDB6CCAD | DB6: CCMS administration - Display |
| SDB6CCMS | DB6: CCMS Transaction Control Layer |
| SDB6CCMS2 | DB6: Display Space Config and History |
| SDB6DB02 | DB6: First Layer of Transaction DB02 |
| SDB6DIAG | DB6: Diagnostic Tools |
| SDB6HIS | DB6: Collection of History Data |
| SDB6JOB | DB6: Job Planning and Execution |
| SDB6MON | DB6: Database Alert Monitoring |
| SDB6PLAN | DB6: Planning Interface for DBA Actions |
| SDB6PM | DB6: Performance Monitoring Interface |
| SDB6PMST04 | DB6: Function Group Layer 1 of ST04 |
| SDB6XDB | DB6: XDB Interface |
| SDBX | DB6: Function Modules |
SAP Package STU6 contains 29 transactions.
| DB36 | DB6: Alert Configuration |
|---|---|
| DB37 | DB6: Alert Message Log |
| DB6BACKHIST | DB6: DBA Planning Calendar |
| DB6CLP | DB6: Command Line Processor |
| DB6COCKPIT | DB6: DBA Cockpit |
| DB6CST | DB6: Analyze Cumulative SQL Trace |
| DB6CST_LST | DB6: Analyze Cumulative SQL Trace |
| DB6DB21 | DB6: RUNSTATS Control |
| DB6DBALOG | DB6: DBA Log Viewer |
| DB6DBM | DB6: Database Manager Configuration |
| DB6DBP | DB6: Database Configuration |
| DB6DBS | DB6: Analyze Database Snapshot |
| DB6DIAGLOG | DB6: DBA Log Viewer |
| DB6DLK | DB6: Analyze Deadlocks |
| DB6EXL | DB6: Analyze Exclusive Lock Waits |
| DB6EXPLAIN | DB6: Explain SQL Statement |
| DB6FSC | DB6: File System Configuration |
| DB6PARHIS | DB6: Show Parameter History |
| DB6PERF | DB6: DB2 UDB Cockpit Performance |
| DB6PLAN | DB6: DBA Planning Calendar |
| DB6SPACE | DB6: Space Analysis |
| DB6SQC | DB6: Analyze SQL Cache |
| DB6STATS | DB6: Run Single Statistics |
| DB6SYSCFG | DB6: System Registration |
| DB6TAC | DB6: Analyze Table Snapshot |
| DB6TRC | DB6: Trace Status |
| DBA_VIEW_ABAP_SOURCE | DBA Cockpit: View ABAP Source |
| DBACOCKPIT | DB6: DBA Cockpit |
| DBACOCKPIT_ITS | DBA Cockpit |
SAP Package STU6 contains 59 database tables.
| DB6_RESET_DATA | DB6: Datacluster for monitor reset data |
|---|---|
| DB6ALRTCFG | DB6: Alert Configuration Data |
| DB6ALRTMSG | DB6: Alert Log Table for Database System Check |
| DB6AUDITDT | DB6: Audit log for maintenance actions |
| DB6AUDITHD | DB6: Audit log for maintenance actions |
| DB6CONVL | DB6: DB6CONV: Log Table |
| DB6CONVT | DB6: DB6CONV: Control Table |
| DB6CSTRACE | DB6: Results Table for DB6 CS Trace (Cumulative DBSL Trace) |
| DB6GSDTBS | DB6: Cumulated Table-Specific Snapshot Data |
| DB6IREORG | DB6: Database REORG Check Information: Indexes |
| DB6JOBTAB | DB6: parallel processing of tables through jobs |
| DB6NAVSYST | DB6: System Registration Table |
| DB6PM_CLN | DB6: Cleanup of History Tables |
| DB6PM_DLK | DB6: Table to Store the Output of Detected Deadlocks |
| DB6PM_LST | DB6: Sysout Listing (Standard Output of an Executable) |
| DB6PM_TIME | DB6: Protocol Record of Statistical Data Collection |
| DB6PMCD | DB6: Configuration Database |
| DB6PMCD2 | DB6: Database configuration |
| DB6PMCF | DB6: Configuration File Systems |
| DB6PMCG | DB6: Protocol Table for Logfile related Operations |
| DB6PMCK | DB6: All Backups of History File |
| DB6PMCK_P | DB6: All Backed Up Tablespaces of History File |
| DB6PMCM1 | DB6: Configuration Database Manager (Part 1) |
| DB6PMCM2 | DB6: Configuration Database Manager (Part 2) |
| DB6PMCN | DB6: Configuration Nodes (Partitions) |
| DB6PMCP | DB6: Configuration Tablespace |
| DB6PMCR | DB6: Configuration Container |
| DB6PMHCDM | DB6: Database and Database Manager Parameter Changes |
| DB6PMHSD | DB6: Database Performance Statistics History |
| DB6PMHT | DB6: Detail Record of Table and Index Space Statistics |
| DB6PMHT_HD | DB6: Summary Record of Table and Index Space Statistics |
| DB6PMHXP | DB6: Detail Record of Tablespace and DB Space Statistics |
| DB6PMHXPHD | DB6: Summary Record of Tablespace And DB Space Statistics |
| DB6PMHXT | DB6: Detail Record of Tablespace and DB Table/Index Stats |
| DB6PMHXTHD | DB6: Summary Rec. of Tablespace and DB Table/Index Stats |
| DB6PMPROT | DB6: Protocol Table for DBA Actions |
| DB6PMSA | DB6: Application Snapshot |
| DB6PMSA_AG | DB6: Application Agents Snapshot |
| DB6PMSA_LW | DB6: Application Lock Wait Snapshot |
| DB6PMSA_SS | DB6: Application Subsections Snapshot |
| DB6PMSA_ST | DB6: Application Statement Snapshot |
| DB6PMSB | DB6: Buffer Pool Snapshot |
| DB6PMSD | DB6: Database Snapshot |
| DB6PMSL_AP | DB6: Application Lockst. Snapshot |
| DB6PMSL_DB | DB6: Snapshot Locks Database |
| DB6PMSL_LK | DB6: Snapshot Locks Application Locks |
| DB6PMSL_LW | DB6: Snapshot Locks Application Lock Waits |
| DB6PMSM | DB6: Database Manager Snapshot |
| DB6PMSM_FC | DB6: Snapshot Database Manager FCM (Fast Comm. Manager) |
| DB6PMSM_FN | DB6: Snapshot Database Manager FCM Nodes |
| DB6PMSP | DB6: Tablespace Snapshot |
| DB6PMSP_HD | DB6: Tablespace Header Snapshot |
| DB6PMSQ | DB6: Snapshot SQL Cache |
| DB6PMST | DB6: Snapshot Table |
| DB6PMST_HD | DB6: Snapshot Table Header |
| DB6TREORG | DB6: Database REORG Check Information: Tables |
| DBSTATHDB6 | DB6: Statistical History of Application Monitor |
| DBSTATIDB6 | DB6: Statistics for Indexes (Application Monitor) |
| DBSTATTDB6 | DB6: Table Statistics for Application Monitor |
SAP Package STU6 contains 99 structures.
| DB6_RESET_KEY | DB6 |
|---|---|
| DB6ADMACTREF | DB6: action reference entry |
| DB6ADMBPND | DB6: System Catalog table BUFFERPOOLNODES |
| DB6ADMCLAS | DB6: description of data classes |
| DB6ADMCMD | DB6: Command Line |
| DB6ADMCON | DB6: Connection administration entry |
| DB6ADMCTR | DB6: container maintenance grid |
| DB6ADMINT | DB6: internal part of table buffer administration entry |
| DB6ADMLOCK | DB6: Action lock |
| DB6ADMLOG | DB6: Common message layout |
| DB6ADMNGRP | DB6: Nodegroup selection |
| DB6ADMRES | DB6 |
| DB6ADMSTAT | DB6: View of DBSTATC for RFC access |
| DB6ADMSYS | DB6: System administration entry |
| DB6ADMTABIDX | DB6: Index of Table |
| DB6ADMTABNAM | DB6: Tablename |
| DB6ALRTCFG_STRU | DB6: Alert Configuration Data |
| DB6ALRTCMN | DB6: View of Common Alert Config. (Maintained in RZ21) |
| DB6ALRTMSG_STRU | DB6: Alert Log Table for Database System Check |
| DB6BTCMSG | DB6: Message Part of btcxpm |
| DB6CATBP | DB6: System Catalog Information of Bufferpools |
| DB6CATBPND | DB6: System Catalog table BUFFERPOOLNODES |
| DB6CATBUFF | DB6: System Catalog Information for Buffer Pools |
| DB6CATIX | DB6 |
| DB6CATNGRP | DB6: System Catalog Information of Nodegroups |
| DB6CATTSP | DB6: System Catalog Information of Tablespaces |
| DB6CATUDF | DB6: UDF system catalog data |
| DB6CSTABP | DB6: ABAP Prog for Cumulative SQL Trace |
| DB6CSTDET | DB6: Details for Cumulative SQL Trace |
| DB6CSTENT | DB6: Entries for Cumulative SQL Trace |
| DB6DDITREE | DB6: Navigation Tree Structure |
| DB6DIAGDIR | DB6: Directory Contents |
| DB6DIAGLOB | DB6: Layer 2 Interface for System Check |
| DB6INSTCMP | DB6: Description of installed component |
| DB6JOBKEY | DB6: common key for job communication tables |
| DB6JOBPATT | DB6: Pattern description |
| DB6NAVCTRL | DB6: Global Control Data for Navigation Frame |
| DB6NAVSDIS | DB6: System configuration (display) |
| DB6NAVTREE | DB6: Navigation Tree Structure |
| DB6PM_CDM | DB6: DB and DBM Parameter Changes for Display |
| DB6PM_SD | DB6: Database Performance History Display |
| DB6PM_T | DB6: Detail Record of Table/Index Space Stats with Calc |
| DB6PM_T_HD | DB6: Detail Record of Table/Index Space Stats with Calc |
| DB6PM_XP | DB6: Detail Record of Tablespace and DB Space Stats Calc |
| DB6PM_XPHD | DB6: Tablespace and DB Space Statistics with Calculations |
| DB6PM_XT | DB6: Detail Tablespace and DB Table/Index Stats with Calc |
| DB6PM_XTHD | DB6: Tablespace and DB Table/Index Stats with Calculations |
| DB6PM1ST4 | DB6: Initial Screen of Transaction ST04 |
| DB6PMADVIX | DB6 |
| DB6PMCCNT | DB6: Tablespace Container Configuration Data (Calculated) |
| DB6PMCF1 | DB6: Structure to display file system configuration |
| DB6PMCIDX | DB6: Configuration of All Indexes of a Table |
| DB6PMCIST | DB6: Index structure in DB and dictionary |
| DB6PMCKOV | DB6: Overview of Backup History |
| DB6PMCTAB | DB6: Configuration of a Table |
| DB6PMCTBS | DB6: Tablespace Configuration Data (Calculated) |
| DB6PMCTCT | DB6: Tablespace Contents (Configuration) |
| DB6PMCTOV | DB6: Configuration of All Tables Overview |
| DB6PMCTST | DB6: Table Structure |
| DB6PMDB02 | DB6: Initial Screen of DB02 - Overview |
| DB6PMDDI | DB6: Check Entry for DB/ABAP Dictionary Consistency Check |
| DB6PMHIS_BACKUP | DB6: History Entry for Backups |
| DB6PMHIS_BACKUP_FILTER | DB6 |
| DB6PMHIS_BACKUP_V82 | DB6 |
| DB6PMLCKWT | DB6: Data of DB2 UDB Lock Waits |
| DB6PMLFAX | DB6: Data of DBAML (lfa, lfx) for Display in DB12 |
| DB6PMPOV | DB6: Partition Overview |
| DB6PMSAPP | DB6: Application Snapshot |
| DB6PMSBP | DB6: Calculated Buffer Pool Snapshot Data |
| DB6PMSD_STOR | DB6: Automatic Storage Paths |
| DB6PMSOV | DB6: System Overview with load sharing |
| DB6PMSQ_FILTER | DB6 |
| DB6PMSQ_HD | DB6: Header Information of SQL snapshot |
| DB6PMSQC | DB6: SQL Cache Snapshot and Percentage Columns |
| DB6PMSTAB | DB6: Calculated Table Snapshot Data |
| DB6PMSTBS | DB6: Calculated Tablespace Snapshot Data |
| DB6PMSTMT | DB6: Application Snapshot Statements |
| DB6PMSYS | DB6: Overall System Check |
| DB6PMTSLST | DB6: List of Tablespaces to Display the Content of |
| DB6PMVOV | DB6: Statistics information from SYSCAT and DBSTATC |
| DB6TRGCHK | DB6: Results of db6treorg check |
| DB6XPLARGU | DB6: structure of EXPLAIN_ARGUMENT |
| DB6XPLCOLS | DB6: structure on SYSCAT.COLUMNS |
| DB6XPLDIAG | DB6: EXPLAIN Table EXPLAIN_DIAGNOSTICS |
| DB6XPLINDX | DB6: structure of SYSCAT.INDEXES |
| DB6XPLINST | DB6: structure of EXPLAIN_INSTANCE |
| DB6XPLIXCOLS | DB6 |
| DB6XPLNODE | DB6: EXPLAIN: syscat.nodegroups+syscat.nodegroupdef |
| DB6XPLOBJ | DB6: structure of EXPLAIN_OBJECT |
| DB6XPLOPER | DB6: structure of EXPLAIN_OPERATOR |
| DB6XPLPRED | DB6: structure of EXPLAIN_PREDICATE |
| DB6XPLSTMT | DB6: structure of EXPLAIN_STATEMENT |
| DB6XPLSTRM | DB6: structure of EXPLAIN_STREAM |
| DB6XPLTABL | DB6: structure of SYSCAT.TABLES + syscat.tablespaces-ngname |
| DB6XPLTEEX | DB6: EXPLAIN: Table for Test Execute |
| DB6XPLVOLA | DB6: EXPLAIN: volatile attr. for tables used in access plan |
| SDBA_RECUR | Recurrence Pattern of a Scheduled DBA Action |
| SDBA_TSTMP | DB6: Planning Timestamp (Date and Time) |
| TAB_DB6 | DB6: Table Information from DB Tables |
SAP Package STU6 contains 8 programs.
| DB6CONV | DB6 table conversion |
|---|---|
| RSDB6COLL | DB6: Job Dispatcher for actions of TCOLL |
| RSDB6CSTRACE | Evaluation of DB2 UDB Trace (Cumulative DBSL Trace) |
| RSDB6GETSOURCE | Translation of DB6 Trace Location Information to ABAP Source and Line |
| RSDB6REO | DB2 Universal Database: Table reorganization - plannable calendar job |
| RSDB6RSTATS | DB6: check step for RUNSTATS via DBSTATC |
| RSDBST04LIST | Provide ST04 information for benchmark tests |
| RSDSTDB6 | Copy the DB statistics to application monitor (DB6) |
SAP Package STU6 contains 2 message classes.
| DB6 | DB6: Alert Monitoring and Alert Configuration |
|---|---|
| DB6PM | DB2 UDB for UNIX, Windows: Performance Monitoring |