Through control center (object view), select the database/tablespaces.
Select your tablespace you want to see. Click on Show Related. When that
window pops up, you can also click on show sql and it will show you the sql
it used to generate the table and index list.

-----Original Message-----
From: Sheth Jignesh
[mailto:db2udbdba-ezmlmshield-x54790753.[Email address protected]
Sent: Thursday, January 27, 2005 9:39 AM
To: LazyDBA Discussion
Subject: Tablespace


Hi,

I need to find out what tables, indexes and other objects that are assigned
to a particular tablespace. Is there a command or query that I can run to
list all the objects for a particular tablespace ?

Thanks.


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

***********************************************************************
This message, including any attachments, may contain
confidential information intended for a specific individual
and purpose, and may be protected by law. If you are not
the intended recipient, please notify the sender by e-mail
or telephone immediately, and then immediately delete this
message. Any disclosure, copying or distribution of this
message, or the taking of any action based on it, by any
unintended recipient is strictly prohibited.

Checked by the Safelite e-mail scanner which may have
resulted in the attachments being modified or removed.

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