|
Problem IC66569
|
Status: Closed |
DB2HAICU XML IMPORT ONLY SUPPORTS ONE VIRTUAL IP PER PARTITION |
| product: |
DB2 FOR LUW / DB2FORLUW / 980 - DB2 |
| Problem description: |
db2haicu xml import only created one virtual IP per partition
when 3 were defined:
<DB2Partition dbpartitionnum="0" instanceName="bcuaix">
<VirtualIPAddress baseAddress="9.23.20.196"
subnetMask="255.255.252.0" networkName="db2_public_network_0"/>
<VirtualIPAddress baseAddress="10.1.1.40"
subnetMask="255.255.255.0" networkName="db2_FCM_network"/>
<VirtualIPAddress baseAddress="10.1.2.34"
subnetMask="255.255.255.0" networkName="db2_MGMT_network"/>
<Mount filesystemPath="/db2path/bcuaix/NODE0000" />
<Mount filesystemPath="/db2fs/bcuaix/NODE0000" />
<NPlusMNode standbyNodeName="bluejay16" />
</DB2Partition>
The import completed without any error:
Creating domain bcudomain in the cluster ...
Creating domain bcudomain in the cluster was successful.
Configuring quorum device for domain bcudomain ...
Configuring quorum device for domain bcudomain was successful.
Adding network interface card en12 on cluster node bluejay14 to
the network db2_public_network_0 ...
Adding network interface card en12 on cluster node bluejay14 to
the network db2_public_network_0 was successful.
Adding network interface card en12 on cluster node bluejay15 to
the network db2_public_network_0 ...
Adding network interface card en12 on cluster node bluejay15 to
the network db2_public_network_0 was successful.
Adding network interface card en12 on cluster node bluejay16 to
the network db2_public_network_0 ...
Adding network interface card en12 on cluster node bluejay16 to
the network db2_public_network_0 was successful.
Adding network interface card en11 on cluster node bluejay14 to
the network db2_FCM_network ...
Adding network interface card en11 on cluster node bluejay14 to
the network db2_FCM_network was successful.
Adding network interface card en11 on cluster node bluejay15 to
the network db2_FCM_network ...
Adding network interface card en11 on cluster node bluejay15 to
the network db2_FCM_network was successful.
Adding network interface card en11 on cluster node bluejay16 to
the network db2_FCM_network ...
Adding network interface card en11 on cluster node bluejay16 to
the network db2_FCM_network was successful.
Adding network interface card en0 on cluster node bluejay14 to
the network db2_MGMT_network ...
Adding network interface card en0 on cluster node bluejay14 to
the network db2_MGMT_network was successful.
Adding network interface card en0 on cluster node bluejay15 to
the network db2_MGMT_network ...
Adding network interface card en0 on cluster node bluejay15 to
the network db2_MGMT_network was successful.
Adding network interface card en0 on cluster node bluejay16 to
the network db2_MGMT_network ...
Adding network interface card en0 on cluster node bluejay16 to
the network db2_MGMT_network was successful.
Adding DB2 database partition 0 to the cluster ...
Adding DB2 database partition 0 to the cluster was successful.
Adding DB2 database partition 1 to the cluster ...
Adding DB2 database partition 1 to the cluster was successful.
Adding DB2 database partition 2 to the cluster ...
Adding DB2 database partition 2 to the cluster was successful.
Adding DB2 database partition 3 to the cluster ...
Adding DB2 database partition 3 to the cluster was successful.
Adding DB2 database partition 4 to the cluster ...
Adding DB2 database partition 4 to the cluster was successful.
All cluster configurations have been completed successfully.
db2haicu exiting ...
Only the last defined virtual IP was created:
# lssam -g db2_bcuaix_0-rg
Online IBM.ResourceGroup:db2_bcuaix_0-rg Nominal=Online
|- Online IBM.Application:db2_bcuaix_0-rs
|- Online
IBM.Application:db2_bcuaix_0-rs:bluejay14
'- Offline
IBM.Application:db2_bcuaix_0-rs:bluejay16
|- Online
IBM.Application:db2mnt-db2fs_bcuaix_NODE0000-rs
|- Online
IBM.Application:db2mnt-db2fs_bcuaix_NODE0000-rs:bluejay14
'- Offline
IBM.Application:db2mnt-db2fs_bcuaix_NODE0000-rs:bluejay16
|- Online
IBM.Application:db2mnt-db2path_bcuaix_NODE0000-rs
|- Online
IBM.Application:db2mnt-db2path_bcuaix_NODE0000-rs:bluejay14
'- Offline
IBM.Application:db2mnt-db2path_bcuaix_NODE0000-rs:bluejay16
'- Online IBM.ServiceIP:db2ip_10_1_2_34-rs
|- Online
IBM.ServiceIP:db2ip_10_1_2_34-rs:bluejay14
'- Offline
IBM.ServiceIP:db2ip_10_1_2_34-rs:bluejay16
The balanced warehouse requires 3 virtual IPs on the coordinator
partiiton |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Smart Analytic Systems *
****************************************************************
* PROBLEM DESCRIPTION: *
* More than one service IP per database partition cannot be *
* defined in the XML and imported by db2haicu. If more than *
* one IP resource is defined, only the first one will be *
* created and the other will be ignored. No error in the *
* import will be reported. *
****************************************************************
* RECOMMENDATION: *
* Update to DB2 V98 FP3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.8 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.8 Fix Pack 4 for AIX and Linux
DB2 Version 9.8 Fix Pack 5 for AIX and Linux
|
| Solution |
Fixed in DB2 V98 FP3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.02.2010
20.12.2010
20.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.8.FP3
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.8.0.3
|
 |
