Learn how to a build a cloud-first strategyRegister Now


Can DB2 LUW logging be turned off completely?

Posted on 2012-09-05
Medium Priority
Last Modified: 2012-09-09
Hi Gurus,

Is it at all possible to turn off logging for DB2 ie. no archive or circular logging whatsoever? How do you turn off logging in DB2?
Is there a DBM or DB configuration parameter that can turn on/off logging?
What could be a legitimate reason for wanting to do anything like turning off DB2 logging?

This question came in a conversation about Oracle being able to turn off and I wasn't certain if Db2 can do the same.

Question by:Enyinnaya
LVL 37

Accepted Solution

momi_sabag earned 336 total points
ID: 38367443
you can turn off logging for a specific object so that you can do a massive update to it quickly but you can not turn off logging altogether
i don't think you can do that in oracle either. In oracle you can turn off logging for a single object for the same purpose, but i find it hard to believe logging can be turned off completely.
One of the reasons people are using relational database is to get consistency.
Without logging, the database can't support transactions and thus can't guarantee consistency
LVL 46

Assisted Solution

by:Kent Olsen
Kent Olsen earned 332 total points
ID: 38367669
Hi Enyinnaya,

I believe that Momi's correct.

Why in the world would you want to turn off logging on a continuing basis?  The result would be that ANY failed change (INSERT, UPDATE, DELETE, MERGE) would render the table corrupted and unusable.

LVL 26

Assisted Solution

by:Tomas Helgi Johannsson
Tomas Helgi Johannsson earned 332 total points
ID: 38380844

I totally agree with both Momi's and Kent's comments.
Having a table not logged will most certainly give you situations where the table will become corrupted and unusable and in some cases not even possible to recover except to last known good backup. Having a table or tables with NOT LOGGED attribute in a production environment is one of  the DBA's worst nightmare.

As a DBA and Data Architect I would not put data, that may not be seen/retrieved in/from logs , into a database as databases rely on logs for data consistency.

    Tomas Helgi

Author Closing Comment

ID: 38381507
Thanks guys!!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Storage devices are generally used to save the data or sometime transfer the data from one computer system to another system. However, sometimes user accidentally erased their important data from the Storage devices. Users have to know how data reco…
How to update Firmware and Bios in Dell Equalogic PS6000 Arrays and Hard Disks firmware update.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question