Checkpointing is taking too much time

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
maffan76
Participant
Posts: 110
Joined: Tue Aug 23, 2005 5:27 am

Checkpointing is taking too much time

Post by maffan76 »

Hi,
I am facing a problem in DS in execution of Job that Job take a minute to finish but the checkpointing is taking approx. 15-20 Mins to complete. I am clueless where to look for the slowness of the checkpointing. Any clue and guidance would be helpful.

Thanks in Advance.
Regards,
Affan
"Questioning is Half Knowledge"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:? Checkpoints are a feature of Sequence jobs, is that what you mean? I don't see how that could take anything other than moments.
-craig

"You can never have too many knives" -- Logan Nine Fingers
maffan76
Participant
Posts: 110
Joined: Tue Aug 23, 2005 5:27 am

Post by maffan76 »

Yes thats what surprising me as well in DS Director the step says "Checkpointing Job" and if you see the timings then the the taken by this step is 15-20 Minutes and the rest of the steps finish in 1-2 Minutes.
Where does DS do the checkpointing and is there any housekeeping required for DS to avoid delys in Checkpointing.[/img]
Regards,
Affan
"Questioning is Half Knowledge"
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Post by gateleys »

It should NOT take more than a few seconds. Does it take that long in all your sequence jobs?
gateleys
maffan76
Participant
Posts: 110
Joined: Tue Aug 23, 2005 5:27 am

Post by maffan76 »

Yes in most of the cases
Regards,
Affan
"Questioning is Half Knowledge"
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Post by gateleys »

maffan76 wrote:Yes in most of the cases
Time to get the attention of your Support folks!!
gateleys
maffan76
Participant
Posts: 110
Joined: Tue Aug 23, 2005 5:27 am

Post by maffan76 »

Local Support is not very helpful :( as they are third party and they dont have right skill for DS.
Regards,
Affan
"Questioning is Half Knowledge"
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Can't help you there. Is your install disk... full? Or highly fragmented, perhaps? Anything else behaving oddly or literally just this?
-craig

"You can never have too many knives" -- Logan Nine Fingers
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Are you certain that it is checkpointing that is slowing things down? If you turn it off does it actually much faster?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Take a look at the job control code generated by compiling the job sequence. Managing the checkpoints is a single function call. It ought to take hardly any time at all. I suggest that there is something else at fault here.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply