You must use DB2MOVE utility :
To extract data from database 1: db2move <database> export
To load data to database 2 : db2move <database> load -lo replace
-----Message d'origine-----
De : Maxim Ness
[mailto:db2udbdba-ezmlmshield-x51799011.[Email address protected]
Envoyé : mercredi 27 octobre 2004 17:30
À : LazyDBA Discussion
Objet : 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