IBM Support

JR50345: -302 ERROR HAPPENS WHEN IUD A NICKNAME WITH COLUMN LENGTH LARGE ENOUGH

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The problem usually happens in the replication scenarios when
    Federated database is with codepage 1208 and Data source db is
    with single byte character set.
    
    An example:
    
    1. Data source is a MSSQL database with 1252 codepage.
    
    2. Federated database is with 1208 codepage.
    
    3. There is a table on MSSQL database as:
       CREATE TABLE TEST(C1 INT, C2 CHAR(10))
    
    4. On Federation side, create the nickname NICK1 for above
    table, by default the column length fo C2 should be 10.
    
    5. An application (e.g. a Replication Apply Program) connects to
    Federated database, and tries to update the nickname:
       UPDATE NICK1 SET C2 = :H1 WHEE C1 = :H0
    
    6. Most of the time the program should work well, but when it
    tries to bind '12345?6789' to H1, -302 error happens. The error
    happens because the length of '12345?6789' with codepage 1208 is
    11 which exceeds the length of NICK1.C2.
    
    7. Alter the nickname to enlarge the column size:
       ALTER NICKNAME NICK1 ALTER COLUMN C2 LOCAL TYPE CHAR(11)
    
    8. However the -302 error persists. This is unexpected since
    CHAR(11) should be large enough to save '12345?6789' in
    Federated database, also CHAR(10) should also be large enough to
    store it in MSSQL database given its codepage is 1252.
    
    With the fix, -302 error should not happen after extending the
    column size at step 7.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 10.5fp5 or higher                             *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 10.5fp5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR50345

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2014-05-28

  • Closed date

    2020-07-20

  • Last modified date

    2020-07-20

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

    JR50339

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

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SS2K5T","label":"InfoSphere Federation Server"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
03 August 2020