SAP Package STU6
DB6: Performance-Monitor (UNIX/Windows)
Unsere Literaturempfehlung
ABAP Workbench - 100 Tipps & Tricks
Es gibt 100 gute Gründe, warum Sie dieses Buch kaufen sollten. Doch die verraten wir Ihnen hier nicht. Nur so viel: Wenn Sie die ABAP Workbench als Ihr zweites Wohnzimmer begreifen, ist dieses Buch genau das richtige für Sie! Die Mini-Tutorials in diesem Buch unterstützen Sie dabei, Software in ABAP effizienter zu entwickeln. Tipps und Tricks, wie Sie sich bei der Bearbeitung von Quelltext das Leben leichter machen, wie Sie häufig wiederkehrende Programmieraufgaben automatisieren oder umständliches Vorgehen früherer Tage endlich über Bord werfen. Sie werden die ABAP Workbench in einem ganz neuen Licht erleben. Eine klare Sprache, Klick-für-Klick-Anleitungen, Zusammenfassungen und Hervorhebungen sorgen dabei für einen schnellen und unkomplizierten Lernerfolg.
Bei amazon.de ansehen →
The package STU6 (DB6: Performance-Monitor (UNIX/Windows)) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | STU6 |
| Short Text | DB6: Performance-Monitor (UNIX/Windows) |
| Parent Package | BASIS |
Function Groups
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 |
Transactions
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 |
Database Tables
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 |
Structures
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 |
Programs
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) |
Message Classes
SAP Package STU6 contains 2 message classes.
| DB6 | DB6: Alert Monitoring and Alert Configuration |
|---|---|
| DB6PM | DB2 UDB for UNIX, Windows: Performance Monitoring |