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
1,554
<node2> 1,318 0 0
1,318
tsm: TSMSRV06>
-----Original Message-----
From: Robert Ouzen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 20, 2001 5:19 AM
To: [EMAIL PROTECTED]
Subject: Select command
Hi
Did anybody know how to calculate with a select command the sum of all my Q
OCC ??????
Thanks Robert Ouzen
E-Mail: [EMAIL PROTECTED]
