JR27512: DISCOVERY FUNCTION DOES NOT WORK CORRECTLY FOR MS SQL SERVER 2005 BECAUSE OF SYSTEM TABLE CHANGES IN MS SQL SERVER

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

APAR status

• Closed as program error.

Error description

• The discover function in the Control Center displays incorrect
  remote schemas for a MS SQL Server 2005 data source.
  

Local fix

• Modify the remote schema before you click OK to create the
  nicknames.
  

Problem summary

• Users affected: Users of the discovery dialogs to query MS SQL
  Server in WebSphere Federation Server
  
  Problem description and summary:
  See error description.
  

Problem conclusion

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

Temporary fix

• See LOCAL FIX.
  

Comments

APAR Information

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

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

  JR28859

Fix information

• Fixed component name

  CONTROL CENTER

• Fixed component ID

  5724N9704

Applicable component levels

• R910 PSN

     UP

• R911 PSN

     UP

• R950 PSN

     UP