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,

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

Yes i agree with him.

Unse event Configure event monitor and alerts so that you can get message on perticular condition.

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

Thanks much everyone

kevin