Appropriate Content: Informix Documentation Team

From archive: March 2012

Alerts for tables with in-place alter operations

96QY_Pat_Smith Tags: in-place alters ph_alert ‎ 2,936 Views

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 .

Find what you need and then some!

jmcdavid ‎ 2,100 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

http://pic.dhe.ibm.com/infocenter/informix/v121/index.jsp

11.70 Information Center: Complete 11.70 documentation and a portal full of useful links

http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp

11.50 Information Center: Complete 11.50 documentation and a portal full of useful links
http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp

The IBM Informix Virtual Appliance: Available through the free-product download site
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.virtappnode.doc/virtnode.htm

Informix Exchange Collection: A place to view code samples and examples, and to share your own

http://www.ibm.com/developerworks/software/exchange/informix

Informix Frequently Asked Questions (FAQ): Find the answers to common questions about installation, upgrading, and administration
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.ifx_faq.doc/ifx_faq.htm

List of Informix-Related Blogs: Hear what Informix experts are saying, from inside and outside of IBM
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.community.doc/blogs.htm

Informix Warehousing Portal: Resources for implementing Informix dimensional databases, creating data warehouse applications, and optimizing your data warehouse queries
http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.datawhsenode.doc/datawhse.htm

The International Informix Users Group (IIUG) Forums: Join the conversation and share ideas with other Informix users
http://www.iiug.org/forums

The OpenAdminTool Youtube Channel: Videos of key OAT features
https://www.youtube.com/user/OpenAdminToolChannel/feed

Modified on by jmcdavid

IBM Informix Genero version 2.40 documentation is available

AnaB Tags: programming informix genero 4gl database ‎ 4,097 Views

For the first time, the IBM® Informix® Genero® documentation is available in the Informix 11.70 Information Center. The doc is fully indexed and searchable.

See the Release Notes for Informix Genero new feature information.

Connection Manager event alarms

96QY_Pat_Smith Tags: events event_alarms connection ‎ 2,946 Views

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:

The Connection Manager instance name in the INFORMIXCMNAME environment variable
The Connection Manager connection unit name in the INFORMIXCMCONUNITNAME environment variable.

For more information, see Connection Manager event alarms.

Feed for Blog Entries Feed for Blog Comments

Blogs