CMN_1022 : Database driver error [informatica访问informix出错]

初级会员 注册时间: 2009-06-08 23:19:48 文章: 7 离线

CMN_1022 : Database driver error [informatica访问informix出错]
系统环境
hp ux 11.11 (64bit)
oracle 10204
informix 9.4
power center 8.6.1

用informatica用户安装的informatica,但是是用oracle启动的informatica。
informix用户安装informix

现在想采用native connection的方式访问informix，来读取数据load到oracle库。
步骤是这样的。
1.在xp上安装informix client sdk 2.9。
2.设置好ODBC，测试连接hpux端的informix成功。
3.本机装了oracle，所以可以访问hpux端的oracle。
4.打开PC,配置好source,target,mapping
5.在workflow设置connection.
a)打开connection->relational
informatica_connection002.jpg (25.36 KB)
2009-11-16 17:05

b)点击new,选择informix
informatica_connection003.jpg (15.93 KB)
2009-11-16 17:05

c)输入hpux上informix的相关信息
informatica_connection015.jpg (36.24 KB)
2009-11-16 17:05

d)在Edit Tasks对话框下的Mapping栏，设置source为刚才新建的连接
informatica_connection007.jpg (73.51 KB)
2009-11-16 17:05

e)设置Target为oracle的链接，并设置。

f)运行
得到下面的错误：
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6228 : Writing session output to log file [/info/ifma/server/infa_shared/SessLogs/test1.log].
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6014 : Initializing session [test1] at [Tue May 05 00:48:42 2009].
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6683 : Repository Name: [new_rep1]
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6684 : Server Name: [new_int1]
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6686 : Folder: [Tuto]
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6685 : Workflow: [test1] Run Instance Name: [] Run Id: [4]
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6101 : Mapping name: test1.
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6964 : Date format for the Session is [MM/DD/YYYY HH24:MI:SS.US]
2009-05-05 14:48:42 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6703 : Session [test1] is run by 64-bit Integration Service [New_node01_HP2000], version [8.6.1], build [1217].
2009-05-05 14:48:42 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24058 : Running Partition Group [1].
2009-05-05 14:48:42 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24000 : Parallel Pipeline Engine initializing.
2009-05-05 14:48:42 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24001 : Parallel Pipeline Engine running.
2009-05-05 14:48:42 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24003 : Initializing session run.
2009-05-05 14:48:42 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : CMN_1569 : Server Mode: [UNICODE]
2009-05-05 14:48:42 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : CMN_1570 : Server Code page: [MS Windows Simplified Chinese, superset of GB 2312-80, EUC encoding]
2009-05-05 14:48:42 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6151 : The session sort order is [Binary].
2009-05-05 14:48:42 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6156 : Using low precision processing.
2009-05-05 14:48:42 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6180 : Deadlock retry logic will not be implemented.
2009-05-05 14:48:43 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6307 : DTM error log disabled.
2009-05-05 14:48:43 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TE_7022 : TShmWriter: Initialized
2009-05-05 14:48:43 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6007 : DTM initialized successfully for session [test1]
2009-05-05 14:48:43 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : PETL_24033 : All DTM Connection Info: [<NONE>].
2009-05-05 14:48:43 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24004 : PETL_24004 Starting pre-session tasks. : (Tue May 05 00:48:43 2009)
2009-05-05 14:48:43 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24027 : PETL_24027 Pre-session task completed successfully. : (Tue May 05 00:48:43 2009)
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : PETL_24006 : Starting data movement.
2009-05-05 14:48:44 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6660 : Total Buffer Pool size is 609824 bytes and Block size is 65536 bytes.
2009-05-05 14:48:44 : INFO : (16037 | READER_1_1_1) : (IS | new_int1) : New_node01_HP2000 : DBG_21438 : Reader: Source is [dme@demo_on], user [informix]
2009-05-05 14:48:44 : ERROR : (16037 | READER_1_1_1) : (IS | new_int1) : New_node01_HP2000 : CMN_1022 : Database driver error...
CMN_1022 [Database driver event...Error occurred loading library [Unable to find library 'libpminf.sl'.]Database driver event...Error occurred loading library [libpminf.sl]]

2009-05-05 14:48:44 : ERROR : (16037 | READER_1_1_1) : (IS | new_int1) : New_node01_HP2000 : BLKR_16002 : ERROR: Initialization failed.
2009-05-05 14:48:44 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24031 :
***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
Thread [READER_1_1_1] created for [the read stage] of partition point [SQ_test2] has completed. The total run time was insufficient for any meaningful statistics.

2009-05-05 14:48:44 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24005 : PETL_24005 Starting post-session tasks. : (Tue May 05 00:48:44 2009)
2009-05-05 14:48:44 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24029 : PETL_24029 Post-session task completed successfully. : (Tue May 05 00:48:44 2009)
2009-05-05 14:48:44 : INFO : (16037 | MAPPING) : (IS | new_int1) : New_node01_HP2000 : TM_6018 : The session completed with [0] row transformation errors.
2009-05-05 14:48:44 : INFO : (16037 | MANAGER) : (IS | new_int1) : New_node01_HP2000 : PETL_24002 : Parallel Pipeline Engine finished.
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : PETL_24013 : Session run completed with failure.
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6022 :

SESSION LOAD SUMMARY
================================================

2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6252 : Source Load Summary.
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : CMN_1740 : Table: [SQ_test2] (Instance Name: [SQ_test2])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6253 : Target Load Summary.
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : CMN_1740 : Table: [TEST2_INMX_ORA] (Instance Name: [TEST2_INMX_ORA])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6023 :
===================================================

2009-05-05 14:48:44 : INFO : (16037 | DIRECTOR) : (IS | new_int1) : New_node01_HP2000 : TM_6020 : Session [test1] completed at [Tue May 05 00:48:44 2009].

我尝试过了，给informix的安装目录都设置chmod -R a+r *和chmod -R a+x *，但是还是不行。。

[root@:/]#find / -name libpminf
[root@:/]#
运行find.也没找到libpminf.....
谁能帮我看看哪的问题？