Informix & Baan Installation

I hope there is an Informix Guru out there will be able to shed some light on this. We have a HP9000 D270 (a single CPU PA-8000 at 160MHz) with 256MB RAM and 4x4GB HDD running HPUX10.20. Installed on this is Informix OnLine version 7.23.UC6. Listed at the end of this message are the parameters I think may be helpful for anyone who wishes to try and solve this problem. The Problem: I am in the process of installing Baan IV on our system which is using OnLine as its database server. This installation is supposed to take less that 12 hours to complete, yet on our system it takes 9 days to install! (I am in the process of doing this a second time, and that is why I know how long it will take despite being in the middle of the installation process.) The reason I am reinstalling is because I thought that there must have been something wrong with my OnLine setup at the first instance, and so I recreated it all again. However, the problem persists! One thing I have noticed is that using 'onstat -g sql sesid' on a given baan session suggests that each SQL statement is taking *forever* to complete (I mean *hours*). If anyone can shed some light on this I would really appreciate it. Lee lee@ykkap.com.sg Configuration Details: According to the $INFORMIXDIR/release/en_us/0333/ONLINE_7.2 release notes, our system does not support ipcshm so I have configued for NETTYPE ipcstr and soctcp. I have raw devices: Device Size Symbollic Link /dev/vg02/rdb_chunk1 512MB /dev/on_rootdbs /dev/vg02/rdb_chunk2 512MB /dev/on_llogdbs /dev/vg02/rdb_chunk3 2048MB /dev/on_datadbs /dev/vg03/rdb_chunk5 512MB /dev/on_plogdbs /dev/vg03/rdb_chunk6 512MB /dev/on_tempdbs /dev/vg03/rdb_chunk7 2048MB /dev/on_idxdbs ls -l crw-rw---- 1 informix informix 64 0x020002 rdb_chunk01 crw-rw---- 1 informix informix 64 0x020003 rdb_chunk02 crw-rw---- 1 informix informix 64 0x020004 rdb_chunk03 crw-rw---- 1 informix informix 64 0x030002 rdb_chunk05 crw-rw---- 1 informix informix 64 0x030003 rdb_chunk06 crw-rw---- 1 informix informix 64 0x030004 rdb_chunk07 DBSPACES/BLOBSPACES Number of When Id Name Chunks Created Status 1 rootdbs 1 06/19/98 N 2 plogdbs 1 06/19/98 N 3 llogdbs 1 06/19/98 N 4 tempdbs 1 06/19/98 N T 5 datadbs 1 06/19/98 N 6 idxdbs 1 06/19/98 N Chunk Chunk Pages Pages Full Pathname Status Id Offset In Chunk Used 1 0 256000 1021 /dev/on_rootdbs PO- 2 0 256000 150053 /dev/on_plogdbs PO- 3 0 256000 30053 /dev/on_llogdbs PO- 4 0 256000 597 /dev/on_tempdbs PO- 5 0 1024000 46756 /dev/on_datadbs PO- 6 0 1024000 35471 /dev/on_idxdbs PO- Logs are as follows: PHYSICAL LOG: Buffer Bufsize Bufused Numpages Numwrites pages/IO P-2 16 0 24923 1664 14.98 Phybegin Physize Phypos Phyused % Used 200035 150000 60788 64 0.04 LOGICAL LOG: Buffer Bufsize Bufused Numrecs Numpages Numwrites Recs/Page Pages/IO L-2 16 4 1518981 83747 5533 18.14 15.14 INDIVIDUAL LOG FILES: Number Flags Uniqid Dbspace Pages Used % Used 4 U---C-L 188 llogdbs 5000 785 15.70 5 U-B---- 183 llogdbs 5000 5000 100.00 6 U-B---- 184 llogdbs 5000 5000 100.00 7 U-B---- 185 llogdbs 5000 5000 100.00 Some important onfonfig parameters are: ROOTNAME rootdbs # Root dbspace name ROOTPATH /dev/on_rootdbs # Path for root dbspace ROOTOFFSET 0 # Offset of root dbspace ROOTSIZE 512000 # Size of root dbspace (Kbytes)PHYSDBS plogdbs # Location (dbspace) of physical log PHYSFILE 300000 # Physical log file size (Kbytes) LOGFILES 6 # Number of logical log files LOGSIZE 10000 # Logical log size (Kbytes) DBSERVERNAME jazzipc # Name of default database server DBSERVERALIASES jazznet # List of alternate dbservernames DEADLOCK_TIMEOUT 60 # Max time to wait of lock RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 0 # 0 for single-processor NUMCPUVPS 1 # Number of user (cpu) vps SINGLE_CPU_VP 1 # If non-zero, limit cpu vps to one LOCKS 20000 # Maximum number of locks BUFFERS 24000 # Maximum number of shared buffers NUMAIOVPS 2 # Number of IO vps PHYSBUFF 32 # Physical log buffer size (Kbytes) LOGBUFF 32 # Logical log buffer size (Kbytes)LOGSMAX 10 # Maximum number of logical log files CLEANERS 2 # Number of buffer cleaner processes SHMBASE 0x0 # Shared memory base address SHMVIRTSIZE 16000 # initial virtual shared memory segment size SHMADD 8192 # Size of new shared memory segments SHMTOTAL 0 # Total shared memory 0=>unlimited LRUS 8 # Number of LRU queues LRU_MAX_DIRTY 60 # LRU percent dirty begin cleaning limit LRU_MIN_DIRTY 50 # LRU percent dirty end cleaning limit LTXHWM 50 # Long transaction high water mark LTXEHWM 60 # Long transaction high water mark TXTIMEOUT 0x12c # Transaction timeout (in sec) STACKSIZE 64 # Stack size (Kbytes) NETTYPE soctcp,1,50,NET # TCP/IP network NETTYPE ipcstr,1,20,CPU # Shared memory via stream pipes DBSPACETEMP tempdbs # Default temp dbspaces Some 'onstat' output: onstat -g glo =============MT global info: sessions threads vps lngspins 5 19 8 0 sched calls thread switches yield 0 yield n yield forever total: 1559974608 1069817600 1021449563 305188 2136510 per sec: 20251 3797 18278 2 43 Virtual processor summary: class vps usercpu syscpu total cpu 1 34669.78 15959.58 50629.36 aio 2 240.25 808.71 1048.96 lio 1 5.59 17.28 22.87 pio 1 4.80 14.86 19.66 adm 1 6.24 13.09 19.33 soc 1 13.53 26.43 39.96 msc 1 0.03 0.01 0.04 total 8 34940.22 16839.96 51780.18 Individual virtual processors:@@N