IBM Support

JR33586: ALTER NICKNAME WINDOW DOES NOT OPEN IN A CONTROL CENTER IN FEDERATED EVNIORNMENT WHEN IT IS CLOSED FOR THE FIRST TIME.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The reproduction steps are as follows #
    
    Catalog the AIX 2 databases on Windows machine
    
    db2 update dbm cfg using FEDERATED YES
    
    open control center
    Select the target database
    expand it, select federated objects.
    Right click - create wrapper
    datasource : db2
    Wrapper : drda
    
    Create server :
    Select source database
    Select type to be Db2 LUw
    Select appropriate version
    Update user /pwd in properties
    
    Create user mapping:
    Provide the User id where the mapping needs to be done
    provide the userid / pwd
    
    Create Nickname
    Select Schema
    Select table
    
    Now through the drda wrapper you are able to view the table and
    access the data from the table of the source database into
    target database
    
    -------
    
    If you alter the nickname for the first time it is successful.
    However after closing the control center and then opening it it
    does not show window for alter nickname.
    

Local fix

  • Use Alter nickname from command line prompt.
    

Problem summary

  • Users Affected:
    All users prior to DB2V95 FP5
    
    Problem Description:
     ALTER NICKNAME WINDOW DOES NOT OPEN IN A CONTROL
    
    CENTER
    IN FEDERATED EVNIORNMENT WHEN IT IS CLOSED FOR THE FIRST TIME.
    

Problem conclusion

  • First Fixed in DB2 V95 FP5
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR33586

  • Reported component name

    DB2 UDB EXE WIN

  • Reported component ID

    5724E4901

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-07

  • Closed date

    2009-12-17

  • Last modified date

    2009-12-17

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

    JR32562

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

    IC64706

Fix information

  • Fixed component name

    DB2 UDB EXE WIN

  • Fixed component ID

    5724E4901

Applicable component levels

  • R950 PSY

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 December 2009