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.  Parameters adjusted at startup

    Posted 14 hours ago

    Greetings, Y'all. (Spell-checker does not object to "Y'all".  Cute.)

    I have a newly configured toy RH Linux system at work.  When I bounced it this morning, watching the online log, the first lines were:

    Parameter's user-configured value was adjusted. (DIRECT_IO)
    Parameter's user-configured value was adjusted. (VPCLASS)
    Parameter's user-configured value was adjusted. (DS_NONPDQ_QUERY_MEM)

    It does not state what it changed from and to.  (There MUST be a feature request to fill that knowledge!)

    Here are those params from the $ONCONFIG:

    DIRECT_IO 2
    DS_NONPDQ_QUERY_MEM 51240    # Copied from prod server
    VPCLASS cpu,num=1,noage
    VPCLASS aio,num=3,noage
    VPCLASS idsxmlvp,num=1
    VPCLASS msc,num=2,noage

    So I ran a simple query on sysmaster:sysconfig to get these and see what the server has done to them:

    cf_name cf_default cf_original cf_effective
    DIRECT_IO 0 2 0
    DS_NONPDQ_QUERY_MEM 256 51240 51200
    VPCLASS             (No default) idsxmlvp,num=1  idsxmlvp,num=1 
    VPCLASS             (No default) aio,num=3,noage aio,num=3      
    VPCLASS             (No default) msc,num=2,noage msc,num=2      
    VPCLASS             cpu,num=1,noage cpu,num=1,noage cpu,num=1,noage

    • I see it has turned off DIRECT_IO. Could this be because the chunks are on block devices?  (Linux is notoriously unfriendly to character devices.)
    • I also see it has removed the noage from aio and msc VP classes

    Finally my main question:  Why did it turn of DIRECT_IO?  I mentioned block devices but is that actually the reason?

    Smaller issue: Why did it turn off noage on aio and msc VPclasses?

    Thanks for pointers here.



    ------------------------------
    +-----------------------------------------------------------+
    | I am pleased to report that I had no problems today. |
    | I had only issues, opportunities, challenges and valuable |
    | learning experiences. |
    +------------------------------------------ Jacob S --------+
    ------------------------------


  • 2.  RE: Parameters adjusted at startup

    Posted 14 hours ago

    Jacob:

    DIRECT_IO setting of "2" is ONLY for AIX to enable CONCURRENT IO which is required for KAIO service on AIX.

    Setting of '1' turns on direct io, so even on AIX the correct setting would be '3' (1 + 2 - duh).

    In recent releases of 14.10 and 15.0 you can also add the '4' flag to enable direct io for temp dbspaces.

    It was turned off because you didn't actually turn it on with '2'.

    The vpclass complaint is about the vpclass for aio vps. You cannot set noage for the aio vps, only for cpu vps (even private cpu vps are OK, but not aio vps). Note that the other vpclass settings were not modified.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Parameters adjusted at startup

    Posted 14 hours ago
    The message log should tell you about DIRECT_IO

    AFAIR noage is not applicable AIO/MISC - I think it is in the manual

    On 2/18/2026 11:50 AM, Jacob Salomon via IBM TechXchange Community wrote:
    0100019c71e03fda-4e298ce8-441c-463c-af5f-cbe1ac65b0a0-000000@email.amazonses.com">
    Greetings, Y'all. (Spell-checker does not object to "Y'all". Cute.) I have a newly configured toy RH Linux system at work. When I bounced it...