Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: How can I clear the DB2 Transaction log

    Hi folks,
    How can I empty the log.
    one more thing, following is my DB cfg, it was supposed to use 'cycle log' but why I always get 'log full' message.
    thanks a lot
    Degree of parallelism (DFT_DEGREE) = 1
    Log retain for recovery status = NO
    User exit for logging status = NO
    Log file size (4KB) (LOGFILSIZ) = 1000
    Number of primary log files (LOGPRIMARY) = 3
    Number of secondary log files (LOGSECOND) = 2
    ...

    [db]$ db2 "refresh table fact6d1pcube"
    DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0964C The transaction log for the database is full. SQLSTATE=57011

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    The circular logs can be reused after all transactions have committed. If the amount of logging in a unit of work of an SQL statement (commit scope) is too large for the log size you specified, you will get the error you received. You need to increase the number of logs (I would double them), and the size of each log (I would increase the size by a factor of 10). That would make each log file 40 MB, which is not much disk space.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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