DSXchange

Did you download the documentation/help HTML that forms part of ETLstats?

Check that the Node agent and Logging agent are running.

Can you obtain a premium membership please?

Premium memberships are one of the ways that the hosting and bandwidth costs of DSXchange are met. I don't propose to prejudice the continued existence of DSXchange by undermining that mechanism.

Six minutes?!!!! That's gotta be a DSXchange record for impatience!! Hey, I know you're new, but please realise that DSXchange is an all volunteer site, whose members post as and when they can. If you want immediate response sign up with your official support provider for priority service, and learn...

StartLoop (1..6) ---> WaitForFile (3 hours) ----> Notification ----> EndLoop | | | | | Success | Failure | | V V

You can't do Calculation and Count Rows in one Aggregator stage, but you can do two Calculations. The other is Sum of an input column whose value is 1 in every row. This gives you the count.

There hasn't been a uvrpc service for DataStage since version 6.0, when it was replaced with the dsrpc service. It's part of DataStage engine, and does run on VMWare - I've been teaching an IBM class (Advanced DataStage) this week and that runs the engine, services and repository tiers on a VMware i...

It isn't. It's inferred from the Scale value. There's no need to store it.

Yes. Have the same data stream coming in on both links. Properly key-partitioned and sorted, of course.

It is not mandatory but I'd strongly recommend that you do so, so as not to violate the Law of Least Astonishment when your administrators have to communicate with IBM Support.

There's nothing out of the box. You could create a routine. Or you could search DSXchange for one that someone has already written.

In parallel jobs (in any version) data types are strictly enforced; in server jobs they are not enforced at all except on the boundaries (to files, databases and the like). In a parallel Transformer stage a space in an integer column will throw an exception; if the Transformer stage has a reject lin...

Pull? What does this mean? What do you want to do with the metadata?

NextSurrogateKey() will only work if the state file or database sequence for the surrogate key generator has been initialized.

Either is OK, but don't use the reserved schema name XMETA for your corporate data. I would prefer separate databases, but it will work if they're in the same database.