Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    27

    Unanswered: Please help in urgent

    Hi all
    I have some questions.
    1> how can you solve the deadlock problem. Tell me the
    steps to do that.
    I do not know how to find which application ID involve
    in deadlocks.

    2> if my system file is full, around 85%, it will give
    me an alert.
    How to solve this problem.

    3> the db2diag.log and instance.nfy is very big, I
    could not go through the whole file. how can I solve
    the problem.

    Best regards,

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    1) Use Event Monitor to determine you deadlock issue. Look it up in the manuals.

    2) Add more disk space.

    3) You can periodically archive these files (move them someplace else). DB2 will create new ones if they do not exist. If you do not need to keep them around, you can just delete them.

    Andy

  3. #3
    Join Date
    Jul 2006
    Location
    Bangalore
    Posts
    57
    Yes i agree with him.

    Unse event Configure event monitor and alerts so that you can get message on perticular condition.
    Ritesh Kumar Singh
    IBM Certified DB2 DBA for LUW
    **Knowledge Is Theft If Not Shared !!**

  4. #4
    Join Date
    Dec 2004
    Posts
    7

    deadlocks

    Hi, Kevin,

    Newer releases of DB2 are [I]supposed[I] to capture deadlock info in the db2diag.log file, you may not need to start an event monitor.

    NOTE: I haven't tested this myself!!

    As for adding disk space, if you're in Windows and used all the install defaults, you'll need to extend the directory where you did the CREATE database from.

    Hope this helps!

    Willy

  5. #5
    Join Date
    Jun 2006
    Posts
    27
    Thanks much everyone

    kevin

Posting Permissions

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