IBM Support

JR32887: DB2LOOK COLLECTS UNNECESSARY PRIMARY KEY DEFINITION FOR NICKNAME.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2look collects the primary key definition for nickname
    although the primary key is defined on remote table. Due to the
    primary key information is fetched to local when creating
    nickname, we'll get redundant primary key definition error by
    running this output.
    
    For example:
    ALTER NICKNAME "<schema>"."<nickname>" ADD CONSTRAINT <primary
    key name> PRIMARY KEY(key1, key2...) NOT ENFORCED ENABLE QUERY
    OPTIMIZATION
    DB21034E The command was processed as an SQL statement because
    it was not a
    valid Command Line Processor command. During SQL processing it
    returned:
    SQL0624N Table "<schema>.<nickname>" already has a "PRIMARY"
    key. SQLSTATE=42889
    
    
    The correct one should be:
    db2look doesn't generate this ALTER statement.
    

Local fix

Problem summary

  • Users affected:
       Users of the DB2 for LUW Homogeneous Federation Feature or
    InfoSphere Federation Server
    Problem description and summary:
       See error description.
    

Problem conclusion

  • Problem was first fixed in Version 9.5 FixPak 5 (s091123 ). This
    fix should be applied on the federation server.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR32887

  • Reported component name

    FEDERATED RUNTI

  • Reported component ID

    5724N9703

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-05-05

  • Closed date

    2009-12-22

  • Last modified date

    2009-12-22

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

    JR32885

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

    JR34586

Fix information

  • Fixed component name

    FEDERATED RUNTI

  • Fixed component ID

    5724N9703

Applicable component levels

  • R950 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCAVPX","label":"Federated Server"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
22 December 2009