direct i/o for cooked files in innovator-c edition

I have recently installed a fresh instance of IDS 11.50FC7IE Innovator-Community Edition on Centos 5.5. The variable DIRECT_IO has value 1 in onconfig.xxx Output from onstat -d is ------------------------------------------------------------------------------ IBM Informix Dynamic Server Version 11.50.FC7IE -- On-Line -- Up 05:45:45 --2080288 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags owner name a39d8028 1 0x70001 1 1 2048 N B informix rootdbs a50840c8 2 0x70001 2 1 2048 N B informix physdbs a5084a80 3 0x60001 3 1 2048 N B informix logdbs a5286490 4 0x42001 4 1 2048 N TB informix tempdbs a5493e00 5 0x60001 5 1 2048 N B informix userdbs a516ddd0 6 0x60011 6 1 2048 N BB informix blobdbs 6 active, 2047 maximum Note: For BLOB chunks, the number of free pages shown is out of date. Run 'onstat -d update' for current stats. Chunks address chunk/dbs offset size free bpages flags pathname a39d81c0 1 1 0 100000 93769 PO-BD ./rootdbs.chk1 a5084260 2 2 0 102400 0 PO-BD ./physdbs.chk1 a5084c18 3 3 0 1048576 536688 PO-BD ./logdbs.chk1 a5286628 4 4 0 2097152 2097124 PO-B- ./tempdbs.chk1 a516d520 5 5 0 26214400 26214372 PO-BD ./userdbs.chk1 a5157d60 6 6 0 5242880 ~5242880 5242880 POBBD ./blobdbs.chk1 6 active, 32766 maximum NOTE: The values in the "size" and "free" columns for DBspace chunks are displayed in terms of "pgsize" of the DBspace to which they belong. Expanded chunk capacity mode: always ------------------------------------------------------------------------------ The chunks for the cooked files show a 'D' for direct i/o enabled. Is this feature really enabled for the innovator community edition? ciao Jörg

DIRECT_IO is not supported, see for example http://www.informix-zone.com/aggregator/sources/32. For me it's unclear if this means is not licensed and that you are not allowed to use it or if this feature is not available. For PDQ I can say, that I got a message on engine start up: 23:18:28 Warning: PDQ functionality is not supported in IDS Innovator-C Edition. The value of PDQPRIORITY cannot be set to 50. It is reset to 0. I would expect the same for DIRECT_IO. On 16.06.10 13:49, JöRG SEIDER wrote: > I have recently installed a fresh instance of > IDS 11.50FC7IE Innovator-Community Edition on Centos 5.5. > > The variable DIRECT_IO has value 1 in onconfig.xxx > > Output from onstat -d is > ------------------------------------------------------------------------------ > IBM Informix Dynamic Server Version 11.50.FC7IE -- On-Line -- Up 05:45:45 --> 2080288 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > a39d8028 1 0x70001 1 1 2048 N B informix rootdbs > a50840c8 2 0x70001 2 1 2048 N B informix physdbs > a5084a80 3 0x60001 3 1 2048 N B informix logdbs > a5286490 4 0x42001 4 1 2048 N TB informix tempdbs > a5493e00 5 0x60001 5 1 2048 N B informix userdbs > a516ddd0 6 0x60011 6 1 2048 N BB informix blobdbs > 6 active, 2047 maximum > > Note: For BLOB chunks, the number of free pages shown is out of date. > > Run 'onstat -d update' for current stats. > > Chunks > address chunk/dbs offset size free bpages flags pathname > a39d81c0 1 1 0 100000 93769 PO-BD ./rootdbs.chk1 > a5084260 2 2 0 102400 0 PO-BD ./physdbs.chk1 > a5084c18 3 3 0 1048576 536688 PO-BD ./logdbs.chk1 > a5286628 4 4 0 2097152 2097124 PO-B- ./tempdbs.chk1 > a516d520 5 5 0 26214400 26214372 PO-BD ./userdbs.chk1 > a5157d60 6 6 0 5242880 ~5242880 5242880 POBBD ./blobdbs.chk1 > 6 active, 32766 maximum > > NOTE: The values in the "size" and "free" columns for DBspace chunks are > > displayed in terms of "pgsize" of the DBspace to which they belong. > > Expanded chunk capacity mode: always > ------------------------------------------------------------------------------ > > The chunks for the cooked files show a 'D' for direct i/o enabled. > Is this feature really enabled for the innovator community edition? > > ciao > Jörg > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > >

AFAIK DirectIO is available in all IDS versions. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) 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, Jun 16, 2010 at 7:49 AM, JöRG SEIDER <joerg.se@gmx.de> wrote: > I have recently installed a fresh instance of > IDS 11.50FC7IE Innovator-Community Edition on Centos 5.5. > > The variable DIRECT_IO has value 1 in onconfig.xxx > > Output from onstat -d is > > ------------------------------------------------------------------------------ > IBM Informix Dynamic Server Version 11.50.FC7IE -- On-Line -- Up 05:45:45 > --> 2080288 Kbytes > > Dbspaces > address number flags fchunk nchunks pgsize flags owner name > a39d8028 1 0x70001 1 1 2048 N B informix rootdbs > a50840c8 2 0x70001 2 1 2048 N B informix physdbs > a5084a80 3 0x60001 3 1 2048 N B informix logdbs > a5286490 4 0x42001 4 1 2048 N TB informix tempdbs > a5493e00 5 0x60001 5 1 2048 N B informix userdbs > a516ddd0 6 0x60011 6 1 2048 N BB informix blobdbs > 6 active, 2047 maximum > > Note: For BLOB chunks, the number of free pages shown is out of date. > > Run 'onstat -d update' for current stats. > > Chunks > address chunk/dbs offset size free bpages flags pathname > a39d81c0 1 1 0 100000 93769 PO-BD ./rootdbs.chk1 > a5084260 2 2 0 102400 0 PO-BD ./physdbs.chk1 > a5084c18 3 3 0 1048576 536688 PO-BD ./logdbs.chk1 > a5286628 4 4 0 2097152 2097124 PO-B- ./tempdbs.chk1 > a516d520 5 5 0 26214400 26214372 PO-BD ./userdbs.chk1 > a5157d60 6 6 0 5242880 ~5242880 5242880 POBBD ./blobdbs.chk1 > 6 active, 32766 maximum > > NOTE: The values in the "size" and "free" columns for DBspace chunks are > > displayed in terms of "pgsize" of the DBspace to which they belong. > > Expanded chunk capacity mode: always > > ------------------------------------------------------------------------------ > > The chunks for the cooked files show a 'D' for direct i/o enabled. > Is this feature really enabled for the innovator community edition? > > ciao > Jörg > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e6d58a97e1f3b40489255a7a