Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: log file full need help

    We keep getting
    DIA3609C Log file was full.

    DB2 UDB 7.2 32 bit on AIX 5.2 32 bit

    our database backup hangs and users cannot access database

  2. #2
    Join Date
    Mar 2003
    Posts
    343
    Are there any messages in the diag? Is it an online backup? Is it possible that somewhere along the way the archiving process stopped working - maybe the disk is full? Or that there's a transaction which spans all primaries and secondaries and cannot complete? If the database is across multiple nodes then ensure that you're looking on all nodes. There has to be a transaction out there which isn't committing. When the backup fails does it cite the log full condition as the reason?

  3. #3
    Join Date
    May 2003
    Posts
    369

    thanx logfile parameters

    I ran an offline backup to get the tablespaces back to normal and increased the log parameters, logfilesiz, logprimary and logsecondary to accomodate the transaction processing.

  4. #4
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Please also see the following link.

    http://www.dbforums.com/t926118.html

    Hope this helps,
    Grofaty

Posting Permissions

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