Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

We need some controls on the Change Tables created in DB2 for the Batch Apply process

txgeezer
Contributor III
Contributor III

We need some controls on the Change Tables created in DB2 for the Batch Apply process

The "attrep_changesxxxx" Tables created to hold changes before apply in the Target Db2 LUW Database does not provide anyway to control the Tablespace or the commit points for inserts. We have millions of updates that are put into these Tables without any commits and it causes us a lot of problems with logging. The Tables are also repeatedly truncated and reused causing large amounts of pages in the Tablespace that are not reused and needs to be freed. I would like to see a setting that can control the number of inserts done between commits. We also would like a way to set the Tablespace Name for these Tables when they are created and maybe a way to drop and recreate them, besides stopping the tasks, when needed. 

Tags (2)
3 Comments
Shelley_Brennan
Former Employee
Former Employee

This capability is not planned for DB2 LUW target since we do not have a native endpoint for DB2 LUW.  

Status changed to: Open - Not Planned
txgeezer
Contributor III
Contributor III
What are your plans for a native endpoint for Db2?


Meghann_MacDonald

Archiving due to age of idea and engagement. Please resubmit if still relevant.

Status changed to: Closed - Archived