Db2 Warehouse (On Premises and Cloud)

nested-group-icon.png

DB2

Expand all | Collapse all

DB2 Warehouse - Cannot Prune log files

  • 1.  DB2 Warehouse - Cannot Prune log files

    Posted Mon November 30, 2020 01:48 PM
      |   view attached
    I have DB2 Warehouse 11.5 container on a windows Docker and it is increasing in size everyday even without any transaction. I noticed the ARCHIVE directory is grown to 175GB.
    I tried to prune the logs but no logs are getting deleted even the PRUNE command ran successfully.
    I'm attaching my DB Configuration. Please Help

    ------------------------------
    Pandian Mariadoss
    IT Consulting Specialist
    IBM
    Coppell TX
    ------------------------------

    Attachment(s)

    txt
    dbcfg.txt   10 KB 1 version


  • 2.  RE: DB2 Warehouse - Cannot Prune log files

    Posted Tue December 01, 2020 03:19 AM
    Hi, 
    That behavior is strange indeed. What you could do is:
    1. Relocate the archivelog location to a mounted volume in docker so you do not blow up your container, just to mitigate the issue.
    2. After that you could try to take a  backup and prune afterwards to see if that will help. I see auto_backup is on so that could be in the way.
    3. Otherwise you could use the prune history with the force option.
    4. Last option would be to delete the files manually if you are sure you do not need them anymore.

    kind regards

    ------------------------------
    Guido Verbraak
    IBM Data & AI Expert Labs
    ------------------------------



  • 3.  RE: DB2 Warehouse - Cannot Prune log files

    Posted Tue December 01, 2020 04:16 PM
    Thanks. I turned OFF of archive for now.

    ------------------------------
    Pandian Mariadoss
    IT Consulting Specialist
    IBM
    Coppell TX
    ------------------------------