Results 1 to 5 of 5

Thread: Disable Logging

  1. #1
    Join Date
    May 2004
    Location
    Bordentown, NJ
    Posts
    27

    Unanswered: Disable Logging

    Is there a way to disable logging? We don't need to use it for this particular DB and we keep getting "Transaction Log Full". Any suggestions????

  2. #2
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking

    What version of DB2 are you using and on what OS?

    You can make it circular logging and you can set the configuration parameter logretain = off. You cannot make online backups after you set this. You can also specify the number of primary log and secondary log files to be used too.

    HTH
    Newbie

  3. #3
    Join Date
    May 2004
    Location
    Bordentown, NJ
    Posts
    27
    Version 8 on Windows

  4. #4
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking

    Could you also let us know, what operation you did, when you started getting the "transaction log full" error? Did you also check out the disk space / log file folder size too?

    Db2 requires logging to perform tasks. You cannot eliminate logs, but you can make it circular type. To make it circular, go to the control center, right click on the database, choose configure database logging and follow the instructions in the wizard.

    HTH.
    Newbie

  5. #5
    Join Date
    Apr 2004
    Posts
    2

    have reqular commit

    I think you are using the circular logging in your shop. To overcome the message of getting the " Transaction full" you commit regularly, it would solve the issue. If it persist try to increase the log size .

    James

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •