Or you can use the scripts in
http://www.db2click.com/scripts.htm <http://www.db2click.com/scripts.htm>
Sample output is attached ..
Thanks
Sathyaram
www.db2click.com <http://www.db2click.com>
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com <http://www.LazyDBA.com>
To unsubscribe: http://www.lazydba.com/unsubscribe.html
<http://www.lazydba.com/unsubscribe.html>
For additional commands, e-mail: db2udbdba-[Email address protected]
**********************************************************************
This email and any files transmitted with it are confidential and are
intended solely for the use of the individual or entity to whom they are
addressed. This communication represents the originator's personal views and
opinions, which do not necessarily reflect those of HPI Limited. If you are
not the original recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this
email in error, and that any use, dissemination, forwarding, printing, or
copying of this email is strictly prohibited. If you received this email in
error, please immediately notify [Email address protected]
This message has been scanned by Panda Anti-Virus. Recipients are advised to
apply their own virus checks to this message on delivery.
**********************************************************************
http://www.db2click.com/scripts.htm
Tablespace Containers for Database :db01
TsID Tablespace TSType ContId ContType PagesAlloc Container Name
---- ---------- ------ ------ -------- ---------- -------------------------------------------
0 SYSCATSPACE SMS 0 Path 10167 /path1/containers/syscatspace
1 TS1 SMS 0 Path 657881 /path1/containers/TS1
2 USERSPACE1 SMS 0 Path 5207 /path1/containers/userspace1
3 STATS DMS 0 File 80000 /path1/containers/STATS_01
4 TRANS DMS 0 File 355000 /path1/containers/TRANS_01
1 File 355000 /path1/containers/TRANS_02
2 File 355000 /path1/containers/TRANS_03
3 File 355000 /path1/containers/TRANS_04
4 File 430000 /path1/containers/TRANS_05
5 File 355000 /path1/containers/TRANS_06
6 File 355000 /path1/containers/TRANS_07
DB2 & UDB email list listserv db2-l LazyDBA home page