IBM Support

JR50339: -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:                                              *
    * The users running Federation server.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 V10.1 FP5 or later version.                   *
    ****************************************************************
    

Problem conclusion

  • This problem is firstly fixed on V10.1 FP5.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR50339

  • Reported component name

    FEDERATION SERV

  • Reported component ID

    5724N9700

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-05-28

  • Closed date

    2015-07-14

  • Last modified date

    2015-07-14

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

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

    JR50344 JR50345

Fix information

  • Fixed component name

    FEDERATION SERV

  • Fixed component ID

    5724N9700

Applicable component levels

  • RA50 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPY","label":"General Issues"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 July 2015