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


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