JR62549: REFRESH FAILS USING FASTLOAD WHEN SCHEMA LEVEL BACKUP FEATURE ENABLED IN DB2WAREHOUSE

APAR status

• Closed as program error.

Error description

• The following error is displayed in the trace logs
  A SQL
  exception has occurred. The SQL error code is '-206'. The SQL
  state is: 42703. The error message is:
  SQLSTATE 42703: An
  undefined column, attribute, parameter name, or period was
  detected.
  SQL0206N "SYSROWID" is not valid in the context where
  it is used. SQLSTATE=42703
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue might affect you if you use CDC for Db2 to        *
  * replicate data into Db2 warehouse or IIAS, and the database  *
  * has schema level backup enabled.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * When Db2 schema level backup is on, hidden columns are added *
  * to the table to enable backup and restore. CDC was           *
  * attempting to load data into one of the hidden columns.      *
  * Replication would fail on error. Further information related *
  * to the changes to the db2load utility used by CDC for Db2    *
  * are available at                                             *
  * https://www.ibm.com/support/knowledgecenter/SSHRBY/com.ibm.s *
  * wg.im.iias.admin.doc/doc/relnotes_1023.html .                *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR 11.4.0.3-5566 or newer for Db2 resolves this
  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

  IS CDC DB2 LUW

• Fixed component ID

  5725E30DL

Applicable component levels