DSXchange

We recently migrated from 8.1 to 9.1 version. For oracle database, we changed from entripse stage to connector stage. we are using 4 node config file. when we run the job, jobs are getting hung. queries are strucked on wait status. DBAs are saying multi DML statements are pointing to same segments/block so query is not completing. Later, we changed the oracle connector stage execution mode to sequential. Jobs are running fine.

Do we need to mention any environment variables? or any config setup we need to do? why connector stage is not working in parallel. Any ideas or suggestions? Thanks in advance.

We found an solution. DS 8.1 use less block size compared to DS9.1. So while we are updating the records, blocks arrays are different.

Our DBA identified the issue. while updating the rows, locks are happening in DS9.1. So He increased the INITRANS for tables in database. Problem is solved.