Menu

SAP Package STU6

DB6: Performance-Monitor (UNIX/Windows)

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