ALLBASE/SQL Performance and Monitoring Guidelines [ MPE/iX Documentation Guide ] MPE/iX 5.0 Documentation
MPE/iX Documentation Guide
ALLBASE/SQL Performance and Monitoring Guidelines
Customer Order Number: 36216-90102
Part Number: Use customer order number
Functional Focus: ALLBASE database administration
This guide describes how to improve the performance of your ALLBASE/SQL
database.
This guide contains information on the following topics:
* Improving performance through logical and physical data design.
* Writing queries and transactions for best performance.
* Administering the database for best performance.
* Tuning your operating system for best performance with
ALLBASE/SQL.
* Troubleshooting performance problems with SQLMON, an online tool
for monitoring the activity of a DBEnvironment.
* Using the SQLMON screens and commands.
MPE/iX 5.0 Documentation