Results 1 to 5 of 5

Thread: Logs DB2

  1. #1
    Join Date
    Jan 2011
    Posts
    2

    Unanswered: Logs DB2

    Good Morning:

    You need to make a time-consuming in a DB2 database, which generates a lot of logs which is unnecessary, as the logs off


    Thanks

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What is your question/problem?

  3. #3
    Join Date
    Jan 2011
    Posts
    2

    Logs DB2

    Thanks

    I do not Know the command for disable the logs, until finish an activity, that generate lot logs unnecesary

    OS is . AIX

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  5. #5
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    logs records are not unnecessary. Any DBMS writes out log records for any change to the database in order to ensure recoverability and integrity. If you have a process that is writing a ton of log records and is causing your logs to fill, but they cannot be archived, because your thread is still running, that is another issue. There are a couple of ways around that issue. Have you considered LOAD? If it is a process that for some reason you feel cannot be handled with load, then issue periodic commits during your processing to free up the log files.
    Dave

Posting Permissions

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