Re: Extremely Slow
From: CN Liu <cn@mail.sinyih.com.tw>
>
>The local Informix engineer told us to do 2 things: (1) increasing
>number of logicl files to at least 6 and (2) updating statistics. Now we
>have done these (the number of logical files is now 20 = 160MB total,
>and I will increase it to 60 files later) as told by Informix.
I would have said UPDATE STATISTICS was the charm. Are you sure you don't
have hardware damage (a disk that got some damage during the power problems,
for instance)?
>tbconfig:
>
>PHYSDBS rootdbs
Can you move your physical and logical logs out to separate spindles?
>PHYSFILE 8192
>LOGFILES 20
>LOGSIZE 8192>USERS 200
>TRANSACTIONS 200
>LOCKS 100000
>BUFFERS 15000
This looks a bit low. What is the output from tbstat -p?
>TBLSPACES 400
>CHUNKS 8
>DBSPACES 8
>PHYSBUFF 512
>LOGBUFF 1024>LOGSMAX 60
>CLEANERS 4
>SHMBASE 0x0
>CKPTINTVL 900>BUFFSIZE 2048
>LRUS 16
>LRU_MAX_DIRTY 8
>LRU_MIN_DIRTY 3
>LTXHWM 40
>LTXEHWM 50>DYNSHMSZ 0
>GTRID_CMP_SZ 32
>TXTIMEOUT 300>SPINCNT 0
>
>/etc/conf/cf.d/mtune:
>
>* Semaphore Parameters
>SEMMAP 10 10 100
>SEMMNI 4096 300 300
>SEMMNS 4096 60 300
>SEMMNU 30 10 100
>SEMMSL 25 25 60
>SEMOPM 10 10 10
>SEMUME 10 10 10
>SEMVMX 32767 32767 32767
>SEMAEM 16384 16384 16384
>* Shared Memory Parameters
>SHMMAX 60000000 131072 2147483647
>SHMMIN 1 1 1
>SHMMNI 255 100 2000
>
>tbstat -d:
>
>RSAM Version 5.10.UC1 -- On-Line -- Up 02:57:02 -- 42144 Kbytes
>
>Dbspaces
>address number flags fchunk nchunks flags owner name
>80055b7c 1 1 1 4 N informix rootdbs
> 1 active, 8 total
>
>Chunks
>address chk/dbs offset size free bpages flags pathname
>800556bc 1 1 0 1000000 4 PO- /dev/ru2
>80055754 2 1 0 1000000 2 PO- /dev/ru3
>800557ec 3 1 0 1000000 386697 PO- /dev/p2d1
>80055884 4 1 0 1000000 999997 PO- /dev/p2d2
> 4 active, 8 total
>
>I much worrry about the outcome when tommorrow comes. Can someone give
>me any suggestions so that I can try once this machine starts to crawl
>again?
Good luck!
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com