|
Problem IC91667
|
Status: Closed |
MISSING DEPENDENCIES FROM THE DB2 PARTITION RESOURCES TO THE PUBLIC NETWORK EQUIVALENCY |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
The TSA dependency which should be created between the db2
partitition resources and the public network equivalency does
not exist. This can be verified from the output of the "lsrel"
command:
$ lsrel
lsrel: 2622-344 There are no relationships defined.
For example in the following HADR/TSA configuration:
Online IBM.ResourceGroup:db2_db2inst1_db2inst1_HADRDB-rg
Nominal=Online
'- Online
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs
|- Offline
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:perfhadr1
'- Online
IBM.Application:db2_db2inst1_db2inst1_HADRDB-rs:perfhadr2
Online IBM.ResourceGroup:db2_db2inst1_perfhadr1_0-rg
Nominal=Online
'- Online IBM.Application:db2_db2inst1_perfhadr1_0-rs
'- Online
IBM.Application:db2_db2inst1_perfhadr1_0-rs:perfhadr1
Online IBM.ResourceGroup:db2_db2inst1_perfhadr2_0-rg
Nominal=Online
'- Online IBM.Application:db2_db2inst1_perfhadr2_0-rs
'- Online
IBM.Application:db2_db2inst1_perfhadr2_0-rs:perfhadr2
Online IBM.Equivalency:db2_db2inst1_db2inst1_HADRDB-rg_group-equ
|- Online IBM.PeerNode:perfhadr2:perfhadr2
'- Online IBM.PeerNode:perfhadr1:perfhadr1
Online IBM.Equivalency:db2_db2inst1_perfhadr1_0-rg_group-equ
'- Online IBM.PeerNode:perfhadr1:perfhadr1
Online IBM.Equivalency:db2_db2inst1_perfhadr2_0-rg_group-equ
'- Online IBM.PeerNode:perfhadr2:perfhadr2
Online IBM.Equivalency:db2_public_network_0
|- Online IBM.NetworkInterface:en0:perfhadr2
'- Online IBM.NetworkInterface:en0:perfhadr1
There should exist the following two dependencies:
root@perfhadr2:/> lsrel
Displaying Managed Relations :
Name
Class:Resource:Node[Source]
ResourceGroup[Source]
db2_db2inst1_perfhadr2_0-rs_DependsOn_db2_public_network_...
IBM.Application:db2_db2inst1_perfhadr2_0-rs
db2_db2inst1_perfhadr2_0-rg
db2_db2inst1_perfhadr1_0-rs_DependsOn_db2_public_network_...
IBM.Application:db2_db2inst1_perfhadr1_0-rs
db2_db2inst1_perfhadr1_0-rg
These two missing dependencies can be created by stopping the
database manager and running the following commands as root:
1) mkrel -p dependson -S
IBM.Application:db2_db2inst1_perfhadr1_0-rs -G
IBM.Equivalency:db2_public_network_0
db2_db2inst1_perfhadr1_0-rs_DependsOn_db2_public_network_0-rel
2) mkrel -p dependson -S
IBM.Application:db2_db2inst1_perfhadr2_0-rs -G
IBM.Equivalency:db2_public_network_0
db2_db2inst1_perfhadr2_0-rs_DependsOn_db2_public_network_0-rel |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
1. Stop the database manager.
2. Create dependencies from every DB2 partition resource to
every db2_public_network equivalency via the mkrel command. |
| available fix packs: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.04.2013
13.10.2013
13.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
