SEO

#1 (**permalink**) 04-19-2008, 06:30 PM

Hi,

Does someone know a mean which permit me to associate an or several
index to a specific b-tree cleaner ?

Thanks a lot in advance for your answers.

Best Regards
Fred

#2 (**permalink**) 04-19-2008, 06:32 PM

Hi,

Before to begin I would like to thank Alexey Sonkin, William - Spookey
- and Norbert for their reply and all people who have tried to help
me.
Thanks again.

For your information,

This is what I have learned and the answers to my question :

There is only 1 btree cleaner thread per database instance in 7.3x.
Unfortunatly, this can not be changed.
Thus, this btree cleaner (named 'btclean' in the output of the 'onstat
-g ath') thread performs the removal of delete entries from indexes
alone. With 'onstat -C' you can display more information about its
status. Via the 'partnum' you can identify the respective tables being
processed as follows:

in dbaccess :

SELECT tabname FROM systables WHERE partnum='<partnum>';

By the way this SQL statement will not work for fragmented tables so
you may use :

SELECT tabid FROM sysfragments WHERE partn='<partnum>'
SELECT tabname FROM systables where tabid='<tabid>';

Rem : Do not forget that with the onstat -C the partnum is in
hexadecimal and that in the systables this one is in decimal. So do
the convertion !

Best Regards
Fred

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

B-tree cleaners