刘胜涛
作者刘胜涛·2016-11-17 10:26
数据库管理员·Volkswagen Group China

TSA创建resource出错解决办法

字数 3049阅读 2947评论 0赞 1

几乎是最后一步,

[16:07:40]Retrieving high availability configuration parameter for instance 'db2inst1' ...

[16:07:40]The cluster manager name configuration parameter (high availability configuration parameter) is not set. For more information, see the topic "cluster_mgr - Cluster manager name configuration parameter" in the DB2 Information Center. Do you want to set the high availability configuration parameter?
[16:07:40]The following are valid settings for the high availabi​-ity configuration parameter:
[16:07:40] 1.TSA
[16:07:40] 2.Vendor
[16:07:40]Enter a value for the high availability configuration parameter: [1]
[16:07:54]1
[16:07:54]Setting a high availability configuration parameter for instance 'db2inst1' to 'TSA'.
[16:07:54]Adding DB2 database partition '0' to the cluster ...
[16:07:57]Creating resources for the instance '' has failed.
查看db2diag.log中报错
[16:15:57]2016-11-16-16.10.04.421043+480 I198988E521 LEVEL: Event
[16:15:57]PID : 573 TID : 140246041749248 PROC : db2sysc 0
[16:15:57]INSTANCE: db2inst1 NODE : 000 DB :
[16:15:57]APPHDL : 0-66 APPID: *LOCAL.db2inst1.161116080059
[16:15:57]AUTHID : DB2INST1 HOSTNAME: vgchuvisimdb2p002.ap.vwg
[16:15:57]EDUID : 22 EDUNAME: db2agent (instance) 0
[16:15:57]FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
[16:15:57]CHANGE : CFG DBM: "Cluster_mgr" From: "" To: "TSA"
[16:15:57]
[16:15:57]2016-11-16-16.10.07.388830+480 E199510E800 LEVEL: Error
[16:15:57]PID : 31465 TID : 140662905067296 PROC : db2haicu
[16:15:57]INSTANCE: db2inst1 NODE : 000
[16:15:57]HOSTNAME: vgchuvisimdb2p002.ap.vwg
[16:15:57]FUNCTION: DB2 UDB, high avail services, sqlhaAddResource, probe:1919
[16:15:57]MESSAGE : ECF=0x90000543=-1879046845=ECF_SQLHA_CREATE_RES_FAILED
[16:15:57] Create resource failed
[16:15:57]DATA #1 : String, 60 bytes
[16:15:57]libsqlha: sqlhaAddResource() call error from wrapper library
[16:15:57]DATA #2 : String, 35 bytes
[16:15:57]db2_db2inst1_vgchuvisimdb2p002_0-rs
[16:15:57]DATA #3 : String, 201 bytes
[16:15:57]Line # : 11195---vgchuvisimdb2p002.ap.vwg: 2661-011 The command specified for attribute MonitorCommand is NULL, not a absolute path, does not exist or has insufficient permissions to be run.
[16:15:57]; FFDC ID:
[16:15:57]DATA #4 : signed integer, 4 bytes
[16:15:57]98343
[16:15:57]
[16:15:57]2016-11-16-16.10.07.389533+480 E200311E387 LEVEL: Error
[16:15:57]PID : 31465 TID : 140662905067296 PROC : db2haicu
[16:15:57]INSTANCE: db2inst1 NODE : 000
[16:15:57]HOSTNAME: vgchuvisimdb2p002.ap.vwg
[16:15:57]FUNCTION: DB2 UDB, high avail services, sqlhaCreateClusterObject, probe:2085
[16:15:57]RETCODE : ECF=0x90000543=-1879046845=ECF_SQLHA_CREATE_RES_FAILED
[16:15:57] Create resource failed
找度娘未果,请出level 2,告知查看 /usr/sbin/rsct/sapolicies /usr/sbin/rsct/sapolicies有无db2目录 ,我内个去果然没有,告知执行/opt/data/ibm/db2/V10.5/install/tsamp/db2cptsa ,执行完毕后生成db2目录 。。。然后,就没有然后了,问题解决,重新执行一切OK。。

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

1

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广