各位专家,我在一个数据库中导出了按行存储的表的数据,然后导入另一个库中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
请专家予以指点啊!
错误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)是否存在,有无访问权限。