Hi, Daniel, Brian.
The second select statement is selecting from filespaces. If you have a 2GB
client drive with 1GB of data on it, and if that counts as a filespace on
your OS, then your filespaces table will show that filespace as having a 2GB
capacity and 50% utilization. That's data on the client at last backup, not
in the ADSM server. However, when you go into the realm of storage space
used on the ADSM server, the number from filespaces doesn't take into
account the fact that there are inactive versions and deleted files stored
on the *SM server associated with that node. The first select statement
includes those inactive and deleted files.
I hope that helps.
Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail
(503) 745-5091 fax
PS: output from HELP Q FI
Capacity (MB)
Specifies the amount of space, in megabytes, assigned to this file
space on the client node.
Pct Util
Specifies the percentage of the file space that is occupied.
-----Original Message-----
From: Johnson, Brian [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 20, 2000 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: Another ADSM capacity question
Daniel,
Absolutely no offence taken...
Looking at the second command it seems to be trying to do something slightly
different, something clever which my command doesnt !!!
Can someone please explain !!
Many thanks,
Brian Johnson
> -----Original Message-----
> From: Daniel Swan/TM [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 2:45 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Another ADSM capacity question
>
> 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:[EMAIL PROTECTED]]
> > Sent: Wednesday, September 20, 2000 12:30 PM
> > To: [EMAIL PROTECTED]
> > 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:[EMAIL PROTECTED]]
> > > Sent: Wednesday, September 20, 2000 2:13 PM
> > > To: [EMAIL PROTECTED]
> > > 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?
