DSXchange

Ok... since this thread has gone totally off track, I don't feel too bad about continuing its downhill slide. And since this ties in (somewhat) with the subject of the post, I thought I would pass along this interesting website, which was the recent cause of a very long and LOUD 'discussion' in the ...

ray.wurlod wrote:

chulett wrote:I've also go a multi-instance job ...

Farg. Any idea how many times I looked at that post? [heavy sigh]

The spell checker in Google toolbar is very handy for places like this, but now I'm wishing they had a grammar checker as well.

Or a new interface - too hard to find a good ergonomic keyboard anymore. I found the 'a' issue I assume you were speaking of but lost on the 't' issue.

That's ok, not the first nor the last time I'm sure.

So now we're talking Parallel jobs? Search for forum for that error message, odd as this sounds it too has been discussed before here. From what I recall, you need to use the Sequential stage to return only the filename(s) found - not the contents - and feed them to an XML Input stage set to the 'UR...

Whale dreck. Of a sort. So we're fine on the whole 'additive' thing then. I didn't look closely at the descriptions of each, just saw the sequence of numbers from zero to four. Showing them as 0,1,2 and 4 puts us back in the 'power of two' realm and all is right with the world again. Funny, though, ...

That's true, they have to be powers of two so sums are - as Ray rightly points out - unambiguous. Normally tracing levels are additive, so take that as a generic comment, this stage looks like it isn't following those rules. There should be Proprty Help for that field in the stage, park your cursor...

When you get the patch (or if you know now) can you post the associated ecase number, please?

Too true, it was all right there.

No, it's because you are 'LOG'd on to a specific project. At the TCL prompt type LOGTO UV and try again.

narasimha wrote:You can add up the Tracing levels to give more information. 7 gives combined tracing information.

As noted, they are 'additive' so (specifically) 7 means you want 3 & 4.

Seems like at least one 'user written' routine was not moved into the Production project: IntMTHYR2LastDayofMonth. Suggest you check them all while you are in there.

Excellent. Please mark the post as Resolved.

Any 'From previous run...' information if you reset the job?

Regardless, suggest you bump up the tracing level.

DB2 wants dates in internal format, from what I recall. Try just the Iconv part and see how that works.

[cough] ETLStats [cough]

Search and ye shall find.