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 not
stgpool_name='OFFSITEVOLS'
>>> [EMAIL PROTECTED] 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
Operations Supervisor
=====================
Tel ---> 514-398-2321
Fax ---> 514-398-6876
E-mail ---> [EMAIL PROTECTED]
