Fixes are available
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 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:
Fix information
Fixed component name
DB2 UDB EXE WIN
Fixed component ID
5724E4901
Applicable component levels
R950 PSY
UP
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"950","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 October 2021