在两台linux centos 平台上搭建q复制环境,具体配置如下:
IP: 192.168.244.128 192.168.244.129
角色: capture apply
数据库名: resource target
实例: db2inst3 db2inst3
数据库版本 db29.7.5 db29.7.5
Q Capture Schema ASN ASN
Q Apply Schema ASN ASN
Q Capture 路径 /db2data/sqlre /db2data/sqlre
QMGR SOURCE TARGET
MQ版本 6.0.2 6.0.2
配置后进行测试,数据库编目、MQ消息发送和接收都没有问题。
问题出现在使用Q replacation centre配置Q capture server时候,点击“administrator queue”后的按钮,弹出框就会一直在搜索,但是始终不能发现需要的队列,如图
在搜索过程中,192.168.244.128的db2diag.log报出如下日志:
2014-03-21-14.19.16.335595+480 I725409E1249 LEVEL: Error
PID : 4866 TID : 139678627784480PROC : db2fmp (
INSTANCE: db2inst3 NODE : 000
APPID : 192.168.244.129.37193.140321061829
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:80
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : Hex integer, 4 bytes
0x00000009
DATA #2 : String, 11 bytes
libmqm_r.so
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F09790F46FE pdOSSeLoggingCallback + 0x100
[1] 0x00007F0978777F46 /home/db2inst3/sqllib/lib64/libdb2osse.so.1 + 0x1D3F46
[2] 0x00007F0978779762 ossLog + 0xA6
[3] 0x00007F097878422B _ZN11OSSHLibrary4loadEPKcm + 0x1D3
[4] 0x00007F096DB8B3F5 _Z18Router_loadLibraryP6RouterPcS1_PKccPP11OSSHLibrary + 0x1D7
[5] 0x00007F096DB8B21C _Z24FunctionUtil_loadLibraryP8FunctionPcS1_PKccPP11OSSHLibrary + 0xA
[6] 0x00007F096DB9B5DA _Z25MQAccess_loadServerClientP13MQ_CFunctionsc + 0x6E
[7] 0x00007F096DB9B79C _Z16MQAccess_FMQCONNP13MQ_CFunctionsPcc + 0x14
[8] 0x00007F096DB991FC _Z13MQ_QM_connectP5MQ_QM + 0x4A8
[9] 0x00007F096DB9CE7A _Z15IMQ_Q_list_openP8Function + 0x286
2014-03-21-14.19.16.414893+480 I726659E1266 LEVEL: Error
PID : 4866 TID : 139678627784480PROC : db2fmp (
INSTANCE: db2inst3 NODE : 000
APPID : 192.168.244.129.37193.140321061829
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : String, 70 bytes
libmqm_r.so: cannot open shared object file: No such file or directory
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F09790F46FE pdOSSeLoggingCallback + 0x100
[1] 0x00007F0978777F46 /home/db2inst3/sqllib/lib64/libdb2osse.so.1 + 0x1D3F46
[2] 0x00007F0978779762 ossLog + 0xA6
[3] 0x00007F097878428F _ZN11OSSHLibrary4loadEPKcm + 0x237
[4] 0x00007F096DB8B3F5 _Z18Router_loadLibraryP6RouterPcS1_PKccPP11OSSHLibrary + 0x1D7
[5] 0x00007F096DB8B21C _Z24FunctionUtil_loadLibraryP8FunctionPcS1_PKccPP11OSSHLibrary + 0xA
[6] 0x00007F096DB9B5DA _Z25MQAccess_loadServerClientP13MQ_CFunctionsc + 0x6E
[7] 0x00007F096DB9B79C _Z16MQAccess_FMQCONNP13MQ_CFunctionsPcc + 0x14
[8] 0x00007F096DB991FC _Z13MQ_QM_connectP5MQ_QM + 0x4A8
[9] 0x00007F096DB9CE7A _Z15IMQ_Q_list_openP8Function + 0x286
2014-03-21-14.19.16.438511+480 I727926E1250 LEVEL: Error
PID : 4866 TID : 139678627784480PROC : db2fmp (
INSTANCE: db2inst3 NODE : 000
APPID : 192.168.244.129.37193.140321061829
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:80
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : Hex integer, 4 bytes
0x00000002
DATA #2 : String, 11 bytes
libmqm_r.so
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F09790F46FE pdOSSeLoggingCallback + 0x100
[1] 0x00007F0978777F46 /home/db2inst3/sqllib/lib64/libdb2osse.so.1 + 0x1D3F46
[2] 0x00007F0978779762 ossLog + 0xA6
[3] 0x00007F097878422B _ZN11OSSHLibrary4loadEPKcm + 0x1D3
[4] 0x00007F096DB8B3F5 _Z18Router_loadLibraryP6RouterPcS1_PKccPP11OSSHLibrary + 0x1D7
[5] 0x00007F096DB8B21C _Z24FunctionUtil_loadLibraryP8FunctionPcS1_PKccPP11OSSHLibrary + 0xA
[6] 0x00007F096DB9B6CE _Z25MQAccess_loadServerClientP13MQ_CFunctionsc + 0x162
[7] 0x00007F096DB9B79C _Z16MQAccess_FMQCONNP13MQ_CFunctionsPcc + 0x14
[8] 0x00007F096DB991FC _Z13MQ_QM_connectP5MQ_QM + 0x4A8
[9] 0x00007F096DB9CE7A _Z15IMQ_Q_list_openP8Function + 0x286
2014-03-21-14.19.16.438873+480 I729177E1267 LEVEL: Error
PID : 4866 TID : 139678627784480PROC : db2fmp (
INSTANCE: db2inst3 NODE : 000
APPID : 192.168.244.129.37193.140321061829
FUNCTION: DB2 Common, OSSe, OSSHLibrary::load, probe:90
MESSAGE : ECF=0x90000076=-1879048074=ECF_LIB_CANNOT_LOAD
Cannot load the specified library
DATA #1 : String, 70 bytes
libmqm_r.so: cannot open shared object file: No such file or directory
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F09790F46FE pdOSSeLoggingCallback + 0x100
[1] 0x00007F0978777F46 /home/db2inst3/sqllib/lib64/libdb2osse.so.1 + 0x1D3F46
[2] 0x00007F0978779762 ossLog + 0xA6
[3] 0x00007F097878428F _ZN11OSSHLibrary4loadEPKcm + 0x237
[4] 0x00007F096DB8B3F5 _Z18Router_loadLibraryP6RouterPcS1_PKccPP11OSSHLibrary + 0x1D7
[5] 0x00007F096DB8B21C _Z24FunctionUtil_loadLibraryP8FunctionPcS1_PKccPP11OSSHLibrary + 0xA
[6] 0x00007F096DB9B6CE _Z25MQAccess_loadServerClientP13MQ_CFunctionsc + 0x162
[7] 0x00007F096DB9B79C _Z16MQAccess_FMQCONNP13MQ_CFunctionsPcc + 0x14
[8] 0x00007F096DB991FC _Z13MQ_QM_connectP5MQ_QM + 0x4A8
[9] 0x00007F096DB9CE7A _Z15IMQ_Q_list_openP8Function + 0x286
内容为无法打开库文件libmqm_r.so。于是将db2的LD_LIBRARY_PATH路径新加了一条该文件所在目录/opt/mqm/lib,重启主机重新配置Q replacation centre,问题依然。
问题已经出现一天,急求解答,多谢!!!