JR31239: Predicates on binary columns in MS SQL Server nicknames might re turn incorrect results

DB2 Version 9.1 Fix Pack 7  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

• Using the MS SQL Server wrapper, predicates that compare
  nickname columns whose remote column type is binary to string or
  hex constants sometimes return incorrect results.  (MS SQL
  Server binary types are SQL_BINARY, SQL_VARBINARY, and
  SQL_GUID.)  The underlying problem is that DB2 does not always
  pass the remote type to the MS SQL Server wrapper.  As a
  result, the wrapper does code page conversion on the binary
  data.  In DB2 V9.1 and V9.5, this problem also causes no
  pruning from the DONEMSG table when using Q-Replication with an
  MS SQL Server target under a federated Unicode database.
  

Local fix

Problem summary

• Users affected:
    Users of the MSSQL wrapper in InfoSphere Federation Server
  Problem description and summary:
    See error description
  

Problem conclusion

• Problem was first fixed in Version 9.1, FixPak 7 (s090308). This
  fix should be applied on the federation server.
  

Temporary fix

Comments

APAR Information

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

  JR30616

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

Fix information

• Fixed component name

  MSSQL WRAPPER

• Fixed component ID

  5724N9705

Applicable component levels

• R910 PSN

     UP

• R911 PSN

     UP