Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014

    Unanswered: Log full condition in db2 luw

    Suppose the translog gets full SQL0968C The file system is full. SQLSTATE=57011
    and the current directory is


    then is the below solution correct

    db2diag -A /XY/XXW/new_directory name
    chmod 755 new_directory name

    Please advice

  2. #2
    Join Date
    Apr 2012
    From your message I am not 100% on your issue. Is the db2diag.log what filled your file system? If so move the current file to another location and that will free up the space. Depending on your version of db2 you can have this done automatically. If you filled your transaction log directory do not delete the logs. First check how many primary/secondary logs you can allocated and make sure you have sufficient space. It is best practices to isolate these to their own file system. If you do not have sufficient space you can either increase the file system or decrease the number/size of logs that db2 can allocate. This will of course require an outage.

Posting Permissions

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