DSXchange

The third party sorters, like SyncSort and CoSort, cost money because they sort fast. The UNIX sort command is acceptable in many cases. Server Sort stage, however, is notoriously slow.

orchdbutil to retrieve a table definition can be done from the command line. But that doesn't get the table definition into your repository.

'fraid not. Hassle your support provider. Meantime keep monitoring the ASB agent process and restarting it as required. The last site I was at created a script for doing just that.

Import > Table Definitions > Orchestrate then choose the orchdbutil option.

There is no "exe".

There are no tools for regenerating from the generated osh, but a person should be able to do it. Indeed, it's an exercise to do so in my Advanced DataStage class.

Have you disabled display of "performance statistics"?

Moderator: please move to parallel forum

CPU usage can be monitored using Monitor.

Are your data sorted on the grouping keys? Most Aggregator problems in server jobs relate to running out of memory because they have to keep the entire result set in memory. When input data are sorted this is not the case, and jobs run orders of magnitude faster as a result. You do, however, have to...

The only way you can create an Excel macro is in Excel. You could make this an autostart macro. Another technique would be a small VBA script outside of Excel that could be invoked from Windows, to accomplish the same tasks.

You'd have to talk to IBM about that. Version 10 of UniVerse changed the rules about device licensing and phantom operations; instead of simply being "all connections from the one IP address" it's now more tightly controlled. Further, UV/Net is not a part of DataStage (it was taken out whe...

Computers are dumb. Your job/sequence will do whatever you program it to do and no more. YOU must decide how to differentiate between a job name and a description - surely there's some kind of pattern-based rule?

There are quite a few bugs in 8.0.1, most of which are fixed in 8.1.

Search the forum for "BCI". You don't need any form of script - just a valid ODBC connection. On Windows there should be no licensing issues.