DSXchange

Yes, the indexes are in place for the where clause columns
The stats are up to date

Hi, we use DataStage 8.0.1 on AIX 5.9 TL12. The Oracle client is 10.1.0 We migrated the Oracle databases used by our projects to another site. We noticed a high performance loss when jobs use the upsert mode in the Oracle Entreprise stage. We test particulary a job with length of time of 7 minutes b...

What version are you on? We're on version 8.0.1 and what got us fixed was installing the latest fix packs. Support informed us that there were several issues with the logging agent fixed in the fix pack releases. We have got also the issue "ECJ0053E: Authorization failed for /UNAUTHENTICATED w...

I had the same problem: "Transfer does not have this output interface as its destination". Now there is an IBM patch: fix JR31099. By waiting its implementation, i found a temporary workaround: our project was with 6 nodes, i modify to have only one. It is longer but now, it is running fine.

I had the same problem: "Transfer does not have this output interface as its destination". Now there is an IBM patch: fix JR31099. By waiting its implementation, i found a temporary workaround: our project was with 6 nodes, i modify to have only one. It is longer but now, it is running fine.

First, thank you for your help. O/S is 64bit. Yes, i monitored the space while the jobs ran and the error was generated. Nothing significant. The job failed after a little more than 1 minute. What it is strange, is we have the same problem at the same moment in 3 differents servers not in the same p...

Hi, Datastage 8.0.1 OS: AIX 5.3.0.0 When trying to write to a dataset, I'm getting the following errors: ######################## FATAL : ######################## APT_CombinedOperatorController(7),4: Write to dataset on [fd 17] failed (Error 0) on node node5, hostname <Server name> APT_CombinedOpera...

We try to install Datastage on a new server. So i have many problems. After launching a job with ORACLE Request, i don't have any result (with sqlplus on the server i have) ######################## WARNING : ######################## 1123\2009-10-29 17:15:22\2\FF01_FILES\1\02Extraction0010XXXX.TRF_HA...

only some of them.

Thanks for your answer

I m not sure to well understand your question.

Only the oracle version will change. datas, connexions will stay the same.

i don't understand why you are talking about data or metadata repository. For me they don't have to change.

I would to know what we have to change in Datastage after migrating on a server the Oracle version from 9 to 10.g .

We use ORAOCI 9 stage.

Do we have to modify ODBC connection on Datastage server ?

Same question if we have to change AIX version.

Thank you by advance for your answers