ADSM-L

Re: Select command

2001-12-20 08:01:07
Subject: Re: Select command
From: "Cook, Dwight E (SAIC)" <cookde AT BP DOT COM>
Date: Thu, 20 Dec 2001 06:57:07 -0600
Well, right off I'd say
        q auditocc
now besides that use
select sum (num_files), sum (physical_mb), sum (logical_mb), node_name from
adsm.occupancy group by node_name

Dwight

Unnamed[1]: 46132
Unnamed[2]: 1554.47
Unnamed[3]: 1523.37
 NODE_NAME: <node1>

Unnamed[1]: 10992
Unnamed[2]: 1317.63
Unnamed[3]: 1285.25
 NODE_NAME: <node2>


tsm: >q auditocc <node>*                        (node names changed to
protect the innocent;-)
License information as of last audit on 12/20/01 at 05:15:34.

Node Name                              Backup   Archive Space-Managed
Total
                                      Storage   Storage  Storage Used
Storage
                                    Used (MB) Used (MB)          (MB) Used
(MB)
----------------------------------- --------- --------- -------------
---------
---------
<node1>                               1,554         0             0
<node1>                               1,554         0             0
1,554
<node2>                               1,318         0             0
1,318

tsm: TSMSRV06>

<Prev in Thread] Current Thread [Next in Thread>