Menu

SAP Package STUI

Informix Database Monitor

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