DSXchange

I dont see any reason, how in the datastage admin world, the different ips have got same host names. Host naming should be intuitive, I mean it should easy to login.

Then I dont see any reason, why its failing. Try aruna's suggestion. Thats a good tip too. also, if its ok Try doing it for few records in sandbox first before handling millions of records.

There must be a problem with your schema. Check the tgt schema and table schema to which you are inserting data.

Also, make sure you have all non nullable fields populated.

I go with Jwiles.

Dont sort in parallel or Keep everything in sequential if the # of records is less than 1m. Just designate ids for all the records and get the first and last records as per the requirements. you can use src stage, transformer, agg (find min & max), move those 2 records to the tgt stg. I hope it ...

you will be having a different domain name of ip2 and project name & credentials remain the same.