It is not necessarily the join.  It is the backups table.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Marc Lowers [mailto:Marc.R.Lowers AT GSK DOT COM]
Sent: Friday, August 02, 2002 6:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: select statement using filespaces and tapes


select volume_name from volumeusage, backups where
volumeusage.filespace_name=backups.filespace_name and
backup_date='2002-07-05 18:01:32.000000' and backups.filespace_name='/' and
stgpool_name='UX_COPYPOOL'

I've tried the above statement with a few manual arguments which appears to
work OK, only thing is the amount of time it takes to come up with the
answer, it takes ages!  Even on our smallest of TSM databases.  Is this
common with select statements that use joins?






"John Naylor" <john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK>

Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> 31-Jul-2002 
09:14
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>




        To:     ADSM-L

        cc:
        Subject:        Re: select statement using filespaces and tapes

Marc,
Don't think you can do this, including backup date.
I am posting a select which does the rest

/*  Script Name:  Q_TAPE_VOLS                */
/*  Description: Display the TAPES that      */
/*               relate to a specific node   */
/*               and filespace               */
/*  Parameter:   node name filespace name    */
/*               and storage pool            */
/*  Example:  run q_tape_vols test2  test2\data:  tape2 */ select distinct
volume_name,node_name,filespace_name from -
  volumeusage where node_name = upper('$1') -
  and filespace_name = upper('$2') -
  and stgpool_name = upper('$3')





Marc Lowers <marc.r.lowers AT gsk DOT com> on 07/30/2002 05:00:29 PM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  select statement using filespaces and tapes



I'm looking for a select statement which will provide me with a list of
tapes associated with a given node, filespace name and backup date.  I've
been looking into linking the backups table with another to provide the
result  but this has been unsuccessful so far.

Am I close or miles off with this method?


Marc.