DSXchange

my question is : 1。 my datastage runs in aix server alone, and my db run two hp server. Should I have to setup environment variable ,such as put the line : APT_ORACLE_NO_OPS=1 in profile? if not, is datastage is aware automatically? 2. if I use odbc entry as following paragraph: WORKDB = (DESCRIPTIO...

I am sure that it's not about table partition.if i run job in one node, I don't meet that problem. I just load a file into one table,this is a small table, not used by anyone rahter by datastage job. I just assume that datastage create 2 connections to two node in the rac,one lock table and another ...

thanks, ray The datastage don't return any error and just hung, if I terminate the job, i can see that a session is holding the lock on the temp table. Since it happend in occassionly and the locked table is also randomly, I want to know how to avoid the problem occur, and what mechanism when datast...

We have two node's oracle rac, ordinary we run etl job to load data into temp table smoothly. But occassionly, the job will be hung and no error returned. if we check the oracle session wait events, it 's row cache lock . But I think no other app concurrently access this temp table . My oracle rac d...