DSXchange

Stick with your script. There's no way to emulate that behavior in a Sequence job.

Windows 7 is not a supported platform for the server components... any components for that matter. Unfortunately.

In other words, what's already been suggested twice.

There's a little bit more to it when the child sequence sends out the failures and the master sequence send out the success, which is what the OP is doing.

Poovalingam wrote:Does it mean datastage maintains 2 meta data repository, one in Universe and another in Xmeta after 8X?

Yes.

Poovalingam also wrote:Shall we completely trust Universe meta data information?

Yes.

As far as I know, you'll either need to write your own or continue to use the Server routine in your Parallel jobs via a Server Shared Container.

Your official support provider is also a resource you can leverage for help with this. They should be able to clarify the syntax / properties you'd need in the connector to make that all work.

You do want separate state files for each target, yes, just like each would typically have its own unique / dedicated sequence generator in the database. Also, see if this post helps with your TWT question, the last reply specifically.

It is a Datastage question as this needs to happen from the Netezza Connector stage Just as an FYI, that part isn't really relevant. Your question to start with is how do you do it regardless of the tool, not how do you do it in DataStage. That aspect comes later and is usually not the tricky part....

I for one have no idea, being happily Netezza ignorant. In your shoes I'd start by asking your Netezza DBA as it really isn't a DataStage question.

A hash file is a tool to shape... oh, you know the drill by now - right?

Have you involved support?

There were no deleted files, their T30FILES setting in dsenv was too low. Once that number is exhausted, no more hashed files can be opened and that includes all of those that make up the repository. While the reboot made the problem 'go away', you may want to consider raising the value and then doi...

No, he means have one Success notification and one Failure notification. Before each one put a Sequencer - set it to All for the Success email and Any for the Failure email. Then run two triggers from each stage, one to each, as noted. Another option is for the Success triggers to go from Job Activi...

What 'same issue' exactly? Post some details.

Can you narrow down the 'sometimes'? What stage are you trying to get counts from?