"select tbspace, tabname from syscat.tables group by tbspace,tabname"






"Sheth Jignesh "
<db2udbdba-ezmlms
hield-x18711224.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
01/27/2005 09:47
AM Subject
RE: sort list tablespaces show
detail










When I try this command. I get the information list below. What I was
looking for was a list of table names and so on.

db2 LIST TABLESPACES SHOW DETAIL | more

Tablespaces for Current Database

Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = Any data
State = 0x0000
Detailed explanation:
Normal
Total pages = 42806
Useable pages = 42568
Used pages = 32360
Free pages = 10208
High water mark (pages) = 32360
Page size (bytes) = 4096
Extent size (pages) = 8
Prefetch size (pages) = 32
Number of containers = 17





-----Original Message-----
From: Trace R Jones
[mailto:db2udbdba-ezmlmshield-x37064103.[Email address protected]
Sent: Thursday, January 27, 2005 9:41 AM
To: LazyDBA Discussion
Subject: sort list tablespaces show detail






anyway to sort by USED when doing a LIST TABLESPACES SHOW DETAIL?

Thanks,

TRJ



---------------------------------------------------------------------
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