DSXchange

for the sake of closure in this topic...

it turns out the reason for these failures was these jobs had compiler errors

sorry for the 'red herring'

thanks,

steve

guys, thanks for your input. ken, thanks especially for your 'goodies'. btw i already registered on your web site & downloaded everything i could lay my hands on including the jobcontrolgoodies. i presume the version you posted in the member's area is more recent so i'll see if i can get that. s...

thanks for the input. this is for parallel jobs. our std job template invokes a 'before job' routine that populates the job's parms from a series of parm files (one global, one for the application and one for the job). this technique makes it possible to use standard parms but override them for a sp...

We are new to datastage. We are about to roll out our 1st project & have spent a lot of effort developing infrastructure. one infrastructure item is parameter management. we had a consultant provide is with sample code that can update the parameter of the currently running job. the sample code i...

we always make sure we land the data before loading and do the loading in separate jobs.

btw those consultant types deserted ship a month or two ago.

thanks,

steve

kumar_s wrote: BTW: Does you job works withou any issue like resource contraint or intermetten cutoff problem with this 100 stages.

yes, the jobs work fine. also, its not just this job. about half of our fact jobs have this same problem.

thanks everyone for the input.

steve

being new to DS we had a bunch of very expensive IBM consultants recommend how to structure our jobs. In general we found them very helpful. one area in which they were quite adament was in us NOT landing the data (notwithstanding restart considerations) for performance reasons. This dictated very l...

i am still waiting to hear back from them.

thanks,
steve

i have been trying to get ETLSTATS up and working and found that one of our jobs caused the 'dsjob -report' command to fail. it turns out that a good number of our jobs cause dsjob to fail as follows: dsadm@vml-dwetl02:/dwhome/test/app_code/global/ini> /dwhome/Ascential/DataStage/ DSEngine/bin/dsjob...

ultramundane,

we are using 7.5.2 (on suse) and i see no difference between server & parallel performance on the canvas. Both are good.

good luck,
steve

if the ratio of rows being updated (verses rows in the table) is high (eg > 20%), try dropping all indexes not required for the update. you may also see perf boost if you sort the data in the order of the remaining index.

then recreate indexes.

good luck,

steve