DSXchange

Hi, I would like to know which stage to be used to read *.dbf files on Unix Box. I have the default dBase driver in my odbc.ini file.Here in my .odbc.ini entry. How should i configure to read my dbf files? [dBase] Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdbf23.so Description=DataD...

Finally we got the tnnames.ora file and everything working fine.
Thanks Criag for your Input.

I am validating my new installation of Information Analyzer v 8.1 under Analysis Database/Validate Engine connection. it is failed and here is the output in iasHandler.log. 2009-03-17 10:38:19,620 Error [IBM-IA-HANDLER] [] AnalysisSessionImpl.java:186 Job 15: PxValidation00689903: aborted 2009-03-17...

Thank you Criag for your input, I am waiting to get my tnsnames.ora file. I will post the result when I am done with my testing.

Thank you Criag for your input, I am waiting to get my tnsnames.ora file. I will post the result when I am done with my testing.

Criag, I changed the permission on the opt/Oracle folder level and rerun the job pointing to $ORACLE_HOME/lib32 and it failed with EFCLASS32 error and changed the path to $ORACLE_HOME/lib it failed with below error. Oracle_Enterprise_0: Connect failed: ORA-12514: TNS:listener does not currently know...

Criag, At the /opt/Oracle/10.2.0/client_1/lib32 level here is the permissions. -rwxrwxr-x 1 testid staff 20369280 Mar 13 10:33 libclntsh.so.10.1 At the /opt/Oracle level here is the permissions. drwxrwx--- 3 testid staff 512 Mar 13 10:31 10.2.0 do you think i need to change any permissions here?

Craig, I tried changing the lib to lib32 and again got the same error message. main_program: Error loading "orchoracle": Could not load "orchoracle": ld.so.1: osh: fatal: /opt/Oracle/10.2.0/client_1/lib32/libclntsh.so.10.1: Permission denied. It is saying permission denied, do we...

We installed IBM Information Server V 8.1 on Unix Sun Solaris SPARC 64 bit and We installed Oracle client libraries and updated the path in dsenv file as well as stop and start the Datastage server. We are testing the oracle connectivity using Oracle Enterprise stage and we are getting the below err...

We installed IBM Information server on 4 CPU box except Information Analyzer and then installed IBM Information Server on 2 CPU box for Information Analyzer except Datastage and qualitystage designer but pointing the 2 CPU box to use xmeta of 4 CPU box for common metadata repository between these tw...

We have a host server and created 2 zones one with 4 CPU and one with 2 CPU(Virtually it is two machines).We want to use 4 cpu box for datastage and qualitystage jobs, we want to use 2 CPU box for Infomation Analyzer. How we can do a single IBM Iformation server installtion in this case with a commo...

I am not sure about it because it is a huge Teradata warehouse and there is a possibilty of running other jobs.

We resolved the Issue by setting the Isolation Level = 0 and column analysis completed successfully.

Only ODBC Connector is supported with Information Analyzer Version 8.0.1.But i tried with Teradata connector and it is saying not supported with this version. I went and checked in Datastage director for this job and it is having the same error message what ever i posted earlier.But Here I am pastin...

We are trying to run a column analysis on Teradata table and it is failing with the below error.I am using Teradata Version 12. pxbridge: Error when checking operator: [IIS-CONN-ODBC-000036] Could not obtain error message from driver (function=SQLPrepare) (CC_OdbcDBStatement::dbsPrepare, file CC_Odb...