Database REORGANIZATION

[David_FA]

Hi,
I have run an "ESTIMATE DBREORGSTATS" to estimate how much space could be recovered if I run a DATABASE REORG.
I am a bit afraid because the ESTIMATE DBREORGSTATS took about 10 hours!! I dont know if the DATABASE REORG will tako so long.

Does anyone have any experience it?

I add my databe q db f=D:

Available Space (MB) : 90.004
Assigned Capacity (MB) : 90.004
Maximum Extension (MB) : 0
Maximum Reduction (MB) : 4.128
Page Size (bytes) : 4.096
Total Usable Pages : 23.041.024
Used Pages : 21.925.759
Pct Util : 95,2
Max. Pct Util : 95,2
Physical Volumes : 37
Buffer Pool Pages : 38.400
Total Buffer Requests : 1.904.511.219
Cache Hit Pct. : 98,94
Cache Wait Pct. : 0
Backup in Progress? : No
Type of Backup In Progress :
Incrementals Since Last Full : 3
Changed Since Last Backup (MB) : 2.224,07
Percentage Changed : 2,6
Last Complete Backup Date/Time : 7/02/08 11:29:03 CET
Estimate of Recoverable Space (MB) : 21.496
Last Estimate of Recoverable Space (MB) : 13/01/08 19:39:28 CEST

Thanks in advance,

 

[BBB]

Your reorg will probably take longer than the estimate, possibly much longer.

It helps if you put the DB onto the fastest possible disks - or massive RAMDISK as one or two people on the board like to do

 

[mateinone]

- or massive RAMDISK as one or two people on the board like to do

I cannot do that anymore :cry: no longer working at the old joint with fully populated p595's at my disposal... I think I was spoilt


I would suggest you are absolutely no chance at all of getting the process completed in 10 hours without the free RAM, with a 90gb database I would be absolutely stunned if you managed to get it done in a week, unless you has some exceptionally high level disk available.

 

[David_FA]

First of all, I am sorry baucase Ithink I have written my post in the wrong forum.

Thank for you comments.

I have IBM DS8100 DISK with 15.000 RPM.

However, I wont do a reorganization.

Thanks a lot.