DSXchange

tell us the amount of data which you trying to pass

append zeros for hours minutes and seconds to the source data and make it as per oracles requirments.

Trim the fields of any spaces before you do the lookup. If one of the field is filled with spaces, you lookup will fail

you can only capture logical rejects in server jobs as far as i know. You cannot have a reject link so you need to define a regular link and guide your reject rows to that link. and you certanly cannot do anything like seq--trnsform--DB2--trnsform-seq if you want to capture rejects. My suggestion: I...

Are the indexes properly setup? BTW how much speed you want to attain with it? for me its a pretty good speed There is no where clause, it's a dump of a single table. I will verify that the table doesn't have issues by itself. 726 rows/sec from anywhere going straight to the bit bucket is acceptabl...

for some strange reason our support team wants all jobs to write to the same log file. Possible, but it has to be sequential. For parallel processing, they have to be seperate files. Perhaps your support team needs to know that simultaneous writes to the same file is not possible, whether its the c...

For a start you could tell us what your database is.

even 35 million rows should not take 9 hours. my guess is that the tables has lots of referential dependencies.

Have you checkd for any warnings?

eliminating DS should do the trick.

Are the indexes properly setup?
BTW how much speed you want to attain with it? for me its a pretty good speed

There are around 12 bulk loader jobs which run in parallel but with different tables as targets. Are you providing different TEMP_DIR's for all these jobs in the DB2 Load Stage? They are all trying to create the same set of command files. If their folder is the same then thats your problem right th...

fmartinsferreira wrote:Thanks!

Fernando

mark it resolved please..helps others.

narasimha wrote:Introduce some delay/sleep between the jobs in your sequence, so that the files get exclusive access.

exclusive access to what? how will inducing sleep between jobs help?

Is the sequential file that is used in this job being used in any other Job_Activity in your sequence? Can you check if other job activities are using this sequential file? Whale. No the sequential file is not used by any other job/activity. the folder in which the file is being accessed by many jo...

Are you using any more Bulk Loader jobs in this sequence job which are fired in parallel? I am just guessing here as I am running out of ideas. The Bulk Loder message file, does it contain any helpful messages? I have already ran out of ideas. The bulk loader message file has not much information a...

re run of the job makes it run fine. It fails only when it is run with sequencer. IT fails everytime i run it using the sequence.