银行Db2 10.5
[求助]db2-informix联邦
环境:
centos虚拟机 64位
db2 V10.5
informix 客户端:clientsdk.4.10.FC3DE.LINUX.tar.gz
问题描述:
在db2 V10.5的实例下,创建informix的wrapper的时候报错.
db2 "create wrapper wrinf library 'libdb2informix.so'"
------------------------------------------------------------------------------------------------------------------
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL10013N The specified library "libdb2informixF.so" could not be loaded.
SQLSTATE=42724
------------------------------------------------------------------------------------------------------------------
查看日志 db2diag -t 2014-08-21-10.16
------------------------------------------------------------------------------------------------------------------
2014-06-21-10.16.46.393091+480 E591241E770 LEVEL: Error (OS)
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: EINTR (4)
DATA #1 : Library name or path, 45 bytes
/home/db2inst/sqllib/lib64/libdb2informixF.so
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
0
DATA #3 : String, 72 bytes
/home/db2inst/sqllib/lib64/libdb2informixF.so: undefined symbol: frmcmpr
2014-06-21-10.16.46.411772+480 I592012E3717 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Common Trace API, sqlqg_call_sqloLoadModule, probe:50
MESSAGE : ZRC=0x870F009B=-2029059941=SQLO_MOD_LOAD_FAILED
"Dynamic library load failed."
DATA #1 : Hexdump, 18 bytes
0x00007F7FB3FF8B9C : 6C69 6264 6232 696E 666F 726D 6978 462E libdb2informixF.
0x00007F7FB3FF8BAC : 736F so
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F7FC79B8C8C _Z25sqlqg_call_sqloLoadModuleP16sqloModuleHandlePhib + 0x36C
[1] 0x00007F7FA42EF4BF _Z17CommonWrapperLoadbbP12Wrapper_Info + 0x2BF
[2] 0x00007F7FA42EFB33 FencedWrapper_Hook + 0x33
[3] 0x00007F7FC7A5D89C _Z21sqlqg_FMP_FindWrapperPhP17sqlqg_FMP_RequestPP13FencedWrapper + 0x41C
[4] 0x00007F7FC7A538EB _Z11sqlqgRouterP17sqlqg_FMP_RequestPP15sqlqg_FMP_ReplyP10sqlri_ufob + 0x37DB
[5] 0x00007F7FC7A11F92 _Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply + 0x422
[6] 0x00007F7FC7A02259 _Z15sqlqgVerifyLoadP15UnfencedWrapper + 0xB9
[7] 0x00007F7FC79E6A06 _Z20sqlqgRegisterWrapperP12Wrapper_InfoPS0_ + 0x166
[8] 0x00007F7FC73DFD2C _Z24sqlnq_create_wrapper_onePhjS_jP11option_pairP3loc + 0x44C
[9] 0x00007F7FC73DE8F6 _Z25sqlnq_create_wrapper_stmtPP8stknode_i10actiontypePhP3loc + 0x3C6
[10] 0x00007F7FC876DB0C _Z12sqlnp_smactnP8sqlnp_cbi + 0xA8C
[11] 0x00007F7FC4E4620F _Z12sqlnp_parserP8sqlnp_cb + 0x77F
[12] 0x00007F7FC4E4DB58 _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x278
[13] 0x00007F7FC4BBAAD4 /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x4155AD4
[14] 0x00007F7FC4BBA032 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_cmpl_env + 0x22
[15] 0x00007F7FC56CB7F6 _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP_LOCK_INFOP16sqlra_cached_varPi + 0x7D6
[16] 0x00007F7FC56DBD2D _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idjjPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOC + 0x7DD
[17] 0x00007F7FC572D3D5 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x775
[18] 0x00007F7FC57AD7D5 _Z21sqlri_ddl_get_sectionP8sqlrr_cb + 0x65
[19] 0x00007F7FC57ACC5B _Z16sqlri_ddl_commonP8sqlrr_cb + 0x39B
[20] 0x00007F7FC7D2A900 _Z14sqlri_djx_rddlP8sqlrr_cb + 0x50
[21] 0x00007F7FC880670C _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1CC
[22] 0x00007F7FC561C514 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x544
[23] 0x00007F7FC560DA7B _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x12B
[24] 0x00007F7FC4991A22 _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + 0x552
[25] 0x00007F7FC872E5B6 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x3F6
[26] 0x00007F7FC872E97C _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x36C
[27] 0x00007F7FC496984A /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x3F0484A
[28] 0x00007F7FC4967E09 /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x3F02E09
[29] 0x00007F7FC4964E89 /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x3EFFE89
[30] 0x00007F7FC4964A7B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xEB
[31] 0x00007F7FC4690351 _ZN8sqeAgent6RunEDUEv + 0x8B1
[32] 0x00007F7FC5BF3724 _ZN9sqzEDUObj9EDUDriverEv + 0xF4
[33] 0x00007F7FC545B337 sqloEDUEntry + 0x2F7
[34] 0x00007F7FCCE2E851 /lib64/libpthread.so.0 + 0x7851
[35] 0x00007F7FBF8C290D clone + 0x6D
2014-06-21-10.16.46.608317+480 I595730E768 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Query Gateway, CommonWrapperLoad, probe:20
MESSAGE : ZRC=0x870F009B=-2029059941=SQLO_MOD_LOAD_FAILED
"Dynamic library load failed."
DATA #1 : String, 26 bytes
Unable to load the library
DATA #2 : Hexdump, 18 bytes
0x00007F7FB3FF8B9C : 6C69 6264 6232 696E 666F 726D 6978 462E libdb2informixF.
0x00007F7FB3FF8BAC : 736F so
2014-06-21-10.16.46.608606+480 I596499E486 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_FMP_FindWrapper, probe:120
MESSAGE : Wrapper object is not hooked up
2014-06-21-10.16.46.608749+480 I596986E684 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqgRouter, probe:689
MESSAGE : ZRC=0x80260160=-2144992928=SQLQG_ERROR "Error constant for gateway."
DATA #1 : String, 43 bytes
Unable to load the fencible wrapper library
DATA #2 : Hexdump, 8 bytes
0x00007F7FA4659E80 : 5752 494E 4600 0000
------------------------------------------------------------------------------------------------------------------
libdb2informixF.so是用djxlinkInformix创建的,创建时没有发生错误.
已查看相关动态库以及informix的客户端库文件所在路径都是775
不知道各路高手有没有遇到过这个问题.
centos虚拟机 64位
db2 V10.5
informix 客户端:clientsdk.4.10.FC3DE.LINUX.tar.gz
问题描述:
在db2 V10.5的实例下,创建informix的wrapper的时候报错.
db2 "create wrapper wrinf library 'libdb2informix.so'"
------------------------------------------------------------------------------------------------------------------
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL10013N The specified library "libdb2informixF.so" could not be loaded.
SQLSTATE=42724
------------------------------------------------------------------------------------------------------------------
查看日志 db2diag -t 2014-08-21-10.16
------------------------------------------------------------------------------------------------------------------
2014-06-21-10.16.46.393091+480 E591241E770 LEVEL: Error (OS)
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, oper system services, sqloLoadModule, probe:190
CALLED : OS, -, dlopen OSERR: EINTR (4)
DATA #1 : Library name or path, 45 bytes
/home/db2inst/sqllib/lib64/libdb2informixF.so
DATA #2 : shared library load flags, PD_TYPE_LOAD_FLAGS, 4 bytes
0
DATA #3 : String, 72 bytes
/home/db2inst/sqllib/lib64/libdb2informixF.so: undefined symbol: frmcmpr
2014-06-21-10.16.46.411772+480 I592012E3717 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Common Trace API, sqlqg_call_sqloLoadModule, probe:50
MESSAGE : ZRC=0x870F009B=-2029059941=SQLO_MOD_LOAD_FAILED
"Dynamic library load failed."
DATA #1 : Hexdump, 18 bytes
0x00007F7FB3FF8B9C : 6C69 6264 6232 696E 666F 726D 6978 462E libdb2informixF.
0x00007F7FB3FF8BAC : 736F so
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0x00007F7FC79B8C8C _Z25sqlqg_call_sqloLoadModuleP16sqloModuleHandlePhib + 0x36C
[1] 0x00007F7FA42EF4BF _Z17CommonWrapperLoadbbP12Wrapper_Info + 0x2BF
[2] 0x00007F7FA42EFB33 FencedWrapper_Hook + 0x33
[3] 0x00007F7FC7A5D89C _Z21sqlqg_FMP_FindWrapperPhP17sqlqg_FMP_RequestPP13FencedWrapper + 0x41C
[4] 0x00007F7FC7A538EB _Z11sqlqgRouterP17sqlqg_FMP_RequestPP15sqlqg_FMP_ReplyP10sqlri_ufob + 0x37DB
[5] 0x00007F7FC7A11F92 _Z21sqlqg_Call_FMP_ThreadP17sqlqg_FMP_RequestPP15sqlqg_FMP_Reply + 0x422
[6] 0x00007F7FC7A02259 _Z15sqlqgVerifyLoadP15UnfencedWrapper + 0xB9
[7] 0x00007F7FC79E6A06 _Z20sqlqgRegisterWrapperP12Wrapper_InfoPS0_ + 0x166
[8] 0x00007F7FC73DFD2C _Z24sqlnq_create_wrapper_onePhjS_jP11option_pairP3loc + 0x44C
[9] 0x00007F7FC73DE8F6 _Z25sqlnq_create_wrapper_stmtPP8stknode_i10actiontypePhP3loc + 0x3C6
[10] 0x00007F7FC876DB0C _Z12sqlnp_smactnP8sqlnp_cbi + 0xA8C
[11] 0x00007F7FC4E4620F _Z12sqlnp_parserP8sqlnp_cb + 0x77F
[12] 0x00007F7FC4E4DB58 _Z10sqlnp_mainP12sqlnq_stringbP3locPP9sqlnq_qur + 0x278
[13] 0x00007F7FC4BBAAD4 /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x4155AD4
[14] 0x00007F7FC4BBA032 _Z10sqlnn_cmplP8sqeAgentP11sqlrrstrings17sqlnn_compileModesP14sqlrr_cmpl_env + 0x22
[15] 0x00007F7FC56CB7F6 _Z17sqlra_compile_varP8sqlrr_cbP14sqlra_cmpl_envPhitiiiiiP14SQLP_LOCK_INFOP16sqlra_cached_varPi + 0x7D6
[16] 0x00007F7FC56DBD2D _Z14sqlra_find_varP8sqlrr_cbP17sqlra_cached_stmt13sqlra_stmt_idjjPhjthP14sqlra_cmpl_env15sqlra_fill_modePiiS8_iiiS8_P14SQLP_LOC + 0x7DD
[17] 0x00007F7FC572D3D5 _Z13sqlra_get_varP8sqlrr_cbiibPbS1_ + 0x775
[18] 0x00007F7FC57AD7D5 _Z21sqlri_ddl_get_sectionP8sqlrr_cb + 0x65
[19] 0x00007F7FC57ACC5B _Z16sqlri_ddl_commonP8sqlrr_cb + 0x39B
[20] 0x00007F7FC7D2A900 _Z14sqlri_djx_rddlP8sqlrr_cb + 0x50
[21] 0x00007F7FC880670C _Z15sqlriSectInvokeP8sqlrr_cbP12sqlri_opparm + 0x1CC
[22] 0x00007F7FC561C514 _Z23sqlrr_execute_immediateP8sqlrr_cbi + 0x544
[23] 0x00007F7FC560DA7B _Z14sqlrr_execimmdP14db2UCinterfaceP16db2UCprepareInfo + 0x12B
[24] 0x00007F7FC4991A22 _Z19sqljs_ddm_excsqlimmP14db2UCinterfaceP13sqljDDMObject + 0x552
[25] 0x00007F7FC872E5B6 _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UCinterface + 0x3F6
[26] 0x00007F7FC872E97C _Z10sqljsParseP13sqljsDrdaAsCbP14db2UCinterfaceP8sqeAgentb + 0x36C
[27] 0x00007F7FC496984A /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x3F0484A
[28] 0x00007F7FC4967E09 /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x3F02E09
[29] 0x00007F7FC4964E89 /home/db2inst/sqllib/lib64/libdb2e.so.1 + 0x3EFFE89
[30] 0x00007F7FC4964A7B _Z17sqljsDrdaAsDriverP18SQLCC_INITSTRUCT_T + 0xEB
[31] 0x00007F7FC4690351 _ZN8sqeAgent6RunEDUEv + 0x8B1
[32] 0x00007F7FC5BF3724 _ZN9sqzEDUObj9EDUDriverEv + 0xF4
[33] 0x00007F7FC545B337 sqloEDUEntry + 0x2F7
[34] 0x00007F7FCCE2E851 /lib64/libpthread.so.0 + 0x7851
[35] 0x00007F7FBF8C290D clone + 0x6D
2014-06-21-10.16.46.608317+480 I595730E768 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Query Gateway, CommonWrapperLoad, probe:20
MESSAGE : ZRC=0x870F009B=-2029059941=SQLO_MOD_LOAD_FAILED
"Dynamic library load failed."
DATA #1 : String, 26 bytes
Unable to load the library
DATA #2 : Hexdump, 18 bytes
0x00007F7FB3FF8B9C : 6C69 6264 6232 696E 666F 726D 6978 462E libdb2informixF.
0x00007F7FB3FF8BAC : 736F so
2014-06-21-10.16.46.608606+480 I596499E486 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqg_FMP_FindWrapper, probe:120
MESSAGE : Wrapper object is not hooked up
2014-06-21-10.16.46.608749+480 I596986E684 LEVEL: Error
PID : 2265 TID : 140186457466624 PROC : db2sysc 0
INSTANCE: db2inst NODE : 000 DB : DWDB
APPHDL : 0-7 APPID: *LOCAL.db2inst.140621021637
AUTHID : DB2INST HOSTNAME: centosbase
EDUID : 22 EDUNAME: db2agent (DWDB) 0
FUNCTION: DB2 UDB, Query Gateway, sqlqgRouter, probe:689
MESSAGE : ZRC=0x80260160=-2144992928=SQLQG_ERROR "Error constant for gateway."
DATA #1 : String, 43 bytes
Unable to load the fencible wrapper library
DATA #2 : Hexdump, 8 bytes
0x00007F7FA4659E80 : 5752 494E 4600 0000
------------------------------------------------------------------------------------------------------------------
libdb2informixF.so是用djxlinkInformix创建的,创建时没有发生错误.
已查看相关动态库以及informix的客户端库文件所在路径都是775
不知道各路高手有没有遇到过这个问题.