Monica,

If you are using 8,2, you can use db2 table function.

db2 "select * from table (snapshot_tbs_cfg('', -2)) as a"

HTH,

--Akhilesh



"Strubel Monica \[LTD\] "
<db2udbdba-ezmlmshield-x59222217.[Email address protected]
24/07/2006 02:41 PM
Mail Size: 3956

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
System tables behind 'list tablespaces show detail'
Our Ref

Your Ref







Hi,

I have a developer who does not have permission to submit 'list
tablespaces show detail' to a Prod database.

1) Is there a 'grant' statement (or whatever other means) that I can
grant him to allow him only this command?
2) What system tables/views can I have him query for him to get the
following info on a tablespace:

Total pages
Useable pages
Used pages
Free pages

Thank you.

Monica




---------------------------------------------------------------------
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 originated from the Internet. Its originator may or
may not be who they claim to be and the information contained in
the message and any attachments may or may not be accurate.
******************************************************************





-----------------------------------------
*******************************************************************
This e-mail is confidential. It may also be legally privileged.
If you are not the addressee you may not copy, forward, disclose
or use any part of it. If you have received this message in error,
please delete it and all copies from your system and notify the
sender immediately by return e-mail.

Internet communications cannot be guaranteed to be timely,
secure, error or virus-free. The sender does not accept liability
for any errors or omissions.
*******************************************************************
"SAVE PAPER - THINK BEFORE YOU PRINT!"

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