Hi Rachel
move drmedia source=dbbackup should do the trick I think.
Why do you want to move your database backups without moving the data
tapes? You wont have any use for the database backups as long as you dont
have the normal data tapes. I guess you're moving the tapes in a disaster
recovery scenario. However, restoring a database backup which hasnt got
it's corresponding data tapes is useless. It will only make your TSM
environment unsynchronized(the database thinks some data is on tape but in
fact isnt, as you havent got the updated data tapes).
Best Regards
Daniel Sparrman
-----------------------------------
Daniel Sparrman
Chef Utveckling & Drift
Exist i Stockholm AB
Propellervägen 6B
183 62 TÄBY
Växel: 08 - 754 98 00
Mobil: 070 - 399 27 51
"Smith, Rachel" <Rachel.Smith AT XEROX DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
2004-10-07 16:35
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To
ADSM-L AT VM.MARIST DOT EDU
cc
Subject
Re: select command
Hi,
I am using drm functions within tsm but the move script that is
scheduled is moving all tapes written to, I want this script to move
only database tapes from today only, not data tapes as well.
If you set the command "move drmedia * wherest=mountable source=dbbackup
tost=vault" to checkout only database tapes, it does not only checkout
db tapes, it checks database and data.
I was going to try the "select" command to select database tapes that
are onsite, send out to a file and run a checkout/move on the listed
media. But move and checkout does not allow you to use file output. So
it looks like scripts are the way for this one.
Thank you for your assistance,
Rachel
Forum: ADSM.ORG - ADSM / TSM Mailing List Archive
Date: Oct 07, 10:20
From: Daniel Sparrman <nobody at nowhere.com <mailto:nobody at
nowhere.com> >
Hi Rachel
No, you cant accomplish this TSM internal scripting.
Have you considered using the DRM functionality within TSM? The DRM
has=20
built-in commands for handling the movement of DB backups between
on-site=20
and vault(and back again)?
Best Regards
Daniel Sparrman
-----------------------------------
Daniel Sparrman
Chef Utveckling & Drift
Exist i Stockholm AB
Propellerv=E4gen 6B
183 62 T=C4BY
V=E4xel: 08 - 754 98 00
Mobil: 070 - 399 27 51
-----Original Message-----
From: Smith, Rachel
Sent: 07 October 2004 15:17
To: 'ADSM-L AT VM.MARIST DOT EDU'
Subject: RE: Re: select command
Yes, I already have scripts that do something similar but wanted
to have this running from TSM, not external.
To answer your question, the idea is/was to query volh for
database backups that have been written to today, checkout of library
and send offsite.
Thanks for reply.
Forum: ADSM.ORG - ADSM / TSM Mailing List Archive
Date: Oct 07, 09:42
From: Daniel Sparrman <nobody at nowhere.com
<mailto:nobody at nowhere.com> >
Hi Rachel
First, the SQL language used in TSM is not TSM specific.
Therefore, the=20
command move, which is not a SQL command, cannot be used
in an SQL=20
statement.
Second, as far as I know, you cant use resultlists from
SQL statements and =
pass these on to TSM internal commands without using any
form of external=20
scripting like ksh scripting.
Depending on the platform you're using, you could use
some form of=20
external scripting tool, like command scripting on the
Windows platform or =
KSH scripting on AIX to accomplish what you're looking
for.
One small question though; why do you want to move your
backup tapes?=20
Cause this is what I guess you're looking for, a way to
find out which=20
tapes were used, and the move them out of the library.
In that case, the use of copy storagepools would
probably be alot better,=20
as copy pools have these capabilities built-in.
Best Regards
Daniel Sparrman
-----------------------------------
Daniel Sparrman
Chef Utveckling & Drift
Exist i Stockholm AB
Propellerv=E4gen 6B
183 62 T=C4BY
V=E4xel: 08 - 754 98 00
Mobil: 070 - 399 27 51
-----Original Message-----
From: Smith, Rachel
Sent: 07 October 2004 14:30
To: 'ADSM-L AT VM.MARIST DOT EDU'
Subject: Re: select command
Hi, the option below worked, thanks for that.
But is there a way to send the output from the select
command to issue the move command to checkout tapes?
select volume_name from volhistory where
Date(date_time)=date(current_timestamp)
type='BACKUPFULL' location<>'VAULT'
move drmedia * tost=vault
Thanks again:)
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT
VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> ] On Behalf Of
Das, Samiran (IDS ECCS)
Sent: Wednesday, October 06, 2004 12:19 PM
To: ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT
VM.MARIST DOT EDU>
Subject: Re: select command
Or this one if you want to see volumes from today's
backup.
select volume_name from volhistory where
Date(date_time)=3Ddate(current_timestamp) and type in
('BACKUPFULL','BACKUPINCR')
Or may be a simpler one.
Q volhist begind=3Dtoday type=3Ddbb
Regards, Samiran Das
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT
VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> ] On Behalf Of
Das, Samiran (IDS ECCS)
Sent: Wednesday, October 06, 2004 12:19 PM
To: ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT
VM.MARIST DOT EDU>
Subject: Re: select command
Rachel,
Try this select query.
select volume_name from volhistory where
date_time<timestamp(date(current_timestamp),'00:00') and
type in
('BACKUPFULL','BACKUPINCR')
Following pdf By Andrew Reibeck is the best place to
start with tsm sql.
http://www-dat.lrz.de/dat/8/asys/doc/tsmserv/adsmserv-sql/doc/pdf/adsm_s
<http://www-dat.lrz.de/dat/8/asys/doc/tsmserv/adsmserv-sql/doc/pdf/adsm_
s>
ql.pdf
Regards, Samiran Das
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT
VM.MARIST DOT EDU <mailto:ADSM-L AT VM.MARIST DOT EDU> ] On Behalf Of
Smith, Rachel
Sent: Wednesday, October 06, 2004 11:31 AM
To: ADSM-L AT VM.MARIST DOT EDU <mailto:ADSM-L AT
VM.MARIST DOT EDU>
Subject: select command
Hi,
=20
I am trying to complete a select command to "select
volume_name from
volhistory where type=3D'backupfull' and
date_time>'today'" which fails
because today is incorrect, can you tell me the correct
format. Also
when the above runs successfully, I will require it to
use the out but
from the select command to move the media to
tost=3Dvault.
=20
Any ideas on how to do this or a web site that helps us
understand SQL
better?
=20
Thanks..=20
--------------------------------------------------------
=20
If you are not an intended recipient of this e-mail,
please notify the
sender, delete it and do not read, act upon, print,
disclose, copy,
retain or redistribute it. Click here for important
additional terms
relating to this e-mail.
http://www.ml.com/email_terms/=20 <http://www.ml.com/email_terms/=20>
--------------------------------------------------------=20
--------------------------------------------------------
=20
If you are not an intended recipient of this e-mail,
please notify the =
sender, delete it and do not read, act upon, print,
disclose, copy, =
retain or redistribute it. Click here for important
additional terms =
relating to this e-mail.
http://www.ml.com/email_terms/=20 <http://www.ml.com/email_terms/=20>
--------------------------------------------------------
=20
|
