Menu

SAP Package STU2

CCMS for DB2 for OS/390

Technical Information

Package STU2
Short Text CCMS for DB2 for OS/390
Parent Package BASIS

Package Contents

The package STU2 is a normal package. It contains the following embedded packages and dictionary objects.

Function Groups

The package STU2 contains 10 function groups.

DB02_DB2 DB2/390 Tables and Indexes Monitor, DB02
DBSYCHK_DB2 DB2 for OS/390: Database System Check
GENERAL_DB2 General functions
HIGHAV_DB2 Test function group
S_CCDSNU_DB2 Control Center Stored Procedures
S_DBALERT_DB2 DB2 for OS/390 Database Alerts
S_MCOD_DB2 DB2 Multiple Components in One Database
S_TABIXMON_DB2 DB2 for OS/390 Table and Index Monitor
S390 R/3 JCL Submission Services for OS/390
S391 Func. Group for OS/390 Space Measurement

Transactions

The package STU2 contains 5 transactions.

DB2B DB2/390: Buffer pool tuning
DB2C DB2 Catalog Browser
DB2J Manage JCL Jobs for OS/390
DB2T DB2/390 Timeout Monitor
DB2U Long Running Units of Recovery

Database Tables

The package STU2 contains 32 database tables.

DB2BPTUNE DB2/390: Buffer Pool Tuning Settings
DB2CCACCOR Parameters of Control Center stored procedure DSNACCOR
DB2CCDAILY List of TS/IXS needing utility treatment (DSNACCOR Daily)
DB2CCDL_OUTTS DSNACCDL: History of output table
DB2CCDL_PARMS DSNACCDL: History of execution parameters for DB13 jobs
DB2CCDS_IN DSNACCDS: History of input table for DB13 jobs
DB2CCDS_PARMS DSNACCDS: History of execution parameters for DB13 jobs
DB2CCHOUR List of TS/IXS needing utility treatment (DSNACCOR Hourly)
DB2CCMO_ERROR DSNACCMO: History of error info with length > 255 CHAR
DB2COPYI DB2 copy information from SYSIBM.SYSCOPY
DB2IREORG Information for Database Reorgcheck: Indexes
DB2IXBACK List of indexes that need a backup
DB2JOB JCL Jobs for OS/390
DB2JSINF Header Table of JCL Administration
DB2JSTATUS Status of Submitted JCL Jobs
DB2JU TSO User on OS/390
DB2MON DB2/390 Monitor Table
DB2NORUN Exclude table spaces from RUNSTATS ALL
DB2REOIX REORG of Indexes
DB2REOTS REORG of Tablespaces
DB2SAPSYS SAP systems located in one DB2 subsystem
DB2TREORG Information for Database reorgcheck: Tables
DB2TSBACK List of tablespaces that need a backup
DB2UTPARM DB2/390: Parameters for DB2 Utilities
DBCHECKDB2 Configuration of DB2/390 System Check Parameters
DBMSGDB2 DB2/390 System Check Messages
DBSTAIHDB2 DB2/390 Statistics for Indexes
DBSTATHDB2 DB2/390 Statistics for Tables (History)
DBSTATIDB2 DB2/390 Statistics for Indexes
DBSTATTDB2 DB2/390 Statistics for Tables
DBSYCHKDB2 DB2/390: Global Information for Database System Check
SDBADDB2 Detail Table for DBA Logs

Views

The package STU2 contains 6 views.

DB2CCEXTNT Display output of DSNACCOR, field selection EXTENTS
DB2CCREOIX Display output of DSNACCOR, field selection REORG index
DB2CCREORG Display output of DSNACCOR, field selection REORG
DB2CCRESTR Display output of DSNACCOR, field selection RESTRICTED STATE
DB2CCRUNST Display output of DSNACCOR, field selection RUNSTATS
DB2TSBACKN List of TS/IXS needing backup, new structure of DSNACCOR

Structures

The package STU2 contains 164 structures.

AUTHDB2 Authorization Fields for DB2/390
D2SCPYVAR Variables for Program RSDB2850
D2SYSCOPY Structure for Table SYSIBM.SYSCOPY (DB2 on OS/390)
DB2_EXT_AL DB2/390 Alert: Too Many Extents
DB2_TSLIST Structure for typing int. tables to identify tablespaces
DB2ACCDL Parameters of Control Center stored procedure DSNACCDL
DB2ACCDS Parameters of Control Center stored procedure DSNACCDS
DB2ACCMO Parameters of Control Center stored procedure DSNACCMO
DB2ACCOR Parameters of Control Center stored procedure DSNACCOR
DB2ALERT DB2/390: Alert Tree: Single Messages
DB2ASUTIL Performance Values for OS/390 Address Spaces
DB2BACKUP DB2/390: Backup Needed
DB2BPCTRL Buffer Pool Table Control
DB2BPTUNE1 DB2/390: Buffer Pool Tuning
DB2CATINX Info on Indexes from DB2 Catalog Table SYSIBM.SYSINDEXES
DB2CATTAB Info on Tables from DB2 Catalog Table SYSIBM.SYSTABLES
DB2CCDLOUT Output List of CC/390 Stored Procedure DSNACCDL
DB2CCDSIN Structure of global temp DS input table DSNACC.DSNRECORDS
DB2CCEXC Structure of DSNACCOR exception table (EBCDIC)
DB2CCMOT1 Structure of global temp input table DSNACC.MO_TBL
DB2CCMOT2 Structure of global temp input table DSNACC.MO_TBL2
DB2CCMOUT Output List of CC/390 Stored Procedure DSNACCMO
DB2CCOUT Output List of Table-/Indexspace of CC/390 Stored Procedures
DB2CCOUTIX Output List of index of CC/390 Stored Procedures
DB2CCOUTTS Output List of Tablespace of CC/390 Stored Procedures
DB2CHAR18 Structure for typing internal tables with one column CHAR18
DB2CHAR8 Structure for typing internal tables with one column CHAR8
DB2CPYTSC DB2/390: COPY Parameters for Control Center Stored Procedure
DB2CPYTSP DB2/390: COPY parameters
DB2DBSIZH DB2/390: History of R/3 System Size (DB02)
DB2DSINFO Storage and Catalog Information on DB2 Datasets
DB2DSNUC Control Center stored procedures parameters
DB2DSNUP DB2/390: Parameters Passed to DSNUTILS Stored Procedure
DB2DSSTOR Storage Information on Datasets Allocated by DB2
DB2DSVOL List of Volumes on which R/3 Datasets Reside
DB2EXTMON DB2/390: Structure for DB02's Extent Monitor
DB2EXTMONT DB2/390: Table Control Structure for DB02's Extent Monitor
DB2ICLISRV DB2/390: ICLI Server Information
DB2IFI313 DB2/390: Structure for Long-Running Units of Recovery
DB2INT2C Test Structure for Integer 2
DB2IXDETL Detailed Information on a DB2 Index
DB2IXDETLP Detailed Information on a Partition of a DB2 Index
DB2IXDYN Dynamics of the Size of Indexes
DB2IXDYNT Template for List Output: Dynamics of Size of Indexes
DB2IXHIS DB2/390: Storage Information on R/3 Indexes
DB2IXHISRG Time Range of the History of Index Sizes
DB2IXKEY DB2/390: Description of the Key of an Index
DB2IXSIZE DB2/390: Storage Information on R/3 Indexes
DB2IXSIZED DB2/390: Storage Information on Datasets of Indexes
DB2IXSIZEO DB2/390: Storage information on R/3 indexes
DB2IXSIZEP DB2/390: Storage Information on Partitions of Tablespaces
DB2IXSIZEV DB2/390: Storage Information on R/3 Indexes
DB2JCLSS Types of JCL Submission Services
DB2JOBPROFILE JCL job profiles
DB2LOCKSH Locked Resources for a Thread
DB2LOCKSHC Locked Resources for a Thread
DB2MCPTSP DB2/390: MERGECOPY Parameters
DB2MONIKEY Key for Access to Table MONI
DB2NQW03C Number of Waiters and Holders on a Resource
DB2Q3ST accumulated statistics for SSSS and SSAM resource manager
DB2Q3STC accumulated statistics for SSSS and SSAM resource manager
DB2Q9ST command statistical counters
DB2Q9STC command statistical counters
DB2QBAC Buffer Pool Statistics Data
DB2QBACC Buffer Pool Statistics Data
DB2QBGA DB2/390: Group Buffer Pool for Given Thread
DB2QBGAC DB2/390: Group Buffer Pool for Given Thread
DB2QBGB DB2/390: Group Buffer Pool Parameters
DB2QBGL Statistics Group Buffer Pool
DB2QBGLC Statistics Group Buffer Pool
DB2QBST Buffer Manager Statistics Block
DB2QDBP Buffer Manager Dynamic Pool Attributes
DB2QISE EDM Pool Statistics
DB2QISEC EDM Pool Statistics
DB2QIST DB2/390 Datamanager Statistics
DB2QISTC DB2/390 Datamanager Statistics
DB2QJST log manager statitics block
DB2QJSTC log manager statitics block
DB2QSTC Structure for Statement Trace
DB2QTGA DB2/390: Data Sharing Locking for Given Thread
DB2QTGAC DB2/390: Data Sharing Locking for Given Thread
DB2QTGS DB2/390: Statistics Global Locking
DB2QTGSC DB2/390: Statistics Global Locking
DB2QTST service controller statistics block
DB2QTSTC service controller statistics block
DB2QTXA SSC statitics and accounting data mapping
DB2QTXAC SSC statitics and accounting data mapping
DB2QWHC correlation data mapping
DB2QWHCC correlation data mapping
DB2QWHS instrumentation header mapping
DB2QWHSC instrumentation header mapping
DB2QWP1 Installation Parameters (DSN6SYSP)
DB2QWP2 Installation Parameter (LOG)
DB2QWP3 DB2/OS390 Installation Parameter (Archive)
DB2QWP4 Instrumentation Mapping for System Initialization Parameter
DB2QWP6 VSAM Catalog Qualifier Used for Database Dataset (DB2)
DB2QWP8 Databases to be Started Automatically During DBM1 Startup
DB2QWP9 Facility Start Information (DB2/OS390)
DB2QWPA Data Sharing Group Initialization Parameters
DB2QWPB Application Programming Defaults (DB2 for OS390)
DB2QWSD instrumentation mapping for statistics information
DB2QWSDC instrumentation mapping for statistics information
DB2QXST RDS Statistics Block
DB2QXSTC RDS Statistics Block
DB2RDI SQL Statement Data
DB2REBIDX DB2/390: REBUILD INDEX Parameters
DB2RECTSP DB2/390: RECOVER TABLESPACE Parameters
DB2REOIDX REORG INDEX Parameters
DB2REOTSP REORG TABLESPACE Parameters
DB2RSTLIST List of tablespaces on which RUNSTATS is to be run
DB2RSTTSP DB2/390: RUNSTATS TABLESPACE parameters
DB2RSTTSPI DB2/390: RUNSTATS TABLESPACE INDEX parameters
DB2RSTTSPT DB2/390: RUNSTATS TABLESPACE TABLE parameters
DB2RUNST DB2/390: Runstats Needed
DB2SDBAHI Internal Table for sdba Results used for RFC purposes
DB2SELCHAR Structure for character field selection
DB2SELDB Structure for database selection
DB2SELTB Structure for table selection
DB2SELTS Structure for tablespace selection
DB2SPREBIX REBUILD INDEX Parameters for Stored Procedures
DB2SPRUNTS RUNSTATS Parameters for Stored Procedures
DB2STATDEC DB2/390: Buffer Pool Tuning: Table Categorisation
DB2SUSCRNC Fields for DB2 for OS/390 Performance Monitor Subscreen
DB2SWPARM Summary Structure for System-Wide Parameters
DB2SWPARMC Summary Structure for System-Wide Parameters
DB2SYSPARC Derived DB2 System Parameters
DB2SYSPRNT DB2/390: Structure of table SYSIBM.SYSPRINT
DB2TABONL DB2/390: Screen for Online Space Info on a Table (DB15)
DB2TABSTAT DB2/390: Screen for Statistical Space Info on a Table (DB15)
DB2TBCOLS DB2/390: Column Definition of a Database Table
DB2TBDETL Detailed Information on a Table from the DB2 Catalog
DB2TBIXSUM DB2/390: Initial Screen for Table and Index Monitor (DB02)
DB2TBLIST DB2/390: List of Tables
DB2TDUMMY Dummy Structure for Internal Use
DB2THREADC DB2 Performance Monitor: Thread List
DB2THREADS DB2 Performance Monitor: Thread List
DB2TIMEGC DB2 for OS/390 Times over all Threads
DB2TIOUTHW Timeout Structure (Holder and Waiter)
DB2TIOUTRS Timeout Structure (Resource and Victim)
DB2TS_SIZE DB2/390: Type for int. table of size info of tablespaces
DB2TSDETL Detailed Information on a DB2 Tablespace
DB2TSDETLP Detailed Information on a Partition of a DB2 Tablespace
DB2TSDYN Dynamics of the Size of Tablespaces
DB2TSDYNO Dynamics of the size of tablespaces
DB2TSDYNT Template for List Output: Dynamics of Size of Tablespaces
DB2TSHIS DB2/390: Storage Information on R/3 Tablespaces
DB2TSHIS_O DB2/390: Storage information on R/3 tablespaces
DB2TSHISRG Time Range of the History of Tablespace Sizes
DB2TSSIZE DB2/390: Storage Information on R/3 Tablespaces
DB2TSSIZED DB2/390: Storage Information on Datasets of Tablespaces
DB2TSSIZEO DB2/390: Storage information on R/3 tablespaces
DB2TSSIZEP DB2/390: Storage Information on Partitions of Tablespaces
DB2TSSIZEV DB2/390: Storage Information on R/3 Tablespaces
DB2TSVOL List of Volumes on which the Datasets of a Tablespace Reside
DB2VCATTAB DB2/390: List of VCAT Names
DB2VERSION DB2/390: Input for Function DBSYCHK_COMPARE_VERSION
DB2VOLLST List of Volumes on which R/3 Objects Reside
DB2VOLLSTF Free Space on OS/390 DASD
DBA_DATTIM Date and Time of a Scheduled DBA Action
DBSTAIDB2N Copy of DBSTATIDB2 with all components DB2 SMALLINT-conform
DBSTATDB2N Copy of DBSTATTDB2 with all components DB2 SMALLINT-conform
FMPROG_REF Referenz auf eine Anweisung in einem ABAP Programm->PROG_REF
PLAN_TABLE DB2 for OS/390: Plan Table
SALDB2AL DB2/390: Database Alert Threshold

Programs

The package STU2 contains 46 programs.

DB2_DBCONINFO Program DB2_DBCONINFO
DB2_DISPLAY_CATALOG Program DB2_DISPLAY_CATALOG
MONI_WHOLE_TREE_DB2 ALERTS NEXT GEN: Build Entire DB2/390 Monitoring Tree
MONI_WHOLE_TREE_DB2_2 ALERTS NEXT GEN: Build Entire DB2/390 Monitoring Tree (Rel >= 4.6A)
RSANADB2 Analyze PLAN_TABLE
RSDB2_COLLECT_DAILY Program RSDB2_COLLECT_DAILY
RSDB2_COLLECT_HOURLY Program RSDB2_COLLECT_HOURLY
RSDB2060 Program RSDB2060
RSDB2850 Backup History for Transaction DB12
RSDB2BCKCOLL Collect objects needing a backup and report into alert monitor
RSDB2BPR Buffer Pool Tuning: Table Categorization
RSDB2BPT Buffer Pool Tuning: Table Categorization
RSDB2C00 DB2 Catalog Browser
RSDB2CHECK Data Collector for Database System Check on DB2 for OS/390 (SE16/SE17)
RSDB2CKDB DB2 for OS/390: System Check Parameter Configuration
RSDB2CKRD DB2 for OS/390: Display Results of Database System Check
RSDB2CONLIST Program RSDB2CONLIST
RSDB2COPY_ASYNC Program RSDB2COPY_ASYNC
RSDB2DAL DB2/390: Deletion of old alert table entries
RSDB2DB20 Program RSDB2DB20
RSDB2DBA DB2 for OS/390: Forms for Report Program RSALSUP5
RSDB2DSM Data supplier for database host
RSDB2HS1 Program RSDB2HS1
RSDB2J00 JCL generation and submission
RSDB2LOGSHORT Tables needing RUNSTATS (TODO flag in DBSTATC)
RSDB2LUR DB2/390: Long-running units of recovery
RSDB2OSA Program RSDB2OSA
RSDB2OSC RSDB2OSC - Collecting Tool for OS/390 Data
RSDB2R00 Tables needing a RUNSTATS (TODO-FLAG in DBSTATC)
RSDB2RI0 Indexes needing a REORG
RSDB2RIT Programm RSDB2RTI to look if a reorg is needed for TS and IX
RSDB2RSTCOLL Collect Objects needing RUNSTATS and Report into Alert Monitor
RSDB2RT0 Tablespace needing a REORG
RSDB2RTC Tablespaces and indexes in RESTRICT mode
RSDB2RTRCOLL Collect tspaces which in RESTRICT mode and report into alert monitor
RSDB2RXRCOLL Collect indexes which in RESTRICT mode and report into alert monitor
RSDB2SDB Copy Contents of Table SDBAD to SDBADDB2
RSDB2SWITCH Switching of Database Host
RSDB2T0D Refresh Screen 0110 for RSDB2060
RSDB2T2M Transaction DB02 Update
RSDB2TIO DB2 for OS/390: Timeout Monitor
RSDB2U00 DB2 for OS/390 database administration using DSNUTILS
RSXPLDB2 PLAN_TABLE analysis
SAPJCL00 JCL Service Main Module
SAPJCL01 List JCL file contents
SAPJCLXX Program SAPJCLXX

Message Classes

The package STU2 contains 1 message classes.

D3 CCMS - DB2 on OS390

Authorization Objects

The package STU2 contains 1 authorization objects.

S_DB2_ADM DB2/390: Database Administration