Hi All,
I am using Change Capture stage for comparing previous and new records. The volume of records is 0.7 millions and the lenghth of a single record is 4750 char with some numeric fields in between.The job is taking 39-40 mins to complete. Also the records are sorted on both links with the change capture key. This sorting also is taking long time. Is there any environment variable to reduce the sort time or using separate sort stage is preferable.Please provide your valuable inputs.
Suman
Perfomance Tuning in Change Capture Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How have you proven that it's the sort time?
I always prefer an explicit Sort stage, because it allows me to allocate more memory to the tsort operator. This can result in quicker finishing. It also allows sort mode of "don't sort (previously sorted)" where applicable.
I always prefer an explicit Sort stage, because it allows me to allocate more memory to the tsort operator. This can result in quicker finishing. It also allows sort mode of "don't sort (previously sorted)" where applicable.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.