ADSM-L

Re: Needs help from SQL Genius'

2000-02-12 19:37:40
Subject: Re: Needs help from SQL Genius'
From: Joel Fuhrman <joelf AT CAC.WASHINGTON DOT EDU>
Date: Sat, 12 Feb 2000 16:37:40 -0800
Try the QUERY OCCUPANCY command.

On Fri, 11 Feb 2000, Michael Dummitt wrote:

> I need to write a query to show me the total capacity for each node.
> Or, even if I could just get the nodename and capacity for each filespace
> without the filespace name, platform type, filespace, or Pct. utilization.
>
> Node Name                   Filespace           Platform     Filespace
> Capacity   Pct
>                                           N
> ame                     Type                                   (MB)  Util
> ------------------------------   -----------
> --------      ---------         --------     -----
> ADSMRS                         /usr          AIX
> JFS           1,736.0   72.3
> ADSMRS                         /              AIX
> JFS           32.0        38.3
> ADSMRS                         /var           AIX
> JFS           32.0        73.1
> ADSMRS                         /home          AIX
> JFS             8.0         20.1
> ADSMRS                         /root          AIX
> JFS            16.0        66.7
> ADSMRS                         /MKSYSB        AIX
> JFS             8.0         25.3
>
<Prev in Thread] Current Thread [Next in Thread>