DSXchange

Very true, all of the standard rules for processing files being transferred into your processing system in 'real time' (rather than batched) should come into play here.

Much like what this FAQ posting discusses.

This error message? The 'ulimit' error message? That has nothing directly to do with DataStage but is coming from your operating system based on the commands in the dsenv file. Looks like someone added a line attempting to raise the ulimit (probably to 'unlimited') there and your executing user isn'...

There's nothing special about the dsadm userid from a Linux / operating system standpoint, so no. It's not 'root' even though it does play that role inside the tool.

You migrated from what, an earlier version of DataStage or another tool? If DataStage, were you working with Parallel jobs or is that all new for you?

If I had any hands-on DB2 experience, I would be more than happy to help. However, I do not so can only point you to the documentation and hope that others who have actually done this join in the conversation. I have no idea what you mean by "install extra db2 database plug-in". All you sh...

I would just use two, one for the counter and one for the previous 'composite' key. Of course, this presupposes the data has been sorted. Note that having the Sort stage add a Key Change column can make this a little easier.

What Oracle query would that be? Nothing listed so far has been for Oracle. Ah... the query to find all of the jobs with Oracle stages. Never mind.

I don't see what this SQL has to do with getting the "last day of the month", nevermind the fact that Oracle (which this looks to be) has a built-in function for that.

Good luck with that.

I'm going to err on the side of complication and assume it needs to motor along doing something (even if that something is nothing) until the magic file shows up. And because I'm pressed for time this morning, this is a freebie high-level overview of what I would do in your shoes. Tools you'll need:...

Hopefully, what you meant to type was:
Also be mindful of the century pivot when you use two-digit years.

Not quite.

The Date And Time Formats are fully documented in the Parallel Job Developer Guide pdf.

Do an exact search for "COMO ON".

Contact your official support provider, get some one-on-one hands on help. Or just have them do it for you and explain / document what all the steps were so someone there can do it the next time this comes up.