SAP Package STUI
Informix Database Monitor
Unsere Literaturempfehlung
IDoc-Entwicklung für SAP: Customizing, Erweiterung, Eigenentwicklung
Wenn der Standard nicht ausreicht: Mit diesem Buch lernen Sie, IDocs selbstständig zu programmieren und zu erweitern. Die Autorin beschreibt Customizing-Techniken, die Erweiterung der Standardbausteine und komplette Eigenentwicklungen. Ob Rückmeldungen von Statuswerten, E-Mail-Workflows oder Serialisierung – für alle Aufgaben finden Sie Anleitungen und Tipps aus der Programmierpraxis. Neu in dieser Auflage: Überwachung und Fehlerbehandlung mit dem SAP Application Interface Framework.
Bei amazon.de ansehen →
The package STUI (Informix Database Monitor) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Technical Information
| Package | STUI |
| Short Text | Informix Database Monitor |
| Parent Package | BASIS |
Function Groups
SAP Package STUI contains 3 function groups.
| SDBI | Informix Database Administration |
|---|---|
| STD2 | Informix Database Statistics Modules |
| STUI | INFORMIX Performance Monitor |
Database Tables
SAP Package STUI contains 1 database tables.
| ONSTATOPT | Options for INFORMIX Tool 'onstat' |
|---|
Structures
SAP Package STUI contains 42 structures.
| CRITOBJ | Informix ST04 Critical Object |
|---|---|
| DBSPACDISP | Informix DBSpace Size Display |
| DBSPACEEXT | Informix Table Extents - Extents in DBSPACE |
| DBSPACEIO | Informix Chunk I/O Statistics - I/O Per Chunk |
| DBSPACEIOS | Informix I/O Statistics per Dbspace |
| DBWEEKALL | DBSpace Weekly Change Detail |
| DBWEEKAVE | DBSpace Weekly Change Average |
| EARTABACT | Informix Table Activities Information - For ST04 |
| FLAGS_TEXT | INFORMIX Performance Monitor: Flags Description |
| INFDBSPACE | Informix DBSpace Structure for DB_INF_DB_SPACE_ALL |
| INFFRAGTAB | Informix List of Fragmented Tables |
| INFSQL | One Informix SQL statement |
| INFST04 | ST04 - Informix Monitor Main List |
| INFTABACT | Informix Table Activities Information - For ST04 |
| INFTFLAG | Informix Table Extents 1, 2 Tables, 3 All DBspaces |
| INFVP | Informix Virtual Processor Information |
| INFVPCLASS | Informix Virtual Processor Information |
| INFVPCLDSP | Informix Virtual Processor Display |
| INFVPDISP | Informix Virtual Processor Display |
| INFWAITSTA | Informix Wait Statistics |
| IOPERDEV | Informix Chunk I/O Statistics - I/O Per Device |
| IOPERPATH | Informix Chunk I/O Statistics - I/O Per Path |
| MISSIDX | List of Missing Indexes |
| SDBAIILOG | Informix: Information on Structure of Log Backup |
| SDBAINFREQ | INFORMIX DBA: Onarchive Request Identification |
| SQLSTRUCT | SQL Statement Structure |
| SQLTEXT | SQL Statement Text |
| STUIINDEX | Informix Index Information |
| STUISESINF | Database Sessions and R/3 User and Report Names |
| STUISESSCH | Database Sessions and R/3 User and Report Names |
| STUITHRSTA | Thread Statistics (Informix Monitor) |
| STUIUPDSTA | Update Statistics Information (Informix Monitor) |
| STUIUPDSTD | Update Statistics Detail Information (Informix Monitor) |
| STUIUPDSTI | Update Statistics Information for Indexes (Informix Monitor) |
| TBLEXTENTS | Informix Monitor: Table with More than 10 Extents |
| TBLWOUTIDX | List of Tables Without Indexes |
| TOOMUCHIDX | List of Indexes Not Defined in SAP DDIC |
| TST04INF | Statistics: Structure for Database Information Display |
| TST04MEM | INFORMIX DB Monitor: Shared Memory Monitor Descriptions |
| TUNESTRUCT | Date Definitions for Parameters for Function Module STUI |
| UPDATESTAT | Informix Update Statistics RSINF033 |
| UPDSTAT1 | Update Statistics Information - 'X' = Yes, ' ' = No |
Programs
SAP Package STUI contains 115 programs.
| EXECSQLS | Find And Analyze All R/3 EXEC SQL Statements |
|---|---|
| NROWS | DD: Count table entries |
| RSDBUPSJ | Job for Starting RSDBUPST (for New Installation |
| RSDBUPST | Update Statistics Scheduling (Original from Heinz Wolf) |
| RSINF000 | INFORMIX Performance Analysis |
| RSINF001 | INFORMIX Database (from sysdatabases) |
| RSINF002 | INFORMIX Tables (from systabnames) |
| RSINF003 | INFORMIX Session Waits Profiles (from sysseswts) |
| RSINF004 | INFORMIX Logical Logs (from syslogs) |
| RSINF005 | INFORMIX Chunks (from syschunks) |
| RSINF006 | INFORMIX Dbspaces (from sysdbspaces) |
| RSINF007 | INFORMIX Locks (from syslocks) |
| RSINF008 | INFORMIX Active Sessions (from syssessions) |
| RSINF009 | INFORMIX Session Activity Profile (from syssesprof) |
| RSINF010 | INFORMIX VP Profile (from sysvpprof) |
| RSINF011 | INFORMIX Extents listings (from sysextents) |
| RSINF012 | INFORMIX Profile Listing (from sysprofile) |
| RSINF013 | INFORMIX Data Replication Info (from sysdri) |
| RSINF014 | INFORMIX Chunk io stats (from syschkio) |
| RSINF015 | INFORMIX Partition Profile (from sysptprof) |
| RSINF020 | INFORMIX Partition Header Table (from systabinfo) |
| RSINF021 | INFORMIX Partition Bitmap Table (from sysptnbit) |
| RSINF022 | INFORMIX Chunk Table Info (from syschktab) |
| RSINF023 | INFORMIX Mirrored Chunk Table Info (from sysmchktab) |
| RSINF024 | INFORMIX Shared Memory Header (from sysshmhdr) |
| RSINF025 | INFORMIX Flags_text View (from flags_text) |
| RSINF026 | INFORMIX Chunks Free List (from syschkextents) |
| RSINF027 | INFORMIX Data Distribution Table (sysdistrib) |
| RSINF028 | INFORMIX Mutexes list (from sysmutexes) |
| RSINF029 | INFORMIX Tables Information (from systables) |
| RSINF030 | INFORMIX Databases (from sysdatabases) |
| RSINF031 | INFORMIX Sessions/Threads Monitor |
| RSINF032 | INFORMIX Databases (from sysdatabases) |
| RSINF033 | INFORMIX Partition Profile (from sysptprof) |
| RSINF034 | INFORMIX Sysdistrib Dump per User Entered Table (from sysdistrib) |
| RSINF035 | INFORMIX Update Statistics Information |
| RSINF036 | INFORMIX LRU Buffers (from syslrus) |
| RSINF037 | INFORMIX SQL Distribution Cache (from sysdistcache) |
| RSINF038 | INFORMIX SQL Statements (from syssqlcurall) |
| RSINF039 | INFORMIX DB Monitor: sysconditions |
| RSINF040 | INFORMIX DB Monitor: syssqlcurses |
| RSINF041 | Table DBSTATTINF |
| RSINF042 | INFORMIX DB Monitor: sysdiccache |
| RSINF043 | INFORMIX SQL Statements (from syssqexplain) |
| RSINF044 | INFORMIX Segment Views (from syssegments) |
| RSINF046 | INFORMIX R/3 Database Table Information |
| RSINF047 | INFORMIX Update Statistics Information |
| RSINF048 | Sysfragments Native Display |
| RSINF049 | INFORMIX SQL Monitor |
| RSINF050 | INFORMIX Statistics by Client-INFORMIX Calls |
| RSINF060 | INFORMIX Performance Monitor: Tables |
| RSINF075 | INFORMIX Database Monitor: Memory Monitor (Initial Screen) |
| RSINF076 | INFORMIX Database Monitor: Memory Monitor (Buffer Cache Information) |
| RSINF077 | INFORMIX Active Sessions (from syssessions) |
| RSINF078 | INFORMIX Wait Statistics |
| RSINF079 | INFORMIX Database Monitor |
| RSINF081 | Update Statistics Information for All Indexes |
| RSINF082 | INFORMIX Tables with Lockwaits |
| RSINF084 | INFORMIX Performance Monitor: Database History |
| RSINF085 | INFORMIX Top 50 Tables with Seqential Scans |
| RSINF086 | INFORMIX Top 50 Tables with Deadlocks |
| RSINF087 | INFORMIX Top 50 Tables with Lock Timeouts |
| RSINF088 | INFORMIX Top 50 Tables with Respect to I/O |
| RSINF089 | INFORMIX Top 50 Tables with Respect to Buffer Use |
| RSINF090 | INFORMIX Parameter Settings |
| RSINF110 | INFORMIX Database Parameter Information |
| RSINF114 | INFORMIX Dbspace I/O Statistics |
| RSINF200 | INFORMIX Performance Monitor: Dialog Window with Flags Text |
| RSINF245 | INFORMIX SQL Monitor |
| RSINF246 | INFORMIX SQL Monitor - Without Table Names |
| RSINF600 | INFORMIX Dbspace Information |
| RSINF601 | INFORMIX Tables/Missing Indexes Analysis |
| RSINF602 | INFORMIX Tables/Extents Analysis |
| RSINF603 | INFORMIX Dbspace Chunks Analysis |
| RSINF604 | INFORMIX Dbspace Chunk Free Analysis |
| RSINF605 | INFORMIX Table Extents Analysis |
| RSINF606 | INFORMIX Table Structure Analysis |
| RSINF607 | INFORMIX Table Extents Analysis |
| RSINF608 | INFORMIX User-friendly Chunk Display |
| RSINF609 | INFORMIX Table Extents Analysis |
| RSINF620 | INFORMIX Space Requirements of Tables and Indexes |
| RSINF800 | Start Complete Database Backup |
| RSINF850 | Display Logs |
| RSINF851 | Display ON Archive Catalog Tables |
| RSINF855 | Backup Monitor (Onbar Only) |
| RSINF856 | Information About Logical Log Files (Onbar Only) |
| RSINF860 | INFORMIX Partition Header Table (from sysptnhdr) |
| RSINF861 | INFORMIX Partition Header Table (from sysptnhdr) |
| RSINF862 | INFORMIX Partition Header Table (from sysptnhdr) |
| RSINF863 | INFORMIX Partition Header Table (from sysptnhdr) |
| RSINF870 | Recovery Report |
| RSINF880 | Various Function Routines for Onbar |
| RSINF890 | Show Backup and Restore Actions (onbar: bar_action) (onbar only) |
| RSINF891 | Show Successful Backup Actions (onbar: bar_instance) (onbar only) |
| RSINF892 | Show Backup Objects (onbar: bar_object) (onbar only) |
| RSINF893 | Show Backup Server (onbar: bar_server) (onbar Only) |
| RSINF894 | Show Backup Versions (onbar: bar_version) (onbar only) |
| RSINFADM | Database Administration for Informix Database |
| RSINFDBA | INFORMIX-Specific Forms for SAPDBA |
| RSINFFRM | INFORMIX GET_MAXEXTENT |
| RSINFI98 | onstat |
| RSINFI99 | onstant Commands |
| RSINFINI | INFORMIX Performance Monitor: Additional DB Definitions for SAP R/3 |
| RSINFLCK | Exclusive Lockwaits for Informix |
| RSINFMN0 | Informix Alert Monitor |
| RSINFRAD | RADDBDIF Subroutine for INFORMIX Databases |
| RSINFT0D | INFORMIX Performance Monitor: Tables |
| RSINFT2M | INFORMIX Performance Monitor: Dbspace History |
| RSINFT4M | INFORMIX Performance Monitor: Database History |
| RSINFT6M | INFORMIX Performance Monitor: History of Tables and Indexes (Batch) |
| RSINFTB1 | INFORMIX Table Detail Analysis |
| RSINFTB2 | INFORMIX Table Detail Analysis |
| RSINFTBM | History INFORMIX DBSPACES |
| RSINFTD1 | ddd |
| RSINFVER | Monitor Version |