DSXchange

Thanks, Vincent. The more I delve the stranger it gets. They only have the logical model in ERwin - but there are apparently tools for converting that into an ingestible XML file available from IBM Services. As to operational (process) metadata from the mainframe jobs, I might just have to put that ...

On the client or on the server? Which particular Rule Set?

What's special about them? Nothing. You use @ every time you use an email address!

It means that your hash table has grown to 16384 entries. That is, 16384 different combinations of grouping column values when HASH method is being used. It's meant to alert you to the fact that you're consuming a certain amount of memory, and might therefore consider switching to SORT method. Nothi...

Where I'm working now use they're in the middle of upgrading DataStage from 7.5 to 8.5 and want to start using BG and MWB. The DataStage jobs are a mix of server and mainframe jobs, and they've gone (for reasons I have yet to ascertain) with three independent environments in DEV, each with its own s...

Please confirm that your environment, including version, is identical to that of the original poster. You are hijacking a thread in which the previous post is 30 months old!

Have you researched the possible causes of segmentation fault errors, either here or elsewhere?

Yes, the score is written as a single event into the job log when $APT_DUMP_SCORE is True.

These are all clearly explained in the manuals, the on-line help and in the Information Center. Method allows you to choose the way that the result table is handled, and affects the amount of memory consumed. Hash builds a hash table in memory to store results for every combination of grouping keys....

A minor correction to what Craig said.

If there were no zeroes in your test ranges, the output from Oconv() in this case could be treated as Boolean. In DataStage BASIC, 0 or "" are "false" in a Boolean context and any other non-null value is "true".

Sorting options on the input link Partitioning tab are only there because every stage input has these options. It would be silly to pre-sort data that you are going to sort.

What makes them "special"? There are NO special characters. Every character is a character.

(Auto) will always give a working mechanism - that is, an algorithm that is guaranteed to work. However, it may not be optimal in regard to performance. Once you clearly understand how partitioning works, you may be able to use custom settings to have your job perform faster. For example, Modulus is...

Depends. What do you mean by "mainprogram"?

That's not an error. It's a message indicating that the step (the job) finished OK.

Please note that the client tier does not use MKS Toolkit. Can you please advise why you believe that this is the problem? Are you really installing only the client tier?