JR22914: INCORRECT ERROR MESSAGE FROM DRDA FEDERATED DATASOURCE WHEN THE USER ID DOES NOT HAVE ENOUGH PRIVILEGES ON THE OBJECT

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

APAR status

• Closed as program error.

Error description

• Incorrect error message from DRDA federated datasource when the
  user ID does not have enough privileges on the object
  
  The current message is:
  
  SQL0551N  "The ODBC authid " does not have the privilege to
  perform
  operation
  "unknown " on object "unknown ".  SQLSTATE=42501
  
  New message will be:
  
  SQL1822N  Unexpected error code "-551" received from data source
  "datasource name".
  Associated text and tokens are " SQL0551N  "USERID" does not
  have the privilege  to perform operat".  SQLSTATE=560BD
  

Local fix

Problem summary

• User's affected: all that use federation
  Problem description: Incorrect error message from DRDA federated
  datasource when the
  user ID does not have enough privileges on the object
  Problem summary: The same
  

Problem conclusion

• First fived in v8fp15, s070720
  

Temporary fix

Comments

APAR Information

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

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

Fix information

• Fixed component name

  WS II DRDA WRAP

• Fixed component ID

  5724C7406

Applicable component levels

• R820 PSY

     UP