DSXchange

When all parameters set to same in both cases the difference should only be due to multiple jobs running from sequencer which might be using the same database where the bandwhidth is shared. When this job is running from sequencer observe what others jobs are running simultaniously, it should help ...

Use Db2/oracle connector in place of odbc.
(watever ur target is)
it works in parallel

@Videsh If I use a flat file then I have to make another job which will write the data from file to my target. @Jothi I dont have any where clause nor I have any date specific data, its a simple one to one mapping. I am using 32 nodes, I also tried DB2 connector as my target with Insert mode. Even t...

I have a parallel job, its a plain one to one mapping. Source is Oracle(oracle connector) and the target is DB2(DB2 Bulk Load). My problem is the source has 2.36 billion records and I have to optimize the job so that it shud finish within 5-6 hours. Plz suggest.

Performance issue : Parallel job as follows: 1>Sequential file ---> transformer------->db2connector (upsert method) 2>Job running on datastage 8 node.Array size =2000 ,transaction size =4000, readers per node=8. Problem description: While running same job individually it takes 1 min36 sec to proces...

Dear Naresh,

Kindly change the property as follows in sequential file stage.

1>Read method =File pattern

2>file =Date_*

Then run the Job

Thanks
Kishor

Hi, The TIMESTAMP format is showing like %yyyy-%mm-%dd %hh:%nn:%ss in default format tab of Job properties window for parallel job. My source timestamp format is yyyy-mm-dd hh:mm:ss:sssssss (example : 2011-03-23 23:12:12:123456 ) and I want to load the same into target. But when I am trying to load,...

Hi All, Could any one please explain the significance of various parameters available in different DB2 Source/Target stages and how they improve the performance of the job. For example : In ODBC Enterprise Stage 1) Insert Array Size 2) Row Commit Level 3) Isolation Level In DB2 Connector Stage 1) Tr...