Job Parameter Limit

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
tathoong
Participant
Posts: 3
Joined: Wed Sep 29, 2004 9:19 pm

Job Parameter Limit

Post by tathoong »

Hi All,

Is there any limit for the job parameter in a server job? Currently one of my server job is having 62 job parameters. The encyrpted
parameter was passed wrongly after I changed other parameter which was not encrypted.

In order to avoid the reoccur of this problem, everytime I change job parameter I needed to re-key in all the encrypted parameter.

tathoong
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

No limit that I've ever run into, though I'm sure there is one. But then I've never seen a job that needed 62 job parameters. :shock:

I have, however, seen problems in older versions with encrypted parameters needing their values to be rekeyed at times, but seem to recall it was only if you 'arrowed' down through it on your way to another parameter. But not something I've seen in the last few years that I recall.
-craig

"You can never have too many knives" -- Logan Nine Fingers
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Hmmm, sounds like you're using defaults in jobs rather than feeding at runtime with job control. Maybe you should consider changing your standard?
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Try to have a lookup table in the job design with the static informations, to avoid fuzzy.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I have seen master job sequences with this many and more.

There is no theoretical limit to the number of job parameters than may exist in a job or job sequence. If there is a practical limit, it is running out of memory to store the lists of names, default values, prompt texts and so on. Thousands, if not more.
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