Re: Another ADSM capacity question
2000-09-20 14:45:42
Brian, in no way did I mean to imply your statement was faulty... I guess
what I was hoping for is a better understanding of the output it generates.
From my limited understanding, the two commands below should generate
identical #'s. Ie, Total occupancy of a client should equal the sum of all
filespaces of a client.
Obviously I've made a faulty assumption, and am hoping someone can point out
to me where, and how.
Best regards,
Dan.
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -----Original Message-----
> From: Johnson, Brian [SMTP:BrJohnson AT EXCHANGE.ML DOT COM]
> Sent: Wednesday, September 20, 2000 12:30 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Another ADSM capacity question
>
> Daniel,
> My command only sums up the number of files backed up and the total MB per
> client. It doesnt do any percentages and so on - so just for a set of
> totals
> my command works ok and the figures are ok
>
> Regards,
>
> Brian Johnson
> 212 647 3557
>
> > -----Original Message-----
> > From: Daniel Swan/TM [SMTP:Daniel.Swan AT TELUS DOT COM]
> > Sent: Wednesday, September 20, 2000 2:13 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: Another ADSM capacity question
> >
> > Brian, your SQL statement worked like a charm, however, I am having
> > trouble
> > reconciling the difference between the following outputs, which I think
> > should be the same:
> >
> > adsm> select total_MB from auditocc where node_name='U1_APPS'
> >
> > TOTAL_MB
> > -----------
> > 7396917
> >
> > ---AND---
> >
> > adsm> select node_name, cast(sum(capacity * (PCT_UTIL/100))as decimal
> > (9,0))
> > as percent_utilized from filespaces group by node_name order by
> > percent_utilized
> >
> > <SNIP>
> > U1_APPS 473461
> >
> > How do I reconcile these differences, and which is a more accurate
> picture
> > of how much space is being taken up on my ADSM server?
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question, Richard Sims
- Re: Another ADSM capacity question, Crump, Adam (CC-MIS Open Sys)
- Re: Another ADSM capacity question, Johnson, Brian
- Re: Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question, Daniel Swan/TM
- Re: Another ADSM capacity question, Johnson, Brian
- Re: Another ADSM capacity question,
Daniel Swan/TM <=
- Re: Another ADSM capacity question, Johnson, Brian
- Re: Another ADSM capacity question, Alex Paschal
- Another ADSM capacity question, Daniel Swan/TM [mailto:Daniel.Swan
- Re: Another ADSM capacity question, Johnson , Brian [mailto:BrJohnson
|
|
|