DSXchange

There is a DB2 Configuration guide in the documentation set.

Note, though, that it does not contain any information about the DB2 Connector stage. Patch JR36509 (applied after 8.1 FP1) includes missing documentation on this and the Oracle Connector and Distributed Transaction stages.

what is desc saying <none>Searchable? N Means. The "<none>" means that whoever imported/created the table definition or column definition was lazy and did not provide a description. "Searchable? N" means either that the table does not have an index on this column or that the ind...

Login as a user who has DataStage and QualityStage Administrator role in Information Server.

It is present. I just checked.

Indeed, the Sort stage has been in DataStage since version 1.0.

Next questions, then. How long is it taking? How long was expected? Why? (Don't forget to answer this one.) Are there any/many warnings being logged?

Is this shared tables (which would be new) or shared table definitions (which we already have in XMETA)? Surely any table in a database or file on a file system is already, innately, shared?

Seriously, this depends entirely on your data. Maximum frequency limits the number of potential duplicates per block, and can help to avoid block overruns. I believe you're right to say 100,000 looks too high - are you likely to have 100,000 JOHN SMITH values at the same address?

Run the job with a small number of rows (you can do this after compiling in trace mode). Perhaps 10 is sufficient. Review that run's log, address and correct the things that are causing the myriad log events, and then recompile normally (not in trace mode).

Start by enclosing your examples in Code tags, so we can understand what's happening.

No idea.

For details see (install) log files.

I doubt very much that this is precisely the same problem with the same history etc. Therefore please begin your own thread with your own problem, version, etc.

Check the "job starting" event in the job log, particularly the PATH and LIBPATH environment variables*. Have the DB2 components been removed from these?

* or LD_LIBRARY_PATH or SHLIB_PATH, as appropriate.

Easily remedied. Here, for example.

Where did you introduce the word "horizontal" into your design? A Pivot stage does not need this.

Clearly, because the product works, it's not necessary.