shm initialization problem solved - was NUMAIOVPS
Posted in 1998
Answer to my own question -
shm init problem solved at last
NUMAIOVPS was not set (look at my onconfig file). I changed the parameter to 1
(defeult is 6 or num chunks * 2, whichever is greater) according to the book
from Elisabeth Sato- Informix Performance Tuning (p. 66/67):
ROOTOFFSET was 0
INFORMIX Online dynamic server is controlled by a set of I/O vps. (...) On some
operating systems, the actual disk I/O is handled not by the AIO vps but by the
UNIX kernel. This type of I/O is known as *kernel* AIO and can add a
significant performance boost to to I/O processing. However, it is used for
online I/O only on certain systems.
(...check machine notes...
...AIOs used *only* for raw devices...
...run onstat -g ioq on a system that works... )
I had a running instance with cooked files, hence received this output for
onstat -g ioq:
AIO big buffer usage summary:
class reads writes
pages ops pgs/op holes hl-ops hls/op pages ops pgs/op
kio 0 0 0.00 0 0 0.00 0 0 0.00
adt 0 0 0.00 0 0 0.00 0 0 0.00
opt 0 0 0.00 0 0 0.00 0 0 0.00
msc 0 0 0.00 0 0 0.00 0 0 0.00
aio 66 39 1.69 6 2 3.00 6 5 1.20
pio 0 0 0.00 0 0 0.00 0 0 0.00
lio 0 0 0.00 0 0 0.00 1 1 1.00
"A clever indication that the online system is using kernel AIO of a kio queue
in this output. If you see the kio queue and you are using raw devices, set the
number of AIO VPS to 1 "
Again, Then I changed NUMAIOVPS to 1 , changed ONCONFIG to
$INFORMIXDIR/etc/onconfig.raw, ran oninit -i -s et voil' -
(see my online log : )
Mon Jul 20 23:15:49 1998
23:15:49 Event alarms enabled. ALARMPROG =
'/home/dvs_fs6/informix/etc/log_fu'
23:15:49 Booting Language <c> from module <>
23:15:49 Loading Module <CNULL>
23:15:49 Booting Language <builtin> from module <>
23:15:49 Loading Module <BUILTINNULL>
23:15:58 DR: DRAUTO is 0 (Off)
23:15:58 INFORMIX-Universal Server Version 9.13.UC2 Software Serial Number
23:16:00 INFORMIX-Universal Server Initialized -- Complete Disk Initialized.
23:16:00 Checkpoint Completed: duration was 0 seconds.
23:16:00 Dataskip is now OFF for all dbspaces
23:16:00 Quiescent Mode
23:20:59 Checkpoint Completed: duration was 0 seconds.
Good bye
Knut
-
*************************************************************************
Knut Behrends
Vettersstr. 66 / 329
09126 Chemnitz
Germany
Phone: 0177- 33 40 486
*************************************************************************