DSXchange

In other words, the mask much match the incoming data so it knows how to parse it, not what you think the output should be.

You can't simply drop the month value by six without regard for the day.

My understanding is those values are not user editable but would require a 'patch' from IBM to change them. As Ray noted, however, you are much better off treating the disease rather than the symptom.

I guess we'll see... hopefully by now they've got it sorted out, however.

greggknight wrote:I run this code in a batch job.

That looks like KBA code to me... and I've always wondered how much of the things like that people have done "under the covers" would still work in the 8.x world.

I'd start with this message and your DBA:

[IBM][SQLServer JDBC Driver][SQLServer]The transaction log for database 'XMeta' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

I don't see what the error you posted has to do with the code you posted before that. Post the entire code for this 'RunNumber' routine.

ray.wurlod wrote:This really belongs in a different thread.

Done. Nagac, please start threads properly rather than jumping on things you stumble across while searching.

A stop or 'hang' usually means a blocking lock, have your DBA trace the sessions. Another test - run on a single node.

You need to decide on the approach that works for you. And since we're talking about something that happens once per job run, I don't see that "most efficient" has much play here. Me, I would include a Routine Activity stage in a Sequence that runs one of the "KeyMgtGetNextValue"...

Sure. More than one way to skin that cat.

Checkpoints.

It's been discussed here before, so other posts should have additional information. Biggest thing to take away is that 'node' in the config file is more akin to 'thread' than machine or CPU.

There's no "reject reason" recorded so (AFAIK) this is strictly a manual process. Compare the rejected rows to the metadata you've defined in the stage to see which fields have data that do not fit their metadata, for example a date column with an invalid date in it. If you want them proce...