IV91017: WSRR DATABASE ON DB2 Z/OS: MOD_LOCK TABLE REQUIRES SELECT PERMISSION.

WebSphere Service Registry and Repository V8.5.6 Fix Pack 1

APAR status

• Closed as program error.

Error description

• If the Specified WSRR DB User is not the Table Owner or a DB
  admin, when attempting to update the MOD_LOCK Table used to
  ensure data integrity the following error is seen:
  
  ServiceRegistryImpl checkSetSerialize GSR5000I: Captured
  exception [4749]: com.ibm.db2.jcc.am.SqlSyntaxErrorException:
  DB2 SQL Error:
  SQLCODE=-551, SQLSTATE=42501,
  SQLERRMC=WSRR;SELECT;WSSCH.MOD_LOCK,
  DRIVER=4.16.53
  
  For the update to succeed SELECT must also be granted
  to the user for that table
  

Local fix

• Add SELECT permission on the MOD_LOCK table for the WSRR DB
  User.
  

Problem summary

• ****************************************************************
  USERS AFFECTED:
  All users of IBM WebSphere Service Registry and Repository V8.5
  with a database on DB2 z/OS.
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  The database creation script did not grant the WSRR DB user
  sufficient privileges.
  

Problem conclusion

• This fix is targeted for inclusion in WSRR V8.5.6.1
  

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

  SERVICE REGISTR

• Fixed component ID

  5724N7200

Applicable component levels

• R850 PSY

     UP