I had trouble to get the hmon work in 8.x FP 8 and FP 9 .
The server runnig Windows 2003 SP1 on a member server.
The db2 services are running under an domain admin account.
Ok, no problem so far (HMON working) .
Now i had made a special local group a the member server (contains both
local and domain admin accounts and some local accounts without local
windows admin rights) and i had aaded these group to SYSADM_GROUP .
After restart, HMON does nothing.
For "get health snapshot for dbm", DB2 reports after houres of run
at the "instance highest severity alert state" "Not yet evaluated"
With diaglevel "3" DB2 reports no error. With diaglevel "4" you may
see this error:
2005-05-17-11.52.50.982000 +120 I3330566H1014 LEVEL: Error
PID : 5652 TID : 2824 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ******* APPHDL
: 0-27 APPID: *LOCAL.DB2.0505 17095250
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : Hexdump, 136 bytes
0x08784948 : 5351 4C43 4120 2020 8800 0000 BCFB FFFF SQLCA
.........
0x08784958 : 0D00 4144 4D49 4E49 5354 5241 544F 5200
...ADMINISTRATO R.
0x08784968 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x08784978 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x08784988 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x08784998 : 0000 0000 0000 0000 5351 4C45 5843 4D4E
.........SQLEXC MN
0x087849A8 : 0000 0000 0000 0000 0000 0000 0000 0000
............... ..
0x087849B8 : 0000 0000 4000 0000 2020 2020 2020 2020 ....@...
0x087849C8 : 2020 2020 2020 2020
2005-05-17-11.52.50.982000 +120 I3331582H619 LEVEL: Severe
PID : 5788 TID : 5344 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
DATA #1 : SQLCA, PD_DB2_TYPE_SQL CA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1092 sqlerrml: 13
sqlerrmc: ADMINISTRATOR
sqlerrp : SQLEXCMN
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
The workaround for me is:
"db2set DB2_GRP_LOOKUP= ,TOKEN" !!!
Now it works fine. IBM should investigate in this problem. It was very
hard to troubleshoot this.
I had already opened a PMR, but it was not a great help .
-Zahni 1 2404 za*****@gmx.de wrote: I had trouble to get the hmon work in 8.x FP 8 and FP 9 .
The server runnig Windows 2003 SP1 on a member server.
The db2 services are running under an domain admin account.
Ok, no problem so far (HMON working) .
Now i had made a special local group a the member server (contains both local and domain admin accounts and some local accounts without local windows admin rights) and i had aaded these group to SYSADM_GROUP . After restart, HMON does nothing.
For "get health snapshot for dbm", DB2 reports after houres of run at the "instance highest severity alert state" "Not yet evaluated"
With diaglevel "3" DB2 reports no error. With diaglevel "4" you may see this error:
2005-05-17-11.52.50.982000 +120 I3330566H1014 LEVEL: Error PID : 5652 TID : 2824 PROC : db2syscs.exe INSTANCE: DB2 NODE : 000 DB : ******* APPHDL : 0-27 APPID: *LOCAL.DB2.0505 17095250 FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10 DATA #1 : Hexdump, 136 bytes 0x08784948 : 5351 4C43 4120 2020 8800 0000 BCFB FFFF SQLCA ........ 0x08784958 : 0D00 4144 4D49 4E49 5354 5241 544F 5200 ..ADMINISTRATOR . 0x08784968 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0x08784978 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0x08784988 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0x08784998 : 0000 0000 0000 0000 5351 4C45 5843 4D4E ........SQLEXCM N 0x087849A8 : 0000 0000 0000 0000 0000 0000 0000 0000 ............... . 0x087849B8 : 0000 0000 4000 0000 2020 2020 2020 2020 ....@...
0x087849C8 : 2020 2020 2020 2020
2005-05-17-11.52.50.982000 +120 I3331582H619 LEVEL: Severe PID : 5788 TID : 5344 PROC : db2fmp.exe INSTANCE: DB2 NODE : 000 DATA #1 : SQLCA, PD_DB2_TYPE_SQL CA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1092 sqlerrml: 13 sqlerrmc: ADMINISTRATOR sqlerrp : SQLEXCMN sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: The workaround for me is:
"db2set DB2_GRP_LOOKUP= ,TOKEN" !!!
Now it works fine. IBM should investigate in this problem. It was very hard to troubleshoot this.
I had already opened a PMR, but it was not a great help .
-Zahni
Had this problem too. Hope the next Fixpack will all help us.
cu,
indika This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 health monitor - when I get notification messages
all they say is that a particular instance/db has a warning or alarm. I
have to open the health centre to see what the actual warning / alarm is. I
would much prefer if the email had at least a...
|
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 health snapshot for dbm
But I can't seem to get any info regarding the database itself. I
tried the following commands:
|
by: christopher keller |
last post by:
Hello,
If we have UDB Express and DB2 Connect Versions 8.1.4 installed on the
same server, the Health Center start window appears andwill then after
one minute disappear. Javaw.exe remains active.
This is due to the fact that the health monitor wants to monitor the
databases cataloged with DB2 Connect. This, of course, we don't want.
Can one restrict the scope of the Health Center to just the local
databases? We have not found any...
|
by: Mike |
last post by:
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....
|
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 syslog message. for
now, i am just trying to figure out what message db2 is sending, by
printing out the parameters db2 is sending.
set up:
Indicator Name = ts.ts_util
Default = No
| |
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 report for the
databases.
Also suggest me gud books for learning DB2.
Thanks in advance,
|
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 at 100%, and
so far over the last 18 hours I have only gotten one email about it.
Is there a way to adjust the frequency of the threshold check? I am
aware of the sensitivity setting, and we have that at 0.
Thanks,
rdudejr
|
by: Cage |
last post by:
hi,all
As we known,DB2 Health Center is a very good tool,but it made me a little confusion. I will be very appreciate if anyone give me some advices.
The problem is that I want to monitor my tablespacle utilization,then I did some test work:
1.I create a tablespace "TESTDMS"managed by database,
db2=>CREATE REGULAR TABLESPACE TESTDMS PAGESIZE 4 K MANAGED BY DATABASE USING ( FILE 'D:\test\test' 5120 ) EXTENTSIZE 16 OVERHEAD 10.5 PREFETCHSIZE...
|
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 huge problems with slow connect times and heavy resource locking in high concurrency / high transaction volume environments. I have an OLTP with 30-90 transactions per second activity, and start of Health Monitor every 2 hours was crashing our...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |