远程load 加lobs from报错

For Remote LOAD, you have to copy or mount LOBS FROM or XML FROM directory to the remote DB2 server otherwise LOAD will fail.收起

回复 13# kld208


    你把路径写全试试。收起

回复 7# weiruan85


   兄弟，帮忙看下应该如何处理呢，谢谢！收起

回复 10# kld208


   兄弟，帮忙看下应该如何处理呢，谢谢收起

各位有知道啥原因的不，多谢了收起

回复 7# weiruan85


   不好意思，刚才语句执行失败了。
SQL3126N  Remote client requires absolute path for files and directories.收起

回复 7# weiruan85

我之前发的语句，只要去掉“del lobs from /home/umipdata/data/dbbak/20140702/”是可以导入的，加上就报错。

  db2 "load client  from /home/umipdata/data/dbbak/20140702/UMIPDATA_PUB_BAK_STATUS.del of del lobs from /home/umipdata/data/dbbak/20140702/  modified by codepage=1386 NOROWWARNINGS dumpfile=M:/logs/20140805/dump//UMIPDATA_PUB_BAK_STATUS.rej coldel0x03 keepblanks nochardel usedefaults  lobsinfile  messages /home/umipdata/log/dbbak/20140805/msg//msg.load.UMIPDATA_PUB_BAK_STATUS  insert into UMIPDATA.PUB_BAK_STATUS    data buffer 1000"收起

回复 7# weiruan85

执行成功
Number of rows read         = 1Number of rows skipped      = 0
Number of rows loaded       = 0
Number of rows rejected     = 1
Number of rows deleted      = 0
Number of rows committed    = 1收起

cd  /home/umipdata/data/dbbak/20140702/

db2 "load client  from UMIPDATA_PUB_BAK_STATUS.del of del lobs from  .   modified by codepage=1386  sert into UMIPDATA.PUB_BAK_STATUS   "

试试，把结果贴一下。收起

LOBS FROM lob-path
    The path to the data files containing LOB values to be loaded. The path must end with a slash. If the CLIENT option is specified, the path must be fully qualified. The names of the LOB data files are stored in the main data file (ASC, DEL, or IXF), in the column that will be loaded into the LOB column. The maximum number of paths that can be specified is 999. This will implicitly activate the LOBSINFILE behavior.

    This option is ignored when specified in conjunction with the CURSOR file type.收起