Re: Description of onstat -C

#1

On Wed, 27 Aug 2003 03:24:08 -0400, Oxow wrote:

Outstanding requests are requests for the BTREE-CLEANER thread to clean some
index. Invalidations? Got me.

Art S. Kagel

Quote:

Hi,

Could someone tell me what is the difference between the two following
sections in the onstat -C command and what is there meaning ? - Invalidation
Requests
- Outstanding Requests

Thanks a lot for your answers.

Best Regards
Fred

#2

Oxow,

"Outstanding Requests" are requests to clean some page that have to be
worked on by the btree cleaner. They are issued after some index key got
deleted.

An "Invalidation Request" is a request to cancel an outstanding request.
This is done for example when an index with outstanding requests is
dropped or when btree pages with outstanding requests are merged.

Best Regards
Michael

Oxow wrote:

Quote:

Hi,

Could someone tell me what is the difference between the two following
sections in the onstat -C command and what is there meaning ?
- Invalidation Requests
- Outstanding Requests

Thanks a lot for your answers.

Best Regards
Fred

-- --

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

Re: Description of onstat -C

comp.databases.informix comp.databases.informix

Re: Description of onstat -C - 08-27-2003 , 02:58 PM

Re: Description of onstat -C - 08-28-2003 , 08:41 AM