互联网服务Db2数据库

DB2 BLU表如何使用LOAD和INGEST导入数据?

各位专家,我在一个数据库中导出了按行存储的表的数据,然后导入另一个库中BLU表中,目前只能用import导入陈工,我用LOAD和INGEST都不成功,请问我如何使用LOAD和INGEST导入数据?另外我在DB2 V10.5的库中建了一个行式存储的表,用LOAD也导不进去数据。不知道为什么?V10.5的load语法有变化么?还是为什么的?
以下是INGEST的错误:

db2 => ingest from file ODS_ACPS_CUPSCOMNINFO201511.del format delimited(
db2 (cont.) => $CHKDATE       VARCHAR(10) ,
db2 (cont.) => $ACCPBANK      VARCHAR(11) ,
db2 (cont.) => $SENDBANK      VARCHAR(11) ,
db2 (cont.) => $SYSSERNO      VARCHAR(6)  ,
db2 (cont.) => $THIRDSYSTIME  VARCHAR(10),  
db2 (cont.) => $FILETYPE      VARCHAR(5) ,  
db2 (cont.) => $CITYID        VARCHAR(4),  
db2 (cont.) => $MERTYPE       VARCHAR(4),  
db2 (cont.) => $MERID         VARCHAR(15),
db2 (cont.) => $RECEIVEDATE   VARCHAR(8),  
db2 (cont.) => $LST_AMD_DT    DATE     ,   
db2 (cont.) => $LST_AMD_TM    TIMESTAMP 'YYYY',   
db2 (cont.) => $PAYERACC      VARCHAR(19))
db2 (cont.) => restart off insert into ODS_ACPS_CUPSCOMNINFO201511  (
db2 (cont.) => $CHKDATE       ,
db2 (cont.) => $ACCPBANK      ,
db2 (cont.) => $SENDBANK      ,
db2 (cont.) => $SYSSERNO      ,
db2 (cont.) => $THIRDSYSTIME  ,
db2 (cont.) => $FILETYPE      ,
db2 (cont.) => $CITYID        ,
db2 (cont.) => $MERTYPE       ,
db2 (cont.) => $MERID         ,
db2 (cont.) => $RECEIVEDATE   ,
db2 (cont.) => $LST_AMD_DT    ,
db2 (cont.) => $LST_AMD_TM    ,
db2 (cont.) => $PAYERACC);
SQL2923N  The ingest utility failed because the following invalid field type
was specified: "VARCHAR"
SQL2902I  The ingest utility completed at timestamp "2016-03-07
19:08:48.327361". Number of errors: "1". Number of warnings: "0".

以下是我用load导入一个按行存储的表,也进不去:

[ngcms@ngcms1 ~]$ db2 "load from /home/ngcms/ODS_ACPS_CUPSCOMNINFO201511.del of del insert into ODS_ACPS_CUPSCOMNINFO201511_TMP"
SQL3501W  The table space(s) in which the table resides will not be placed in
backup pending state since forward recovery is disabled for the database.

SQL3109N  The utility is beginning to load data from file
"/home/ngcms/ODS_ACPS_CUPSCOMNINFO201511.del".

SQL2036N  The path for the file, named pipe, or device
"/home/ngcms/ODS_ACPS_CUPSCOMNINFO201511.del" is not valid.

SQL3107W  At least one warning message was encountered during LOAD processing.


Number of rows read         = 0
Number of rows skipped      = 0
Number of rows loaded       = 0
Number of rows rejected     = 0
Number of rows deleted      = 0
Number of rows committed    = 0

请专家予以指点啊!

参与3

1同行回答

disizhishoudisizhishou研发工程师IBM
错误1: SQL2923N  The ingest utility failed because the following invalid field type was specified: \"VARCHAR\"==>  把里面所有的VARCHAR改成 CHAR, field type不支持 varchar, 见信息中心: http://www.ibm.com/support/knowledgecenter/SSEPGG_...显示全部

错误1:

SQL2923N  The ingest utility failed because the following invalid field type

was specified: \"VARCHAR\"

==>  把里面所有的VARCHAR改成 CHAR, field type不支持 varchar, 见信息中心: http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0057198.html?lang=en


错误2:

SQL2036N  The path for the file, named pipe, or device

\"/home/ngcms/ODS_ACPS_CUPSCOMNINFO201511.del\" is not valid.

==> 检查下该文件路径(/home/ngcms/ODS_ACPS_CUPSCOMNINFO201511.del)是否存在,有无访问权限。

收起
软件开发 · 2016-03-07
浏览1555

提问者

houhailiang2007
数据库架构师北京银丰
擅长领域: 数据库关系型数据库存储

相关问题

相关资料

相关文章

问题状态

  • 发布时间:2016-03-07
  • 关注会员:2 人
  • 问题浏览:3510
  • 最近回答:2016-03-07
  • X社区推广