DSXchange

If you open up the transform in the designer are the links red? The error messages regarding "DSLink18" would tend to indicate a naming error.

TOAD and SQLPLUS do not return all the data immediately, so this time comparison is probably not valid.

I would test this empirically before taking the documentation's word for it.

V.J., didn't you post the same question in this thread ? The way the question is phrased makes it look just like a test question or an interview question; neither of which are particularly liked on this site. If this question is neither, then it would be worth discussing locking and concurrency, as ...

That sounds like a real bug in the client. Apart from talking to support, can't putty redirect ports, changing a call to 9080 to 59080? I can't check right now, but seem to recall it does off that functionality.

DSDexter wrote:Andrw,
All environments are isolated and lie on different servers.

In that case the one machine has less swap space than the others and that is causing your virtual memory issues.

5Mb score is pretty large. Is this a big DS Job and is the machine a small one?

Can you try switching versions with the MCM back and forth one time to see if that might initialize a library.

Are all 3 environments on the same machine? Solaris is odd in that it preallocates swap space when memory is allocated.

DataSets are DataStage objects stored on disk, not in any database.

You can't do it from the MQ stage. If you have been granted the MQ rights, you can execute the appropriate "runmqsc" UNIX command sequence to return the queue depth to your calling sequence and branch accordingly.

Changing the .dsx attributes globally ought to do the trick. With V8 you don't have a choice - the metadata goes into an SQL Compliant database of your choice (as long as you choose DB2 or Oracle).

The simplest way is to extract the YYYY portion from the birthdate string and subtract it from the numeric YYYY current year value. But is this acceptable according to your business rules? Does the current month/day make a difference?

The target column attribute "Extended" for milliseconds needs to be enabled.

In the aggregator, did you specify the "sort" and "sort order" for any of your columns? If you didn't then the Aggregator stage has no way of knowing that the data is sorted and it doesn't have to store the data in memory for group changes.