Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2010
    Posts
    7

    Unanswered: How to remove log files of DB2DETAILDEADLOCK

    Hi,

    This is my first time to remove event monitor log files in our production server.
    In the db2inst1.nfy, it always shows the following message

    ADM2001W The Event Monitor "DB2DETAILDEADLOCK" was deactivated because the MAXFILES and MAXFILESIZE CREATE EVENT MONITOR parameters' limits have been reached.

    Our current number of output files for event monitor, db2detaildeadlock, is reach 20 and the size of each file is 2M.

    Obviously, I need to remove those output files under db2event/db2detaildeadlock folder because the number of files is reach 20, maximum number by default.

    However, what's the process of removing?

    Should I do the removing work by following process? (Method A)
    1. db2 connect to db_name.
    2. db2 "set event monitor DB2DETAILDEADLOCK state 0"
    3. Delete all 20 output files in db2event/db2detaildeadlock folder
    4. db2"set event monitor DB2DETAILDEADLOCK state 1"
    5. db2 connect reset

    Or, I just delete all 20 output files from the folder, db2detaildeadlock, directly? (Method B)

    Or, I can do it by another way? (Method C)

    Which one I should do? A, B, or C?

    Since it is for our production database, I need to double check for it.

    Thanks,
    zhif

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Event monitor is already deactivated so you can remove all .evt files and db2event.ctl and then restart the monitor.

  3. #3
    Join Date
    Aug 2010
    Posts
    7
    Hi Bella,

    So, the exact process is,
    1. Remove all files in 'db2detaildeadlock' folder
    2. db2 connect to db_name
    3. db2"set event monitor DB2DETAILDEADLOCK state 1"
    4. db2 connect reset

    Is it correct?

    Thanks,
    zhif

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Sounds goods. Use db2evmon to save deadlock info prior to removing the files, if needed. You can also drop this default event monitor and create your own.

  5. #5
    Join Date
    Aug 2010
    Posts
    7
    Thank you. Bella

Posting Permissions

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