you said you ran this SQL via navigator, but I wonder if this could be ran from restricted state or how much of the system would I need to start to run this via STRSQL?

On 10/22/2012 12:51 PM, rob@xxxxxxxxx wrote:
I only gained between 4 and 5 percent by this reorg.

System ASP . . . . . . : 326.2
% system ASP used . . : 64.081

Some reorgs can take awhile. This one was running with no interactive or
batch jobs running:
Job 339929/ROB/GLH started on 10/22/12 at 11:38:39
Job 339929/ROB/GLH ended on 10/22/12 at 12:20:27;
Didn't really have that many deleted rows (at least compared to some of
the heavy hitters). Active rows are significant, 25,715,052.

Rob Berendt

This thread ...


Return to Archive home page | Return to MIDRANGE.COM home page