You may have scratch tapes in multiple locations, depending on your TSM set
up...
select location, stgpool_name, volume_name from volumes where scratch='Yes'
George Lesho
Storage/System Admin
AFC Enterprises
Ron Pavan <[EMAIL PROTECTED]> on 02/23/2001 10:34:21 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: George Lesho/Partners/AFC)
Fax to:
Subject: Re: Query Scratch Volumes
select volume_name, status from libvolumes where (status='Scratch')
-----Original Message-----
From: Steve Hicks [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 23, 2001 8:13 AM
To: [EMAIL PROTECTED]
Subject: Query Scratch Volumes
What would the syntax be for a query to only show scratch volumes?
