DSXchange

I think we need some clarification from the Editor; I don't think that all of my posts are going to be invisible to those who haven't got a premium membership - if that were the case I'd have to revisit my participation (since few people like to do free work and see someone else get "paid" for it). ...

Greg,

this forum remains free as well; and hopefully most of it will remain so in the future (I hope). Also, the IBM/Ascential site remains open as well, so I'm not sure what the added value of a new site will be - who are you looking for as your target participation audience?

Although it is nice to see the popup, is there some way to get it turned off after viewing it n-times? I find it very bothersome to have it automajically move around the screen as I page and take up valuable screenspace in the posts.

I think that you aren't the only one with mixed feelings on the subject; those members whose answer-to-question ratio is greater than one are not going to be pleased about this change; and I sometimes feel that many whose answer-to-question ratio is below one consider getting quick and accurate resp...

Setting the value to 1 might be a bit extreme - I've never measured the performance impact when writing to a UV table but can imagine that a couple of hundred should be big enough to no blow any READU lock limits.

Craig, although it's too late now, it would be interesting to do a LIST.READU if this happens again. Also, what do you have the "rows per transaction" set to in the UV Stage? If at the default value of 0 I assume that DS will put a READU lock on each record that is part of the transaction until the ...

Sudhakar, I am trying to illustrate that there no set minimum number of rows to give reliable performance statistics. You need to achieve a minimum Job runtime (the longer the better to make the job startup times play a smaller role) and a low std. deviation between test runs. How many rows it takes...

The answer is enough rows to make you job run at least several minutes. I don't know your job or configuration; some installations are happy to get 500 row/second while others get 40,000/second. The sample should be large enough to even out other system factors. Your standard deviation for repeating...

Mario, I would recommend doing a fresh install on the new system. I remember that, in the olde days, changing the IP Address and/or hostname after an installation of UniVerse/DataStage would cause problems. That might be solved, but the extra 30 minutes spent on a new install are worth it just to be...

That is a very small sample and won't return meaningful results; any slight changes in the system (a couple of other process doing a bit of work during your sampling period) will give you wildly different results. For DataStage jobs I won't use any sample less than about 5 minutes run and preferably...

Prasad, NO NEED TO SHOUT IN UPPERCASE (unless you still have a teletype keyboard). You don't need to write a PX function to handle nulls, you can either use the column attributes for null handling or use a modify stage to do this change for you. Are you merely trying to replace NULL values with a sp...

I didn't think that re-indexing would help because the original post stated that this happened to all projects - rather imporobable but it would seem that it is possible.

Antonio,

could you use the mask "D4/MDY" instead of "DE" for the ICONV; I'm not at a PC with DS now so I can't look up the BASIC manual, but it is best to make sure that the conversion is as explicit as possible for the ICONV.

The handler only works for PX jobs. I think it's also not a good idea to publicly announce a licence violation, as IBM/Ascential most certainly have one or two people who (at least occasionally) look at this site. Or are you using AIX?

That's the only way I've used to date; but now I have a second method to use.