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
Back to discussions
Expand all | Collapse all

Undocumented feature: DIRECTIO enabled for temp dbspaces

  • 1.  Undocumented feature: DIRECTIO enabled for temp dbspaces

    Posted Tue April 07, 2020 03:48 PM
    Apparently, temp dbspaces with cooked file chunks don't have DIRECTIO enabled from the get go. And so there is an undocumented feature that allows you to turn that feature on:
    starting with 12.10.xC13, 14.10.xC1 you can enable DIRECT_IO for temp dbspaces as well. - just not doc'd
    The value of this parameter is a set of flags, which may be combined:
    0x1 Direct I/O
    0x2 Concurrent I/O (AIX only)
    0x4 Enable special I/O for TEMP DBspaces
    So, in order to activate DIRECT_IO for temp dbspaces as well, you'll set it to 5 (0x1 & 0x4)

    Thanks to @Paul Watson for the tidbit ^_^

    R
    ​

    ------------------------------
    Ramon Rey
    Any opinions I express here are my own and not the views of my employer.
    ------------------------------

    #Informix


Related Content