Re: Really bad performance for a sql query after upgrading to v 3.7

2000-11-02 Thread Lawrence Clark
Tried it2 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

Really bad performance for a sql query after upgrading to v 3.7

2000-11-02 Thread Mark Brown
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