20 million zookeeper Transaction Processing

Create Table Hotel
(
Name varchar (255 ),
Cardno varchar (255 ),
Descriot varchar (255 ),
Ctftp varchar (255 ),
Ctfid varchar (255 ),
Gender varchar (255 ),
Birthday varchar (0, 255 ),
Address varchar (255 ),
Zip varchar (1, 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 (1, 255 ),
Tel varchiar (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)
)

Batch import of DB2 command lines

Import from 'C: \ xinvoicemodel_20121203.csv 'of del

Insert_update into sndbusr. xinvoicemodel (field1, field2 ...);

Question? :

db2 => list tablesTable/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 =>

Solution:

Hi greenteco,
Unless you started the CLI with the-T option (changing the line terminator) the semicolon the end of the line is the problem.
Drop the semicolon. The command shocould work fine .)
Good luck,
Kent

 

Question? :

C: \ Program Files \ IBM \ sqllib \ bin> DB2 import from "F: \ hotel \ A-0001-200W.csv" of del insert into hotel
Sql310000n the utility is beginning to load data from File
"F: \ hotel \ A-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.

Solution:

When the transaction log of the database is full, increase the following database Parameters
Log File size (4 kb) (logfilsiz)
Number of Primary log files (logprimary)
Number of secondary log files (logsecond)

 

To modify the corresponding parameters, run the following command:

Update dB CFG [fordbname] Using <Parameter Name> <parameter value>

DB2 => Update dB CFG using logretain on

 

First Batch:

C: \ Program Files \ IBM \ sqllib \ bin> DB2 import from "F: \ hotel \ A-0001-200W.csv" of del insert into hotel
Sql310000n the utility is beginning to load data from File
"F: \ hotel \ A-0001-200W.csv ".

Sql3148w a row from the input file was not inserted into the table. sqlcode
"-302" was returned.

Sql0302n the value of a host variable in the execute or open statement is out
Of range for its corresponding use. sqlstate = 22001

Sql3185w the previous error occurred while processing data from row "799240"
Of the input file.

Sql3114w some data following "Chen" in row "936527" and column "1" was not
Loaded.

Sql3148w a row from the input file was not inserted into the table. sqlcode
"-302" was returned.

Sql0302n the value of a host variable in the execute or open statement is out
Of range for its corresponding use. sqlstate = 22001

Sql3185w the previous error occurred while processing data from row "1177644"
Of the input file.

Sql3148w a row from the input file was not inserted into the table. sqlcode
"-302" was returned.

Sql0302n the value of a host variable in the execute or open statement is out
Of range for its corresponding use. sqlstate = 22001

Sql3185w the previous error occurred while processing data from row "1541815"
Of the input file.

Sql3148w a row from the input file was not inserted into the table. sqlcode
"-302" was returned.

Sql0302n the value of a host variable in the execute or open statement is out
Of range for its corresponding use. sqlstate = 22001

Sql3185w the previous error occurred while processing data from row "1598633"
Of the input file.

Sql3148w a row from the input file was not inserted into the table. sqlcode
"-302" was returned.

Sql0302n the value of a host variable in the execute or open statement is out
Of range for its corresponding use. sqlstate = 22001

Sql3185w the previous error occurred while processing data from row "1727125"
Of the input file.

Sql3148w a row from the input file was not inserted into the table. sqlcode
"-302" was returned.

Sql0302n the value of a host variable in the execute or open statement is out
Of range for its corresponding use. sqlstate = 22001

Sql3185w the previous error occurred while processing data from row "1948313"
Of the input file.

Sql3110n the utility has completed processing. "2000094" rows were read from
The input file.

Sql3221w... begin commit work. Input record count = "2000094 ".

Sql3222w... commit of any database changes was successful.

Sql3149n "2000094" rows were processed from the input file. "2000088" rows
Were successfully inserted into the table. "6" rows were rejected.

Number of rows read = 2000094
Number of rows skipped = 0
Number of rows inserted = 2000088
Number of rows updated = 0
Number of rows rejected = 6
Number of rows committed = 2000094