Sequence Job running very slow.

sam334 · Post by **sam334** » Tue Feb 18, 2014 12:46 pm

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.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 18, 2014 2:08 pm

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.)

sam334 · Post by **sam334** » Wed Feb 19, 2014 12:56 pm

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.

rkashyap · Post by **rkashyap** » Wed Feb 19, 2014 3:06 pm

Can you check with your DBA and seek their input on this. They may help to tune this job/sequence design.

sam334 · Post by **sam334** » Thu Feb 20, 2014 8:38 am

rkashyap,
I actually first told our DBA to do a database maintenance. All the maintenance was done in regular basis. After changing the transaction count performance improved but though 1.30 hour for 10 million record would be too much.

Thanks.