Results 1 to 5 of 5

Thread: db2diag

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: db2diag

    Hi,

    The /db2/SID/db2dump folder reaches 95%utilisation.I have archive the db2diag log file also using db2diag -A path.After that it reaches 93%,I ghave checked db2ir.nfy size is 2.3 GB.Every day this file increasing.How to reduce this file..

    Regards,
    Raj

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    This file is useful when you have to investigate system errors ...

    On a daily basis, tar and compress the files in this directory, delete the files and move the compressed file to a different directory for later retrieval .. You can delete the compressed files older than n days (30 is my guideline)

    Why not increase the size of the filesystem to accomodate more files in this directory ?

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Wouldn't the right question be what is causing all those dumps and fix the problem then figuring out how to reduce folder utilization?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Quote Originally Posted by Cougar8000
    Wouldn't the right question be what is causing all those dumps and fix the problem then figuring out how to reduce folder utilization?
    That's a good suggestion ..

    Of course, there are other tasks that log into db2diag.log - like LOAD, automatic maintance, STMM etc. So the size of the db2dump filesystem has to accomodate this too ...

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Quote Originally Posted by sathyaram_s
    Of course, there are other tasks that log into db2diag.log - like LOAD, automatic maintance, STMM etc. So the size of the db2dump filesystem has to accomodate this too ...
    For sure. but I have a feeling it is not one of those that caused this posting
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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