DSXchange

Hello Folks/Experts, We are having a requirement to connect to a Netezza DB in our parallel jobs to pull data from tables. Can someone assist in providing steps to follow for doing the necessary configurations at server level before we can use the netezza connector stage to pull data. Also is there ...

Hi All , I am using RCP in my job and because of which i am getting lot of warnings. Job design is as below. OracleStage----->CheckSum--->Filter-------->CheckSum1 OR CheckSum2--->Funnel---->DestOracleStage I am getting warnings only for the DestOracleStage. Warnings are Schema field FLD_15 in input ...

Thanks all for your valuable inputs.

Hi All,

I would like to know if there is any limit in Datastage as to execute the number of jobs is parallel?

(In Specific- Can we execute 10 jobs in parallel or is there a limit on number jobs?).

TIA
Sameer.

Thanks both of you for clearing my doubt.

We have two machines as follows. AIX 6 and SunOS 5.10. When taken export of a same job with executables on these two machines, the size of the resulting files differs a lot. Ex: AIX Executable job has size 3MB where as SUN executable has 11MB. Are we missing any step or this difference is normal and...

Server status says 'SERVER1 is running'. The issue is my dsrpc is running at 9080 port, previously(before restarting WAS) it running at 9081. I am not able to login even if i give 9080 port in the credentials.

@AndrW : I am able to login to the XMETA

@Sainath : tried starting the server with same username but no luck

Hi All, I have a datastage running on HP-UNIX machine. It stopped working with error message "Unable to begin a transaction". Then i restarted WAS. Now i am not able to login to datastage, error message is "Could not connect to server XXXXX on port XXXX ". I am not even able to s...

I am not able to connect to oracle. I get following error when i run the job. Error loading "orchoracle": Could not load "orchoracle": dsenv entries are as follows ORACLE_HOME=/oracle/ora10gr2 export ORACLE_HOME LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/lib32...

Hi All, I am new to Datastage, wanted to know some information regarding logs and job deletion. Scenario is , i have deleted the jobs now i want to know whether all the logs assiciated with these jobs will automatically be purged? If not then , how to remove logs from repository manually. Thanks in ...