DSJE_TIMEOUT

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Did you notice if the machine was slower than usual when this happened? The timeout is often seen on heavily overloaded boxes, so the message isn't surprising. But if you have never seen this before and haven't changed anything significant on the machine it needs to be investigated.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

30 minutes? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

Thank you ArndW,

We have reported this to out UNIX server admin.
Thanks and Regards!!
dspxlearn
throbinson
Charter Member
Charter Member
Posts: 299
Joined: Wed Nov 13, 2002 5:38 pm
Location: USA

Post by throbinson »

How many jobs were attempting to start/run concurrently?
Check you uvconfig settings.
With the DataStage default configuration parameters, you
normally can run 50 to 60 jobs concurrently. After setting GLTABSZ = 120,
RLTABSZ = 120, MAXRLOCK = 119, you can run about 100 jobs concurrently. So the number of DataStage jobs that can be run concurrently is determined by the DataStage lock table.
Setting those values to their default or too low can result in the DSJE_TIMEOUT
you are experiencing.
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

Hi throbinson,

Our default configuration settings(uvconfig) are as below:
GLTABSZ =120
RLTABSZ =220
MAXRLOCK =219

We had 80 to 90 jobs started at the same time (04:00 AM) out of which 32 failed. Out of these jobs few were running in multiple instances.
Thanks and Regards!!
dspxlearn
dspxlearn
Premium Member
Premium Member
Posts: 291
Joined: Sat Sep 10, 2005 1:26 am

Post by dspxlearn »

By searching the forum, i found that many people suggest that increasing these parameters will not help much.

Anyways, we raised this to our admin. I will post their solution once i hear from them.
Thanks and Regards!!
dspxlearn
fridge
Premium Member
Premium Member
Posts: 136
Joined: Sat Jan 10, 2004 8:51 am

Post by fridge »

this is caused by a hardwired timeout limit of 60 seconds in which the job has to kick in - and this can be missed if lots of jobs kick in at the same time, the main problem is each job has to open universe files for logs, config , status etc - this can be tweaked via uvconfig - but only two cetain limits.

if u have no luck with UNIX guys -there is a patch that incorparates a way of changing the default time out from 60 secs - speak to your datastage support provider
Post Reply