Is KAIO in use
On AIX with IDS 9.40.FC9, the user saw no kio (KAIO) entries in 'onstat -g iov' despite exporting KAIOOFF=0 and IFMX_AIOKAIO_NUM_REQ. Replies noted KAIO runs as threads on CPU VPs (visible via onstat -g ath / iov as 'kio'), works only on raw chunks prior to 11.10, and needs the AIX AIO driver enabled. The cause was the KAIOOFF variable itself: merely having it set (even to 0) disabled KAIO. Unsetting it (KAIO is on by default except on HP-UX, where KAIOON is needed) made kio lines appear, confirming KAIO was active.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi,
I'm running an informix 94FC09 engine on an AIX box using KAIO. I launched the
engine after setting the following OS parameters KAIOOFF=0 and
IFMX_AIOKAIO_NUM_REQ=12288, knowing NUMAIOVPS is set to 2, and the OS AIOs
configuration is Min number server=10, Max number server = 20 and Max number
of requests = 20480
When I run 'onstat -g iov' (see result below), I found no kaio vp. So my
question is : how can I know (see) that KAIO is being used by the informix
engine ? :
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 04:52:19 --6812848 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
msc 0 i 3.8 66391 0 0 0 83845 0.8 0
aio 0 i 84.6 1484145 1363824 107520 0 1369833 1.1 0
aio 1 i 23.5 411942 314114 95141 0 301582 1.4 0
pio 0 i 0.0 756 0 756 0 18287 0.0 0
lio 0 i 0.5 8802 0 8802 0 26312 0.3 0
Can someone help, please ?
Thanks
You can only get KAIO working in 9.40 if your chunks are RAW (character)
devices. In 11.10 and later you can also use KAIO for filesystem chunks
with DIRECT_IO and CONCURRENT_IO enabled, but 9.40 did not support that.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Mar 16, 2011 at 5:57 AM, GILLES TCHAPPI <ntgilfr@voila.fr> wrote:
> Hi,
>
> I'm running an informix 94FC09 engine on an AIX box using KAIO. I launched
> the
> engine after setting the following OS parameters KAIOOFF=0 and
> IFMX_AIOKAIO_NUM_REQ=12288, knowing NUMAIOVPS is set to 2, and the OS AIOs
> configuration is Min number server=10, Max number server = 20 and Max
> number
> of requests = 20480
>
> When I run 'onstat -g iov' (see result below), I found no kaio vp. So my
> question is : how can I know (see) that KAIO is being used by the informix
> engine ? :
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 04:52:19 --> 6812848 Kbytes
>
> AIO I/O vps:
> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
> msc 0 i 3.8 66391 0 0 0 83845 0.8 0
> aio 0 i 84.6 1484145 1363824 107520 0 1369833 1.1 0
> aio 1 i 23.5 411942 314114 95141 0 301582 1.4 0
> pio 0 i 0.0 756 0 756 0 18287 0.0 0
> lio 0 i 0.5 8802 0 8802 0 26312 0.3 0
>
> Can someone help, please ?
>
> Thanks
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--20cf307abcbd95d035049e972349
On 16 March 2011 10:38, Art Kagel <art.kagel@gmail.com> wrote:
> You can only get KAIO working in 9.40 if your chunks are RAW (character)
> devices. In 11.10 and later you can also use KAIO for filesystem chunks
> with DIRECT_IO and CONCURRENT_IO enabled, but 9.40 did not support that.
>
> Art
>
> Art S. Kagel
> Advanced DataTools (www.advancedatatools.com)
> Blog: http://informix-myview.blogspot.com/
>
> Disclaimer: Please keep in mind that my own opinions are my own opinions and
> do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
> organization with which I am associated either explicitly, implicitly, or by
> inference. Neither do those opinions reflect those of other individuals
> affiliated with any entity with which I am affiliated nor those of the
> entities themselves.
>
> On Wed, Mar 16, 2011 at 5:57 AM, GILLES TCHAPPI <ntgilfr@voila.fr> wrote:
>
>> Hi,
>>
>> I'm running an informix 94FC09 engine on an AIX box using KAIO. I launched
>> the
>> engine after setting the following OS parameters KAIOOFF=0 and
>> IFMX_AIOKAIO_NUM_REQ=12288, knowing NUMAIOVPS is set to 2, and the OS AIOs
>> configuration is Min number server=10, Max number server = 20 and Max
>> number
>> of requests = 20480
>>
>> When I run 'onstat -g iov' (see result below), I found no kaio vp. So my
>> question is : how can I know (see) that KAIO is being used by the informix
>> engine ? :
>>
>> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 04:52:19 -->> 6812848 Kbytes
>>
>> AIO I/O vps:
>> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
>> msc 0 i 3.8 66391 0 0 0 83845 0.8 0
>> aio 0 i 84.6 1484145 1363824 107520 0 1369833 1.1 0
>> aio 1 i 23.5 411942 314114 95141 0 301582 1.4 0
>> pio 0 i 0.0 756 0 756 0 18287 0.0 0
>> lio 0 i 0.5 8802 0 8802 0 26312 0.3 0
>>
>> Can someone help, please ?
>>
>> Thanks
>>
>>
>>
>>
According to your iov output you are not using kaio, you should see some lines
beginning kio with stats and your aio stats should be nil except one
which should
be very low.
Is KAIO enabled for the OS ? See the machine release notes for instructions on
turning it on and then restart the engine. If it is not correctly
configured you will see
messages in the on-line log.
As mentioned you need RAW chunks, also remenber to keep 3/4 aio VPs as you
will need them for writing message log, console log, af and shmem files.
keith
KAIO is not a VP but a thread running on the CPU VP.
You can see the KAIO threads using onstat -g ath
onstat -g glo shows the list of all of the VPs running in your instance.
onstat -g iov does not show the actual VPs; only the thread names running on
VPs performing IO (kio, aio, lio, pio, ...)
KAIO can be used if activated on RAW devices ONLY prior to IDS V11.10
Starting V11.10, you can have KAIO on files if DIRECT_IO is activated.
IFMX_AIOKAIO_NUM_REQ will allow you to handle the number of requests, to the
KAIO threads, available. Sometimes this value is not enough for your load and
this will show in your online.log file as "KAIO: out of ressources..."
Khaled Bentebal
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr
Le 16/03/11 10:57, GILLES TCHAPPI a écrit :
> Hi,
>
> I'm running an informix 94FC09 engine on an AIX box using KAIO. I launched
the
> engine after setting the following OS parameters KAIOOFF=0 and
> IFMX_AIOKAIO_NUM_REQ=12288, knowing NUMAIOVPS is set to 2, and the OS AIOs
> configuration is Min number server=10, Max number server = 20 and Max number
> of requests = 20480
>
> When I run 'onstat -g iov' (see result below), I found no kaio vp. So my
> question is : how can I know (see) that KAIO is being used by the informix
> engine ? :
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 04:52:19 --> 6812848 Kbytes
>
> AIO I/O vps:
> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
> msc 0 i 3.8 66391 0 0 0 83845 0.8 0
> aio 0 i 84.6 1484145 1363824 107520 0 1369833 1.1 0
> aio 1 i 23.5 411942 314114 95141 0 301582 1.4 0
> pio 0 i 0.0 756 0 756 0 18287 0.0 0
> lio 0 i 0.5 8802 0 8802 0 26312 0.3 0
>
> Can someone help, please ?
>
> Thanks
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Hi,
I'm running informix engine Version 9.40.FC9 on an AIX box and this what is
said in the ids_machine_notes_9.40.txt :
3. Kernel Asynchronous I/O (KAIO)
KAIO is enabled by default on this platform. The AIO driver must be
configured into the AIX system for KAIO to work. Instructions are
provided in the "System Requirements" section above. If AIO is not
configured, the IBM Informix Dynamic Server will report the following
error while coming up:
0509-037 System error: error data is: oninit
0509-023 Symbol kaio_rdwr in /usr/lib/libc.a is not defined.
0509-023 Symbol listio in /usr/lib/libc.a is not defined.
0509-023 Symbol acancel in /usr/lib/libc.a is not defined.
0509-023 Symbol iosuspend in /usr/lib/libc.a is not defined.
0509-022 Cannot load library libc.a[aio.o].
0509-026 System error: Cannot run a file that does not have a valid
format
To disable KAIO, set the environment variable KAIOOFF.
KAIOOFF=1 ; export KAIOOFF ( for Bourne or Korn shell )
setenv KAIOOFF 1 ( for C shell )
The aio is ON in this server (see below) :
informix@pcam02:pcampcam_tcp:/produits/informix/940FC9/release/en_us/0333>
lsdev | grep aio
aio0 Available Asynchronous I/O (Legacy)
posix_aio0 Defined Posix Asynchronous I/O
I set up the env variables related to KAIO like this:
export KAIOOFF=0
export IFMX_AIOKAIO_NUM_REQ=12288
Then I launch my engine and had no error in the online.log (see below)
05:55:20 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
05:55:20 Physical Recovery Started at Page (3:46215).
05:55:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
05:55:20 Logical Recovery Started.
05:55:20 10 recovery worker threads will be started.
05:55:23 Logical Recovery has reached the transaction cleanup phase.
05:55:23 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
05:55:24 Onconfig parameter SHMVIRT_ALLOCSEG modified from 12884901888 to 3.
05:55:24 Dataskip is now OFF for all dbspaces
05:55:24 Checkpoint Completed: duration was 0 seconds.
05:55:24 Checkpoint loguniq 7393, logpos 0xd0018, timestamp: 0x8d49bc56
05:55:24 Maximum server connections 0
05:55:24 On-Line Mode
05:55:53 Checkpoint Completed: duration was 0 seconds.
05:55:53 Checkpoint loguniq 7393, logpos 0x125018, timestamp: 0x8d49d3b3
The chunks are all raw devices and the onstat -g iov shows no kaio
According to your explanation, I should have kaio listed in the result of
'onstat -g iov' but I don't
What I'm done wrong ?
Regards
Hi there!
Check if this article can help you:
https://www-304.ibm.com/support/docview.wss?uid=swg21202395
Regards,
Alberto Pessonio |DBA Informix Senior
IBM Certified Informix System Administrator V7
IBM Certified Informix Managing and Optimizing Databases V7
IBM Certified Informix Dynamic Server Technical Mastery Test v11
Tel. +55 11 4932 5154 | +55 11 7897 1458
www.orizonbrasil.com.br
-----Mensagem original-----
De: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] Em nome de GILLES
TCHAPPI
Enviada em: quarta-feira, 16 de março de 2011 08:45
Para: ids@iiug.org
Assunto: Re: Is KAIO in use [23100]
Hi,
I'm running informix engine Version 9.40.FC9 on an AIX box and this what is
said in the ids_machine_notes_9.40.txt :
3. Kernel Asynchronous I/O (KAIO)
KAIO is enabled by default on this platform. The AIO driver must be
configured into the AIX system for KAIO to work. Instructions are
provided in the "System Requirements" section above. If AIO is not
configured, the IBM Informix Dynamic Server will report the following
error while coming up:
0509-037 System error: error data is: oninit
0509-023 Symbol kaio_rdwr in /usr/lib/libc.a is not defined.
0509-023 Symbol listio in /usr/lib/libc.a is not defined.
0509-023 Symbol acancel in /usr/lib/libc.a is not defined.
0509-023 Symbol iosuspend in /usr/lib/libc.a is not defined.
0509-022 Cannot load library libc.a[aio.o].
0509-026 System error: Cannot run a file that does not have a valid
format
To disable KAIO, set the environment variable KAIOOFF.
KAIOOFF=1 ; export KAIOOFF ( for Bourne or Korn shell )
setenv KAIOOFF 1 ( for C shell )
The aio is ON in this server (see below) :
informix@pcam02:pcampcam_tcp:/produits/informix/940FC9/release/en_us/0333>
lsdev | grep aio
aio0 Available Asynchronous I/O (Legacy)
posix_aio0 Defined Posix Asynchronous I/O
I set up the env variables related to KAIO like this:
export KAIOOFF=0
export IFMX_AIOKAIO_NUM_REQ=12288
Then I launch my engine and had no error in the online.log (see below)
05:55:20 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
05:55:20 Physical Recovery Started at Page (3:46215).
05:55:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
05:55:20 Logical Recovery Started.
05:55:20 10 recovery worker threads will be started.
05:55:23 Logical Recovery has reached the transaction cleanup phase.
05:55:23 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
05:55:24 Onconfig parameter SHMVIRT_ALLOCSEG modified from 12884901888 to 3.
05:55:24 Dataskip is now OFF for all dbspaces
05:55:24 Checkpoint Completed: duration was 0 seconds.
05:55:24 Checkpoint loguniq 7393, logpos 0xd0018, timestamp: 0x8d49bc56
05:55:24 Maximum server connections 0
05:55:24 On-Line Mode
05:55:53 Checkpoint Completed: duration was 0 seconds.
05:55:53 Checkpoint loguniq 7393, logpos 0x125018, timestamp: 0x8d49d3b3
The chunks are all raw devices and the onstat -g iov shows no kaio
According to your explanation, I should have kaio listed in the result of
'onstat -g iov' but I don't
What I'm done wrong ?
Regards
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
On 16 March 2011 11:44, GILLES TCHAPPI <ntgilfr@voila.fr> wrote:
> Hi,
>
> I'm running informix engine Version 9.40.FC9 on an AIX box and this what is
> said in the ids_machine_notes_9.40.txt :
>
> 3. Kernel Asynchronous I/O (KAIO)
>
> KAIO is enabled by default on this platform. The AIO driver must be
>
> configured into the AIX system for KAIO to work. Instructions are
>
> provided in the "System Requirements" section above. If AIO is not
>
> configured, the IBM Informix Dynamic Server will report the following
>
> error while coming up:
>
> 0509-037 System error: error data is: oninit
>
> 0509-023 Symbol kaio_rdwr in /usr/lib/libc.a is not defined.
>
> 0509-023 Symbol listio in /usr/lib/libc.a is not defined.
>
> 0509-023 Symbol acancel in /usr/lib/libc.a is not defined.
>
> 0509-023 Symbol iosuspend in /usr/lib/libc.a is not defined.
>
> 0509-022 Cannot load library libc.a[aio.o].
>
> 0509-026 System error: Cannot run a file that does not have a valid
>
> format
>
> To disable KAIO, set the environment variable KAIOOFF.
>
> KAIOOFF=1 ; export KAIOOFF ( for Bourne or Korn shell )
>
> setenv KAIOOFF 1 ( for C shell )
>
> The aio is ON in this server (see below) :
> informix@pcam02:pcampcam_tcp:/produits/informix/940FC9/release/en_us/0333>
> lsdev | grep aio
> aio0 Available Asynchronous I/O (Legacy)
> posix_aio0 Defined Posix Asynchronous I/O
>
> I set up the env variables related to KAIO like this:
>
> export KAIOOFF=0
> export IFMX_AIOKAIO_NUM_REQ=12288
>
> Then I launch my engine and had no error in the online.log (see below)
>
> 05:55:20 IBM Informix Dynamic Server Initialized -- Shared Memory
Initialized.
>
> 05:55:20 Physical Recovery Started at Page (3:46215).
> 05:55:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
> 05:55:20 Logical Recovery Started.
> 05:55:20 10 recovery worker threads will be started.
> 05:55:23 Logical Recovery has reached the transaction cleanup phase.
> 05:55:23 Logical Recovery Complete.
>
> 0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
>
> 05:55:24 Onconfig parameter SHMVIRT_ALLOCSEG modified from 12884901888 to 3.
> 05:55:24 Dataskip is now OFF for all dbspaces
> 05:55:24 Checkpoint Completed: duration was 0 seconds.
> 05:55:24 Checkpoint loguniq 7393, logpos 0xd0018, timestamp: 0x8d49bc56
>
> 05:55:24 Maximum server connections 0
> 05:55:24 On-Line Mode
> 05:55:53 Checkpoint Completed: duration was 0 seconds.
> 05:55:53 Checkpoint loguniq 7393, logpos 0x125018, timestamp: 0x8d49d3b3
>
> The chunks are all raw devices and the onstat -g iov shows no kaio
>
> According to your explanation, I should have kaio listed in the result of
> 'onstat -g iov' but I don't
>
> What I'm done wrong ?
>
> Regards
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
Gilles
I havn't got either of these variable exported when I start the engine, suggest
you start a clean session and try to strat the engine without either. If KAIO
is
running then try again with just :
export IFMX_AIOKAIO_NUM_REQ=12288
it may be the engine is just looking for the variable KAIOOFF to be present
regardless of its actual value.
Keith
I'm running informix engine Version 9.40.FC9 on an AIX box and this what is
said in the ids_machine_notes_9.40.txt :
3. Kernel Asynchronous I/O (KAIO)
KAIO is enabled by default on this platform. The AIO driver must be
configured into the AIX system for KAIO to work. Instructions are
provided in the "System Requirements" section above. If AIO is not
configured, the IBM Informix Dynamic Server will report the following
error while coming up:
0509-037 System error: error data is: oninit
0509-023 Symbol kaio_rdwr in /usr/lib/libc.a is not defined.
0509-023 Symbol listio in /usr/lib/libc.a is not defined.
0509-023 Symbol acancel in /usr/lib/libc.a is not defined.
0509-023 Symbol iosuspend in /usr/lib/libc.a is not defined.
0509-022 Cannot load library libc.a[aio.o].
0509-026 System error: Cannot run a file that does not have a valid
format
To disable KAIO, set the environment variable KAIOOFF.
KAIOOFF=1 ; export KAIOOFF ( for Bourne or Korn shell )
setenv KAIOOFF 1 ( for C shell )
The aio is ON in this server (see below) :
informix@pcam02:pcampcam_tcp:/produits/informix/940FC9/release/en_us/0333>
lsdev | grep aio
aio0 Available Asynchronous I/O (Legacy)
posix_aio0 Defined Posix Asynchronous I/O
I set up the env variables related to KAIO like this:
export KAIOOFF=0
export IFMX_AIOKAIO_NUM_REQ=8192
Then I launch my engine and had no error in the online.log (see below)
05:55:20 IBM Informix Dynamic Server Initialized -- Shared Memory Initialized.
05:55:20 Physical Recovery Started at Page (3:46215).
05:55:20 Physical Recovery Complete: 0 Pages Examined, 0 Pages Restored.
05:55:20 Logical Recovery Started.
05:55:20 10 recovery worker threads will be started.
05:55:23 Logical Recovery has reached the transaction cleanup phase.
05:55:23 Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks
05:55:24 Onconfig parameter SHMVIRT_ALLOCSEG modified from 12884901888 to 3.
05:55:24 Dataskip is now OFF for all dbspaces
05:55:24 Checkpoint Completed: duration was 0 seconds.
05:55:24 Checkpoint loguniq 7393, logpos 0xd0018, timestamp: 0x8d49bc56
05:55:24 Maximum server connections 0
05:55:24 On-Line Mode
05:55:53 Checkpoint Completed: duration was 0 seconds.
05:55:53 Checkpoint loguniq 7393, logpos 0x125018, timestamp: 0x8d49d3b3
The chunks are all raw devices and the 'onstat -g ath grep | aio' shows no kaio
informix@pcam02:pcampcam_tcp:/bases/informix/pcampcam/var/bdump> onstat -g ath
| grep aio
4 70000015dca81f8 0 2 sleeping secs: 1 9aio aio vp 0
6 70000015dd001f8 0 2 sleeping secs: 1 11aio aio vp 1
What have I done wrong ?
Regards
Hi,
I red the article and found that what I should have set as OS parameter is
KAIOON=1 (instead of setting KAIOOF to 1). So I changed my conf and tested
once again.
With KAOIOFF=1 I have this
informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
KAIOOFF=0
IFMX_AIOKAIO_NUM_REQ=12288
informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value specifies
in onconfig is 0x700000010000000 or above. Otherwise you will have problems
while attaching or dynamically adding virtual shared memory segments. Please
refer to Server machine notes for more information.
informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:15 --1232896 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
msc 0 i 0.6 10 0 0 0 23 0.4 0
aio 0 i 10.2 163 82 14 0 172 0.9 0
aio 1 i 0.3 5 1 3 0 12 0.4 0
aio 2 i 0.2 4 1 3 0 13 0.3 0
pio 0 i 0.0 0 0 0 0 15 0.0 0
lio 0 i 0.1 1 0 1 0 17 0.1 0
With KAIOON=1 I got this :
informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
IFMX_AIOKAIO_NUM_REQ=12288
KAIOON=1
informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value specifies
in onconfig is 0x700000010000000 or above. Otherwise you will have problems
while attaching or dynamically adding virtual shared memory segments. Please
refer to Server machine notes for more information.
informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:22 --1232896 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 i 2.4 52 49 3 0 120 0.4 0
kio 1 i 1.4 30 19 11 0 58 0.5 0
msc 0 i 0.5 10 0 0 0 29 0.3 0
aio 0 i 4.0 87 16 4 0 105 0.8 0
aio 1 i 0.0 1 0 0 0 17 0.1 0
aio 2 i 0.0 0 0 0 0 18 0.0 0
pio 0 i 0.0 0 0 0 0 21 0.0 0
lio 0 i 0.0 0 0 0 0 22 0.0 0
And in case 2 I have two more class/vp named kio.
I guess these is because KAIO in use. If so, thanks a lot for four answer.
Bests regards
Hi,
I changed my OS conf (using parameter KAIOON=1 instead of setting KAIOOF to 1)
and tested once again.
With KAOIOFF=1 I have this :
informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
KAIOOFF=0
IFMX_AIOKAIO_NUM_REQ=12288
informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value specifies
in onconfig is 0x700000010000000 or above. Otherwise you will have problems
while attaching or dynamically adding virtual shared memory segments. Please
refer to Server machine notes for more information.
informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:15 --1232896 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
msc 0 i 0.6 10 0 0 0 23 0.4 0
aio 0 i 10.2 163 82 14 0 172 0.9 0
aio 1 i 0.3 5 1 3 0 12 0.4 0
aio 2 i 0.2 4 1 3 0 13 0.3 0
pio 0 i 0.0 0 0 0 0 15 0.0 0
lio 0 i 0.1 1 0 1 0 17 0.1 0
With KAIOON=1 I got this :
informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
IFMX_AIOKAIO_NUM_REQ=12288
KAIOON=1
informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value specifies
in onconfig is 0x700000010000000 or above. Otherwise you will have problems
while attaching or dynamically adding virtual shared memory segments. Please
refer to Server machine notes for more information.
informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:22 --1232896 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 i 2.4 52 49 3 0 120 0.4 0
kio 1 i 1.4 30 19 11 0 58 0.5 0
msc 0 i 0.5 10 0 0 0 29 0.3 0
aio 0 i 4.0 87 16 4 0 105 0.8 0
aio 1 i 0.0 1 0 0 0 17 0.1 0
aio 2 i 0.0 0 0 0 0 18 0.0 0
pio 0 i 0.0 0 0 0 0 21 0.0 0
lio 0 i 0.0 0 0 0 0 22 0.0 0
And in the second test, I have two more class/vp named kio.
I guess these is because KAIO in use.
Bests regards
You don't need either environment variable, actually, KAIO is on by default
on all platforms except HPUX (the only place where you NEED to set KAIOON)
and you would only set KAIOOFF at all if you want to turn it off.
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Wed, Mar 16, 2011 at 10:24 AM, GILLES TCHAPPI <ntgilfr@voila.fr> wrote:
> Hi,
>
> I red the article and found that what I should have set as OS parameter is
> KAIOON=1 (instead of setting KAIOOF to 1). So I changed my conf and tested
> once again.
>
> With KAOIOFF=1 I have this
>
> informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
> KAIOOFF=0
> IFMX_AIOKAIO_NUM_REQ=12288
>
> informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
> WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
> with this Server instance, please make sure that your SHMBASE value
> specifies
> in onconfig is 0x700000010000000 or above. Otherwise you will have problems
> while attaching or dynamically adding virtual shared memory segments.
> Please
> refer to Server machine notes for more information.
> informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:15 --> 1232896 Kbytes
>
> AIO I/O vps:
> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
> msc 0 i 0.6 10 0 0 0 23 0.4 0
> aio 0 i 10.2 163 82 14 0 172 0.9 0
> aio 1 i 0.3 5 1 3 0 12 0.4 0
> aio 2 i 0.2 4 1 3 0 13 0.3 0
> pio 0 i 0.0 0 0 0 0 15 0.0 0
> lio 0 i 0.1 1 0 1 0 17 0.1 0
>
> With KAIOON=1 I got this :
>
> informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
> IFMX_AIOKAIO_NUM_REQ=12288
> KAIOON=1
>
> informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
> WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
> with this Server instance, please make sure that your SHMBASE value
> specifies
> in onconfig is 0x700000010000000 or above. Otherwise you will have problems
> while attaching or dynamically adding virtual shared memory segments.
> Please
> refer to Server machine notes for more information.
> informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
>
> IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:22 --> 1232896 Kbytes
>
> AIO I/O vps:
> class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
> kio 0 i 2.4 52 49 3 0 120 0.4 0
> kio 1 i 1.4 30 19 11 0 58 0.5 0
> msc 0 i 0.5 10 0 0 0 29 0.3 0
> aio 0 i 4.0 87 16 4 0 105 0.8 0
> aio 1 i 0.0 1 0 0 0 17 0.1 0
> aio 2 i 0.0 0 0 0 0 18 0.0 0
> pio 0 i 0.0 0 0 0 0 21 0.0 0
> lio 0 i 0.0 0 0 0 0 22 0.0 0
>
> And in case 2 I have two more class/vp named kio.
>
> I guess these is because KAIO in use. If so, thanks a lot for four answer.
>
> Bests regards
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--bcaec5015d3110088d049e9a6abf
Hi,
You're right. I did a third test with no KAIOON parameter and I got this :
informix@pthd02:pthdpthd_tcp:/produits/informix> env | grep KAIO
IFMX_AIOKAIO_NUM_REQ=12288
informix@pthd02:pthdpthd_tcp:/produits/informix> oninit
WARNING : If you intend to use J/Foundation or GLS for Unicode feature(GLU)
with this Server instance, please make sure that your SHMBASE value specifies
in onconfig is 0x700000010000000 or above. Otherwise you will have problems
while attaching or dynamically adding virtual shared memory segments. Please
refer to Server machine notes for more information.
informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -g iov
IBM Informix Dynamic Server Version 9.40.FC9 -- On-Line -- Up 00:00:23 --1232896 Kbytes
AIO I/O vps:
class/vp s io/s totalops dskread dskwrite dskcopy wakeups io/wup errors
kio 0 i 1.9 44 44 0 0 106 0.4 0
kio 1 i 0.6 14 5 9 0 23 0.6 0
kio 2 i 1.0 24 19 5 0 48 0.5 0
msc 0 i 0.4 10 0 0 0 31 0.3 0
aio 0 i 3.8 87 16 4 0 107 0.8 0
aio 1 i 0.0 1 0 0 0 19 0.1 0
aio 2 i 0.0 0 0 0 0 20 0.0 0
pio 0 i 0.0 0 0 0 0 23 0.0 0
lio 0 i 0.0 0 0 0 0 24 0.0 0
informix@pthd02:pthdpthd_tcp:/produits/informix> onstat -c | grep NUMAI
NUMAIOVPS 3 # Number of IO vps
Thanks a lot,
Best regards
Related threads
- Posting from the Informix-list
- Migrating from IDS 9.40.UC6 to 11.50.UC3
- Ip for a network session
- questions onstat -g