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

DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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