DB2 FOR LUW / DB2FORLUW / 970 - DB2

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.

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

Use Alter nickname from command line prompt.

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 V9.5 FP5

N/A

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

19.11.2009
02.03.2010
02.03.2010

9.5.FP5