What do you mean by "For example, is there enough space to do a inline re-org
or should temporary area be used". ?

If you have space to do a reorg, you have space to do a reorg in-line/off-
line, does it matter?
If you don't have enough space, you don't have enough space. Both reorg
method need space to work with, right? Please correct me in this matter as I
am still learning some of the finer points of this tool...

Thanks

peter wrote:
>> Hello Peter,
>> Thanks for the post. It confirms what seems to be happening here especially
>[quoted text clipped - 39 lines]
>> --
>> Message posted viahttp://www.dbmonster.com
>
>The script evolved into a java UDF which does a lot more than just
>selecting a re-org list. It works out an optimal schedule for a re-
>org window based on past performance details, resources required,
>running multiple streams and so on. For example, is there enough
>space to do a inline re-org or should temporary area be used. Has
>exclusion lists. Some tables such data propagator control table or
>using table for event monitors cause issues. Don´t mind telling
>people what it does and why but I want to maintain ownership of the
>techniques I have used for obvious reasons. Sorry.

--
Message posted via http://www.dbmonster.com