Hi, I've been banging my head against the same brick wall - for checking out tapes in an onsite tape pool. Anyway, here's my script that I use to do it. I run a query of volumes I want to work on to a file and then read in the file and pass each parameter into a TSM command. The parameter in the command that should be substituted is replaced with the literal '_parameter'
Mark
(See attached file: archive_tapes_offsite)
--
Mark Ferraretto
Unix Systems Administrator
Deutsche Bank Hong Kong
w: +852 2203 6362 m: +852 9558 8032 f: +852 2203 6971
[EMAIL PROTECTED]
[EMAIL PROTECTED]
ET.COM To: [EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: select statement and tape
update command
EDU
06/17/03 03:15 AM
Please respond to
ADSM-L
Similar situation really,
*except* we want to automate the checkout of backupset volumes, which do not
belong to a specific Stg_pool.
I think the only way to achieve this is through passing the result of a
select statement (select volume_name from libvolumes where
last_use='BackupSet') into a file, and using the parameter in the file to
achieve the checkout libv command.
Is there anyway of scripting it so that the parameter can be passed straight
into the command?
If anyone could help in this, it would enable me to finally get some
sleep...
Regards
Levon
-----Original Message-----
From: Steve Harris [mailto:[EMAIL PROTECTED]
Sent: 15 May 2003 00:03
To: [EMAIL PROTECTED]
Subject: Re: select statement and tape update command
Naveen
Will the move media command do what you want? See the admin guide.
Steve Harris
AIX and TSM Admin
Queensland Health, Brisbane Australia
>>> [EMAIL PROTECTED] 14/05/2003 20:51:13 >>>
Hi,
I want to write a script which will list the volume to which backup was done
on a specific day for an specific stgpool, check it out and make the volume
access status=unavailable.
Currently I have to do it into three steps:
1.0 select volume_name,stgpool_name from volumes where
date(last_write_date)=current DATE and stgpool_name='BACKUP_POOL'
(Assume Output is 488acu)
2.0 Checkout libvolume tapelib 488acu
3.0 update volume 488acu access=unavailable
Can anyone help so that I do not have to specify the volume ID for the
checkout operation and volume update; but using the output directly from the
above select statement.
Thanks
###########################################
This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange.
For more information, connect to http://www.F-Secure.com/
**********************************************************************
This e-mail, including any attachments sent with it, is confidential
and for the sole use of the intended recipient(s). This confidentiality
is not waived or lost if you receive it and you are not the intended
recipient(s), or if it is transmitted/ received in error.
Any unauthorised use, alteration, disclosure, distribution or review
of this e-mail is prohibited. It may be subject to a statutory duty of
confidentiality if it relates to health service matters.
If you are not the intended recipient(s), or if you have received this
e-mail in error, you are asked to immediately notify the sender by
telephone or by return e-mail. You should also delete this e-mail
message and destroy any hard copies produced.
**********************************************************************
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
archive_tapes_offsite
Description: Binary data
