DSXchange

Set your DISPLAY environment variable?

Do you have the Teradata Utilities installed on your DataStage engine?

My bad. Two buffers per link PER NODE. One being written to while the other is being read from. Quite a few environment variables control this mechanism, curiously they all have the word BUFFER in their names.

The same place every stage "stores" input rows; in the virtual Data Set associated with the input link. A virtual Data Set exists only while the job is running, and keeps data in memory buffers (by default two buffers each 3MB per link). The name of the descriptor file associated with a vi...

Didn't say that. Indeed, I cited two possible ways to do so.

Possibly not. Enable APT_DUMP_SCORE in ANALYZERPROJECT to see that IA jobs use some operators not in the usual milieu for DataStage. If those operators do not support message handling, or even if they use a non-standard mechanism for logging messages, chances are the message handlers won't have any ...

What Craig said.

Yes, but the in-memory table for Sort method only has one row.

That is a key in the XMETA database which changing permissions in the local DataStage project won't help at all. As noted, structures have changed since the original post was made. You have to look at the user name tied to the (WebSphere Application Server) metadata access/delivery services.

It should be possible to install the various executables, though they all have complex sets of libraries upon which they depend (essentially the libraries of the Engine tier). Therefore you would need to identify all of those libraries and install them as well. Oh, and you'd need to obtain Linux ver...

Hash aggregation builds a hash table of results in memory. There is one row in this table for each combination of grouping column values. The table is built entirely in memory, so is useful when there are not too many distinct combinations of grouping column values. Sort aggregation uses the fact th...

Well, one sequence would be able to manage the jobs that do all 18 tables but I wouldn't advise anything other than that. The eighteen pairs of jobs are easy to maintain in the event that there are structural changes to the tables.

Six years on the structures are different.

Check the permissions on ALL objects in the project directory, not forgetting the DATA.30, OVER.30 and .Type30 files in the hashed file directories.

You can buy Information Server software from IBM or one of its resellers.

Please advise how this thread was resolved, since you have marked it thus.