DB2 for LUW has been running multi-threaded on Windows since its
inception on that platform (DB2 V2 in 1993 I believe).
Given that the "process-model" is encapsulated we can flip between
threaded and multi-process "at will" (meaning at a moderate cost).
No customer ever asks for infrastructure features. That's why they are
infrastructure. I doubt Informix introduced threading due to customer
W.r.t getting users of IDS onto DB2
I stood up at the IIUG meeting in Anaheim and I will do it again here:
There is no such thing as a project to make DB2 and IDS the same.
All DB2 for LUW SQL features current and planned cross my cluttered
desk. I have no SQL item (that's where the *** hits the road for an
app after all) active under development or planned which purpose it is
to increase compatibility with IDS.
No case sensitive table names, no double quoted strings, no SERIAL
column, no ::-casting, SPL, etc, etc.... in DB2.
DB2 Solutions Development
IBM Toronto Lab