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