JR65096: DMCONFIGURETS CAN FAIL WHEN GENERATING THE SCHEMA LIST IF USER USES RACF SECURITY INSTEAD OF SQL TABLE GRANTS

APAR status

• Closed as program error.

Error description

• dmconfigurets can fail when generating the schema list if user
  uses RACF security instead of SQL Table grants
  

Local fix

• The workaround is to use SQL grants to grant the CDC user
  authority on the CDC user schema.
  
  For example, if the CDC
  user name is "jones", you should grant authority on schema
  "jones" to "jones". This should ensure there is an entry in
  SYSSCHEMAAUTH for schema "jones" and user "jones". The user can
  then select schema "jones" as the replication schema.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you are creating or modifying *
  * an instance of the IDR CDC Replication Engine Db2 for z/OS   *
  * remote source.                                               *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * You might be unable to create or save changes to the         *
  * instance.                                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrading to IDR 11.4.0.4-5644 or newer for Db2 for z/OS     *
  * remote source resolves the issue.                            *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.4-5644 or newer for Db2 for z/OS remote
  source resolves the issue.
  

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

  IDR DB2ZOS REMS

• Fixed component ID

  5737C30DR

Applicable component levels