SAP Package STU2
CCMS for DB2 for OS/390
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The package STU2 (CCMS for DB2 for OS/390) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | STU2 |
| Short Text | CCMS for DB2 for OS/390 |
| Parent Package | BASIS |
Function Groups
SAP 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
SAP 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
SAP 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
SAP 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
SAP 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
SAP 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
SAP Package STU2 contains 1 message classes.
| D3 | CCMS - DB2 on OS390 |
|---|
Authorization Objects
SAP Package STU2 contains 1 authorization objects.
| S_DB2_ADM | DB2/390: Database Administration |
|---|