PI57141: SQLCODE -204 OCCURS IF IIDR CDC IS CONFIGURED WITH A SECURITY IDENTIFIER DIFFERENT FROM THE QUALIFIER SPECIFIED IN CHCBNDPL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Some of the SQL statements that access the DMMD_SIGNALS table
  do so using dynamic SQL, and without specifying a schema name
  on the statement.  DB2 will use the Security Identifier
  assigned to the address space as the schema name for tables
  referenced in dynamic SQL.  If the Security Identifier assigned
  to the address space differs from the value of the QUALIFIER
  keyword on the BIND PACKAGE statements, then a non-existent
  DMMD_SIGNALS table will be referenced, causing SQLCODE -204
  errors.
  

Local fix

• Create an alias of <SecurityIdentifer>.DMMD_SIGNALS for
  <QUALIFERValue>.DMMD_SIGNALS.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IIDR CDC for z/OS who configure an  *
  *                 instance to execute using a Security Ident.  *
  *                 for the address space that is not the same   *
  *                 as the owner assigned to the meta-data       *
  *                 tables being used.                           *
  ****************************************************************
  * PROBLEM DESCRIPTION: The DMMD_SIGNALS meta-data table was    *
  *                      originally designed to be optional.  To *
  *                      support this, dynamic SQL is used to    *
  *                      access this table.  The dynamic SQL     *
  *                      does not provide an owner when it names *
  *                      the DMMD_SIGNALS table, so the owner is *
  *                      taken by DB2 to be the same as the      *
  *                      active security identifier at the time  *
  *                      of issuing the SQL.  If this security   *
  *                      identifier is different from tha actual *
  *                      owner of the table, a "table not found" *
  *                      error will occur.                       *
  ****************************************************************
  * RECOMMENDATION: APPLY CORRECTIVE SERVICE                     *
  ****************************************************************
  
  The DMMD_SIGNALS table will receive SQLCODE -204 if the security
  identifier of the address space is not the same as the owner of
  the meta-data.
  

Problem conclusion

• All accesses of the DMMD_SIGNALS meta-data table have been
  changed to use static SQL.
  

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:

  UI37534

Modules/Macros

•    CHCDLRDB CHCDLSDB CHCDSCDB CHCSDTDB CHCSDTIQ
  

Fix information

• Fixed component name

  INFO SRVR CDC Z

• Fixed component ID

  5655U7600

Applicable component levels

• RA21 PSY UI37534

     UP16/05/23 P F605

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.