home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT09859 Status: Closed

MOUNTV105_MONITOR.KSH SCRIPT IS ERRONEOUSLY REPORTING THE MOUNT RESOURCE AS
"FAILED OFFLINE" INSTEAD OF "OFFLINE".

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
The mountV105_monitor.ksh script is erroneously reporting the 
mount resource as "FAILED OFFLINE" instead of "OFFLINE". 
You can see the following in the db2diag.log: 
 
2015-06-09-17.15.37.323039+060 E4604A504            LEVEL: Error 
PID     : 6815854              TID : 1              PROC : 
db2haicu 
INSTANCE: db2inst1             NODE : 000 
HOSTNAME: db2host1 
EDUID   : 1 
FUNCTION: DB2 UDB, high avail services, 
sqlhaCreateMountInternal, probe:9949 
MESSAGE : Please ensure mount object is in correct state 
DATA #1 : String, 9 bytes 
db2host1 
DATA #2 : String, 20 bytes 
db2mnt-db2_db2inst1-rs 
DATA #3 : String, 9 bytes 
db2host1 
DATA #4 : String, 15 bytes 
db2_db2inst1_0-rs 
 
The issue as already stated is that the mount resource is 
reporting as failed offline on host db2host1: 
 
Jun  9 17:15:34 db2host1 user:debug 
mountV105_monitor.ksh[11730972]: backgrounding the stop force 
for /db2/db2inst1 
Jun  9 17:15:34 db2host1 user:debug 
mountV105_monitor.ksh[11730972]: Returning 3 for mount 
/db2/db2inst1 
 
As a result, the db2haicu utility may fail to add the mount 
resource with the following error: 
Enter the full path of the mount you wish to add to the cluster: 
/db2/db2inst1 
Which DB2 database partition should the path '/db2/db2inst1' be 
associated with? 
0 
Adding mount point '/db2/db2inst1' to the cluster ... 
There was an error with one of the issued cluster manager 
commands. The user can determine the cause of the error by 
invoking 'db2instance -list' and 'db2cluster -list -alert'. The 
db2diag.log for the current member and the DB2 Information 
Center may provide additional details.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platform                                                 * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 Fixpack 7 or Later.                 * 
****************************************************************
Local Fix:
N/A
Solution
First Fixed in DB2 LUW v10.5 Fixpack 7.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.07.2015
21.01.2016
21.01.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList