DSXchange

Set array size to 1 is the safest when multiple instances are running, and set rows/transaction to 1 also. That way you will not experience lock (or deadlock) problems. ... But the problem is, there is no option for me to set array size. Only Row commit level. something like this: http://img530.ima...

any help is appreciated

We have a situation where a parallel job (inserting data from data set to DB2) is set as a multiple instance job writing to the same table. Up to 4 instance might be running at the same time. Each data set contains around 100,000 records the job structure is: Data set --------- Key generator -------...

Yes. I did get the parameters from the log in Director.

hi ArndW, Thanks for the prompt reply. I've tried the view data by using the same parameter values of the invalid run, and I got the same result of the SQL query (by that i mean different from the result of the run). It did not return 0 row everytime. It happens something like this: run_attempt|no_o...

I have a set of jobs which uses ODBC stages to retrieve data from an informix database based on time intervals. SQL used in the ODBC select a,b,c from <table1> where timestamp > 'start_time' and timestamp <= 'end_time' When I manually run the sql query with the exact same intervals, I'll get differe...