February 18, 2014

Enhanced Support for Not-Logged Table Space

Back in August of 2007 I wrote about the new DB2 9 feature to suspend logging. While this was promoted as a way to reduce CPU overhead, I noted that, based on my testing, customers wouldn't save much in CPU -- though they could save on DASD storage.

Now introduced in DB2 11 is the capability to suspend logging for declared global temporary tables.  Again, this doesn't offer any meaningful CPU savings. However, you may consider using this feature to support scalability, particularly for jobs that insert large volumes of data.

Here is the new syntax:

Figure for 2-18-2014 Blog

I haven't used this feature in a real-world setting. If you're using this, I'd appreciate if it you left your thoughts in comments. What benefits are you seeing?