DSXchange

What does the job do? What resources does it use? There's more to making a job multi-instance than simply checking that box, you must account for the fact that it will be running multiple invocations in the design itself. Resources that would be 'shared' across multiple instances would typically hav...

Post some examples. That will hopefully go a long way towards helping people understand exactly what it is you need to do.

Another option - upgrade to at least the 8.7 release and take advantage of the Operations Console which tracks and reports data of that nature.

Only 52 if you restrict the author to Ray. Technically 51 as this one doesn't count.

You have an Oracle issue, not a DataStage one per se. What does the SQL look like that the Oracle Connector is using, is there a TO_DATE() function in it? If so, what format string is it using? A mismatch there is what throws that Oracle error.

I'm not sure off the top of my head but if you modify a job to run "ulimit -a" as a Before Job option, then you could look for which show a current value of 10240. That should at least narrow it down if not answer the question.

And only because you have "vs" in your subject... are you clear on what the two settings control?

Short answer is - there are no "best values".

In this particular case, Sequential job = Sequence job.

If the ^M characters were at the end of each line I would agree with you. In the middle? Not so much.

ArndW wrote:Control-M is a "Carriage Return".

And a carriage return is a CHAR(13). FYI. However, you should still answer Arnd's questions.

SandhyaShetty21 wrote:I am looking for a table which would give me monitor information about the previous runs of a job.

Always best to lead with your actual problem / question.

I wish I could attach screenshots, but I don;t see this option in this forum. You have the same option here as pretty much any other forum - "image" tags. You need to host your image file somewhere (there are many free hosting sites out there) and then use the [Img] tags to hold the URL a...

I don't think i can see a preserve type option. If you can let me know where it is, I can test the job with this option. I did a quick search and found one discussion here which should help. There were others. And I know it's already been answered but just in case, a 'string sort' means numbers wou...

Note the facts as you just did and then... move on.

If you want to officially close the topic, mark it as a Workaround. We'll consider the decommissioning of the server as your workaround.