DSXchange

That 3 year old post was most likely a reference to having the network people open up a firewall that had been blocking client/server traffic on the given port number.

You may want to look into the Distributed Transaction Stage to see if that will handle it as you described.

The last time I discussed this with Support, which by the way was years ago, they were still recommending to use the following values that you now find in the uvconfig file out of the box. DMEMOFF 0x90000000 PMEMOFF 0xa0000000 CMEMOFF 0xb0000000 NMEMOFF 0xc0000000 Since then I have run 8.5 and 8.7 s...

suneelkpx: You have not yet stated any requirement; you have only shown an example of input and output. It would be best if you can state your requirement, in words, as Craig suggested, and show an accurate example to go with the requirement.

Have you tried installing 11.3.1? I think those are memory offset values (as opposed to absolute values) from some base value that I would assume is unique for each engine you've got up and running. Are you finding any errors or problems that may be behind your question? I would not expect any probl...

I'm not sure we're looking at the same post.

I suppose you wouldn't want caching on when you read from and write to the same hashed file in the same job.

Could you clarify if you are wanting to retain (keep) or remove, or something in between, like route one or both to their own separate stage?

When I last renewed, it took 2 business days for it to go through. Have you waited 2-3 business days?

I vaguely recall the hashed file read cache and write cache making some jobs run faster. If you use read hashed files, also enable the pre-load to memory option. It seems like that cache size defaulted to 128 MB but also had a max of 1024 MB.

I think all those settings are intended to improve performance. Some will require additional memory to use, so make sure that physical memory is available. I would be curious if anyone has ever measured a performance improvement.

What is the requirement?

Thank you for all your responses, Ernie. Very helpful. I may run some of these by Support also. I should mention that my background is with DataStage and not java or xml. I get xml basics but for the most part am simply relying on ISD to kindly handle xml details for me. So, I would lean towards not...

To answer one question, after changing uvconfig, you would have to uvregen it and restart before changes would take effect. Another idea is to check whether or not applying fix pack 2 would include anything to help your performance or not. I doubt it would. The NLS difference is a good find. I thoug...

The DataStage job is using the ISD Input and ISD Output stages. 1. ISD is taking the DataStage job columns have a DATE data type and converting them to XML dateTime data type in the WSDL. Example output includes the date, a 'T', the time, and a dash with time zone appended. All we need and want is t...

Compare the uvconfig file settings.