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.050517095250
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
.........SQLEXCMN
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_SQLCA, 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  2391  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.050517095250
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
........SQLEXCMN
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_SQLCA, 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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
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...
|
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,...
|
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...
| |
