Appropriate Content: Informix Documentation Team
In Version 11.70, you can use event alarms to identify Connection Manager error conditions. You can set your alarm program script to capture the Connection Manager class ID and message and initiate corrective actions or notifications.
Starting with version 11.70xC4, you can view the values that the database server sets in the INFORMIXCMNAME and INFORMIXCMCONUNITNAME environment variables when writing an alarm handler for the Connection Manager. If the Connection Manager raises an event alarm, the server automatically creates and stores:
For more information, see Connection Manager event alarms.
With version 11.70, you can see which tables have outstanding in-place alter operations. (Tables that have outstanding in-place alter operations can cause a slight performance degradation.)
Each table with an outstanding in-place alter operation has an informative alert row in the ph_alert table in the sysadmin database. For more information, see In-place alter in the IBM Informix 11.70 Information Center, or see information on the Alerts page of the Health Center in the IBM OpenAdmin Tool for Informix .
jmcdavid 270003BVSW 1,644 Views
Find the information you need, share your ideas, and join the conversation! The following resources can help you do all of these things.
12.10 Information Center: Complete 12.10 documentation and a portal full of useful links
11.70 Information Center: Complete 11.70 documentation and a portal full of useful links
11.50 Information Center: Complete 11.50 documentation and a portal full of useful links
The IBM Informix Virtual Appliance: Available through the free-product download site
Informix Exchange Collection: A place to view code samples and examples, and to share your own
Informix Frequently Asked Questions (FAQ): Find the answers to common questions about installation, upgrading, and administration
List of Informix-Related Blogs: Hear what Informix experts are saying, from inside and outside of IBM
Informix Warehousing Portal: Resources for implementing Informix dimensional databases, creating data warehouse applications, and optimizing your data warehouse queries
The International Informix Users Group (IIUG) Forums: Join the conversation and share ideas with other Informix users
The OpenAdminTool Youtube Channel: Videos of key OAT features