Finding information about undocumentet variables
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