Tried it....2 minutes. we're at 3.7.2

tsm: BACKUP>volumeusage where stgpool_name='NT3590BACK' group by node_name order
             by Numvols desc
ANR2000E Unknown command - VOLUMEUSAGE.
ANS8001I Return code 2.

tsm: BACKUP>select node_name, count (distinct volume_name) as Numvols from volum
            eusage where stgpool_name='NT3590BACK' group by node_name order  by
            Numvols desc
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.

Do you wish to proceed? (Yes/No) yes

NODE_NAME                  NUMVOLS
------------------     -----------
select distinct volume_name,node_name,stgpool_name from volumeusage where 
select distinct volume_name,node_name,stgpool_name from volumeusage where not 
stgpool_name='OFFSITEVOLS'

>>> mark.brown AT MCGILL DOT CA 11/02/00 09:45AM >>>
Hello,

We are currently running TSM Version 3, Release 7, Level 3.6 on OS/390.
We upgraded from version 3.1. On the 3.1 version I used to run a select
command to show me how many tapes each node was using. Here is the
select
command:

select node_name, count (distinct volume_name) as Numvols from
volumeusage where stgpool_name='NT3590BACK' group by node_name order by Numvols 
desc 

This select used to take about 45 minutes to run on the 3.1 version but
now this
select command simply grinds the server to a halt. I eventually have to
cancel adsm
to recover the server. Is there something about the 3.7 version or my
select command
that would cause this kind of problem. If the command takes 2 hours to
run then that
is fine but I can't have the server slowed down so much that I cannot do
other things.


--
Mark Brown
Mark Brown
Operations Supervisor
=====================

Tel      ---> 514-398-2321
Fax      ---> 514-398-6876
E-mail   ---> Mark.Brown AT mcgill DOT ca