informix HPL导入失败

操作系统:RHEL 6U4 64bit
数据库版本:Informix 12.10.FC6X5

使用HPL(onpladm)导入表数据时,报错

[informix@rhel6u4 tmp]$  onpladm run job tt_flu -fl
Connecting to onpload, Please wait...
Successful connection to onpload established 
Wed Dec 16 18:52:11 2015

SHMBASE        0x0000000044000000
CLIENTNUM      0x0000000049010000
Session ID 3

Load Database   -> testdb
Load Table      -> tt
Device Array    -> tt_flu
Record Mapping  -> tt_flu
Convert Reject  -> /tmp/tt_flu.rej
Filter Reject   -> /tmp/tt_flu.flt
Set mode of index ix_tt to disabled
Error occured at HPL failpoint: 19111
Fatal error getting stream buffer from server
Error occured at HPL failpoint: 10561
Reset mode of indexes "informix".ix_tt to original enabled mode

Database Load Completed -- Processed 0 Records
Records Inserted-> 0
Detected Errors--> 0
Engine Rejected--> 0

Wed Dec 16 18:52:14 2015

Job Completed Unsuccessfully ... connection closed

这时,需要设置环境变量PLOAD_SHMBASE及IFX_XFER_SHMBASE,并重启数据库

PLOAD_SHMBASE=0x000004000000000 
IFX_XFER_SHMBASE=0x000005000000000

重启数据库后可正常执行onpladm进行导入操作。

[informix@rhel6u4 tmp]$  onpladm run job tt_flu -fl
Connecting to onpload, Please wait...
Successful connection to onpload established 
Wed Dec 16 18:53:40 2015

SHMBASE        0x0000004000000000
CLIENTNUM      0x0000000049010000
Session ID 3

Load Database   -> testdb
Load Table      -> tt
Device Array    -> tt_flu
Record Mapping  -> tt_flu
Convert Reject  -> /tmp/tt_flu.rej
Filter Reject   -> /tmp/tt_flu.flt
Set mode of index ix_tt to disabled
Reset mode of indexes "informix".ix_tt to original enabled mode
Table 'tt' will be read-only until level 0 archive

Database Load Completed -- Processed 2 Records
Records Inserted-> 2
Detected Errors--> 0
Engine Rejected--> 0

Wed Dec 16 18:53:44 2015

Job Completed Successfully ... connection closed

参考:http://www-01.ibm.com/support/docview.wss?uid=swg21683918

标签: none

添加新评论