Import and Compile of large number of jobs

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
Pete Morris
Charter Member
Charter Member
Posts: 39
Joined: Wed Jun 23, 2004 4:33 am
Location: UK, chester

Import and Compile of large number of jobs

Post by Pete Morris »

We are trying to import 2000 job designs using DS manager and then compile them.
It is taking 5 hours to complete the import and 2 hours to compile them.
The jobs already exist in the target project but are being updated with new versions.

Is there any way i can speed up the process.
Pete Morris
ivannavi
Premium Member
Premium Member
Posts: 120
Joined: Mon Mar 07, 2005 9:49 am
Location: Croatia

Post by ivannavi »

I'm afraid not. Version control will also be slow.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You can speed up the import by checking "overwrite without query" and deleting the existing (old) versions first. Make sure that you have a backup, of course.

You can speed up the compilation by having more than one Multi-Job Compile session running, each compiling a disjoint set of the jobs. Takes a bit of planning, but shouldn't be too difficult - for example filter on the first letter of the job name.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Pete Morris
Charter Member
Charter Member
Posts: 39
Joined: Wed Jun 23, 2004 4:33 am
Location: UK, chester

Post by Pete Morris »

Thanks Ray.
Pete Morris
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

There were 'multi-job compilers' available before the official one from Ascential. They were much more light weight and so ran much faster, I wonder if any of them are still around. MJC is like, the slowest. :wink:

Didn't DSC offer such a thing at one point? Also, Kenneth Bland's Job Control Utilities includes such a utility implemented as a batch job. Way more faster.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

There you go. "Way more faster." You don't get a more better recommendation than that.
Mamu Kim
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yah, man - way more much betta. :lol:
-craig

"You can never have too many knives" -- Logan Nine Fingers
kduke
Charter Member
Charter Member
Posts: 5227
Joined: Thu May 29, 2003 9:47 am
Location: Dallas, TX
Contact:

Post by kduke »

:lol:

You made my day. Thanks dude.
Mamu Kim
Post Reply