DSXchange

In the Administrator client you can define a user ID for running scheduled jobs. You've made this user Administrator. What happens if you make this user dsuser?

Anything different with the permissions on the two folders? Anything like that? What's truly different? Does a re-run with ACERjctFldr1 consistently exhibit the symptom? (Your original post suggest not.) Could something else have been updating the folder at exactly the same time?

Agree totally with *sigh*

Folks, this is why new posts require you to indicate whether the post is about server, parallel or mainframe. Please heed what's there!

The name DSD.DIROpen suggests that it's something in the Folder stage attempting to do something with the directory. A write failure could be permissions, but the second time success suggests otherwise. Could you have mis-spelled something in the parameter value in the run that failed? (Check the "j...

The answer to this will depend on a number of factors, including whether the input files have the same (metadata) structure, and exactly what you need to do (for example, preserve all columns from all inputs, or form the intersection or union of the rows from the inputs). All are doable, the solutio...

A couple of points to note on this one. Because updates to hashed files are destructive overwrites, the suggested protocol will yield LAST rather than FIRST. An Aggregator stage with a set function of First can give the first of each set. Or the extraction SQL can include an appropriate clause (depe...

Have you read the PDF file that accompanies the SAP R/3 plug-in stage? There are essentially two mechanisms for getting the generated ABAP code to execute on the SAP R/3 instance, depending mainly on how much the SAP dudes trust DataStage (which is certified by SAP AG as generating valid (legal) ABA...

NLS setting defaults for DataStage are set in the uvconfig file on the DataStage server (in the Engine directory). There is an NLS button on the Administrator client, where you can set project-wide defaults. Each job's Job Properties has an NLS tab where you can override the project-wide defaults fo...

With that many children in that short an interval I should have thought (note use of the subjunctive there) that you'd trained yourself to do without sleep by now!

Not without inspecting the actual jobs. Try - just as an experiment - a control job that doesn't use DSWaitForJob but, instead, a "busy wait" periodically inspecting the status of each running job (until job status <> DSJS.RUNNING) and sleeping for a short interval. It might also occasionally interr...

Thanks for the heads-up! This one slipped through the cracks. Will answer in about eight hours time.

Almost certainly. The IRowsetFastLoad interface is attempting to provide a row from DataStage for fast load, but has been prevented from doing so. It may be permissions, it may be privileges; it is something in the target preventing this special kind of "write" operation. A "shrink DB" operation ten...

That message (set of messages) may indicate that: (a) the RunJobWrapper routine has not been successfully compiled (b) you have inconsistently spelled or cased the name of the routine Given that DEFFUN indicates that you want to invoke a function, which is supported by the fact that RunJobWrapper ha...

With certain restrictions, it is possible at release 6.x by encapsulating the server job in a shared container. For details see the Parallel Job Developer's Guide, which has a chapter on exactly this topic.

The place to look is the chapter on Buildops in the Parallel Job Developer's Guide