use db2move

Dan Callahan IT Specialist
603-472-4121 t/l 525-4121
[Email address protected]
[Email address protected]




"Maxim Ness "
<db2udbdba-ezmlms
hield-x51799011.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
10/27/2004 11:30
AM 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