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!

Prince Kumar wrote:
> 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?

You can't. db2move exports data in IXF format, but the DB2 splitter
(built into the load utility in V8) will not accept IXF formatted
data. You can use db2move import, though.

> What is the best way of loading all the tables from non-partitoned db
> to the partitioned db?. I have about 200 tables.

Write a script to export the tables in delimited format, and another
script to load the tables.



Good luck,




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Dear Friends,

Anyone has any ideas? Please advice, how it can be accomplished
efficiently.

I have the original tables on one DB without any partitioning key. Now
I have anothet DB created with two partition groups and the tables
have partitioning key on the first column of the primary key.

How do I load the data from the tables which don't have the
partitioning key to the ones with partitioning key? I would like to
extract data from all the tables on the original db and load them on
to the new db.


Thanks,
Prince.

gspk@yahoo.com (Prince Kumar) wrote in message news:<629275ba.0310121805.231b1516@posting.google. com>...
> 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!

Thanks Ian for your response.

I will try the import option first and if it doesn't work I will try
the 2nd alternative.

Prince.

Ian <ianbjor@mobileaudio.com> wrote in message news:<3f8ac34a$1_1@corp.newsgroups.com>...
> Prince Kumar wrote:
> > 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?
>
> You can't. db2move exports data in IXF format, but the DB2 splitter
> (built into the load utility in V8) will not accept IXF formatted
> data. You can use db2move import, though.
>
> > What is the best way of loading all the tables from non-partitoned db
> > to the partitioned db?. I have about 200 tables.
>
> Write a script to export the tables in delimited format, and another
> script to load the tables.
>
>
>
> Good luck,
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Hi,

I tried the import, but it compalined about dependent tables. Then I
set the integrity of all the tables to off. Now I am getting the
following error.

% db2move db2c import -io replace -l /u02/tmp_pk/LOB


SQL3109N The utility is beginning to load data from file "tab2.ixf".

SQL3188N An error occurred while erasing the contents of the table.

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

I am wondering, whether data can be imported when the table is left in
check pending status? Noe, I am replacing the table data here.

Thanks,
Prince.

Ian <ianbjor@mobileaudio.com> wrote in message news:<3f8ac34a$1_1@corp.newsgroups.com>...
> Prince Kumar wrote:
> > 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?
>
> You can't. db2move exports data in IXF format, but the DB2 splitter
> (built into the load utility in V8) will not accept IXF formatted
> data. You can use db2move import, though.
>
> > What is the best way of loading all the tables from non-partitoned db
> > to the partitioned db?. I have about 200 tables.
>
> Write a script to export the tables in delimited format, and another
> script to load the tables.
>
>
>
> Good luck,
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Hi Prince,

LOAD does not necessarily distinguish between input for partitioned and
non-partitioned tables. Of course, you can load a single partition by
saying so on the LOAD statement; however, you are free to load all of the
partitions at once. Then the load statement looks the same as for the
non-partitioned tables.

Regards Rolf

Prince Kumar wrote:

> Hi,
>
> I tried the import, but it compalined about dependent tables. Then I
> set the integrity of all the tables to off. Now I am getting the
> following error.
>
> % db2move db2c import -io replace -l /u02/tmp_pk/LOB

using SET INTEGRITY OFF will not allow you to import your tables
in the wrong order -- it allows only very limited access to the
data.

And, as you found, you can't use import ... replace when you have
RI defined.


You could drop all of your foreign keys and then re-apply them after
importing the data, or, as I suggested earlier, simply write scripts
to export / load your data in delimited format.


Good luck,





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

I have dealt with the same issues. If this is a one-time load
(migration), try this:

1. create your partitioned database with everything on a single
partition
2. create an export script to unload your original database in ixf
format, you might be able to use db2move export to get this database
unloaded.
3. create a script to set integrity off on all your tables you will
load
4. create a script to run load commands for each table in the new
database
5. set integrity on for all your tables. You may have to make
multiple runs of the script if you don't run them in the right parent
child order. You can do this without harm
6. now that the partitioned table is loaded, alter your partition
groups to add the additional partitions
7. redistribute the data

Like I said, this works for a one time deal, it won't work for
on-going loads.

Jack

gspk@yahoo.com (Prince Kumar) wrote in message news:<629275ba.0310121805.231b1516@posting.google. com>...
> 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!