IBM Support

IC70517: SQL1323N IS RETURNED FROM THE DB2IUPGRADE/DB2IMIGR COMMAND WHEN MIGRATING A V9.1/9.5 DB2 INSTANCE TO V9.7.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When the db2iupgrade.exe (or db2imigr.exe) command is executed
    in a batch file or some script to migrate DB2 instance from a
    V9.1/V9.5 DB2 copy to V9.7, although the DB2 instance is
    upgraded to V9.7 successfully, the return code from
    db2iupgrade.exe is -1323, which provides false information.
    
    If the same db2iupgrade command line is executed in a db2
    command window, you will see a message that tells the instance
    was upgraded successfully, even its return code (which is not
    displayed) is also -1323.
    

Local fix

  • Since the DB2 instance actually was upgraded from v91/v95 to v97
    correctly, you can ignore this error code.
    
    The other option to double check whether the DB2 instance was
    migrated to V9.7 correctly is to execute the following DB2
    commands:
      1). db2ilist  :     -- whether the DB2 instance is listed in
    the V9.7 DB2 copy it should be upgraded to
      2). set DB2INSTANCE=[instanceName]
           db2start:      -- whether the upgraded DB2 instance can
    be started successfully in the V9.7 copy
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * WINDOWS                                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When the db2iupgrade.exe (or db2imigr.exe) command is        *
    * executed                                                     *
    * in a batch file or some script to migrate DB2 instance from  *
    * a                                                            *
    * V9.1/V9.5 DB2 copy to V9.7, although the DB2 instance is     *
    *                                                              *
    * upgraded to V9.7 successfully, the return code from          *
    *                                                              *
    * db2iupgrade.exe is -1323, which provides false information.  *
    *                                                              *
    *                                                              *
    *                                                              *
    * If the same db2iupgrade command line is executed in a db2    *
    *                                                              *
    * command window, you will see a message that tells the        *
    * instance                                                     *
    * was upgraded successfully, even its return code (which is    *
    * not                                                          *
    * displayed) is also -1323.                                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Since the DB2 instance actually was upgraded from v91/v95 to *
    * v97 correctly, this error return code can  be ignored.       *
    *                                                              *
    * Since this problem has been fixed in v97fp3, you can         *
    * consider to upgrade to DB2 Version 9.7 Fix Pack 3            *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 3.
    

Temporary fix

  • N/A
    

Comments

  • N/A
    

APAR Information

  • APAR number

    IC70517

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-08-11

  • Closed date

    2010-09-28

  • Last modified date

    2010-09-28

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

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC70517

Modified date: 28 September 2010