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

Informix vNext slides from IIUG/Scott/Karen/Shripad

  • 1.  Informix vNext slides from IIUG/Scott/Karen/Shripad

    Posted Sun July 23, 2023 02:31 AM

    Hi,

    Interesting IIUG talk from Scott/Karen/Shripad abhout vNext New Features

    https://www.iiug.org/wp-content/uploads/2023/04/Informix-VNext-New-Features.pdf

    "Performance better or equal than prior release: 14.10.xC1

    Investigating new compiler impacts, better scaling on Linux, improvement of storage performance, …"

    I know Version 14 started using later compiler versions -

    https://www.ibm.com/docs/en/informix-servers/12.10?topic=notes-linux-x86-64

     "This product was built on Red Hat Enterprise Linux ES release 5.3"

    https://www.ibm.com/docs/en/informix-servers/14.10?topic=notes-linux-x86-64

     ""This product was built on Red Hat Enterprise Linux ES release 7.4""

    I assume this is later compiler versions/more of using new compiler features as vNext does not support RHEL 7 but RHEL 8?

    But what is "better scaling on Linux"/"improvement of storage performance"?

    Does that include 

    https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-440

    "Evaluate using io_uring for I/O in Informix Linux Platform "

    As per https://gavinray97.github.io/blog/io-uring-fixed-bufferpool-zig

    io_uring has a fixed buffer mode where you pre-allocate and register a pool of buffers to use for I/O operations.

    Can this be looked at as part of io_uring?: Not sure if registering the whole of all bufferpool would be viable!

    Also storage performance could include:

    https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-525

    "Support KAIO in cooked files using 4k formated disk for dbspaces with page size multiple of 4 "

    ??

    Regards,
    David.



    ------------------------------
    David Williams
    ------------------------------