The package STUI (Informix Database Monitor) is a standard package in SAP ERP. It belongs to the parent package BASIS.
Package | STUI |
Short Text | Informix Database Monitor |
Parent Package | BASIS |
SAP Package STUI contains 3 function groups.
SDBI | Informix Database Administration |
---|---|
STD2 | Informix Database Statistics Modules |
STUI | INFORMIX Performance Monitor |
SAP Package STUI contains 1 database tables.
ONSTATOPT | Options for INFORMIX Tool 'onstat' |
---|
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 |
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 |