SAP Package STU4
iSeries: CCMS
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The package STU4 (iSeries: CCMS) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | STU4 |
| Short Text | iSeries: CCMS |
| Parent Package | BASIS |
Function Groups
SAP Package STU4 contains 9 function groups.
| S4UP | iSeries-Specific Functions for Upgrade |
|---|---|
| SDB4CCMS | iSeries: CCMS |
| STU4 | iSeries CCMS |
| STU4_DB02 | iSeries: Function Modules for DB02 |
| STU4_DB12 | iSeries: Function Modules used by DB12 |
| STU4_EXPLAIN | iSeries: Function Modules for 'Explain' |
| STU4_RZ20 | iSeries: Function Modules for RZ20 |
| STU4_ST04 | iSeries: Function Modules for ST04 |
| STU4_TCC | iSeries: Function Modules used by TCC |
Transactions
SAP Package STU4 contains 5 transactions.
| DB4COCKPIT | iSeries: Cockpit for CCMS Transact. |
|---|---|
| DB4DB12 | iSeries: Backup and Recovery |
| DB4DGN | Diagnostics |
| DB4LCK | Lock Monitor |
| DB4PTFCHK | PTF Check |
Database Tables
SAP Package STU4 contains 23 database tables.
| DB4_CLUSTER | iSeries: Temporary Statistics Data |
|---|---|
| DB4BACKUP | Store DB4 Backup Data |
| DB4INDEX_HIST | History of Index Sizes in the Database |
| DB4INDEX_STAT | Index Sizes in the Database |
| DB4NAVSYST | iSeries: System Registration Table |
| DB4OX | iSeries: CCMS Object Existence Check |
| DB4TABLE_HIST | History of Table Sizes in the Database |
| DB4TABLE_STAT | Table Sizes in the Database |
| DBSTAIHDB4 | History of Index Sizes in the Database |
| DBSTATHDB4 | History of Table Sizes in the Database |
| DBSTATIDB4 | Index Sizes in the Database |
| DBSTATTDB4 | Table Sizes in the Database |
| SQ1000_DB4 | iSeries: SQL Information (Database Monitor) |
| SQ1000_RST | iSeries: SQL Information (Database Monitor ) |
| SQ3000_DB4 | iSeries: Table Scans (Database Monitor) |
| SQ3001_DB4 | iSeries: Used Indexes (Database Monitor) |
| SQ3002_DB4 | iSeries: Created Indexes (Database Monitor) |
| SQ3003_DB4 | iSeries: Sorts (Database Monitor) |
| SQ3004_DB4 | iSeries: Temporary Files (Database Monitor) |
| SQ3007_DB4 | iSeries: Optimizer Timed Out (Database Monitor) |
| SQ3008_DB4 | iSeries: Subqueries (Database Monitor) |
| SQHVAR_DB4 | iSeries: Host Variable Values for Most Exp. Exec. of a Stmt. |
| SQTEXT_DB4 | iSeries: SQL Statement Text (Database Monitor) |
Structures
SAP Package STU4 contains 117 structures.
| AS4_API_11 | iSeries: Structure for API api_lstpkglib (Internal) |
|---|---|
| AS4_API_12 | iSeries: Structure for API api_lstpkgobj (Internal) |
| AS4_API_13 | iSeries: Structure for API api_lstpkginf (Internal) |
| AS4_API_14 | iSeries: Structure for API api_qqqqsdbm (Internal) |
| AS4_API_16 | iSeries: Structure for API api_getjoblcks (Internal) |
| AS4_API_17 | iSeries: Structure for API api_getrcdlcks (Internal) |
| AS4_API_18 | iSeries: Structure for API api_lstallsplf (Internal) |
| AS4_API_2 | iSeries: Structure for API api_waitstats (internal) |
| AS4_API_23 | iSeries: Structure for API api_parseinfoapar (Internal) |
| AS4_API_3 | iSeries: Structure for API api_damaged_files (internal) |
| AS4_API_30A | iSeries: Structure for API api_rtvjrninfo (Internal) |
| AS4_API_30B | iSeries: Structure for API api_rtvjrninfo (Internal) |
| AS4_API_5 | iSeries: Structure for API API_REVPCKMAP (internal) |
| AS4_API_6 | iSeries: Structure for API api_get_opencurs (internal) |
| AS4_API_7 | iSeries: Structure for API api_getviewtext (Internal) |
| AS4_API_8 | iSeries: Structure for API api_getdbjobs (Internal) |
| AS4_API_SRVDATA | iSeries: Server Data (Internal) |
| AS4_VIEWTEXT | iSeries: View Text |
| AS4ALVPTF | iSeries: PTF Check |
| AS4DSTCFG | iSeries: Configure DST-Switch |
| AS4ESMFR | iSeries Extended Memory Management: Free Resources |
| AS4PTF | iSeries: PTF Status |
| AS4PTF_1 | iSeries: PTF Level on all Active Application Servers |
| AS4PTFNEW | iSeries: PTF Status |
| AS4RMAS | iSeries Roll Management: Active Storage Space |
| AS4RMFRA | iSeries Roll Management: Free Roll Area |
| AS4RMFUM | iSeries Roll Management: Free List |
| AS4RMI | iSeries Roll Management: Internal Information |
| AS4RMR | iSeries Roll Management: Resources |
| AS4RMRA | iSeries Roll Management: Roll Area Management |
| AS4RMUM | iSeries Roll Management: User Management |
| BACKUPDB4 | Backup of the SAP Database Library on iSeries |
| BACKUPINFO | Backup Information on iSeries |
| CHANGESTR | Change of size of table |
| DB02INFDB4 | Structure for Main Screen of DB02 for iSeries |
| DB4_DBMACT | iSeries: Database Monitor Activity per Process (DB Jobs) |
| DB4_EXPLAIN | iSeries: Database Monitor |
| DB4_FILE | iSeries: Structure for LIbrary/File |
| DB4_HISTIM | iSeries Database Performance: Avail. DBMonitor History Info |
| DB4_JOBLCK | iSeries: Jobs Holding/Waiting for a Database Record Lock |
| DB4_JOBSTS | iSeries: Jobs on iSeries Incl. the Job Status (s. WRKACTJOB) |
| DB4_RCDLCK | iSeries: DB Record Locks Held by a Job |
| DB4_SQ1000 | iSeries: SQL Information (Database Monitor) |
| DB4_SQ3000 | iSeries: Table Scans (Database Monitor) |
| DB4_SQ3001 | iSeries: Used Indexes (Database Monitor) |
| DB4_SQ3002 | iSeries: Created Indexes (Database Monitor) |
| DB4_SQ3003 | iSeries: Sorts (Database Monitor) |
| DB4_SQ3004 | iSeries: Temporary Files (Database Monitor) |
| DB4_SQ3007 | iSeries: Optimizer Timed Out (Database Monitor) |
| DB4_SQ3008 | iSeries: Subqueries (Database Monitor) |
| DB4_SQHVAR | iSeries: Host Variable Values for Most Exp. Exec. of a Stmt. |
| DB4_SQTEXT | iSeries: SQL Statement Text (Database Monitor) |
| DB4_TIMESTAMP | iSeries: Timestamp |
| DB4AVGSPC | iSeries: Avarage Growth Rate per Table |
| DB4DBJOBS | iSeries: Database Jobs |
| DB4DBMACTP | iSeries: Database Monitor Activity per Process (DB Jobs) |
| DB4DBMCFG | iSeries: For Memory-Resident DB Monitor Configuration |
| DB4DBMON | iSeries: Database Monitor Header Info for ST04 |
| DB4DLTREC | DB2 UDB for iSeries: Deleted Records |
| DB4FLESTAT | iSeries: File Statistics |
| DB4HISTSPC | iSeries: Space Statistics |
| DB4IDA0100 | iSeries: Database Performance: Advised Indexes (Main screen) |
| DB4IDA0200 | iSeries: Database Performance: Advised Indexes (Detail scr.) |
| DB4IDA0300 | iSeries: Database Performance: List of Advised Indexes |
| DB4IDC0100 | iSeries: Database Performance: Created Indexes (Main screen) |
| DB4IDC0200 | iSeries: Database Performance: Created Indexes (Detail scr.) |
| DB4IDU0100 | iSeries Database Performance: Used Indexes (Main screen) |
| DB4IDU0200 | iSeries Database Performance: Used Indexes (Detail screen) |
| DB4IDULST | iSeries: LIB/TABLE/CST Structure for ST04_DB4_GET_IDU_INFO |
| DB4IXKEYLIST | List of key fields in an index |
| DB4JOBDATA | iSeries: Qualified Jobname |
| DB4JOBLCKS | iSeries: Jobs Holding/Waiting for a Database Record Lock |
| DB4JOBLOG | iSeries: Job Log |
| DB4LCKLST | iSeries: Database Jobs of all Instances of an SAP System |
| DB4LCKSTAT | iSeries: DB Record Locks Held by a Job |
| DB4PKGLIB | iSeries: Libraries Containing SQL Packages |
| DB4PKGTXT | iSeries: Content of one SQL Package |
| DB4QQPAR | Fields for Parameter References (DBMon for iSeries) |
| DB4SIZE | DB2 UDB for iSeries: Database Size |
| DB4SPLFLST | iSeries: Structure for List of Spool Files |
| DB4SQLNAM | iSeries: SQL Names |
| DB4SQLPKG | iSeries: SQL Packages |
| DB4SQR0100 | iSeries Database Performance: SQL Requests/Top 50 |
| DB4SRT0100 | iSeries Database Performance: Sorts |
| DB4SRVLST | iSeries: List of Active Application Servers |
| DB4ST4RFC | iSeries: Performance Overview (RFC Destinations) |
| DB4SYSIXADV | iSeries: SQE Index Advised Information |
| DB4TABLST | iSeries: LIB/TABLE Structure for ST04_DB4_GET* Functions |
| DB4TMF0100 | iSeries Database Performance: Temp. File Creates (Main Scr.) |
| DB4TSC0100 | iSeries Database Performance: Table Scans |
| DB4TSC0200 | iSeries Performance: Table Scans (Detail Screen) |
| DB4TSTAMP | DB2 UDB for iSeries: Timestamp |
| DB4WAITSTS | Wait Statistics for DB2 UDB for iSeries |
| DB4WTSTS_I | iSeries: Wait Statistics Cumulated per Instance |
| DB4WTSTS_P | iSeries: Wait Statistics per Process (Database Jobs) |
| DB4WTSTS_S | iSeries: Wait Statistics Cumulated over all Instances |
| DHISTSTRU | History data in db02_db4_get_space_info |
| HISTSTR | structure for hist parameter of fct. db02_db4_get_space_info |
| HISTSTRU | History Data of db02_get_space_info |
| PARTBCKDB4 | Missing tables in partial backups of the database library |
| PBACKUPDB4 | Partial Backups of the SAP Database Library on iSeries |
| QSYSCOLUMN | iSeries: System Catalog View of Table Fields (SYSCOLUMNS) |
| QSYSCST | iSeries: System Catalog View of Constraints (SYSCST) |
| QSYSINDEXS | iSeries: System Catalog View of Tables in SAP Data Library |
| QSYSKEYCST | iSeries: System Catalog View of Constraints Columns |
| QSYSKEYS | iSeries: System Catalog View of Constraints Columns |
| QSYSTABLES | iSeries: System Catalog View of Tables in SAP Data Library |
| QSYSVIEWDP | iSeries: System Catalog View of View Dependencies on Tables |
| QSYSVIEWS | iSeries: System Catalog View of Tables in SAP Data Library |
| RCVDIRDB4 | Backup Information about Receiver Directory on iSeries |
| SPIMPAR | iSeries: Space Statistics |
| SQHIST_DB4 | iSeries: History Table for Database Performance Overview |
| SQIXADVDB4 | Structure for Index Advised Information |
| SQLTABLE_DB4_T | iSeries: Table Names |
| SUMSTR | used for parameter sum in get_db4_space_statistics |
| TABINCSTRU | Deltas in history tables of db02_db4_get_space_info |
| TIMESDWM | Time structure used in FB db02_db4_get_space_info |
Programs
SAP Package STU4 contains 61 programs.
| RIFSTOTABLE | Map DB4-Backup-Log in IFS into SAP Table |
|---|---|
| RSDB4_TEST_API | Test AS/400 APIs |
| RSDB4_TEST_API_2 | Test AS/400 APIs |
| RSDB4_TEST_DBMON_FILES | Include LPHOCF01 |
| RSDB4003 | File Activity |
| RSDB4007 | iSeries: Display Wait Statistics by SAP Instance |
| RSDB400X | iSeries: Performance Monitor Overview (new DBMON) |
| RSDB4060 | iSeries: DB02 (Main Screen) |
| RSDB4090 | iSeries: Database Activity |
| RSDB409C | Cleanup DBSTA+HDB4 |
| RSDB4850 | Display Logs |
| RSDB4ADM | iSeries |
| RSDB4ANALYZE_V5R3_PLANCACHEDMP | Report RSDB4ANALYZE_V5R3_PLANCACHEDMP |
| RSDB4BFT | Filter Backup Data into MONI, used in DB12 |
| RSDB4DBA | ORACLE-Dependent FORMs for SAPDBA |
| RSDB4DBH | iSeries: Display History of DBMonitor Overview from MONI |
| RSDB4DDC | iSeries: Display Data Dictionary Information (Overview) within ST04 |
| RSDB4DLT | Report for displaying tables with deleted records. |
| RSDB4DMP | iSeries: Dump DBMon Info Depending on Current Timestamp |
| RSDB4DOA | Display detailed object analysis (used in DB02 for AS/400) |
| RSDB4EXP | DB2/400: Explain |
| RSDB4GEN | iSeries: Generate EXEC SQL Reports Used in CCMS |
| RSDB4IDA | Database Performance: Index Advised |
| RSDB4IDC | Database Performance: Index Creates |
| RSDB4IDU | Database Performance: Index Usage |
| RSDB4LCK | iSeries: Database Lock Monitor |
| RSDB4PKG | Display SQL Packages |
| RSDB4PREP_UCPC | Program RSDB4PREP_UCPC |
| RSDB4SDBM | iSeries: Start/Stop Database Monitor |
| RSDB4SQA | Display Statement Text (SQTEXT_DB4) Performance Table |
| RSDB4SQB | Display hostvariables for exp. Statem. (SQHVAR_DB4) Performance Table |
| RSDB4SQC | Display the SQL Query Information (SQ1000_DB4) Performance Table |
| RSDB4SQD | Display the Arrival Sequence (SQ3000_DB4) Performance Table |
| RSDB4SQE | Display the Indexes Used (SQ3001_DB4) Performance Table |
| RSDB4SQF | Display the Indexes Created (SQ3002_DB4) Performance Table |
| RSDB4SQH | Display the Sorts (SQ3003_DB4) DB2/400 performance view |
| RSDB4SQI | Display the Temporary Files (SQ3004_DB4) Performance Table |
| RSDB4SQK | Display the Optimizer Time Outs (SQ3007_DB4) Performance Table |
| RSDB4SQM | Display the Subqueries (SQ3008_DB4) Performance Table |
| RSDB4SQR | iSeries: SQL Requests |
| RSDB4SRT | Database Performance: Sorts |
| RSDB4SY1 | Display the SQL Catalog view of SYSTABLES |
| RSDB4SY2 | Display the SQL Catalog view of SYSCOLUMNS |
| RSDB4SY3 | Display the SQL Catalog view of SYSCST |
| RSDB4SY4 | Display the SQL Catalog view of SYSKEYCST |
| RSDB4SY5 | Display the SQL Catalog view of SYSINDEXES |
| RSDB4SY6 | Display the SQL Catalog view of SYSKEYS |
| RSDB4SY7 | Display the SQL Catalog view of SYSVIEWS |
| RSDB4SY8 | Display the SQL Catalog view of SYSVIEWSDEP |
| RSDB4TAM | iSeries: Display Statistic History of Tables and Indexes |
| RSDB4TMF | iSeries: Temporary FileCreates |
| RSDB4TSC | Database Performance: Table Scans |
| RSDB4UPD | Update SAP Database Performance Tables (iSeries: Memory-Resid DBMon) |
| RSDB4UPG | RSDB4UPG: Model Report for RSDB4UPD (iSeries: Memory-Resident DBMon) |
| RSDB4XPL | DB2/400 Explain |
| RSDSAS4_MEM_MGMT | Program RSDS_AS4_MEM_MGMT |
| RSDSAS4_OS_POOL | D |
| RSDSAS4_PTF_CHECK | iSeries Monitoring Architecture: Data Collection Method for PTF Check |
| RSDSTDB4 | Read DB Statistics Data for Application Monitor (ORACLE) |
| RSMDB401 | iSeries: Data Collection Method for Database Monitoring |
| RSXPLDB4 | iSeries Forms for Function Module DB_EXPLAIN_PLAN |