IBM Support

IC66184: MIGRATION FROM IDS 10 TO IDS 11.50.FC6 FAILS WHEN ONE DATABASE USES CODESET UTF8

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as documentation error.

Error description

  • An assertion failure occurred trying to upgrade to a newer
    version of Informix Dynamic Server (IDS) with a database using
    codeset UTF8.
    
    
    14:14:36  Converting database sysuser ...
    14:14:36  The database sysuser has been converted successfully.
    14:14:36  *** SQL 3 11.50xC6 ***
    14:14:36  The dummy updates succeeded while converting database
    sysuser.
    14:14:36  processing test8859
    14:14:36  *** SQL 4 11.10xC1 ***
    14:14:36  Converting database test8859 ...
    14:14:39  The database test8859 has been converted successfully.
    14:14:39  *** SQL 4 11.50xC1 ***
    14:14:39  Converting database test8859 ...
    14:14:39  The database test8859 has been converted successfully.
    14:14:39  *** SQL 4 11.50xC6 ***
    14:14:39  Converting database test8859 ...
    14:14:39  The database test8859 has been converted successfully.
    14:14:39  *** SQL 4 11.50xC6 ***
    14:14:39  The dummy updates succeeded while converting database
    test8859.
    14:14:39  processing testutf8
    14:14:39  *** SQL 5 9.40xC1 ***
    14:14:39  Assert Failed: Conv/rev: Failed to convert for
    component SQL
    14:14:39  IBM Informix Dynamic Server Version 11.50.FC6W1
    14:14:39   Who: Session(5, informix@host, 0, 111603c00)
                    Thread(19, convert, 1115c3b40, 1)
                    File: framework.c Line: 735
    14:14:39   Results: Dynamic Server must abort
    14:14:39   Action: Restart conversion after fixing the problem.
    14:14:39  stack trace for pid 9645 written to
    /usr2/support/chunks/IDSMigration/af.3fb0e3a
    14:14:39   See Also:
    /usr2/support/chunks/IDSMigration/af.3fb0e3a, shmem.3fb0e3a.0
    14:14:55  framework.c, line 735, thread 19, proc id 9645,
    Conv/rev: Failed to convert for component SQL.
    14:14:56  The Master Daemon Died
    14:14:56  PANIC: Attempting to bring system down
    
    14:14:39
    14:14:39  IBM Informix Dynamic Server Version 11.50.FC6W1
    Software Serial Number AAA#B000000
    
    14:14:39  Assert Failed: Conv/rev: Failed to convert for
    component SQL
    14:14:39   Who: Session(5, informix@host, 0, 111603c00)
            Thread(19, convert, 1115c3b40, 1)
            File: framework.c Line: 735
    14:14:39   Results: Dynamic Server must abort
    14:14:39   Action: Restart conversion after fixing the problem.
    14:14:39  Raw hex dump of stack located in
    /usr2/support/chunks/IDSMigration/af.3fb0e3a.rawstk
    14:14:39  Stack for thread: 19 convert
    
     base: 0x0000000112b75000
      len:   69632
       pc: 0x0000000100e22d58
      tos: 0x0000000112b84021
    state: running
       vp: 1
    
     ucontext: <NULL>
      siginfo: <NULL>
    
    0x100e22d58 oninit :: afstack
    0x100e21a98 oninit :: afhandler
    0x100e20d20 oninit :: afcrash_interface
    0x100a15708 oninit :: do_each_version_work
    0x100a15d04 oninit :: generic_fw_main
    0x100a16490 oninit :: convertSM
    0x100df1ba8 oninit :: startup
    14:14:39   See Also:
    /usr2/support/chunks/IDSMigration/af.3fb0e3a, shmem.3fb0e3a.0
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users of IDS 11.50xC6 and earlier versions.              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The Migration Guide did not specify that the setting of      *
    * GL_USEGLU environment setting must match between the source  *
    * and target server during migration.                          *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to IDS version 11.50.xC7 to view correct             *
    * information.                                                 *
    ****************************************************************
    

Problem conclusion

  • The setting of GL_USEGLU environment setting must match between
    the source and target server during migration. Information on
    this was added to two 11.50xC7 topics: "Preparing for
    migration" and "Setting Environment Variables."
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC66184

  • Reported component name

    IBM IDS ENTRP E

  • Reported component ID

    5724L2304

  • Reported release

    B15

  • Status

    CLOSED DOC

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-02-10

  • Closed date

    2010-11-15

  • Last modified date

    2010-11-15

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B15","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
15 November 2010