DSXchange

Hi, When i am trying to export the metadata from Oracle DB i am facing the below error. An exception was received from the handler: ODBC function "SQLGetInfo(SQL_CATALOG_NAME)" reported: SQLSTATE = HYC00: Native Error Code = 0: Msg = [Microsoft][ODBC driver for Oracle]Driver not capable Th...

Can any explin m about routines and it types and alo how they are created in Datastage.

Hi, We are facing perfomrance issue when we are trying to run one of the DS job which contains many oracle stages as lookup's.When contacted DBA he confirmed that there is only one connection from DataStage and it is trying to fetch the data from all the oracle stages. Where as the same job in our o...

Hi, We have upgraded our DataStage from 751 to 753 and also upgraded our oracle to 9i to 10g. The issue is few of our jobs are running for long time,fo example job name abc which used to run for 1 min in older version is now currently running for more than 2-3 hours and gets hanged.The job uses simp...

Hi,

I have verified the space on my OS, everything looks fine.

Hi all, We have upgraded our Datastage(7.5.1 to 7.5.3) and Oracle(9i to 10g) in our current environment. The issue here is few of the DS jobs which used to run just for 1 min in our previous environment are now running for long time and they are not even getting completed. We are killing them manual...

Hi, Can any one please let me know why $APT_NO_JOBMON varaible is used. This has been called in the parameters in one of our DS parallel jobs. As part of our migration we want to delete this variable. Deleting this variable will effect the job logic? Please let me know whether we can delete this fro...

Hi Sanjay, Please find the warning it gives us before it gets failed. Oracle_Enterprise_1,0: ld.so.1: sqlldr: fatal: /opt/oracle/client/10.2.0/lib32/libclntsh.so.10.1: wrong ELF class: ELFCLASS32 And there is no log file created for this and when searched for log file in the below location it just d...

mgendy wrote:did you try to open the log file /abc/ac/02/scratch/ora.20269.404983.0.log ,,

what did you have there ?

There is no such file created. The source for this job is Oracle Enterprise stage and target is also the same.

Hi, Please find the error below. Oracle_Enterprise_285,0: The call to sqlldr failed; the return code = 35072; please see the loader logfile: /abc/ac/02/scratch/ora.20269.404983.0.log for details. The job is inserting data to theoracle table using Load option, and is getting failed with the error men...

Hi, Please find the error below. Oracle_Enterprise_285,0: The call to sqlldr failed; the return code = 35072; please see the loader logfile: /abc/ac/02/scratch/ora.20269.404983.0.log for details. The job is inserting data to theoracle table using Load option, and is getting failed with the error men...

Hi, I have recompiled the job and re ran the job through DataStage it ran successfully. But the same job when ran through unix script is getting failed again with the same issue. Note: Before the upgrade we have taken the export of the jobs to our local(XP) machine and after the upgrade we have impo...

Hi, Recently we have upgraded the dataStage from 7.5.1 to 7.5.3. After the upgradaton we are facing the issues with the job run. Once the DS job run all the jobs are failing with the below mentioned error: XFM_data_mapping: Failed to load the library "V0S523_jobname_XFM_data_mapping.so"; e...

Thanks, Mate

It worked fine.

Hi,

Can any one let me know, is there any option to complie all the jobs in an DataStage project

Currently the version is 7.5.3