DSXchange

If you called "MyJob.Instance" then the displayed instance will be "Instance", there is no other internal name or number.

Would it be possible to be more exact in what you wish? The routines listed are documented in the manual along with examples, and if you search here with the routine names as keywords you will also find code snippets. "APT_DUMP_SCORE" is not a command but an environment variable.

Perhaps you are hitting your maximum user limit when all jobs are started simultaneously. Can you try putting a delay (call "SLEEP" from a execute command stage) in so that not everything tries to kick off at the same time. Thoe operator combination disable is generally not recommended for...

Your COMO file with the error and it's cause should be in your project's &PH& directory. If you can't locate the correct file by the date/timestamp, clear that directory prior to a run and then go through the files until you find your error message, then post that.

Certification is available for Parallel only, not for Server. There are many threads regarding certification and some of them give hints and also links to informative pages (Vince's pages). Please use the Search factility to find and look at those threads, then post any additional questions here.

Although technically one can call a user-defined routine in a transform stage (either once as a before/after or for each row) that in turn can reset another job, it doesn't make sense to do so and I think that you should look at your design again. A transform is called once a job is started, so in o...

sysmq wrote:...
RLTABSZ from 75 to 300
MAXRLOCK from 74 to 299

Where did you get the recommendations to change these values? Unless you have specific problems that are addressed by this change it is unwise to change these, as they can have an impact on performance.

Sunny, in many cases such a migration is almost automatic but the difficulties start if there are problems, these are almost always specific to an implementation. There is little of value to be added in a generic post without knowing more about what you actually need. The best approach, if possible,...

...we encounter a performance issue all of tha HASH files are taking over the entier RAM and pageFile (6.6 gb ) and than crashes with the error of :unable to alocate memory... Have you measured memory usage by process, or how have you determined this? Do you have just one DataStage job or many? Wha...

Could you mean %mmm?

It would be more like "JobHandle=DSPrepareJob(JobHandle)"

Please try the following - create a brand new job from scratch with just your source, a transform stage output to a copy stage. Add your columns and see if it compiles and runs to completion or also aborts. Could you cut-and-paste rows 8749970 through 8749982? Is there anything different with this r...

Could you try using a letter that is found in the file as a delimiter to see if your error shifts from the first column to the second (or subsequent) columns?

And remember that DSPrepareJob() will return a different job handle if it actually does reset the job.

Are you using NLS? It is just that I have used odd delimiters without issue in both Server and Parallel jobs, thus I think your error is not something inherent in DataStage but in your definitions or environment somewhere.