Hi All,
I am having one issue in sequencer job running. I searched the forum and there is a related topic but does not really make sense.
Now, the sequencer was fine, running perfectly where we have two large loads and one process control update. I added one more job at end and after the migration it is taking hours to load the data. Basically it has one parent sequencer which has another sequencer in it. After adding the new job, both the sequencer jobs are taking hours. Any help how can I address the issue.
Thanks for being such a great help.
Sequence Job running very slow.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Which job is taking all the time? (You can determine this information from the job logs or from the Operations Console.) Why? (You can determine this information from the Performance Analysis tool in Designer.)
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.
Thanks Ray.
Unfortunate we do not have performance analysis tool. I checked the logs and tested the job which was actually delayed. The transaction count and array was 50 and 50. I changed those to 2000 transaction count and 1000 array. I can see definitely performance is improved.
So, changing the array and transaction counts can improve the performance right. Its a full load with millions of records. Target is DB2 UDB
Thanks again.
Unfortunate we do not have performance analysis tool. I checked the logs and tested the job which was actually delayed. The transaction count and array was 50 and 50. I changed those to 2000 transaction count and 1000 array. I can see definitely performance is improved.
So, changing the array and transaction counts can improve the performance right. Its a full load with millions of records. Target is DB2 UDB
Thanks again.