SAP/Informix Database Monitor
SAP/Informix Database Monitor
Use
You can use the SAP/Informix
database monitor to check the status and performance of the database system. The monitor displays the most important indicators of Informix database performance, that is, shared memory, data buffers, cleaners, log buffers, database activity, checkpointing, and asynchronous IO. All data for the display comes from the database host, either through the SQL interface or the interface to the Informix tool onstat .Integration
All the information provided by the SAP/Informix database monitor is based on the diagnostic information that the Informix database supplies to the SAP System. Since all data comes from the database host, you can look at the same data from every application server in your SAP System.
The definitive documentation for Informix performance tuning comes from the DBMS manufacturer, Informix. Use recommendations from the Informix documentation where they differ from any recommendations given here.
Features
Informix stores statistics on database state and activity either in real tables on disk or virtual tables in memory. These tables in memory are also called "pseudotables" and the interface to these tables is called the "sysmaster interface." The SAP/Informix database monitor is implemented using queries to these tables. The tables can be queried either on the database server or from a separate computer.
The following features are available on many screens in the database monitor:
Choose |
To |
Refresh |
Refresh the values shown on the screen |
Reset |
Reset values to 0 |
Since Reset |
Analyze the time period since you last pressed Reset |
Since DB start |
Display the values that have accumulated since you started the database |
Activities