Unix Technical Forum

monitor lockwait

This is a discussion on monitor lockwait within the DB2 forums, part of the Database Server Software category; --> hello everyone, we have load failing due to lockwaits and i do not see any messages related to that ...


Go Back   Unix Technical Forum > Database Server Software > DB2

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 06:49 AM
jag
 
Posts: n/a
Default monitor lockwait

hello everyone,

we have load failing due to lockwaits and i do not see any messages
related to that in diaglog.
i thought they are recorded there but apparently they are not.

i do not know if health monitor would catch that but then again, health
monitor has its own issues ( it start locking itself and cause issues
). i do not know if newer fixpak have eliminated that problem in HMON

i have written script script to take snapshot of applications and then
grep any lockwaits.

i am curious if there is something easier or builtin in udb ( i do not
know about event monitor because they have significant overhead ) which
can be used to catch lockwaits and do some action at the same time

regards,
jag

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 01:58 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com