DSXchange

Search for SETFILE command on this forum.

NLS can not be installed separately. It may be the case that you have installed, but not enabled, NLS. In this case your uvconfig file will contain various NLS... entries, including NLSMODE, which is the "on/off switch" for NLS. If you have not installed NLS, then you must follow the steps shown by ...

Be aware that this value - and the rows per second value - is skewed by operational overheads and sampling interval. The shorter the job the worse are these biasing effects.

Server overloaded.

I've run quite a few more than five simultaneous jobs, but on a 32 CPU machine with lots of memory.

Arnd really means that a reference link has a WHERE clause (to specify which row(s) to be looked up) whereas a stream link may not have a WHERE clause (of course, it may, but a reference link must have one).

Good point. Easy to test. Check the modulus of the hashed file after the job finishes. Change the minimum modulus of the hashed file to at least this value. Run again and see when the warning occurs.

Define "performance".

Read chapter 2 of the Parallel Job Developer's Guide

What do you believe are the "correct results"?
What are you getting? Why do you claim these are wrong?

I think that Ashwin is using DS/390 and will understand about date masks in mainframe jobs, and that Kumar is not using DS/390 and will not. Kumar, we're talking something like the date masks you see in parallel jobs (for example "%yyyy-%mm-%dd"). However, they are specified differently in mainframe...

Read the message again. Read the whole message. It's not about implicit or explicit. It's not about Sort stage versus sort specified on a stage's input link. The message tells you that the sort that you specified is in some way incompatible with the requirements of a downstream operator. You can fin...

Hash partitioning (or a hybrid, such as range-hash partitioning) is found in some database products. It is this you are asking about, or DataStage parallel jobs?

What do you understand by the term "hashing"?

The warning is to alert you that the same data type as the source values may not be large enough to accommodate their sum. Consider int8 as an easy example, the largest value of which is +127. You don't have to add too many of these to exceed +127. Therefore a more appropriate data type for the sum ...

The quickest way will involve about a month's worth of research into the internal structure of the DS_METADATA table and how to translate this into a schema. You really don't want to do it from the command line. (I'm not asking.) Much easier is to look at the table definition using the Manager or th...

Does this happen every time reliably, or intermittently? Do you ever achieve fully successful loads? Do the 200 rows actually make it into BW? Check for permissions and available disk space where the directory for BW load files exists. Have your network administrator check for unexpected dropouts or...

Dunno. May be something to do with losing quotes when submitting. Anyway, the 8+3 name seems OK as a workaround.