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

Related ...

This thread ...


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