DSXchange

Nothing has changed in the mechanism, which is described in dsdskche.pdf - however it seems that few folks are taking advantage of public shared caching.

The pipe character is the default delimiter character both in the control file and the data file(s).

From memory - I am not able to check right now - you can change this in the stage properties.

There is no limit in DataStage.

There is a limit on the total amount of resources (CPU, memory, disk, network bandwidth, processes) that your system can deliver. This is also impacted by anything else that the system might be doing.

It won't work using a Hashed File stage. A Hashed File stage can only perform a lookup against the entire key.

You can set it up to use a UV stage to perform the lookup against a partial key. Search the forum for methods. Search on-line help for multi-row returns from reference inputs.

Possibly as many as none, but if you stop the dsrpc daemon you will not be able to start any more jobs. The dsrpc daemon runs under the dsrpcd id. As Arnd noted, you can run the deadlock daemon dsdlockd to detect deadlocks and clean up after defunct (abnormally terminated) processes. If there are co...

If you ever get that message - no matter where (Ascential product or not) - it's a bug in the client. No-one should ever write code that allows access to a property or method via an assumed With block (or non-existent object). The programmer must guarantee that object references are always scoped wi...

Very hard to diagnose after the event. You have to look at things while the problem is occurring. Most probable causes are locks (one job has a record in a hashed file locked, another job is trying to use it) or system load. Sounds like locks are the most likely culprit; both the Hashed File stage a...

Asccential has no specific DS Admin class.

There is/was one offered in Malaysia by an individual consultant, and Ken Bland's company (which is in the USA) does offer services and mentoring in this field. Check out the Services page there.

The easiest way is to use Print to File in Director. However this is a manual process - OK for one or two jobs, tedious for many.

There has been SQL posted on more than one occasion for archiving job logs. Search for "archive" and "RT_LOG" should find you something.

Yes.

In bin in the latter case.

If NLS is not installed, then NLSMODE does not appear in uvconfig at all. Once any change has been made to uvconfig it does not take effect until uvregen has been run and DataStage restarted. The uvregen utility builds a new image of the disk shared memory segment used by DataStage, structures in wh...

That's OK, and this thread will help anyone who does that in future! :D

Get one of your SAP gurus to check the RFC logs to find out - if possible - why the problem occurred and, indeed, what it may have been. Some kind of timeout would be my guess, but why?

Welcome aboard! :D Please post the complete error/warning message for one row. It is very important in DataStage diagnosis to discern all the information that is provided in error messages. In particular, what error codes are displayed, and what do these mean? Why do you think the date fields are th...

Thanks for posting your "solution". Sometimes questions like those are valuable in "taking a step backwards" from your design. Another good thing is to have someone else look at it - it's amazing how the problem you couldn't see is blindingly obvious to them! And if they're professional they won't s...