db2move and partitioned db on v8.1 I have exported the data from one DB using db2 move and now I want
the data to be loaded on a newly created 2 node partitoned db. The
source db was not partitoned. Can I load the data using "db2move
load". How would I achieve this?
What is the best way of loading all the tables from non-partitoned db
to the partitioned db?. I have about 200 tables.
When I try loading one of the table I get the following error. (I
wanted to try loading just one before trying all)
Is there anyway I can load the data using db2move?
% db2move db2c load -lo replace -l /u02/tmp_pk/LOB
***** DB2MOVE *****
Action: LOAD
Start time: Fri Oct 10 19:08:58 2003
Connecting to database DB2C ... successful! Server: DB2 Common Server
V8.1.0
*** Table "TEST"."TABLE2": ERROR -6100. Check message file
tab46.msg!
*** SQLCODE: -6100 - SQLSTATE: ÈàÐè
*** SQL6100N The partitioning map in the data file and the
partitioning map for the database are not the same.
Disconnecting from database ... successful! |