DSXchange

Try using Load option in the Oracle stage.

If you can not disable the indexes then use the option DIRECT=FALSE. If you have persmission to disable and enable indexes then you may use DIRECT=TRUE.

This should improve your performance.

You wont need to update any thing on DataStage end.

You will have to ensure that correct entry in made in TNS ora file. $ORACLE_HOME/network/admin/tnsnames.ora

Trye the command -

ps -ef | grep 27873

If you see some process then get hold of the user id under which its running. Ask the person or root to execute -
kill -9 27873

May be this will help.

If I have understood your requirement, then may be this will help - 1. Suppose the columns under consideration as C1 and C2 2. Use Column Generator or Transformer to generate a new column C3. 3. Then make C3 = C2 - C1 4. Use Filter stage to apply filter on C3, pertaining to your value. 5. Use Aggreg...

Actually for validating users one needs to use an id that is member of "sys" and "security". Basically the id should be able to validate the user credentials on Unix. In your case, it seems that the "root" was used for configuration the LOCAL OS authority. If that is th...

First Possibility - Which version of DataStage is it? Because if it is DS 7.5.3 and you are connecting to Oracle 10g, then IBM patch has to be installed. Since in this version they had removed db utilities API. On sending email to IBM, they can provide the patch for your machine. Second Possibility ...

First Possibility - Which version of DataStage is it? Because if it is DS 7.5.3 and you are connecting to Oracle 10g, then IBM patch has to be installed. Since in this version they had removed db utilities API. On sending email to IBM, they can provide the patch for your machine. Second Possibility ...

Dear All, I want to connect to my DB2 present on AS/400 and Mainframe. Can you please tell me how to configure my DataStage parallel edition (7.5) lying on AIX Unix for this? I know that one has to use DB2 API stage for connecting to DB2 on AS400 or Mainframe. But before even proceeding for that we ...

yes, i created the dataset at end of the job. before the dataset a sort stage is used. when i give another name for the dataset, it is working fine. so i tried to delete the existing dataset by using dataset management in director, it is telling the same fatal errors i mentioned above and failed to...