Thanks Daniel,
Right, The HEALTH_MON was turn OFF (on DBM configuration file)
But on Instance, we have 3 Databases and Only one Database turn this errors on db2diag.log.
But, I could open Heath Center Monitor manualy (??)
Please, How can I open a PMR on Internet ???
-----Message d'origine-----
De : DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x54767685.[Email address protected]
Envoyé : jeudi 28 juillet 2005 17:49
À : LazyDBA Discussion
Objet : RE: Urgent db2 migration problems - Help
I believe this is a security error. Is the health_mon switch turned on for
that db? If it is open a pmr.
"LA RESERVE S Ext
ROSI/DOSI "
<db2udbdba-ezmlms To
hield-x27969577.x "LazyDBA Discussion"
[Email Address Removed] <[Email address protected]
a.com> cc
07/28/2005 11:16 Subject
AM RE: Urgent db2 migration problems -
Help
Hi Daniel,
I Was lunch db2updv8 on my DataDase (Thanks It's Worked very Well) ;
but, I always have recurring errors in the DB2DIAG.log file :
===> This One
2005-07-28-14.31.43.609000+060 I12781H391 LEVEL: Error
PID : 4180 TID : 5064 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HmonMainCB::refreshDBNode, probe:160
MESSAGE : Failed connecting to database "DBASE"
DATA #1 : Hexdump, 4 bytes
0x0160F344 : 7E8A FFFF
====================================
But :
1. I can open manually "Heath Center Monitor" (no errors) via Control
Center (for this Database)
2. In Instance, We have 3 Databases and Only turns this error.
Please, what this error means ??
We used db2 udb on Win32K
Thank for your assistance
-----Message d'origine-----
De : DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x98824011.[Email address protected]
Envoyé : mercredi 27 juillet 2005 13:32
À : LazyDBA Discussion
Objet : Re: Urgent db2 migration problems - Help
db2updv8 -d CPDBASE
Serge LARESERVE
<serge.[Email Address Removed] wanadoo.fr> To
DANIEL CALLAHAN/Bedford/[Email Address Removed] 07/27/2005 07:25 [Email address protected]
AM cc
Subject
Please respond to Urgent db2 migration problems -
serge.lareserve Help
Hello,
After having migrated my Instance db2 udb from 8.1.6a to 8.2.1 (Fixpak
8a),
I find following errors in db2diag.log file :
==> Diag Errors
2005-07-20-11.13.43.640000+060 I54796H391 LEVEL: Error
PID : 4952 TID : 4960 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, HmonMainCB::refreshDBNode, probe:160
MESSAGE : Failed connecting to database "CPDBASE "
DATA #1 : Hexdump, 4 bytes
0x0160F344 : 7E8A FFFF
======
I think that it is related to Heath Center.
Then, when I try to open the Heath Center Monitor on Control Center,
I have AGAIN the following error :
==> Heath Center Errors
Routine "*LOBJECTS" (specific name "SQL050721211351450") is
implemented with code in library or path "...ALLOBJECTS",
function "SYSPROC.SYSINSTALLOBJECTS" which cannot be accessed.
Reason code: "4". SQLSTATE=42724
PLEASE, VERY URGENTLY ...
Somebody can say to me what that means.
Of course, I have rebinde the procedures of migration on the database :
==> Rebind actions
@db2ubind.lst
@db2cli.lst
@capture.lst
@applycs.lst
@applyur.lst
@db2schema.bnd public blocking ALL grant sqlerror continues
db2rbind CPDBASE - L LOG.log all
======
We Use db2 udb on Win32K - with Cluster Manager
Many Thanks in advance for your assistance.
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page