Mail Archive Search: <+subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*AW\:\s+sql\s+select\s+to\s+count\s+volumes\s+per\s+stgpool\s+by\s+node\s*$/>

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*AW\:\s+sql\s+select\s+to\s+count\s+volumes\s+per\s+stgpool\s+by\s+node\s*$/: 5 ]

Total 5 documents matching your query.

1. AW: sql select to count volumes per stgpool by node (score: 1): Author: Salak Juraj <j.salak AT ASAMER DOT AT>; Date: Fri, 2 May 2003 16:03:27 +0200; Andy, I do not see an error in your SQL statement, but the results are much too good to be correct, new volumes must be created on the fly during the SQL run: e.G. AOHEXCHANGE00 TPBACSAFE 81 While I; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-05/msg00056.html (12,748 bytes)
2. Re: AW: sql select to count volumes per stgpool by node (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Fri, 2 May 2003 07:18:18 -0700; What do you get if you do this: select stgpool_name, volume_name from volumeusage where node_name='AOHEXCHANGE00' order by stgpool_name, volume_name Are duplicate volumes showing up? How about: selec; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-05/msg00058.html (13,800 bytes)
3. Re: AW: sql select to count volumes per stgpool by node (score: 1): Author: Ben Bullock <bbullock AT MICRON DOT COM>; Date: Fri, 2 May 2003 08:37:14 -0600; Or how about this one, it's what we use. It is a large query and takes a while to complete depending on the size of your TSM server. select node_name,stgpool_name,count(distinct(volume_name)) as \"Nu; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-05/msg00060.html (14,658 bytes)
4. Re: AW: sql select to count volumes per stgpool by node (score: 1): Author: David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>; Date: Fri, 2 May 2003 10:37:04 -0400; Try replacing count(*) as "Count" with count(distinct volume_name) as "Count" The problem is that a volser can appear multiple times in volumeusage for a given node/storagepool combination. David And; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-05/msg00061.html (13,086 bytes)
5. Re: AW: sql select to count volumes per stgpool by node (score: 1): Author: Andrew Raibeck <storman AT US.IBM DOT COM>; Date: Fri, 2 May 2003 08:43:05 -0700; Ah yes, you are correct, since file spaces and copy type are part of the volume usage table. Thanks! Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-ma; /usr/local/webapp/mharc-adsm.org/html/ADSM-L/2003-05/msg00071.html (13,899 bytes)

Current List: 1 - 5
Page: [1]