Re: select statement and tape update command

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:Steve_Harris AT HEALTH.QLD.GOV DOT AU]
Sent: 15 May 2003 00:03
To: ADSM-L AT VM.MARIST DOT EDU
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

>>> naveen.nr AT SBM.INTNET DOT MU 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.
**********************************************************************