DSXchange

Hello, I'm working on some parallel jobs that load Oracle 11g tables. I'm using the User Defined Update/Insert option. I was wondering if there is any preferred value for the 'Insert Array Size' parameter. By default this has been set to 500. I see that if I increase this, the job runs faster becaus...

Priyadarshi, Craig and ArndW,

Thanks! I used a cp command as an after job sub-routine to replace the actual file which would get executed only when the job succeeds.

Really appreciate the help

Thanks!

Hello, I have a job which writes some data into a table as well as a sequential file. The property 'file update mode' is set to 'Overwrite'. There is a check in one of the transformers to abort the job if a certain constraint condition succeeds. This check is done to abort the job when it is run twi...

Thanks Ray. I tuned the query a bit and it's running fine now. Thanks again.

Hello, I have a job which hangs when it is kicked off. I can't see much info in the log to see where it is hanging. The job is stuck at this step: main_program: APT configuration file: /dsinst001/IBM/InformationServer/Server/Configurations/config2x.apt { node "node1" { fastname "ttsts...