Can DB2 LUW logging be turned off completely?

Posted on 2012-09-05
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

    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 45

    Assisted Solution

    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 24

    Assisted Solution

    by:Tomas Helgi Johannsson

    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

    Thanks guys!!

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    FreeBSD on EC2 FreeBSD ( is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
    By default, Carbonite Server Backup manages your encryption key for you using Advanced Encryption Standard (AES) 128-bit encryption. If you choose to manage your private encryption key, your backups will be encrypted using AES 256-bit encryption.
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    25 Experts available now in Live!

    Get 1:1 Help Now