JR33797: WHEN DEPLOYING ROUTINES WITH VISUAL STUDIO .NET ADD-INS, PRIVILE GES ARE BEING TAKEN INTO CONSIDERATION WHEN THEY SHOULD NOT BE

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

• When updating and redeploying a stored procedure using the
  Visual Studio .NET add-ins, a GRANT or REVOKE operation may
  be issued after the stored procedure is compiled.  This GRANT
  or REVOKE operation may be unexpected and could ultimately
  cause the deployment of the stored procedure to fail, if the
  GRANT/REVOKE operation fails.
  .
  This may happen even if no privileges are defined for the
  stored procedure.
  .
  This problem is more likely to happen against a DB2 for z/OS v9
  server.
  

Local fix

Problem summary

• Users Affected:  Visual Studio .NET addin users
  Problem Description:
  When updating and redeploying a stored procedure using the
  Visual Studio .NET add-ins, a GRANT or REVOKE operation may
  be issued after the stored procedure is compiled.  This GRANT
  or REVOKE operation may be unexpected and could ultimately
  cause the deployment of the stored procedure to fail, if the
  GRANT/REVOKE operation fails.
  

Problem conclusion

• First fixed in DB2 UDB Version 9.5, Fixpak 5
  

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:

  IC62206

Fix information

• Fixed component name

  DB2 CPE WINDOWS

• Fixed component ID

  5724B5601

Applicable component levels

• R950 PSN

     UP