473,231 Members | 1,948 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

Health monitor causing issues!

Hellos again,
I seem to be having a weird issue. Whenever DB2 Health monitor seems
to run, all connections to the database seem to just lock up. For
example: (and this seems consistent) In list applications, DB2Hmon
will show as "compiling statement", If I issue a "connect to
database"it will hang there until DB2HMON is completed and no longer
showing as a active application. Below is a lock snapshot that occurs
when this is happening. The apps trying to connect do not show as
connected or lock waiting during this time. Any help would be much
appreciated!
Thanks,
Mike

Database Lock Snapshot

Database name = DVDBSE

Database path = F:\DB2\NODE0000\SQL00002\

Input database alias = DVDBSE

Locks held = 4

Applications currently connected = 12

Agents currently waiting on locks = 0

Snapshot timestamp = 10/19/2004
12:24:36.629286

Application handle = 382

Application ID = *LOCAL.DB2.041019172404

Sequence number = 0001

Application name = DB2HMON

Application status = Compiling

Status change time = 10/19/2004
12:23:34.032541

Application code page = 1252

Locks held = 4

Total wait time (ms) = 0

List Of Locks

Lock Name = 0x5359534C48323032B4B76E9441

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Plan Lock

Mode = S

Lock Name = 0x01000000010000000100180056

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Variation Lock

Mode = S

Lock Name = 0x5359535348323030DDECEF2841

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Plan Lock

Mode = S

Lock Name = 0x53514C4445464C5428DD630641

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Plan Lock

Mode = S
Nov 12 '05 #1
2 6142

I had bad experience with health monitor ex instance crash I was at FP4
and my perticular problem was fix in Fp5or6 I can't remember. In regard
to your problem make sure you are let say at least at FP6; it seems that
issues with the Health Monitor was fixed in these FP.
t again,
I seem to be having a weird issue. Whenever DB2 Health monitor seems
to run, all connections to the database seem to just lock up. For
example: (and this seems consistent) In list applications, DB2Hmon
will show as "compiling statement", If I issue a "connect to
database"it will hang there until DB2HMON is completed and no longer
showing as a active application. Below is a lock snapshot that occurs
when this is happening. The apps trying to connect do not show as
connected or lock waiting during this time. Any help would be much
appreciated!
Thanks,
Mike

Database Lock Snapshot

Database name = DVDBSE

Database path = F:\DB2\NODE0000\SQL00002\

Input database alias = DVDBSE

Locks held = 4

Applications currently connected = 12

Agents currently waiting on locks = 0

Snapshot timestamp = 10/19/2004
12:24:36.629286

Application handle = 382

Application ID = *LOCAL.DB2.041019172404

Sequence number = 0001

Application name = DB2HMON

Application status = Compiling

Status change time = 10/19/2004
12:23:34.032541

Application code page = 1252

Locks held = 4

Total wait time (ms) = 0

List Of Locks

Lock Name = 0x5359534C48323032B4B76E9441

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Plan Lock

Mode = S

Lock Name = 0x01000000010000000100180056

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Variation Lock

Mode = S

Lock Name = 0x5359535348323030DDECEF2841

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Plan Lock

Mode = S

Lock Name = 0x53514C4445464C5428DD630641

Lock Attributes = 0x00000000

Release Flags = 0x40000000

Lock Count = 1

Hold Count = 0

Lock Object Name = 0

Object Type = Internal Plan Lock

Mode = S

Nov 12 '05 #2
Dany,
Sorry I thought I gave specs..
Db2 8.2 fp 7a
Win2k3

MM
Dany <da******@videotron.ca> wrote in message news:<cl*********@news1.stadia.fi>...
I had bad experience with health monitor ex instance crash I was at FP4
and my perticular problem was fix in Fp5or6 I can't remember. In regard
to your problem make sure you are let say at least at FP6; it seems that
issues with the Health Monitor was fixed in these FP.

Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Bruce MacDonald | last post by:
I am unable to see the health monitor SQL table functions (e.g.: SQLPROC.HEALTH_CONT_HI). Have I missed a utility which registers the functions? DB2 8.1.3.132 WR21324. Another point about the...
2
by: Debbie E | last post by:
Are there any issues with the Health Monitor in a partitioned environment? I have turned on the health monitor and can obtain the health snapshot for the DBM via the following command: get...
1
by: p175 | last post by:
Anyone got any ideas as to what could be causing these errors ? ESE 8.2.2 on Win2k server FP4 2005-08-16-21.46.53.554000-240 I1202H313 LEVEL: Warning PID : 2464 ...
0
by: nycjay | last post by:
i am trying to use the db2 health monitor alert to run a script. i set up the health monitor to run a script when the tablespace utailization is too high. in the end, the script should send a...
0
by: nycjay | last post by:
I am trying to use a script to take some action when DB2 issues health alerts. To find out what message the health monitor is sending to the script, I wrote a sdcript which would just write the...
4
by: Maddy | last post by:
Hi all, I am new to DB2 database.I just have the basic knowledge abt this database.I in a serious situation of handling 5 large databases.Can some one help me how to prepare the health check...
1
by: rdudejr | last post by:
How often does the health monitor check the threshold of an indicator to see if there is a warning or alarm? I am trying to simulate the behaviour of the health monitor and have a dms tablespace...
4
by: onedbguru | last post by:
DB2Connect Informational tokens are "DB2 v8.1.0.96", "s050811", "U803921", FixPak "10". I am getting txxxxxx.0000 files approximately every 14 minutes that look like: <Trap> <Header> DB2...
5
by: jbenner | last post by:
I have opened a PMR for this with IBM, and am not asking for advice from the DB2 DBA community. I am posting this as an FYI that DB2 Health Monitor, even at the latest version of DB2, still can cause...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.