NOLRUPRIO / LRUPRIORITY IDS 7.31_UC2

Hi Folks, I am after some more information and advise regarding the LRU priority bug mentioned within this newsgroup. We are running IDS 7.31_UC2 on a 10way HP T520, 1.75 Gb RAM running HPUX 10.20 with KAIO enabled and NO_SUBQF=1 set. I am able to keep bufwaits > 10% but only by increasing buffers to > 35% of total memory. Currently we are forced to bounce the engine every Sunday due to degrading performance over time. onstat -P | tail -5 shows the following on Monday morning: Percentages: Data 42.78 Btree 56.66 Other 0.56 But by Thursday Btree > 80% and > 90% by Friday. onstat -B | grep " d0 " | wc -l shows 2000 entries on Monday,increasing to around 7000 by Friday. I tried to add export NOLRUPRIO=1 to the environment last Sunday but the engine fails left right and center with this set, either assert fails with numerous different errors on startup or hangs blocked on checkpoint required if I manage to get the engine up. One thing I am confused about is that in some posting LRUPRIORITY is mentioned and NOLRUPRIO in others. Are these variables one and the same thing, or totally different? How should I be setting these parameters in order to work around the problems that we are experiencing? Understand that recreating the indexes is the recommended fix to this problem, but want to be sure that the symptoms match the bug before recreating 100's of indexes on a medium sized database. Is there any way to determine which indexes were created with prior versions of Informix, or which indexes I should focus on recreating first. The reason being is we have been running 7.31_UC2 for one year now and I know "we" have recreated many indexes but "we" don't have records of this. Would an Informix upgrade be of any value in this situation, if so what version would you recommended for us? OK, thanks in advance for any advise, open to all suggestions. Regards Matthew Byrne,. Onstat 'p Note only up one day, realize write cache is very poor at the moment, this is unusual normally write cache is around 85% Informix Dynamic Server Version 7.31.UC2 -- On-Line -- Up 1 days 01:23:13 -- 1265160 Kbytes Profile dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached 13206162 16437681 778610313 98.30 3020313 4369914 8978046 66.36 isamtot open start read write rewrite delete commit rollbk 512009540 4186475 55106373 303101804 1908916 1466246 1006371 148896 304 gp_read gp_write gp_rewrt gp_del gp_alloc gp_free gp_curs 0 0 0 0 0 0 0 ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes 0 0 0 101442.55 68857.57 52 106 bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans 2210679 3226 409305478 4 0 240 57282 183962 ixda-RA idx-RA da-RA RA-pgsused lchwaits 4144333 637883 1249500 5671303 897780 Also please feel free to pick the hell out of our onconfig ROOTNAME mprootdbs ROOTPATH /opt/informix/dev/mprootdbs.ln ROOTOFFSET 0 ROOTSIZE 20000 MIRROR 1 MIRRORPATH /opt/informix/dev/mprootdbsm.ln MIRROROFFSET 0 PHYSDBS mpplogdbs PHYSFILE 40000 LOGFILES 30 LOGSIZE 50000 MSGPATH /opt/informix/logs/tpramimsp.mlog CONSOLE /opt/informix/logs/tpramimsp.clog ALARMPROGRAM /opt/informix/current/etc/no_log.sh SYSALARMPROGRAM /opt/informix/current/etc/evidence.sh TBLSPACE_STATS 0 WSTATS 0 TAPEDEV /dev/rmt/c1t5d0BEST TAPEBLK 1024 TAPESIZE 70000000 LTAPEDEV /dev/rmt/c2t5d0BEST LTAPEBLK 1024 LTAPESIZE 70000000 # System Configuration SERVERNUM 1 DBSERVERNAME tpramimsp_shm DBSERVERALIASES tpramimsp NETTYPE soctcp,9,100,NET NETTYPE ipcshm,9,100,CPU (Note I am sure the above NETTYPE is wrong, but I am having trouble fully understanding this parameter, other DBA in company believe these are correct, 3-tier OLTP application, this instance is on a dedicated database server, 700 concurrent users, via a TP) DEADLOCK_TIMEOUT 60 RESIDENT -1 MULTIPROCESSOR 1 NUMCPUVPS 9 SINGLE_CPU_VP 0 NOAGE 1 AFF_SPROC 1 AFF_NPROCS 9 # Shared Memory Parameters LOCKS 200000 BUFFERS 293750 NUMAIOVPS 2 PHYSBUFF 8 LOGBUFF 8LOGSMAX 40 CLEANERS 127 SHMBASE 0x0 SHMVIRTSIZE 625000 SHMADD 32768 SHMTOTAL 0 CKPTINTVL 1200 LRUS 127 LRU_MAX_DIRTY 1 LRU_MIN_DIRTY 0 LTXHWM 50 LTXEHWM 60 TXTIMEOUT 0x12c STACKSIZE 32 DD_HASHSIZE 91 DD_HASHMAX 10 OFF_RECVRY_THREADS 10 ON_RECVRY_THREADS 1 DRAUTO 0 DRINTERVAL 90 DRTIMEOUT 90 DRLOSTFOUND /opt/informix/current/etc/dr.lostfound.12 CDR_LOGBUFFERS 128 CDR_EVALTHREADS 1,2 CDR_DSLOCKWAIT -1 CDR_QUEUEMEM 500 BAR_ACT_LOG /tmp/bar_act.log BAR_MAX_BACKUP 0 BAR_RETRY 1 BAR_NB_XPORT_COUNT 10 BAR_XFER_BUF_SIZE 31 ISM_DATA_POOL ISMData ISM_LOG_POOL ISMLogs RA_PAGES 6 RA_THRESHOLD 3 DBSPACETEMP mptmpdbs1,mptmpdbs2,mptmpdbs3 DUMPDIR /tmp DUMPSHMEM 0 DUMPGCORE 0 DUMPCORE 0 DUMPCNT 1 FILLFACTOR 90 USEOSTIME 1 MAX_PDQPRIORITY 100 DS_MAX_QUERIES 2 DS_TOTAL_MEMORY 8000 DS_MAX_SCANS 100 DATASKIP OFF OPTCOMPIND 0 ONDBSPACEDOWN 0LBU_PRESERVE 0 OPCACHEMAX 0 HETERO_COMMIT 0 OPT_GOAL -1 DIRECTIVES 1 CDR_LOGDELTA 30 CDR_NUMCONNECT 16 CDR_NIFRETRY 300 CDR_NIFCOMPRESS 0 Sent via Deja.com http://www.deja.com/ Before you buy.