Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Petty comments on Version 15 ...

    Posted 5 hours ago

    Hi ... just because ...

    1. 

    Warning: Parameter duplicated in config file (/products/15.01.FC1/etc/onconfig_leap16_j_a).
    Only the first occurrence will be used. (USERMAPPING)

    > grep USERMAPPING onconfig.std
    # USERMAPPING - Control access to the server for users without operating
    USERMAPPING OFF
    # USERMAPPING - Control access to the server for users without operating
    USERMAPPING OFF

    2. Initialising with DIRECT_IO set to 1 and the following is reported 

    14:29:04  IBM Informix Dynamic Server Version 15.0.1.0DE
    14:29:04  Performance Advisory: Currently IBM Informix Dynamic Server cannot
              support KAIO on the device containing
              '/instances/leap16_j_a/chunks/rootdbs'
              Its Sector Size (4096) and the page size (2048) are incompatible.
    14:29:04   Results: Direct and concurrent I/O are disabled for this chunk.
    14:29:04   Action: Standard AIO (possibly buffered) will be used for I/O
               to this chunk.

    However, after just a restart of informix and no other change, kernel aio is all good

    > onstat -g ioq

    IBM Informix Dynamic Server Version 15.0.1.0DE -- On-Line -- Up 00:14:10 -- 563264 Kbytes
    2026-04-08 14:44:00 -- Infrastructure Version: 1 

    AIO I/O queues:
    q name/id    len maxlen totalops  dskread dskwrite  dskcopy
     fifo   0      0      0        0        0        0        0 
    drda_dbg   0      0      0        0        0        0        0 
    sqli_dbg   0      0      0        0        0        0        0 
      kio   0      0     32     4538     1667     2871        0 
      kio   1      0     32     1870      720     1150        0 
      kio   2      0     32     3191      860     2331        0 
      kio   3      0     33     1263      917      346        0 

    ...

    3. Version 15.01.0DE

    informix@leap16-1-a:/products/15.01.FC1/etc> oninit -version
    Program Name:        oninit
    Build Version:        15.0.1.0DE

    Has naming convention changed (i.e. no "FC" like ... 15.01.FC0??)?



    ------------------------------
    Jon Ritson
    ------------------------------


  • 2.  RE: Petty comments on Version 15 ...

    Posted 4 hours ago

    Hi JJ,

    not seeing your 1., in none of my 6 or so v15 installations.

    not seeing your 2. either, after initializing (-ivy) using a 4k sector size disk for my ROOTPATH (and DIRECT_IO 1).  I do see KAIO being added (queues, threads) once defining more chunks on other disks.

    And yes to your 3. -> Fix pack naming conventions

    Cheers,
     Andreas



    ------------------------------
    Andreas Legner
    Informix Dev
    HCL Software
    ------------------------------

    Original Message


  • 3.  RE: Petty comments on Version 15 ...

    Posted 4 hours ago

    Thanks for the response Andreas ... "moving on" :)

    informix@leap16-1-a:/products/15.01.FC1/etc> oninit -version
    Program Name:        oninit
    Build Version:        15.0.1.0DE
    Build Number:        147
    Build Host:        lxv15nb1
    Build OS:        Linux kernel-4.18.0-477.10.1.el8_8.x86_64 glibc-2.28-251.el8_10.25.i686 glibc-2.28-251.el8_10.25.x86_64
    Build Date:        Tue Dec 16 06:44:25 CST 2025
    Build Timestamp:    2025-12-09T13:46:56-06:00
    Build Commit:        ea65e6c33153a1cc52f0f3286fdf7e49bacee28a
    GLS  Version:        glslib-8.0.0.2
    informix@leap16-1-a:/products/15.01.FC1/etc> oninit -V
    IBM Informix Dynamic Server Version 15.0.1.0DE
     Tue Dec 16 06:44:25 CST 2025



    ------------------------------
    Jon Ritson
    ------------------------------

    Original Message


Related Content