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" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
31-Jul-2002 09:14
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> on 07/30/2002 05:00:29 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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.
