二千万のホテルデータ処理

CREATE TABLE Hotel
(
Name varchar(255),
CardNo varchar(255),
Descriot varchar(255),
CtfTp varchar(255),
CtfId varchar(255),
Gender varchar(255),
Birthday varchar(255),
Address varchar(255),
Zip varchar(255),
Dirty varchar(255),
District1 varchar(255),
District2 varchar(255),
District3 varchar(255),
District4 varchar(255),
District5 varchar(255),
District6 varchar(255),
FirstNm varchar(255),
LastNm varchar(255),
Duty varchar(255),
Mobile varchar(255),
Tel varchar(255),
Fax varchar(255),
EMail varchar(255),
Nation varchar(255),
Taste varchar(255),
Education varchar(255),
Company varchar(255),
CAddress varchar(255),
CZip varchar(255),
Family varchar(255),
Version varchar(255),
id varchar(255)
)

db2命令行批量导入

IMPORT FROM 'C:XINVOICEMODEL_20121203.CSV' OF DEL

INSERT_UPDATE INTO SNDBUSR.XINVOICEMODEL(field1, field2...);

問題❶：

db2 => list tables

Table/View                      Schema          Type  Creation time
------------------------------- --------------- ----- --------------------------
CATALOG                         DB2INST1        T     2011-10-21-16.35.38.068444

  1 record(s) selected.

db2 => IMPORT FROM IMPORT.csv OF DEL INSERT INTO CATALOG;
SQL3035N  The tablename parameter in the target specification is not valid.

db2 =>

解決策：

Hi Greensburo,
Unless you started the CLI with the -t option (changing the line terminator) the semicolon on the end of the line is the problem.
Drop the semicolon. The command should work fine.（セミロンを削除すると、できるになりました。）
Good Luck,
Kent

問題❷：

C:Program FilesIBMSQLLIBBIN>db2 import from "F:hotelA-0001-200W.csv" OF DEL INSERT INTO HOTEL
SQL3109N The utility is beginning to load data from file
"F:hotelA-0001-200W.csv".

SQL3306N An SQL error "-964" occurred while inserting a row into the table.

SQL0964C The transaction log for the database is full. SQLSTATE=57011

SQL3110N The utility has completed processing. "122394" rows were read from
the input file.

解決策：

数据库的事务日志满了，调大以下几个数据库参数
Log file size (4KB)                         (LOGFILSIZ)
Number of primary log files                (LOGPRIMARY)
Number of secondary log files               (LOGSECOND)

修改对应的参数，使用命令：

update db cfg [fordbname] using <参数名> <参数值>

db2 => update db cfg using logretain on

第一批：

C:Program FilesIBMSQLLIBBIN>db2 import from "F:hotelA-0001-200W.csv" OF DEL INSERT INTO HOTEL
SQL3109N The utility is beginning to load data from file
"F:hotelA-0001-200W.csv".