blogger

    blogger
  • hot log

  • comment

    twitter

    • 12.10.xC6出来时候碰到"Could not determine encryption mode from page zero",竟果然是BUG!http://www-01.ibm.com/support/docview.wss?rs=630&uid=swg21973408

      2015-12-21 20:15

    • 空间已经转移到新加坡,希望会好一些。

      2015-11-16 14:34

    • 增加新域名liaosnet.cc,与liaosnet.com同指向。

      2015-10-09 15:25

    • 空间迁移到香港。或许速度会快一点。。

      2014-02-13 20:10

    • 解决个问题:NBU配置Storage时的目录在系统分区上,导致备份失败,最终原因是目录在系统分区上时,需要在 This directory can exist on the root file system or system disk. 这个选项前打上勾。

      2012-09-26 22:21

    • More»

    blog sort

    links

    record

    banner

    informix HPL导入失败

    暗夜星空's Memory from Dec 23 , 2015 at 15:17 PM , under Category:INFORMIX
    操作系统: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

    Post a comment:

    Your email address will not be published. Required fields are marked﹡