- 1. Storage Pool Occupancy for each node report (score: 1)
- Author: Benhayoune Khalid <Benhayoune AT CIH.CO DOT MA>
- Date: Mon, 21 Jun 2004 05:58:33 -0500
- Hi all, I'm new in TSM SQL and I have a problem with the following statement : select stgpools.stgpool_name as "STORAGE POOL", - stgpools.est_capacity_mb, - occupancy.node_name, - sum(occupancy.Physi
- /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-06/msg00572.html (11,523 bytes)
- 2. Re: Storage Pool Occupancy for each node report (score: 1)
- Author: Richard van Denzel <RvanDenzel AT SLTNGROUP DOT COM>
- Date: Mon, 21 Jun 2004 16:34:13 +0200
- Try this one: select node_name, sum(num_files) as NUM_FILES, sum(logical_mb) as STORAGE_MB from occupancy group by node_name Richard. Benhayoune Khalid <Benhayoune AT CIH.CO DOT MA> Sent by: "ADSM: D
- /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2004-06/msg00585.html (12,155 bytes)
This search system is powered by
Namazu