DSXchange

And make sure you remove the line I didn't qoute to you! LD_LIBRARY_PATH=$ORACLE_HOME/lib Leaving that one in will hork up the other change and was what I was referring to when I said 'no need to declare them twice'. Just wanted to know why we need to point only 32 bit libraries ? why not 64 bit li...

chulett wrote:And make sure you remove the line I didn't qoute to you!

Code: Select all

LD_LIBRARY_PATH=$ORACLE_HOME/lib

Leaving that one in will hork up the other change and was what I was referring to when I said 'no need to declare them twice'.

Thanks chulett ,its working fine

chulett wrote:Put your 32bit libraries first. Actually, you can remove the 64bit libraries as they won't be used. No need to declare them twice, either.

Code: Select all

LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32

Thanks for the info chulett , but still the same error

Dear all, I am having the connectivity problem with oracle oci stage ,when i view the data through oarcle stage gives error ds_loadlibrary: error in dlopen - Dynamic Error upon execution gives a warning and job aborts -usr/lib/dld.sl: Bad magic number for shared library: /u01/app/oracle/product/10.1...

Vinay,

You can browse the universe database through command interface available in administrator with dsadm previlege

Hi, I am getting an intermittent error like odbc fecth failed after processing some number of rows like 150,000 Desc : Actually i am trying to pull the data from db2 table using the odbc stage ,some times it will goes fine and job is getting successful ,once in a while i am getting the follwing erro...

Not with so little information. Can you please post actual error/warning messages? Some idea of your setup would be useful too - for example what might be trying to monitor jobs? MetaStage? Or are you working in a cluster, such that exchanges between player processes on different nodes and between ...

Hi


Is there any clues to Job Monitor Port Failures ???
Can anybody share the ideas ...


Thanks in advance
Raj

Hi,

Is there any formula /methodolgy to calculate no of OSH processes in order to size a Datastage EE server.

can anybody share the ideas please ...


Thanks in Advance
Raj

roy wrote:Hi,
then you'll have to have a job parameter for that table name to be parsed outside the job in a squence job's routine activity and passing it as a parameter to the job or similar.

IHTH,

Thanks a lot roy ..will try it

Hi, Jobs are writing the Data into a Table /Extracting Data from table Actual requirement i want to pass table name as dynamic. Table Name is substring of one of the job parametre Example : Parameter Values have like ABC_XYZ Is there any way to pass 'ABC' as Table Name in the DB2 Stage? Can anybody ...

Hi, Jobs are writing the Data into a Table /Extracting Data from table Actual requirement i want to pass table name as dynamic. Table Name is substring of one of the job parametre Example : Parameter Values have like ABC_XYZ How can i pass 'ABC' as Table Name? Can anybody share the ideas ? Thanks in...

Hi user T42 , You haven't read the my posting clearly.,in that i l have mentioned i already tried and its working fine , i wanted to know about the background is there any more impact ???? Thanks Raj In Version 6.x, it was required, at least up to 6.0.2. In Version 7.x, it is not required. Suggestio...

Is it mandatory to use the Dataset Name with .ds and fileset name with the .fs ?

Its working fine if i use the dataset with other extensions also ,but still got a question is there any impact ?

Anybody can share the ideas please ....


Thx
Raj

Hi,
I am getting the error while creating the command file.
I want to use UDB Load to do the loading.

Cheers,
Raj