单db2+hacmp(页 1) - DB2 & Informix - LoveUnix 最强AIX小机技术论坛,UNIX,Linux,存储,数据库,中间件,开发,管理

2005-1-23 17:02 showme

各位老兄，帮帮忙！ 迫切需要db2＋hacmp的安装文档。没有文档稍微指导几下也好! <img src='style_emoticons/default/happy.gif' border='0' style='vertical-align:middle' alt='happy.gif' /> 安装需求：平时只需要a台机器上启动db2，当a机故障时，b机自动把a机的db2接管过去！！

2005-1-24 14:34 wildhorse

那就是db2+hacmp呀。在ibm网站有case下载，名字好像叫db2ee-aixhacmp

2005-1-24 15:21 myuhan

呵呵，引用别人的话（chinaunix,xin9 ）： 系统环境：AIX V5.2 ， DB2 UDB V8.1 ESE 群集软件：HACMP V5.1 安装步骤： 1、安装操作系统，补丁升级为ML04 补丁下载地址 ftp:// <a href="http://ftp.software.ibm.com/aix/fixes/52/ml" target="_blank" style="text-decoration: underline" style="color:blue">http://ftp.software.ibm.com/aix/fixes/52/ml</a> 2、安装HACMP V5.1 HACMP 安装配置完成后，有网卡丢包现象，下载补丁IY53044 <a href="http://www-1.ibm.com/support/docview.wss?uid=isg1IY53044" target="_blank" style="text-decoration: underline" style="color:blue">http://www-1.ibm.com/support/docview.wss?uid=isg1IY53044</a> 2.1 HACMP 规划 两台主机的IP 规划如下表: Adapter IP Label Nodedb_srv Nodedb_boot Nodedb_sty Nodedb_tty Network Type ether ether ether rs232 Network Name Net_ether Net_ether Net_ether Net_rs232 Network Attribute public public Public serial Adapter Function service boot standby Adapter Identifer 192.168.168.32 192.168.168.28 172.16.1.2 /dev/tty0 Node Name nodedb nodedb nodedb nodedb Adapter IP Label Nodeapp_srv Nodeapp_boot Nodeapp_sty Nodeapp_tty Network Type ether ether ether rs232 Network Name Net_ether Net_ether Net_ether Net_rs232 Network Attribute public public Public serial Adapter Function service boot standby Adapter Identifer 192.168.168.33 192.168.168.21 172.16.1.1 /dev/tty0 Node Name Nodeapp nodeapp nodeapp nodeapp 两台主机都安装db2 与websphere, 互为主备， 2.2 Nodedb与nodeapp文件 2.2.1 nodedb /etc/hosts file 127.0.0.1 loopback localhost nodedb # loopback (lo0) name/address 192.168.168.28 nodedb_boot nodedb 192.168.168.32 nodedb_srv 172.16.1.2 nodedb_sty nodedb 192.168.168.21 nodeapp_boot 192.168.168.33 nodeapp_srv 172.16.1.1 nodeapp_sty 2.2.2 nodedb /.rhosts file nodedb nodeapp nodedb_boot nodedb_srv nodedb_sty nodeapp_boot nodeapp_srv nodeapp_sty 2.2.3 nodeapp /etc/hosts file 127.0.0.1 loopback localhost nodeapp # loopback (lo0) name/address 192.168.168.28 nodedb_boot nodedb 192.168.168.32 nodedb_srv 172.16.1.2 nodedb_sty nodedb 192.168.168.21 nodeapp_boot 192.168.168.33 nodeapp_srv 172.16.1.1 nodeapp_sty 2.2.4 nodeapp /.rhosts file H85A H85B H85A_svr H85A_boot H85A_stb H85B_svr H85B_boot H85B_stb 2.3 HACMP配置 2.3.1 拓扑定义 （1）定义CLUSTER ->Initialization and Standard Configuration ->Add Nodes to an HACMP Cluster Add/Change/Show an HACMP Cluster [输入字段] * Cluster Name [ERP] NOTE: HACMP must be RESTARTED on all nodes in order for change to take effect （2）定义nodedb节点 -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Nodes -> Add a Node to the HACMP Cluster Add a Node to the HACMP Cluster [输入字段] * Node Name [nodedb] Communication Path to Node [] + （2）定义nodeapp节点 -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Nodes -> Add a Node to the HACMP Cluster Add a Node to the HACMP Cluster [输入字段] * Node Name [nodedb] Communication Path to Node [] + (3) 定义网络 A. 定义IP网络 -> Extended Configuration ->Extended Topology Configuration ->Configure HACMP Networks -> Add a Network to the HACMP Cluster Add an IP-Based Network to the HACMP Cluster [输入字段] * Network Name [net_ether] * Network Type ether * Netmask [255.255.255.0] + * Enable IP Address Takeover via IP Aliases [No] + IP Address Offset for Heartbeating over IP Aliases [] B. 定义非IP网络 -> Extended Configuration ->Extended Topology Configuration ->Configure HACMP Networks -> Add a Network to the HACMP Cluster 选择# Pre-defined Serial Device Types 中的rs232 Add a Serial Network to the HACMP Cluster [输入字段] * Network Name [net_rs232] * Network Type rs232 (4) 定义网络接口 A. 定义IP网络接口 定义nodedb_boot接口: -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Communication Interfaces/Devices -> Add Communication Interfaces/Devices 选择 Add Pre-defined Communication Interfaces and Devices 选择 Communication Interfaces 选择net_ether (0.0.0.0/0) Add a Communication Interface [输入字段] * IP Label/Address [nodedb_boot] + * Network Type ether * Network Name net_ether * Node Name [nodedb] + Network Interface [] 定义Nodedb_sty接口: -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Communication Interfaces/Devices -> Add Communication Interfaces/Devices 选择 Add Pre-defined Communication Interfaces and Devices 选择 Communication Interfaces 选择net_ether (0.0.0.0/0) Add a Communication Interface [输入字段] * IP Label/Address [Nodedb_sty] + * Network Type ether * Network Name net_ether * Node Name [nodedb] + Network Interface [] 定义nodeapp_boot接口: -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Communication Interfaces/Devices -> Add Communication Interfaces/Devices 选择 Add Pre-defined Communication Interfaces and Devices 选择 Communication Interfaces 选择net_ether (0.0.0.0/0) Add a Communication Interface [输入字段] * IP Label/Address [nodeapp_boot] + * Network Type ether * Network Name net_ether * Node Name [nodeapp] + Network Interface [] 定义nodeapp_sty接口: -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Communication Interfaces/Devices -> Add Communication Interfaces/Devices 选择 Add Pre-defined Communication Interfaces and Devices 选择 Communication Interfaces 选择net_ether (0.0.0.0/0) Add a Communication Interface [输入字段] * IP Label/Address [nodeapp_sty] + * Network Type ether * Network Name net_ether * Node Name [nodeapp] + Network Interface [] B. 定义非IP网络接口 定义nodedb_tty接口: -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Communication Interfaces/Devices -> Add Communication Interfaces/Devices 选择 Add Pre-defined Communication Interfaces and Devices 选择 Communication Device 选择 net_rs232 Add a Communication Device [输入字段] * Device Name [Nodedb_sty] * Network Type rs232 * Network Name net_rs232 * Device Path [/dev/tty0] * Node Name [nodedb] 定义nodeapp_tty接口: -> Extended Configuration -> Extended Topology Configuration ->Configure HACMP Communication Interfaces/Devices -> Add Communication Interfaces/Devices 选择 Add Pre-defined Communication Interfaces and Devices 选择 Communication Device 选择 net_rs232 Add a Communication Device [输入字段] * Device Name [nodeapp_tty] * Network Type rs232 * Network Name net_rs232 * Device Path [/dev/tty0] * Node Name [nodeapp] 2.3.2 定义应用服务及资源组 定义Was应用服务器: ->Initialization and Standard Configuration ->Configure Application Servers ->Add an Application Server Add Application Server [输入字段] * Server Name [was] * Start Script [/usr/bin/wasstart] * Stop Script [/usr/bin/wasstop] 定义共享资源组 定义rgwas资源组 ->Initialization and Standard Configuration ->Configure HACMP Resource Group ->Add a Resource Group 选择Cascading Add a Resource Group with a Cascading Management Policy (standard) [输入字段] * Resource Group Name [rgwas] *Participating Node Names (Default Node Priority) [nodeapp nodedb] + 修改资源组属性 修改rgwas资源组属性: ->Initialization and Standard Configuration ->Configure HACMP Resource Group -> Change/Show Resources for a Cascading Resource Group(standard) Change/Show Resources for a Cascading Resource Group [输入字段] Resource Group Name wlyres Participating Node Names (Default Node Priority) nodeapp nodedb * Service IP Labels/Addresses [] + Volume Groups [wasvg] + Filesystems (empty is ALL for VGs specified) [] + Application Servers [was] + 定义Service IP 定义nodedb的service IP地址: ->Initialization and Standard Configuration ->Configure Resources to Make Highly Available ->Configure Service IP Labeles/Addresses ->Add a service IP Labeles/Addresses Add a Service IP Label/Address (standard) [输入字段] * IP Label/Address [nodeapp_srv] + * Network Name [net_ether] + 定义db2数据库服务 ->Initialization and Standard Configuration ->Configure Application Servers ->Add an Application Server Add Application Server [输入字段] * Server Name [db2] * Start Script [/usr/bin/hadb2start] * Stop Script [/usr/bin/hadb2stop] 定义共享资源组 定义rgdb2资源组 ->Initialization and Standard Configuration ->Configure HACMP Resource Group ->Add a Resource Group 选择Cascading Add a Resource Group with a Cascading Management Policy (standard) [输入字段] * Resource Group Name [rgdb2] *Participating Node Names (Default Node Priority) [nodedb nodeapp] + 修改资源组属性 修改rgdb2资源组属性: ->Initialization and Standard Configuration ->Configure HACMP Resource Group -> Change/Show Resources for a Cascading Resource Group(standard) Change/Show Resources for a Cascading Resource Group [输入字段] Resource Group Name rgdb2 Participating Node Names (Default Node Priority) nodedb nodeapp * Service IP Labels/Addresses [] + Volume Groups [db2vg] + Filesystems (empty is ALL for VGs specified) [] + Application Servers [db2] + ( 定义Service IP 定义nodedb的service IP地址: ->Initialization and Standard Configuration ->Configure Resources to Make Highly Available ->Configure Service IP Labeles/Addresses ->Add a service IP Labeles/Addresses Add a Service IP Label/Address (standard) [输入字段] * IP Label/Address [nodedb2_srv] + * Network Name [net_ether] + 2.3.3 同步HACMP配置 ->Initialization and Standard Configuration -> Verify and Synchronize HACMP Comfiguration Verify and Synchronize HACMP Comfiguration [输入字段] * Verify, Synchronize or Both [Both] + Force synchronization if verification fails? [No] + * Verify changes only? [No] + * Logging [Standard] + 9、 HACMP服务的启动和停止 启动: #smitty clstart Start Cluster Services [输入字段] * Start now, on system restart or both now + Start Cluster Services on these nodes [nodedb] + BROADCAST message at startup? true + Startup Cluster Lock Services? false + Startup Cluster Information Daemon? false + Reacquire resources after forced down ? false + 停止: #smitty clstop Stop Cluster Services [输入字段] * Stop now, on system restart or both now + Stop Cluster Services on these nodes [nodedb] + BROADCAST cluster shutdown? true + * Shutdown mode graceful+ 注： DB2版本8开始，原来的DB2企业版和企业扩展版合并为企业服务器版，无论对于分区数据库和非分区数据库，在实例目录下都会有db2nodes.cfg文件，该文件记录了服务器节点信息。 在单分区数据库安装模式下，需要建立db2nodes.cfg文件的副本，存放在本地硬盘上，文件名称一致，但内容不同。在HA执行db2启动脚本时将该文件cp到/home/db2inst1/sqlli目录下。 1、在nodedb上创建db2nodes.cfg文件，文件内容为 0 nodedb 0 2、将rc.db2pe.ee文件cp到/usr/bin目录下，并创建db2 脚本hadb2start，内容如下 #db2start script nodedb cp /usr/bin/db2nodes.cfg /home/db2inst1/sqllib/db2nodes.cfg rc.db2pe.ee db2inst1 start db2 停止脚本 # db2 stop script nodedb rc.db2pe.ee db2inst1 stop 在nodeapp上，也创建db2nodes.cfg文件，文件内容更改为nodeapp就可以了，其他步骤相同。 将脚本加入到ha的db2应用服务器中间就可以了。脚本会自动启动db2相关实例。

页: [1]

查看完整版本: 单db2+hacmp