Re: ONCONFIG for 9.40 offered for comment

Neil Truby wrote: > > 9.40 FC3W2 on HP-UX 11.11 > The server has 6 cpus and 6G of RAM. > 3 other, small, IDS 9.40 instances run on the server, and one small 7.31. > kaio is enabled. > > Just put 9.40 live, and it's running about 5-10% more slowly on some key > processes. This reflects what happened in testing. In particular we seem to > be having fun and games with the new BTscanners. I thought I'd post the > ONCONFIG for comment - any and all gratefully received! > [ ... onconfig snipped ... ] Did you have indexes attached in 7.31 and are they detached from tables now in 9.4?? We had to learn, that especially when you see lower index filtering on crieria no so optimal, detaching makes a huge difference *not* to the bettter.... Anyway: Check your sequential scans, if you have more than a few. Check onstat -g ppf. This shows you per partnum, what I/O is going on and how good the table or index chaching rate is. Only caveat is, that one needs a script to add the table or index name to those ppf lines as they identify the objects by their respective partnums only. If you need a brute force Perl script, mail me & I send it to you. dic_k -- Richard Kofler SOLID STATE EDV Dienstleistungen GmbH Vienna/Austria/Europe

"Richard Kofler" <richard.kofler@chello.at> wrote in message news:40D21600.A23E143C@chello.at... > Did you have indexes attached in 7.31 and are they detached from > tables now in 9.4?? Well, this database has gone from 7.13->7.24->9.20->9.21->9.40 in six years. So probably some indexes are still attached from the v7 days (3+ years ago). A lot will have been converted to detached through housekeeping though.