ADSM-L

Re: select statement and tape update command

2003-05-14 19:23:45
Subject: Re: select statement and tape update command
From: Steve Harris <Steve_Harris AT HEALTH.QLD.GOV DOT AU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 15 May 2003 09:02:53 +1000
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.
**********************************************************************

<Prev in Thread] Current Thread [Next in Thread>