Undocumented feature: DIRECTIO enabled for temp dbspaces

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