DSXchange

17CC1E71-9657-499F-8B42-24C45F3B54CD is a MAC address.

PC016989 is the host name of the PC on which the client is running.

29230 is the process ID of the corresponding dsapi_slave process on the server.

Make sure you choose the PID, not the user number.

Curious.

An "all terms" search for "special character password" yielded eight hits for me, of which one is marked as resolved and two as "workaround exists".

Try again?

It's generally safe to assume that if the user ID is not root, then the user does not have superuser privileges. You can certainly check; to have root privileges the user must have an effective user ID of 0. Ask for the password to the root account - just get someone to type it in for you - you don'...

It would depend entirely upon what character set was used to encode the characters within the XML tags.

Further, my test was on a Linux machine, not a Windows machine, so that's another variation on your scenario. Version of DataStage was 7.5.1A. Haven't had another chance to look at it. Have a horrible feeling it's a spurious message, but how to prove that? The topic ID for message handler is DSTAGE_...

Why do you assume it's Oracle, kumar_s?

There is no single function out of the box. But it's certainly possible to write a generic "Run SQL" function using BCI functions; I wrote one aeons ago. But, because you are UNIX-based, and presumably using the Data Direct ODBC drivers shipped with DataStage, you will need a licensed ODBC driver to...

In the server Aggregator stage it's all done through the Derivation in the Columns grid. Double click in this cell to open the derivation editor, then select the input column then either check the Grouping check box or choose an aggregate function from the drop-down list.

Doesn't the Search utility work for you? Indeed, your subject would serve as an ideal search topic. Curiously you're not the first to have encountered this.

Concurrent knowledge of the answer and the question is not permitted.

-- Douglas Adams, in one of the five books in the inaccurately named Hitchhiker's Guide to the Galaxy trilogy.

General forum is probably the best, since Version Control overlaps both server and parallel jobs.

This is a simple economics problem; supply and demand.

If your DBA won't increase the supply, you must reduce the demand.

Do fewer things simultaneously. And/or use smaller configurations (fewer nodes for communicating with Teradata).

Just luck. Dynamic hashed files store only the primary group buffers in one file, using a separate file for secondary buffers. This can mean (though don't rely on it) that more than 2GB could be stored in a dynamic hashed file. The total size on disk should be comparable in either case; the only dif...

This is intriguing. I've been able to create a job that has exactly this issue (using the DCS Strategies site). The job is not run from a job sequence; it looks like this: SequentialFile -----> CopyStage -----> DataSet | | | | Reject | | Reject V Aggregator V Peek | Peek | V Peek The only warning me...