DSXchange

We don't attempt to diagnose errors from APT_CombinedOperatorController. Disable operator combination and post your job design and the actual error that is generated.

De-select detail view.

There's no such thing as a lock that is not visible to a DB2 DBA. Therefore it's not true what you assert. DataStage job is, as far as DB2 is concerned, just another client application; it does not do anything particularly unusual with locks.

And posting the same question over and over is frowned upon.

2377 is not a pid, it is a job number.

This lock is usually taken if the job is open in Director log view (or has been opened by a now-defunct process).

It is locks that you need to address, not indexes or processes.

What rule governs the order of words in the output?

OK, try it without the ".".

It works for me with or without the ".".

Note the keyword DICT that precedes the hashed file's name.

The issue is that John Smith is a very common name, so that the probability of finding a match purely by chance (the "U probability") is quite high. This is reflected in the low aggregate weight; indeed this might take the aggregate weight to a negative value (a "disagreement weight"). Since your da...

The only way that no records are transferred is if you have a constraint expression. Please check this.

Do what I said. It will work.

Welcome aboard.

Version 7.5.1 does not support compiling or running parallel jobs on a Windows platform.

The only versions that do support compiling and running parallel jobs on a Windows platform are 7.5x2 (the "x" is part of the version number), or any version 8.

First question must be "which server" - the DataStage server, the Information Server or the WebSphere Application Server?

Do what you're doing, then pass the results through an Aggregator stage selecting the Last record for each key.

Yes.