The package STU2 (CCMS for DB2 for OS/390) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Package | STU2 |
Short Text | CCMS for DB2 for OS/390 |
Parent Package | BASIS |
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 |
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 |
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 |
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 |
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 |
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 |
SAP Package STU2 contains 1 message classes.
D3 | CCMS - DB2 on OS390 |
---|
SAP Package STU2 contains 1 authorization objects.
S_DB2_ADM | DB2/390: Database Administration |
---|