Worked like a charm on my sample database. Thanks a lot to everyone, I
did not expect replies to be that quick and detailed.

Thanks again

-----Original Message-----
From: lmp5 [mailto:[Email address protected]
Sent: Wednesday, October 27, 2004 11:42 AM
To: Maxim Ness
Subject: RE: Explicitly bind to tablespace


1. Create the new tables under the new schema.

2. Use db2move to export the data from the old tables.

db2move <dbname> EXPORT -sn <oldschema>

3. Edit the db2move.lst file: change the old schema name to the new
schema name

4. use db2move to import or load the data into the new tables

db2move <dbname> LOAD -lo REPLACE

I have done this many times and it is a nice, easy process. If the
amount
of data is large, I would use LOAD instead of IMPORT so you don't blow
up
your active logs with all the inserts (and it's faster).






"Maxim Ness " <db2udbdba-ezmlmshield-x51799011.[Email address protected]
10/27/2004 11:30 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
RE: Explicitly bind to tablespace






Lekharaju,

Thank you for your reply

By using db2look I can recreate tables in different tablespace, but is
there a way to transfer data? I have over 100 tables holding
approximately 4.5 GB of data

-----Original Message-----
From: Lekharaju Ennam
[mailto:db2udbdba-ezmlmshield-x27394881.[Email address protected]
Sent: Tuesday, October 26, 2004 4:46 PM
To: LazyDBA Discussion
Subject: RE: Explicitly bind to tablespace

use db2look

db2look -d dbanme -e -x -t tablelist

-----Original Message-----
From: Maxim Ness
[mailto:db2udbdba-ezmlmshield-x60638200.[Email address protected]
Sent: Tuesday, October 26, 2004 3:41 PM
To: LazyDBA Discussion
Subject: Explicitly bind to tablespace


Hello all,

I ran into the problem. I have to make a copy of one schema with related
tables into the same database using different schema name into separate
tablespace and I don't see the way for doing that unless I copy one
table in a time. Db2move lets me move data between databases but it is
not what I need.
Or is there a way to configure odbc dsn name to use particular
tablespace?

Please help.

Maxim



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






DB2 & UDB email list listserv db2-l LazyDBA home page