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" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 2004-10-07 16:35 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' 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: '[EMAIL PROTECTED]' 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
