I hope Allegro doesn't mind... and that reminds me... I need to talk to Steve Cooper... .anyway (Steve please call me  :-)  )

Allegro has a great program to see what is using the B-Tree Extent table, see
http://www.allegro.com/software/hp3000/stuff/TBLTEST.std

There is also an FFLUSH program that will flush unused entries from the B_tree table.

Defragging will help a lot.  I also found that re-indexing OMNIDEX indexes really does seem to help.   Re-index and then defrag.


Regards,

-Craig


Reggie Monroe <[log in to unmask]> wrote: We have been battling keeping the numbers of extents low on our system
by defragging drive,using the Newci command and keeping an adequate
amount of free disc space. Our Extent B_Tree is still up in the 95%. We
are planning on doing more defrags but we wanted to know do anyone have
any other suggestions.
 
Regards
 
Reginald Monroe
Systems Engineering
Mercury Insurance - Information Technology
(714) 671-6753
[log in to unmask]
 

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *


 
---------------------------------
Check out the all-new Yahoo! Mail beta - Fire up a more powerful email and get things done faster.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *