Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Storage\s+Pool\s+Occupancy\s+for\s+each\s+node\s+report\s*$/: 2 ]

Total 2 documents matching your query.

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