JR57970: Q APPLY FAILS TO READ OR UPDATE COLUMNS CORRECTLY IN Q-SQL REPLICATION FAN-OUT CONFIGURATION

APAR status

• Closed as new function.

Error description

• In a data distribution or "fan-out" configuration that uses
  Q Replication and SQL Replication, the Q Apply program can
  fail to read or update the SYNCHPOINT and SYNCHTIME columns
  in the IBMSNAP_REGISTER table correctly. When the database
  at the middle tier of the configuration is Oracle, the
  ASN7233E error message is issued with "ORA-01036: illegal
  variable name/number" during internal load, and the same
  message is issued with "ORA-01406: fetched column value was
  truncated" during differential replication. When the
  middle-tier database is DB2 for Linux, UNIX, and Windows,
  Q Apply updates the SYNCHPOINT column with an "x" when
  Q Apply starts and never applies any changes. This error
  can affect user applications that read the CCD table
  because these applications usually store the highest LSN
  and then use the next lower point. The "x'' value might be
  interpreted as the highest point after being read by the
  application, causing an incorrect synchpoint value to be
  stored.
  

Local fix

Problem summary

• For Oracle middle tiers, because the IBMSNAP_REGISTER table
  is created in the Oracle database, Q Apply should use SQL
  statements in Oracle format to read the table data. For DB2
  middle tiers, Q Apply should not update the SYNCHPOINT
  column unless changes are applied to the CCD table.
  

Problem conclusion

• With this fix, Q Apply now reads and updates the SYNCHPOINT
  and SYNCHTIME columns correctly.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  JR57968

• APAR is sysrouted TO one or more of the following:

  JR58408

Fix information

• Fixed component name

  WS Q-REPLIC LUW

• Fixed component ID

  5724N9801

Applicable component levels