1. Сгенерил файл на 15М (>6GB)
2. Очистил db2dump каталог
3. Создал табличку с compress yes
4. Запустил load...
-------------------------------------------------------
hunterik@lodge:~$ ls -la /tmp/loadf.del
-rw-r--r-- 1 db2inst1 db2iadm1 6258105099 Aug 11 12:05 /tmp/loadf.del
-------------------------------------------------------
db2inst1@lodge:~/sqllib/db2dump$ tail -f /home/db2inst1/sqllib/db2dump/db2diag.log
2012-08-11-13.08.20.791063-240 I24040G578 LEVEL: Warning
PID : 7630 TID : 2864704368 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.120811170318
AUTHID : DB2INST1 HOSTNAME: lodge
EDUID : 40 EDUNAME: db2lfrm0
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 118 bytes
LOADID: 37.2012-08-11-13.08.20.074974.0 (3;5)
Starting LOAD phase at 08/11/2012 13:08:20.689390. Table TEST .TEST
2012-08-11-13.12.23.278649-240 I24619G557 LEVEL: Warning
PID : 7630 TID : 1035987824 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.120811170318
AUTHID : DB2INST1 HOSTNAME: lodge
EDUID : 43 EDUNAME: db2lrid
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 99 bytes
LOADID: 37.2012-08-11-13.08.20.074974.0 (3;5)
Completed LOAD phase at 08/11/2012 13:12:23.278135.
2012-08-11-13.12.23.279865-240 I25177G557 LEVEL: Warning
PID : 7630 TID : 1035987824 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.120811170318
AUTHID : DB2INST1 HOSTNAME: lodge
EDUID : 43 EDUNAME: db2lrid
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 99 bytes
LOADID: 37.2012-08-11-13.08.20.074974.0 (3;5)
Starting BUILD phase at 08/11/2012 13:12:23.278899.
2012-08-11-13.12.32.644715-240 I25735G559 LEVEL: Warning
PID : 7630 TID : 1035987824 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.120811170318
AUTHID : DB2INST1 HOSTNAME: lodge
EDUID : 43 EDUNAME: db2lrid
FUNCTION: DB2 UDB, database utilities, sqlulPrintPhaseMsg, probe:314
DATA #1 : String, 100 bytes
LOADID: 37.2012-08-11-13.08.20.074974.0 (3;5)
Completed BUILD phase at 08/11/2012 13:12:32.643348.
2012-08-11-13.12.32.894250-240 I26295G583 LEVEL: Warning
PID : 7630 TID : 2867850096 PROC : db2sysc
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-18 APPID: *LOCAL.db2inst1.120811170318
AUTHID : DB2INST1 HOSTNAME: lodge
EDUID : 37 EDUNAME: db2agent (SAMPLE)
FUNCTION: DB2 UDB, database utilities, sqluvtld_route_in, probe:1331
DATA #1 : LOADID, PD_TYPE_LOADID, 45 bytes
LOADID: 37.2012-08-11-13.08.20.074974.0 (3;5)
DATA #2 : String, 25 bytes
Completed LOAD operation.
-----------------------------------------
db2inst1@lodge:~/sqllib/db2dump$ db2 "load from /tmp/loadf.del of DEL modified by codepage=1208 coldel| method P(1,2,3,4,5,6) savecount 100000 messages /tmp/load.out insert into test.test (id,full_name,gender,somedate,dsc,someint) data buffer 256000 sort buffer 256000 cpu_parallelism 2 indexing mode rebuild"
Number of rows read = 15000000
Number of rows skipped = 0
Number of rows loaded = 14941205
Number of rows rejected = 58795
Number of rows deleted = 0
Number of rows committed = 15000000
SQL3107W At least one warning message was encountered during LOAD processing.
------------------------------------------
db2inst1@lodge:~/sqllib/db2dump$ db2 "select count(1) from test.test"
1
-----------
14941205
1 record(s) selected.
-----------------------------------------------
db2inst1@lodge:~/sqllib/db2dump$ cat /tmp/load.out | more
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 "/tmp/loadf.del".
SQL3500W The utility is beginning the "LOAD" phase at time "08/11/2012
12:34:16.650132".
SQL3519W Begin Load Consistency Point. Input record count = "0".
SQL3520W Load Consistency Point was successful.
SQL3116W The field value in row "F1-75" and column "2" is missing, but the
target column is not nullable.
SQL3185W The previous error occurred while processing data from row "F1-75"
of the input file.
SQL3227W Record token "F1-75" refers to user record number "149".
....
---------------------------------------
db2inst1@lodge:~/sqllib/db2dump$ db2 describe table test.test
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
ID SYSIBM INTEGER 4 0 No
FULL_NAME SYSIBM VARCHAR 256 0 No
GENDER SYSIBM CHARACTER 1 0 No
SOMEDATE SYSIBM DATE 4 0 No
DSC SYSIBM VARCHAR 512 0 Yes
SOMEINT SYSIBM INTEGER 4 0 No
6 record(s) selected.
--------------------------------------
ID при создании задавался, как not null primary key.
--------------------------------------------------------------------------
Работает, вроде бы...
