Description of onstat -C

Posted in 2003

Oxow — 27 Aug 2003 00:24:08 -0700 — source: Usenet: comp.databases.informix

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

↪ replying to Oxow

Art S. Kagel — Wed, 27 Aug 2003 15:58:35 -0400 — source: Usenet: comp.databases.informix

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 > 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

↪ replying to Oxow

Michael Mueller — Thu, 28 Aug 2003 15:41:48 +0200 — source: Usenet: comp.databases.informix

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: > 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 -- --

Related threads

Glossary

onstat