摘要：1. Server 准备 2. NFS 系统设置 3. 创建实例 4. rsh/ssh 5. 测试 Server: 192.168.122.1 dpf01.dpf.com dpf01 192.168.122.17 dpf02.dpf.com dpf02 Nodes: --添加用户 groupadd 阅读全文
【HADR】常见的问题
2015-01-29 16:34 by Ivan的一亩三分地, 1253 阅读, 0 推荐, 收藏, 编辑
摘要：[hadrpri@oc0644314035 ~]$ db2 start hadr on db org as primary SQL1768N Unable to start HADR. Reason code = "5". 2015-01-20-09.44.19.684461-300 I29119E 阅读全文
【HADR】搭建实战
2015-01-29 15:57 by Ivan的一亩三分地, 735 阅读, 0 推荐, 收藏, 编辑
摘要：Summary: 简单的HADR，只用一台虚拟机，两个实例间搭建。工作量不大，一般5分钟左右能够完成。 步骤： 1.设定归档模式 2.使用备份建立standby数据库 3.设定hadr相关的参数 4.启动并测试 测试环境： 搭建开始 step 1: 创建组和用户 create primary ins 阅读全文
【HADR】How to reestablish HADR from scratch after a failure on Standby
2015-01-19 19:34 by Ivan的一亩三分地, 286 阅读, 0 推荐, 收藏, 编辑
摘要：转载 http://www-01.ibm.com/support/docview.wss?uid=swg21514783 Cause Have a HADR pair with Primary online but a failure on the Standby makes it necessar 阅读全文
DB2 Check Pending Script
2015-01-15 18:58 by Ivan的一亩三分地, 865 阅读, 0 推荐, 收藏, 编辑
摘要：转载 http://www.zinox.com/archives/144 Thanks to Max Petrenko of DB2 Toronto Lab for sharing a very useful script to remove check pending status from th 阅读全文
db2 tsm backup fails with rc–50(2)
2015-01-12 00:23 by Ivan的一亩三分地, 210 阅读, 0 推荐, 收藏, 编辑
摘要：https://www.ibm.com/developerworks/community/forums/html/topic?id=97cb3b5e-1d8d-48b1-b003-143a4a464a6e 阅读全文
db2 tsm backup fails with rc–50(1)
2015-01-12 00:22 by Ivan的一亩三分地, 739 阅读, 0 推荐, 收藏, 编辑
摘要：2015-01-05-19.21.54.477532+000 E8484227A347 LEVEL: Error PID : 10027058 TID : 1 PROC : db2vend INSTANCE: ldapdb2 NODE : 000 EDUID : 1 FUNCTION: DB2 UD 阅读全文
FAQ of db2fmp messages in the db2diag.log
2015-01-11 23:28 by Ivan的一亩三分地, 1394 阅读, 0 推荐, 收藏, 编辑
摘要：http://www-01.ibm.com/support/docview.wss?uid=swg21470035 Technote (FAQ) Question What do these messages from the db2fmp process mean? Cause This tech 阅读全文
IC79620: USER'S ROUTINE MAY BE TERMINATED ABNORMALLY IF SOME SYSTEMROUTINES WERE RUN IN DB2FMP BEFORE
2015-01-11 23:25 by Ivan的一亩三分地, 494 阅读, 0 推荐, 收藏, 编辑
摘要：http://www-01.ibm.com/support/docview.wss?uid=swg1IC79620 APAR status Closed as program error. Error description User's routine was terminated abnorma 阅读全文
SQL1042C running a fenced routine (stored procedure/UDF)
2015-01-11 23:02 by Ivan的一亩三分地, 706 阅读, 0 推荐, 收藏, 编辑
摘要：Relation to this link http://www-01.ibm.com/support/docview.wss?uid=swg21399105 2015-01-11-13.38.19.538002+000 E263507727A548 LEVEL: Warning PID : 151 阅读全文