This command may require the user to have SYSMON authority.
Check in the Command Reference.
Or you could set DB2_SNAPSHOT_NOAUTH ON but then anybody can take snapshots.
Regards, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "akhileshmittal"
<db2udbdba-ezmlmshield-x48347350.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, July 24, 2006 6:21 PM
Subject: Re: System tables behind 'list tablespaces show detail'


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