Expanded support for not-logged table spaces

In Db2 11, you can specify the logging attributes LOGGED or NOT LOGGED when you define declared global temporary tables. The NOT LOGGED option suspends logging during insert, update, and delete activity for the table.

Because the existing logging facilities in Db2 are finely tuned, suspending logging does not necessarily improve the performance of your system. However, the ability to suspend logging improves scalability, particularly for operations that insert large volumes of data.