Finding information about undocumentet variables
Posted in 2000
Isidre Pons Roca asked where to find documentation for undocumented variables such as LRUAGE and NOLRUPRIO in IDS 7.31 and 9.21. Art Kagel pointed to the Informix FAQ; David Williams listed the FAQ sections covering LRUPOLICY and NOLRUPRIO. Art explained that LRUAGE=1 enables LRU priority aging, lowering the priority of buffers not accessed for a while.
Topics: General Discussion
Hi all. A simple question: Where i can find information about LRUAGE, NOLRUPRIO and other undocumented variables for IDS versions 7.31.UC6 and 9.21.UC3? TIA --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------
Isidre PONS ROCA wrote: > > Hi all. > > A simple question: > > Where i can find information about LRUAGE, NOLRUPRIO and other undocumented variables for IDS versions > 7.31.UC6 and 9.21.UC3? Well they are 'undocumented' soo... But seriously I believe descriptions of these and others were included in the latest version of the FAQ: http://www.smooth1.demon.co.uk/informix.htm David, is this there? Art S. Kagel
In article <3A40F749.419552DC@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Isidre PONS ROCA wrote: >> >> Hi all. >> >> A simple question: >> >> Where i can find information about LRUAGE, NOLRUPRIO and other undocumented >variables for IDS versions >> 7.31.UC6 and 9.21.UC3? > >Well they are 'undocumented' soo... But seriously I believe descriptions >of these and others were included in the latest version of the FAQ: > >http://www.smooth1.demon.co.uk/informix.htm > >David, is this there? > Shuffle, Shuffle, flip, flip .... 8.13 What undocumented Online things are there? Covers LRUPOLICY (not 'the undocumented ONCONFIG parameter LRUPRIORITY' ) ^^^^^^^^^^^ typo to be fixed ASAP! 8.57 What are the main Informix bugs? covers NOLRUPRIO and mentions LRUAGE exists but does not say - what to set it to (??) - what is does! Art, what does LRUAGE do ?? PS WHy are these in Section 8 DBA stuff rather than Section 6 Online stuff?? I'm going mad.. Also I've noticed three sections on busy waits in the FAQ! TIme for a sort out! >Art S. Kagel -- David Williams
David Williams wrote: > > In article <3A40F749.419552DC@bloomberg.net>, Art S. Kagel > <kagel@bloomberg.net> writes > >Isidre PONS ROCA wrote: [SNIP] > > mentions LRUAGE exists but does not say > > - what to set it to (??) > - what is does! > > Art, what does LRUAGE do ?? Setting LRUAGE=1 enables LRU priority aging. This permits the engine to lower the priority of a buffer that has not been accessed for a while. This is to prevent the higher priority classes from starving the lower classes for buffers over time. In this way if a large batch job causes 100,000 index nodes to be loaded into MED-HIGH priority overnight by the next morning most of those nodes will have been aged down to MEDIUM permitting them to be replaced with data pages. > PS WHy are these in Section 8 DBA stuff rather than > Section 6 Online stuff?? I'm going mad.. > > Also I've noticed three sections on busy waits in the FAQ! > > TIme for a sort out! A little house cleaning is always a welcome enterprise. > >Art S. Kagel > > -- > David Williams Art S. Kagel