DSXchange

I did the install and it seems fine I did not change the instance tag since it is on a separate machine.

Thanks.

Hi there, I want to install another instance of the DataStage engine on another server so that Information Anaylyzer has it's own place to run analysis jobs. Is there anything configuration wise that I will need to consider when doing this. I see at the end of the installation it asks you to specify...

OK thanks for the info.

We are doing a POC with IBM on this. We have data sources in a mainframe we need to access.

I appreciate the info.

Sean

Hi Thanks for the info, just so I get this straight. There's a client to connect to the classic fed product, like you install an Oracle client to connect to Oracle?

These drivers are installed by default correct?

So I would just need to put the path in the dsenv file.

Thanks for the help.

Hi there I will be traveling to a vendor site in August for a POC on the classic federation server product.

Has anyone in the forum used this stage before?

Are there any requirements (libraries etc that need to be added to the dsenv file) to use this stage?

Thanks.

I use partitioned indexes as a primary key on my paritioned tables. Unfortunately, DataStage will attempt to reubild the whole index instead of just the partitioned index. I noticed as my tables got larger the more time the job would take to run. The only way to handle this is to load a temporary ta...

On my production environment we have 2 servers. The primary one is hooked up to a SAN has space presented to it. On my secondary node I do not have access to this SAN. If I run a job with the 2 nodes where I am writing to this SAN resource, will my job fail? What would be the best way to handle this...

OK thanks, I think what I'll count the number of occrurances as suggested.

I know in other non-datastage functions, if you want to search backwards you would specify a negative number. Is this possible with this function?

TIA

I'm not sure how version control will be affected. I have not used version control because we planned to go to version 8 from the very beginning so we did not use it. Sorry I can't be of help here.

The answer is yes. And I have used it to switch between 7.5x2 and version 8.

I have a shell script that calls dsjob to execute a sequence job that has an execute command stage in it. The execute command stage runs another script that returns me a temporary table name. Is there any way to return this table name back to the calling shell script?

Hope that's clear.

I put this ticket into support, here's a good resolution. Thanks for all the help. Support for the directive "/NOLOG/" was added to the Execute Command stage to address this issue. Add that directive to the beginning of your "Parameters" property in the stage to suppress that log...

Would that be your best practice recomendation or is there a better way to handle passwords to databases in datastage and passing them to scripts?

Thanks for the help.