DSXchange

Thanks a lot for your response . I did open a PMR with IBM & the issue got resolved . It has to do something with the user which connects from datastage to SAP

Hi , I am working on Datastage 8.5 version . I am trying to connect datastage to SAP source system .I am using ABAP extract stage for that . I am using data transfer method : RFC . Here I am getting the below error An error occurred while validating the RFC destination. ABAP_E_00706`:`An error occur...

What is a psort ?

Got it

Appreciate your inputs James .Till now , I thought that when ever we are running a job on any engine, The DSD.RUN process will show up on server where WAS & Engine are installed . Thanks once again for clarifying

Thanks james for your response .

So , suppose there is a project on engine2 ( server2 ) & there are 2 jobs running in that project . Do you mean to say that we won't be able to see those two job processes on Server1 ( WAS , conductor node ) ??

Hello All , I am working on a cluster environment . We have 4 servers . Server1 is the conductor node ( 8.5 engine & WAS are installed ) .Server2 , Server3 , Server4 have engine installed . There are some projects deployed in server1 , server2 , server3 , server4 . I want to know at any given po...

It depends on many factors ...How big is your reference data , How big is the memory ...How many processes are running at that time etc

You can get all those info in dsxchange or google it .

Yes the dataset is created on 8 node . While reading from that dataset , it is reading 8 node ( even though job executed on 4 node as there is temp config file that you mentioned ) . I am wondering why the other link to the join is also executed on 8 node till join stage ( Oracle --> sort ( 8 instan...

Ray , I understand that we can constrain a stage to run a particular node by defining node pool constraints ...Here my question is how input2 to the join is running on 8 node even after specifying APT_CONFIG_FILE to 4 node in the job parameters .

I have checked the Job monitor & in that I found 8 - instances for sort before join's 2nd input link ( reading from oracle table & sorting ) . let us suppose , It's should run on 4 node ...Then I think join operation won't work properly as one input link ( dataset ) runs on 8 node & anot...

I have executed the job & it looks like other input link to join stage ( Read from oracle table ) is also running on 8 node as opposed to 4-node . Rest of the downstages after join are running on 4 node . Any idea why this is happening ?

Thanks Ray & James for helping me out & clarifying this.

Resolved :D

Thanks for your response Ray . I understand that the dataset will be read on 8 node because of temp config file that you talked about . Now My question is how the other link of the join works ? The other link is reading from a oracle table , hash partitioning on key1 . This operation takes place on ...