Listing System Information with SAPDBA
Use
You can use SAPDBA to quickly view information about your Informix database system. For more information, see
System Information with SAPDBA. Although SAPDBA uses onstat Informix commands, you can use this function without knowledge of onstat .Prerequisites
Procedure
- List Informix Message File
- List Informix Configuration File
- List Profile Information
- List User Information
- List Lock Information
- List Physical and Logical Log Information
For more information about the meaning of the individual fields displayed, see the Informix documentation on
onstat .Result
You now have information on the current status of the database, which helps to improve your administration. Make sure you act in good time on the information listed.
The end result is a more highly tuned database that is more available for your users.
See also:
Informix documentation