Appropriate Content: Informix Documentation Team

Top 10 Informix Support Issues: Chat with the Lab Recording

IngeHalilovic Tags: database server informix support 1,468 Visits

If you missed the Chat with the Labs last week, listen to the replay here: https://www.ibm.com/developerworks/wikis/display/ifmxchatwithlab/Home. Two IBM® Informix® support engineers, Ron Privitt and Sanjit Chakraborty, discuss the top 10 issues that generate support calls. You'll hear about the issues, how to solve and prevent them, and tips on what information to gather so that support can solve your problems quicker.

Should you remove in-place alters before upgrading or reverting?

96QY_Pat_Smith Tags: upgrade versions alters migrate revert in-place 897 Visits

While removing in-place alters is not required before upgrading to Version 11.70, a best practice is to remove all in-place alters before upgrading.

If you upgraded, created in-place alters in the new version, and must revert, you must ensure that the in-place ALTER operations are complete by running a dummy UPDATE statement against the table. If the reversion process does not complete successfully because of in-place ALTER operations:

The reversion process will list all of the tables that need dummy updates.

You must perform a dummy update on each of the tables in the list before you can revert to the older database server.

For more information, see the Preparing to migrate and Preparing to revert Migration Guide topics in the Version 11.70 IBM Informix Information Center.

More dynamically updatable configuration parameters for Informix 11.70.xC4

IngeHalilovic Tags: onmode dynamic informix configuration onconfic database 1,387 Visits

For IBM® Informix® 11.70.xC4, you can update the following additional configuration parameters while the server is running by using the onmode -wf or onmode -wm commands: ALARMPROGRAM, AUTO_REPREPARE, BLOCKTIMEOUT, CKPTINTVL, DBSPACETEMP, DEADLOCK_TIMEOUT, DEF_TABLE_LOCKMODE, DIRECTIVES, DRINTERVAL, DRTIMEOUT, FILLFACTOR, LOGSIZE, LTAPEBLK, LTAPEDEV, LTAPESIZE, MSGPATH, ONDBSPACEDOWN, OPTCOMPIND, RA_PAGES, SHMADD, STACKSIZE, SYSALARMPROGRAM, TAPEBLK, TAPEDEV, TAPESIZE, TBLTBLFIRST, TBLTBLNEXT, TXTIMEOUT, and WSTATS.

See the full list of configuration parameters that you can update dynamically with the onmode -wf or -wm command for Informix 11.70.xC4.

Easier way to find the latest PDFs of Informix manuals

IngeHalilovic Tags: pdf manual publications informix database 1,095 Visits

Happy new year!

The Informix documentation team has already fulfilled one of our new year's resolutions: to make it easier to find the latest version of the 11.70 product manuals in PDF format. Check out this document, which links to the most recently published version of each of the 11.70 manuals, including translated versions of the manuals.

Let us know if you like it!

Feed for Blog Entries ▼ Feed for Blog Comments ▼