IDS Forum

Re: upgrading 11.70 to 12.10

Posted By: LONDONMS LONDONMS
Date: Tuesday, 25 February 2014, at 7:38 a.m.

In Response To: Re: upgrading 11.70 to 12.10 (Marcus Haarmann)

==================================================================================
==================================================================================
Link - http://www.ibm.com/developerworks/data/library/techarticle/dm-1304overview/

Migration to Informix 12.10

Following are the migration paths to Informix 12.10:

If you are on version 11.70, 11.50, 11.10, or 10.00, you can upgrade directly to Informix 12.10 on the same operating system.
If you are on earlier versions of the database server that do not support direct upgrade, consider these options:
Upgrade to an earlier, interim version of the database server that supports direct upgrade to 12.10 before you upgrade to Informix 12.10. Refer to the migration information that is included in the documentation set for the interim version of the database server.
Migrate to Informix 12.10, installing it in a new location, and then use the dbexport and dbimport utilities or distributed SQL to move your data into the new database server.

If necessary, you can revert to the version of the database server from which you upgraded; however, you cannot revert to any other version of the database server.

If you have a high-availability cluster or if you use Enterprise Replication, you must coordinate the migration of all servers involved in high-availability clusters or Enterprise Replication. Follow additional procedures to upgrade your servers from the IBM Informix Migration Guide. See Resources for a link.

After successful migration to Informix 12.10, you must complete a series of post-migration tasks to prepare the new version of the server for use. For further details, see the IBM Informix Migration Guide. See Resources for a link.

Note: Starting with Informix 12.10, the support to directly upgrade from versions 7.31 and 9.40 to the new Informix 12.10 was removed.

==================================================================================
==================================================================================
Link - http://informix-technology.blogspot.com.br/2014/01/f-format-date-strings-formatacao-de.html

This article should be read by customers planning the upgrade to versions 12.10.xC2+ or 11.70.xC8+.
IBM made a change in the default behavior for the %F placeholder used in to_char() and to_date() functions as well as GL_DATETIME and DBTIME environemnt variables.
In previous versions, if we used %F in these scenarios, it would include a dot (.) in the output (when we're converting DATE/DATETIME values to text) or would expect the dot in the input when we're loading/reading text into a DATE or DATETIME variable or field.
It's easy, from my point of view, to accept that this should not work like it did. In other words, the behavior was wrong (why would we get a dot if we don't get a ":" by default to separate hours from minutes or minutes from second?) But, as usual with the defaults, changing it means we can break existing usage. So I'm glad I didn't have to decide on this. If I had to, I'd probably prefer to create a new placeholder that would not produce nor expect the dot. But that was not the decision, and I really think this will impact some customers.
Let's see some examples:

==================================================================================
==================================================================================

Messages In This Thread

• upgrading 11.70 to 12.10
  BillHatVerizon -- Monday, 24 February 2014, at 1:46 p.m.
  • Re: upgrading 11.70 to 12.10
    Marcus Haarmann -- Monday, 24 February 2014, at 3:02 p.m.
    • Re: upgrading 11.70 to 12.10
      LONDONMS LONDONMS -- Tuesday, 25 February 2014, at 7:38 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.