IC90126: ON WINDOWS IMPORT UTILITY MIGHT FAIL WITH ERROR SQL0604N WHEN DB2_COMPATIBILITY_VECTOR=ORA IS SET.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • IMPORT fails with  following error:
    ----
    SQL3109N  The utility is beginning to load data from file
    "data.del".
    
    SQL3037N  An SQL error "-604" occurred during Import processing.
    
    SQL0604N  The length, precision, or scale attribute for column,
    distinct type,
    structured type, array type, attribute of structured type,
    routine, cast
    target type, type mapping, or global variable "CHAR()" is not
    valid.
    SQLSTATE=42611
    
    SQL3110N  The utility has completed processing.  "0" rows were
    read from the
    input file
    ----
    

Local fix

  • Set input file encoding to unicode with global registry variable
    DB2CODEPAGE :
    db2set DB2CODEPAGE=1208
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Windows users with DB2 setting:                              *
    * DB2_COMPATIBILITY_VECTOR=ORA                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 UDB Version 10.1 Fix Pack 3                   *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 UDB Version 10.1 Fix Pack 3
    

Temporary fix

  • Set input file encoding to unicode with global registry variable
    DB2CODEPAGE :
    db2set DB2CODEPAGE=1208
    
    and terminating existing connections with:
    
    db2 terminate
    
    Client application encoding will be set to 1208 (UTF)
    

Comments

APAR Information

  • APAR number

    IC90126

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-11

  • Closed date

    2013-11-04

  • Last modified date

    2013-11-04

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

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

    IC95327

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RA10 PSN

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

10.1

Reference #:

IC90126

Modified date:

2013-11-04

Translate my page

Machine Translation

Content navigation