Number of isread dropped

Posted in 2016

Topics: Installation, Setup & Upgrades, Platform-Specific Issues

ALI SHAHNAZI — Tue, 06 Sep 2016 07:15:35 — source: IIUG Forums & Mailing Lists

Hi All, Upgraded AIX Informix from 11.7FC6 to 12.10FC6. As I'm collecting metrics from sysmaster, I realized that number of "isread" dropped, any comment?

↪ replying to ALI SHAHNAZI

Fernando Nunes — Tue, 06 Sep 2016 07:57:35 — source: IIUG Forums & Mailing Lists

What was the settings for BATCHEDREAD_TABLE / BATCHEDREAD_INDEX in comparison with current version? This is a bit of a wild guess, but it' possible it was turned off (0) and now it's turned on. Considering this implements optimization at ISAM calls level it may explain that. You can see the default and effective values with: SELECT * FROM sysconfig WHERE cf_name LIKE 'BATCHED%' On 11.70.FC8 the default was "1". On FC6 I'm not sure. Regards. On Tue, Sep 6, 2016 at 9:15 AM, ALI SHAHNAZI <ali@datasync.com.au> wrote: > Hi All, > > Upgraded AIX Informix from 11.7FC6 to 12.10FC6. As I'm collecting metrics > from > sysmaster, I realized that number of "isread" dropped, any comment? > > > ************************************************************ > ******************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --001a1143d5cafeb769053bd225d4

↪ replying to Fernando Nunes

ALI SHAHNAZI — Wed, 07 Sep 2016 01:36:29 — source: IIUG Forums & Mailing Lists

Thanks Fernando. Interestingly both were 1 in 11.7 and 12.10. Can I assume that light scan hasn't been used in 11.7 for some reason?