IT26303: INCORRECT "TYPE" VALUE IN IMPLICITVALUE COLUMN OF SYSCAT.COLUMNSFOR ROW CHANGE TIMESTAMP, ROW END OR TRANSACTION START ID COLUMN

Db2 Version 11.1 Mod 4 Fix Pack 7 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• When a ROW CHANGE TIMESTAMP, ROW END or TRANSACTION START ID
  column is added to an existing table via the ALTER TABLE ADD
  COLUMN statement,
  errors may occur during replication of the table, such as the
  following log entry:
  
  Event logged: ID=9506 MSG=IBM InfoSphere Data Replication will
  be shutdown due to an error while parsing logs for table
  <tablename> at position .... The table definition may have
  changed. Please update the table definition and refresh this
  table.  The issue can also be resolved by parking the table and
  restarting the subscription
  
  
  
  
  
  
  Incorrect "TYPE" value in IMPLICITVALUE column of SYSCAT.COLUMNS
  table.
  This is incorrect value for TIMESTAMP column.
  This happen for ROW CHANGE TIMESTAMP.
  

Local fix

• The table must be dropped and recreated with the ROW CHANGE
  TIMESTAMP, ROW END and/or TRANSACTION START ID column.  Export
  and import the table data if necessary.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * ALL                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Db2 version 11.1.4.7                              *
  ****************************************************************
  

Problem conclusion

• First fixed in Db2 version 11.1.4.7
  

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:

  IT38199

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP