JR61391: CDC FOR ORACLE REFRESH USING FAST LOAD CAN GET: Buffer size is to small to hold formatted columns data.

APAR status

• Closed as program error.

Error description

• CDC for Oracle refresh using fast load can get the following
  error during refresh:
  
  Buffer size is to small to hold formatted columns data. Increase
  buffer size used for fast load
  
  
  
  The work-around is to increase value for sys parm
  ts_fast_loader_buffer_size_kb (default is 1000)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * This issue affects clients using CDC for Oracle as a target. *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * For certain CDC source (such as PostgreSQL), when refreshing *
  * a LOB the CDC Oracle target agent may end replication on     *
  * error, with the following error message: "Buffer size is too *
  * small to hold formatted columns data."                       *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDR LUW 11.4.0.2-5512 or newer for Oracle.        *
  ****************************************************************
  

Problem conclusion

• Upgrading to IDR LUW 11.4.0.2-5512 or newer for Oracle resolves
  the issue.
  

Temporary fix

• Set the undocumented system parameter
  "ts_fast_loader_buffer_size_kb" (default value is 1000) to a
  higher value.
  

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 ORACLE

• Fixed component ID

  5725E30OR

Applicable component levels

• RB40 PSY

     UP