Download Up and Running DB2 on Linux

6899ch06.fm
Draft Document for Review April 17, 2008 2:10 pm
______________________________________________________________________________
LOAD_TO_FILE 001
+00000000
Success.
______________________________________________________________________________
PARTITION
000
+00000000
Success.
______________________________________________________________________________
PARTITION
001
+00000000
Success.
______________________________________________________________________________
PRE_PARTITION 000
+00000000
Success.
______________________________________________________________________________
Summary of Partitioning Agents:
Rows Read
= 3000000
Rows Rejected
= 0
Rows Partitioned
= 3000000
db2inst1@mensa:/db2backup/datamove> db2 "select count(*) from
db2inst1.itemload"
1
----------0
1 record(s) selected.
db2inst1@mensa:/db2backup/datamove/load> ls -la
total 27348
drwxr-xr-x 2 db2inst1 db2iadm1
4096 2008-02-11 11:32 .
drwxr-xr-x 4 db2inst1 db2iadm1
4096 2008-02-11 11:30 ..
-rw-r----- 1 db2inst1 db2iadm1 27959550 2008-02-11 11:32 item.del.000
db2inst1@mensa:/db2backup/datamove> db2_all "ls -la /db2backup/datamove/load"
total 27348
drwxr-xr-x 2 db2inst1 db2iadm1
4096 2008-02-11 11:32 .
drwxr-xr-x 4 db2inst1 db2iadm1
4096 2008-02-11 11:30 ..
-rw-r----- 1 db2inst1 db2iadm1 27959550 2008-02-11 11:32 item.del.000
mensa: ls -la /db2backup/datamove/load completed ok
total 27332
drwxr-xr-x 2 db2inst1 db2iadm1
4096
drwxr-xr-x 4 db2inst1 db2iadm1
4096
-rw-r----- 1 db2inst1 db2iadm1 27946236
gemini: ls -la /db2backup/datamove/load
2008-02-11 11:36 .
2008-02-11 11:35 ..
2008-02-11 11:36 item.del.001
completed ok
db2inst1@mensa:/db2backup/datamoved> db2 "load from item.del of del replace
into itemload copy yes to /db2backup/datamove/copydata partitioned db config
mode load_only part_file_location /db2backup/datamove/load
partitioning_dbpartnums (0,1)"
Agent Type
Node
SQL Code
Result
Chapter 6. Administering databases
311