DSXchange

i have installed IBM infosphere info. server suit on windows environment , now i am trying to login Administrator client but i receive an error : No datastage credentials were found for the user (USERNAME) and Datastage server (SERVERNAME). i have given all the relevant roles to the user and have ch...

Hi Chulett I have solved the problem now. I have changed three two things. 1. Changed the dsenv file like this -------------------------------------------------------- #!/bin/sh # PLATFORM SPECIFIC SECTION ORACLE_HOME=/u01/app/oracle/product/10gR2/db_1 export ORACLE_HOME DSHOME=/home/dsadm/Ascential...

Now I have tried all the possibilities like using LD_LIBRARY_PATH and SHLIB_PATH and LIBPATH and LIBRARY_PATH i faced error on all except LD_LIBRARY_PATH. So only LD_LIBRARY_PATH is the correct one and i have deleted all other paramters like SHLIB_PATH. So now we have to concentrate on some other po...

I said Oracle client runs fine on datastage server from any account. This shows that we dont have problem with oracle environmental variables.
Problem is only with Plug-ins in Dstage.

Well I have verified the Oracle Path and it is exactly same what i placed in orale os user profile. I can connect to database from dsadm user which is owner of datastage installation. The file i placed earlier is of linux server which is currently facing the problem. I m not sure about using which p...

Hello Chulett! In Oracel Oci Stage When I try to View Data It prompt me this error ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so: cannot open shared object file: No such file or directory Similarly when i try to import table metadata in Oci stage i.e in Import Plug-in Metadata it give...

Any suggestion guys please???

Hi there, I changed the dsenv file as advised above and every thing was working. After two days we imported complete project and then tried to view the data or tried to import table definitions we are receiving again the same error. I have not made any change to the env file but even then this probl...

Thanks for the sharp response.

Hi All I got following error while executing Ascential DataStage job. DataStage Job 7 Phantom 9296 Creating file "SDKSequences" as Type 2, Modulo 1, Separation 1. Creating file "D_SDKSequences" as Type 3, Modulo 1, Separation 2. Added "@ID", the default record for Retri...

Thanks Ray and Chulett I will test the new dsenv file and let you know the results.

hi chulett I have Datastage Plug-In Installation and Configuration Guide and on page 07 it stats that Oracle OCI 8i is not supported for Red Hat Linux. So any way to change my project to use oci 9i plugin. Any script available to change the project. I have tested that if i change the plugin only and...

Thanks chulett I m new to this so little confused . Let me write the complete file so please tell me whats the proper format for this. It will be great help for this. ======================================== \#!/bin/sh #################################################################### # # dsenv - ...

Hello All I m facing the same problem on Linux Server I have tried to configured the dsenv file but still getting the error. can any one help This is the contents of dsenv file: ====================== ORACLE_HOME=/u01/app/oracle/product/10gR2/db_1; export ORACLE_HOME ORAHOME=/u01/app/oracle/product/...

Hi All i m facing same error on Linux server. ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so: cannot open shared object file: No such file or directory Can any one help me regarding setting dsenv file parameter values. here is the current dsenv file contents. LD_LIBRARY_PATH=/usr/lib:$...