Re: B-tree cleaners

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