Re: [ADSM-L] Re: command to query how much data is stored
2008-11-11 09:30:33
How about 'select sum(physical_mb) from occupancy where
stgpool_name='TAPEPOOL'?
On Tue, Nov 11, 2008 at 3:01 AM, David Bronder <david-bronder AT uiowa DOT
edu>wrote:
> Kelly Lipp wrote:
> >
> > Now the big dogs will weigh in with the perfect 300 character SQL
> > select statement with it summarized, etc, but this will get you
> > started.
>
> It sounded more to me like Richard is looking for "query stgpool"... :)
>
> Well, if he doesn't want to do the math by hand, something like this:
>
> select stgpool_name, cast((est_capacity_mb*pct_utilized/100) -
> as decimal(16,2)) as "UTILIZED_MB" from stgpools
>
> =Dave (not a big dog)
>
>
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
> > Behalf Of
> Cheung, Richard
> > Sent: Monday, November 10, 2008 10:55 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: [ADSM-L] command to query how much data is stored
> >
> > What is the command to show how much data is currently stored in a
> > storage pool - eg tapepool? Not for any specific individual nodes -
> > just at a pure 'how much data is in a storage pool' level?
>
>
> --
> Hello World. David Bronder - Systems
> Admin
> Segmentation Fault ITS-SPA, Univ. of
> Iowa
> Core dumped, disk trashed, quota filled, soda warm.
> david-bronder AT uiowa DOT edu
>
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Re: [ADSM-L] reclamation, (continued)
- Re: [ADSM-L] reclamation, Cheung, Richard
- Re: [ADSM-L] Re: reclamation, David Bronder
- Re: [ADSM-L] Re: reclamation, Cheung, Richard
- Re: [ADSM-L] Re: reclamation, Jim Neal
- Re: [ADSM-L] Re: reclamation, Cheung, Richard
- Re: [ADSM-L] Re: reclamation, Jim Neal
- Re: [ADSM-L] reclamation, David Bronder
- [ADSM-L] command to query how much data is stored, Cheung, Richard
- Re: [ADSM-L] command to query how much data is stored, Kelly Lipp
- Re: [ADSM-L] Re: command to query how much data is stored, David Bronder
- Re: [ADSM-L] Re: command to query how much data is stored,
TSM User <=
- Re: [ADSM-L] command to query how much data is stored, Alex Paschal
- Re: [ADSM-L] Re: reclamation, Scott Bellew
- Re: [ADSM-L] reclamation, Cheung, Richard
- Re: [ADSM-L] reclamation, Huebner,Andy,FORT WORTH,IT
- Re: [ADSM-L] reclamation, Steven Harris
Re: [ADSM-L] Tape throughput troubleshooting?, Paul Zarnowski
|
|
|