DSXchange

My Job is
ODBC ===> sequential file ===> Oracle connector

Hello I have a ODBC stage and I charge an Oracle stage. The load is really slow, average 800 rows per second. Since DataStage has some particular settings with Oracle 12, I do not know how to improve this speed anymore. I have divided the job so that the data is in a sequential file and after transf...

Today I saw the same problem.
I did a run with a harcod value instead of the parameter and it worked but did not take the parameters indicated as ?

Some idea I'm not sure what to look at anymore

SAP ABAP extractor works in development environment but in QA environment and Sandbox environment does not bring back any records.
The configuration in the two environments is the same, does not create log and ends by timeout

SAPPack_7.1_JR52350_26Jan2015

log DS Director: Oracle_OCI stage ==> Transformer_stage ==> Sequential_File_stage Starting Job PruebaLecturaOracleJOB. Environment variable settings: _=/usr/bin/nohup APT_ORCHHOME=/u02/IBM/InformationServer/Server/PXEngine ASBHOME=/u02/IBM/InformationServer/ASBNode BELL=^G CONSOLE=/dev/pts/0 DS_ENAB...

yes i restart the server. [dsadm@XXXXXXXXXXXX~]$ uptime 13:09:04 up 2 days, 20:25, 6 users, load average: 1.03, 1.07, 1.08 [dsadm@XXXXXXXXXXXX~]$ ls -l total 84 drwxr-xr-x 2 dsadm dstage 4096 Aug 26 2011 ArchivosMigracion drwxr-xr-x 2 dsadm dstage 4096 Mar 2 12:50 copia drwxr-xr-x 2 dsadm dstage 409...

tnsping whit "dsadm" result ok

the version of DataStage is 8.1.0.0

the Oracle Connector stage return:

ds_loadlibrary: error in dlopen of oraoci9.so - libclntsh.so.10.1: cannot open shared object file: No such file or directory

the same whit dinamic stage and odbc stage

sory but re-post ....

"Could not query forum moderator information"


in order .... I could not even fix

/u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora has the correct connection string for the database, i confirm this mmm... but if the "oracle user" does "tnsping" with the "user dsadm" not ... You think may be for firewall? @edit done! [root@XXXXXXXXXXXX D...

tks for the answerd yes i do it that way [dsadm@XXXXXXXXXXXX ~]$ sudo su [root@XXXXXXXXXXXXdsadm]# cd /u02/IBM/InformationServer/Server/DSEngine/ [root@XXXXXXXXXXXXDSEngine]# . ./dsenv [root@XXXXXXXXXXXXDSEngine]# tnsping g100603sv242 TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23...

[dsadm@XXXXXXXXXXXX ~]$ export declare -x COPERR="/usr/lib" declare -x COPLIB="/usr/lib" declare -x G_BROKEN_FILENAMES="1" declare -x HISTSIZE="1000" declare -x HOME="/home/dsadm" declare -x HOSTNAME="g500603sv458" declare -x INCLUDE="...