Re: TSM dsmc restore scheduled command...
I would like to add this information from the... Actlog... tsm: FPTIVOLI_SERVER1>q actlog begind=today-1 search=02 11/15/2007 05:02:36 ANR0406I Session 1259 started for node 02 (WinNT) (Tcp/Ip 02.domain.com(3262)). (SESSION: 1259) 11/15/2007 05:02:36 ANR2579E Schedule LOG_RESTORE_02 in domain STANDARD for node 02failed (return code 1). (SESSION: 1259) 11/15/2007 05:02:36 ANR0403I Session 1259 ended for node 02 (WinNT). (SESSION: 1259) 11/15/2007 05:03:18 ANR0406I Session 1261 started for node 02 (WinNT) (Tcp/Ip 02.domain.com(3269)). (SESSION: 1261) 11/15/2007 05:03:18 ANR0403I Session 1261 ended for node 02 (WinNT). (SESSION: 1261) dsmerror.log... 11/15/2007 05:02:37 ANS1909E The scheduled command failed. 11/15/2007 05:02:37 ANS1512E Scheduled event 'LOG_RESTORE_02' failed. Return code = 1. dsmsched.log... 11/15/2007 05:02:36 Executing scheduled command now. 11/15/2007 05:02:36 Node Name: 02 11/15/2007 05:02:36 Session established with server FPTIVOLI_SERVER1: Windows 11/15/2007 05:02:36 Server Version 5, Release 3, Level 6.0 11/15/2007 05:02:36 Server date/time: 11/15/2007 05:02:36 Last access: 11/15/2007 04:07:36 11/15/2007 05:02:36 Executing Operating System command or script: c:\progra~1\tivoli_\tsm\baclient\restore.cmd 11/15/2007 05:02:37 Finished command. Return code is: 1 11/15/2007 05:02:37 ANS1909E The scheduled command failed. 11/15/2007 05:02:37 ANS1512E Scheduled event 'LOG_RESTORE_02' failed. Return code = 1. 11/15/2007 05:02:37 Sending results for scheduled event 'LOG_RESTORE_02'. 11/15/2007 05:02:37 Results sent to server for scheduled event 'LOG_RESTORE_02'. Thank you, \Dan From: Daniel Lane Sent: Tuesday, November 13, 2007 11:11 AM To: 'ADSM-L@VM.MARIST.EDU' Subject: TSM dsmc restore scheduled command... Hello Everyone, The question I have is... Could I add to my dos command file to respond to the "Select an appropriate action" every time it is presented to correct the error or is there another way to address this failure? If I could add the dos command how would I do that? TSM Server Version 5, Release 3, Level 6.0 on Windows Server 2003 Client Node Version 5, Release 3, Level 5.3 on Windows Server 2003 Client Node TSM Scheduled Command is being run on 02 were files are being restored to Client Node TSM Scheduled Command is being restored from 01 dsmc.exe restore -latest -IFNewer -subdir=yes -fromnode=01 -tapeprompt=yes \\01\D$\Backup\Logfiles\*.* \\ 02\D$\Dev\Public\WebLogs\ For each file that in on offline media I get this request using the option -tapeprompt=yes --- Offline Media is Required --- The following object requires offline media to be mounted. Object: \\ 02\d$\Dev\Public\WebLogs_new\Logfiles\FPWWW04\Results Device: Information Not Available Volume Label: Information Not Available Select an appropriate action 1. Wait for the volume to be mounted 2. Always wait for a volume to be mounted 3. Skip this object 4. Skip all objects on this volume (Not Supported) 5. Skip all objects requiring a media to be mounted A. Abort this operation Action [1,2,3,4,5,A] : For each file that is on offline media I get this request using the option -tapeprompt=no in a command window and it never proceeds beyond the 2.27 KB nor is there a request for an offline tape and I get an error in the logfile listed below ANS1114I Waiting for mount of offline media. ANS1898I * Processed 2,000 files * <2.27 KB> [ -] Error 10/31/2007 05:02:03 ANS1909E The scheduled command failed. 10/31/2007 05:02:03 ANS1512E Scheduled event 'LOG_RESTORE_02' failed. Return code = 1. For each file that is on offline media I get this request using the option -tapeprompt=no/yes in a command window and it never proceeds beyond the 2.27 KB nor is there a request for an offline tape and I get an error in the logfile listed below ANS1114I Waiting for mount of offline media. ANS1898I * Processed 2,000 files * <2.27 KB> [ -] Error 10/31/2007 05:02:03 ANS1909E The scheduled command failed. 10/31/2007 05:02:03 ANS1512E Scheduled event 'LOG_RESTORE_02' failed. Return code = 1. Thank You, Dan
Virtual Volumes & DB Backup
Alper, Remco, Allen, & Neil, I went ahead and set up an NFS share on a NAS located in a different building then my TSM servers. Both TSM servers mount the same share and they deposit the DB backups in separate directories. Thus the immediate problem of no backups is solved. Neil, I will pursue that test tomorrow. I want to see what other fun things I can do with virtual volumes. Thanks all, I really appreciate your help! Rob Jones Network Administrator Lafayette College +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +--
Re: Moving Domino backups between TSM servers
You will have to make a new definition of the Domino server on your new TSM server. Then, at you leisure, export the old data to the new server. Orville L. Lantto From: ADSM: Dist Stor Manager on behalf of Zoltan Forray/AC/VCU Sent: Thu 11/15/2007 09:55 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Moving Domino backups between TSM servers I have a big project to move 100TB of Domino backups (and their definitions) to a new TSM server (phasing out AIX). Besides having resource issues (time, disk, tape.the usual), I need to keep the Domino backups running while the moves (imports/exports) are in progress. We perform all three kinds of Domino backups, archivelogs, incremental and selective. Archivelogs run hourly, incrementals run daily and selective every two weeks. I expect some of these moves to run for days, if not more than a week. What are the effects/impact of running export/imports for this kind of data and also performing regular backups, at the same time ? Recommendations on sequence of events to minimize the impact ?
Re: Virtual Volumes & DB Backup
Rob, On the source server, yes you will have sequential devclass regardless (irregardless?) of the type of device on the target server. The device is virtual and gets converted to what is real on the target server through some TSM voodoo magic. Try a small test by: 1. define a small test disk pool of 2GB or so on the target server 2. Create a test domain with the archive copygroup destination of this disk pool on the target server 3. Define the source server on the target server 4. Assign the source server to this domain with "register node type=server" 1. Create the virtual device class on the source server 2. run "prepare devclass=" on the source server 3. on the target server do a "query files" 4. if you have space on the disk perform a db backup from the source 5. look at the volhist on the source server and you will see the virtual volumes One really nice feature of recovering the DB from a virtual volume is that you need no tape devices defined in the OS so you can actually recover TSM while the OS admin is installing the device drivers and the SAN admin is zoning the new server to the tape drives( just don't reboot until the DB recovery is complete). Cheers, Neil Strand Storage Engineer - Legg Mason Baltimore, MD. (410) 580-7491 Whatever you can do or believe you can, begin it. Boldness has genius, power and magic. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of jonesrn Sent: Thursday, November 15, 2007 11:27 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Virtual Volumes & DB Backup Neil, Thanks for your help. On the target server, ensure that the ARCHIVE copygroup in the domain that the source server node definition is assigned to, has a valid destination - it can be either disk or tape. However, if I use the devtype server when I define my devclass, I will get a "Device Access Strategy" of sequential. I don't see any way of defining or updating my way out of this. TSM3>define devclass targetclass devtype=server servername=tsm4 ANR2203I Device class TARGETCLASS defined. tsm: TSM3>q devclass targetclass f=d Device Class Name: TARGETCLASS Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: SERVER At this point I am leaning toward creating a devtype of FILE and putting it on an NFS mount. (The NFS mount would be on a NAS in a different location.) However, I'd still like to get Virtual Volumes working for data migration, etc. My question is: should I be working with the devtype of server or should I just be defining my sourcepool as FILE? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
storage agent support commands
Is there a list somewhere of what server commands a storage agent supports? The storage agent manual doesn't seem to give a list of support commands. Some commands work find (q sess, q mount), but others get routed to the tsm server. I can't find a document for what commands work, and how. rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: CAD seems confused about what time it is?
Hi Allen, No, this shouldn't be a DST thing, unless the OS isn't patched accordingly to support the DST changes; and even then, I can't see it being off by that much (a one-hour difference maybe, but not 14 hours). What does the schedule definition look like? Is the 0800 kick-off within the window? What is randomization? IC53294 come to mind; pay no attention to the "Vista" bit, it isn't Vista specific, but I can't swear it is limited to the classic scheduler, either. Did this client system go to sleep at some time, then wake up? Anything in dsmwebcl.log, dsmerror.log or dsmsched.log that might hint at a clue? Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 11/15/2007 08:18:42 AM: > I've got a few boxes (Windows NT 5, TSM Client 5.4.1.2, TSM server > 5.3.4.0) on which the CAD seems confused about what time to do which. > > An example is a box which has a schedule for 1800, but it attempted to > kick it off at 0800 this AM. The diagnostics seem reasonable > (ANR2568E "request to start schedule is denied) but I can't really > figure out how the CAD reaches the conclusion that 'now is a good > time'. > > A simple search at IBM didn't turn up anything particularly relevant: > Has anyone seen this? I told my customer I was handwaving, but > 'restart the CAD, maybe it is nutso because of daylight savings or > some such'. > > > I found myself going down a numerological rabbit-hole looking for > plausible time-related errors which add up to 10 hours... > > > > - Allen S. Rout
Re: CAD seems confused about what time it is?
>> On Thu, 15 Nov 2007 09:07:31 -0700, Andrew Raibeck <[EMAIL PROTECTED]> said: > No, this shouldn't be a DST thing, unless the OS isn't patched > accordingly to support the DST changes; and even then, I can't see > it being off by that much (a one-hour difference maybe, but not 14 > hours). Actually, it's 10 hours: It was trying to start this evening's schedule. If the restart of the CAD doesn't address the issue, I'll do the next level of troubleshooting, and open a real ticket. It seems it's not a "Oh, yeah, lots of us got that after the time change" sort of thing. Owell. I'll recap how it goes. - Allen S. Rout
Moving Domino backups between TSM servers
I have a big project to move 100TB of Domino backups (and their definitions) to a new TSM server (phasing out AIX). Besides having resource issues (time, disk, tape.the usual), I need to keep the Domino backups running while the moves (imports/exports) are in progress. We perform all three kinds of Domino backups, archivelogs, incremental and selective. Archivelogs run hourly, incrementals run daily and selective every two weeks. I expect some of these moves to run for days, if not more than a week. What are the effects/impact of running export/imports for this kind of data and also performing regular backups, at the same time ? Recommendations on sequence of events to minimize the impact ?
Re: Virtual Volumes & DB Backup
>> On Thu, 15 Nov 2007 15:02:58 +0100, Remco Post <[EMAIL PROTECTED]> said: > do NOT (repeat do NOT!) create circular dependencies between > servers, keep backups of at least one database on disk, tape or > whatever on physical volumes. What he said! A bunch! If you designate one server as -only- the target for TSM server DB backups, you'll find that that server's TSM DB is rather small. This permits all sort of different strategies in protecting the 'seed' of the rest of your TSM infrastructure. I've got one server, which I call 'ctrl', that does library manager work and hosts DB backups, and a full of it is less than 300M. So, I do daily fulls, and incrementals every two hours, stick those files on disk and rdist them all over the place. You could burn a week's worth of DB backups, plus devconfigs and volhists and option files for lots of servers, onto just one DVD at that size. - Allen S. Rout
Virtual Volumes & DB Backup
Neil, Thanks for your help. On the target server, ensure that the ARCHIVE copygroup in the domain that the source server node definition is assigned to, has a valid destination - it can be either disk or tape. However, if I use the devtype server when I define my devclass, I will get a "Device Access Strategy" of sequential. I don't see any way of defining or updating my way out of this. TSM3>define devclass targetclass devtype=server servername=tsm4 ANR2203I Device class TARGETCLASS defined. tsm: TSM3>q devclass targetclass f=d Device Class Name: TARGETCLASS Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: SERVER At this point I am leaning toward creating a devtype of FILE and putting it on an NFS mount. (The NFS mount would be on a NAS in a different location.) However, I'd still like to get Virtual Volumes working for data migration, etc. My question is: should I be working with the devtype of server or should I just be defining my sourcepool as FILE? +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +--
Storage agent to multiple library managers?
Hello . . . (I hope I can ask this without making it so confusing that I don't even understand what I'm asking.) We have 2 datacenters with a SAN connecting them. All tsm instances, library manager instances, libraries, and drives are on this SAN. The 3584 libraries at each datacenter have a local/dedicated Library manager instance. All tsm instances at each site can access all tape drives at each site, via the appropriate library manager. TSM servers write backups to the local 3584, then make direct offsite copypools to the remote library. Say I have a node that performs lanfree backups to it's local tsm server and 3584 library, and then the tsm server creates the offsite copypool. All is good. During a lanfree restore, IF a PRIMARY pool tape is not available and a copy pool tape is used to access the data, that portion of the restore will go LAN - no lanfree path to the offsite tape drives or access to the offsite library manager instance. q) If I define the offsite library manager to the storage node and paths to the offsite library drives, will the storage agent be able to perform lanfree restore from the offsite copy pool? This means that the storage agent will have 3 server-to-server setups: sta -- to -- tsm server for the node sta -- to -- onsite library manager (with appropriate paths) sta -- to -- offsite library manager (with appropriate paths) Q) Does this work? Nothing I've read indicates that a storage agent can handle multiple library manager instances. Thanks Rick - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
Re: Virtual Volumes & DB Backup
jonesrn wrote: > I have two TSM 5.4 servers using SATA drives as their targets. (They > are named TSM3 and TSM4) I do not have any tape drives or libraries > set up. > > I want to backup the database on TSM3 to TSM4 and vice versa. (As > described in an operation suggested in IBM TSM for Linux: > Administrator's Guide, ver 5.3, pages 602-607.) > do NOT (repeat do NOT!) create circular dependencies between servers, keep backups of at least one database on disk, tape or whatever on physical volumes. on tsm3: reg n tsm4 yourpassword t=s ... on tsm4: reg n tsm3 yourpassword t=s ... make sure you have an archive copygroup in the default mgmt class in the domain where you register your nodes (I think a dedicated domain is in order). on tsm3: update server tsm4 pa=yourpassword nodename=tsm3 ... on tsm4: update server tsm3 pa=yourpassword nodename=tsm4 ... (or def server) now, update dev targetclass server=tsm3 or tsm4 backup db dev=targetclass t=f look in both actlogs for tsm3 and tsm4 if things don't work. > However, I get this error: > > ANR0984I Process 91 for DATABASE BACKUP started in the BACKGROUND at > 03:47:08 PM. ANR2280I Full database backup started as process 91. > ANR1404W Scratch volume mount request denied - mount failed. ANR4578E > Database backup/restore terminated - required volume was not mounted. > ANR0985I Process 91 for DATABASE BACKUP running in the BACKGROUND > completed with completion state FAILURE at 03:47:09 PM. > > My strategy was to set up source and target servers for virtual > volumes. When I defined the storage pool on the target server I > specified the devclass as DISK. As in " define stgpool sourcepool > disk". However, on the source server the devclass "targetclass" seems > to want a sequential device. I am guessing that this is why it seems > to be attempting to mount a scratch volume. > > Device Class Name: TARGETCLASS Device Access Strategy: Sequential > Storage Pool Count: 0 Device Type: SERVER > > I have not found a way to update the targetclass device from > "sequential" to "random" . > > Is this the best way to achieve my goal? > > Thanks, Rob > > +-- > |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward > SPAM to [EMAIL PROTECTED] > +-- > -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
internal threads
anyone could remind me the undocumented commands to manage the threads (show thread), for example to kill one of them (to use in a test environment), please ? Regards Vincent
CAD seems confused about what time it is?
I've got a few boxes (Windows NT 5, TSM Client 5.4.1.2, TSM server 5.3.4.0) on which the CAD seems confused about what time to do which. An example is a box which has a schedule for 1800, but it attempted to kick it off at 0800 this AM. The diagnostics seem reasonable (ANR2568E "request to start schedule is denied) but I can't really figure out how the CAD reaches the conclusion that 'now is a good time'. A simple search at IBM didn't turn up anything particularly relevant: Has anyone seen this? I told my customer I was handwaving, but 'restart the CAD, maybe it is nutso because of daylight savings or some such'. I found myself going down a numerological rabbit-hole looking for plausible time-related errors which add up to 10 hours... - Allen S. Rout
Re: internal threads
Look at this site, many of the show commands are listed. http://people.bu.edu/rbs/ADSM.funcdir Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Vincent RATAJSZCZAK Sent: Thursday, November 15, 2007 9:11 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] internal threads anyone could remind me the undocumented commands to manage the threads (show thread), for example to kill one of them (to use in a test environment), please ? Regards Vincent This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: Is their a way to find out - when was the last time a restore was performed for a TSM node.
Again, searching the actlog or the summary table for the restore information is fine as long as what you're looking for is within the retention of the ACTLOGRETENTION and SUMMARYRETENTION values you've set. Or if you're saving the actlog on a regular basis you can search it still. But if it's past those retention values, your kinda SOL. You can dig the information out of the accounting records, but again only if you have accounting on. I'm not sure if some of the OEM monitoring packages (TSMManager, ServerGraph) capture and retain this information or not. Might be an option for you, too. Bill Boyer "My problem was caused my a loose screw at the keyboard" - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rejean Larivee Sent: Thursday, November 15, 2007 9:02 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Is their a way to find out - when was the last time a restore was performed for a TSM node. Hello, and if you want more granularity, you can also use the "REPORTRETRIEVE YES" server option. With this option, message ANR0411I will be logged in the TSM activity log when a file is restored. For example : ANR0411I Session 8 for administrator COLIND-TUC logged in as node COLIND-TUC restored or retrieved Backup object: node COLIND-TUC, filespace \\colind-tuc\c$, object\CODE\TESTDATA\ XXX.OUT Rejean Larivee IBM Tivoli Storage Manager support IBM Global Technology Services ** Visit our new IBM Tivoli Storage Manager support page: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html Expand IBM Tivoli product knowledge through our Support Technical Exchange. http://www-306.ibm.com/software/sysmgmt/products/support/supp_tech_exch.html ** "ADSM: Dist Stor Manager" wrote on 11/12/2007 11:40:08 AM: > As long as the last restore was within the retention you've set for > the summary table. QUERY STATUS to find out the current valut. > SET SUMMARYRETENTION to set/change. > > Same as for a previous suggestion for querying the actlog. The restore > has to be within the ACTLOG retention value. > > Only long term retention of this data is in the accounting data (SET > ACCOUNTING ON). It doesn't say restore for the record, but you could > query that nodename and look at fields 18 and 19 for "retrieved backup > objects". > > Bill Boyer > "Nothing is foolproof to a sufficiently talented fool." - Murphy > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of Ribeiro, Ricardo > Sent: Monday, November 12, 2007 10:25 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Is their a way to find out - when was the last time a > restore was performed for a TSM node. > > Just run this statement... > SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf > Of CAYE PIERRE > Sent: Monday, November 12, 2007 8:23 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Is their a way to find out - when was the last > time a restore was performed for a TSM node. > > Sorry I miss a word... It is for backup only, not restore > > > -Message d'origine- > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la > > part de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : > > ADSM-L@VM.MARIST.EDU Objet : Re: [ADSM-L] Is their a way to find out > > - when was the last time a restore was performed for a TSM node. > > > > I am sure I must be missing something obvious, else I am going to > > learn a new trick... how do you determine from QUERY FILESPACE F=D > > when a node last performed a restore? > > > > Regards, > > > > Andy > > > > Andy Raibeck > > IBM Software Group > > Tivoli Storage Manager Client Product Development Level 3 Team Lead > > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet > > e-mail: [EMAIL PROTECTED] > > > > IBM Tivoli Storage Manager support web page: > > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli > > StorageManager.html > > > > The only dumb question is the one that goes unasked. > > The command line is your friend. > > "Good enough" is the enemy of excellence. > > > > "ADSM: Dist Stor Manager" wrote on 11/12/2007 > > 07:49:17 AM: > > > > > That did the trick. Thanks for the tip > > > > > > Regards, > > > > > > Kamran > > > > > > -Original Message- > > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > > On Behalf > > > Of CAYE PIERRE > > > Sent: Monday, November 12, 2007 4:07 AM > > > To: ADSM-L@VM.MARIST.EDU > > > Subject: Re: [ADSM-L] Is their a way to find out - when was > > the last > > > time a restore was performed for a TSM node. > > > > > > You can also query filespaces : q fi f=d > > > > > >
Re: Virtual Volumes & DB Backup
Rob, Backing up your DB to a virtual volume is a nice option that I use for my entire environment as PART of my recovery strategy. On the target server, ensure that the ARCHIVE copygroup in the domain that the source server node definition is assigned to, has a valid destination - it can be either disk or tape. General procedure: - On source server: - - set servename source_server - - set serverpassword password - - set serverhladdress source_server - - set serverlladdress 1500 - - set crossdefine on - On target server: - - Define TSM server domain,policy,mgmt class and ARCHIVE copygroup destination. - - define server source_server serverpassword=password hladdress=source_server lladdress=1500 crossdefine=yes - - register node source_server password domain=tsm_server type=server - On source server: - - Define devclass virtual_vol devtype=server servername=target_server maxcapacity=100G *note play around with the maxcapacity parameter to get something that fits your environment. Now backup your DB on the source server - Backup db devc=virtual_vol type=full And save your recovery plan - prepare devc=virtual_vol On the target server, you can view the recovery plan - Query rpfile - Query rpfcontent Cheers, Neil Strand Storage Engineer - Legg Mason Baltimore, MD. (410) 580-7491 Whatever you can do or believe you can, begin it. Boldness has genius, power and magic. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of jonesrn Sent: Wednesday, November 14, 2007 4:44 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Virtual Volumes & DB Backup I have two TSM 5.4 servers using SATA drives as their targets. (They are named TSM3 and TSM4) I do not have any tape drives or libraries set up. I want to backup the database on TSM3 to TSM4 and vice versa. (As described in an operation suggested in IBM TSM for Linux: Administrator's Guide, ver 5.3, pages 602-607.) However, I get this error: ANR0984I Process 91 for DATABASE BACKUP started in the BACKGROUND at 03:47:08 PM. ANR2280I Full database backup started as process 91. ANR1404W Scratch volume mount request denied - mount failed. ANR4578E Database backup/restore terminated - required volume was not mounted. ANR0985I Process 91 for DATABASE BACKUP running in the BACKGROUND completed with completion state FAILURE at 03:47:09 PM. My strategy was to set up source and target servers for virtual volumes. When I defined the storage pool on the target server I specified the devclass as DISK. As in " define stgpool sourcepool disk". However, on the source server the devclass "targetclass" seems to want a sequential device. I am guessing that this is why it seems to be attempting to mount a scratch volume. Device Class Name: TARGETCLASS Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: SERVER I have not found a way to update the targetclass device from "sequential" to "random" . Is this the best way to achieve my goal? Thanks, Rob +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: Is their a way to find out - when was the last time a restore was performed for a TSM node.
Hello, and if you want more granularity, you can also use the "REPORTRETRIEVE YES" server option. With this option, message ANR0411I will be logged in the TSM activity log when a file is restored. For example : ANR0411I Session 8 for administrator COLIND-TUC logged in as node COLIND-TUC restored or retrieved Backup object: node COLIND-TUC, filespace \\colind-tuc\c$, object\CODE\TESTDATA\ XXX.OUT Rejean Larivee IBM Tivoli Storage Manager support IBM Global Technology Services ** Visit our new IBM Tivoli Storage Manager support page: http://www-3.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html Expand IBM Tivoli product knowledge through our Support Technical Exchange. http://www-306.ibm.com/software/sysmgmt/products/support/supp_tech_exch.html ** "ADSM: Dist Stor Manager" wrote on 11/12/2007 11:40:08 AM: > As long as the last restore was within the retention you've set for > the summary table. QUERY STATUS to find out the current valut. > SET SUMMARYRETENTION to set/change. > > Same as for a previous suggestion for querying the actlog. The > restore has to be within the ACTLOG retention value. > > Only long term retention of this data is in the accounting data (SET > ACCOUNTING ON). It doesn't say restore for the record, but you > could query that nodename and look at fields 18 and 19 for > "retrieved backup objects". > > Bill Boyer > "Nothing is foolproof to a sufficiently talented fool." - Murphy > > > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > Behalf Of Ribeiro, Ricardo > Sent: Monday, November 12, 2007 10:25 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Is their a way to find out - when was the last time a > restore was performed for a TSM node. > > Just run this statement... > SELECT * FROM SUMMARY WHERE ACTIVITY='RESTORE' > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > Behalf Of CAYE PIERRE > Sent: Monday, November 12, 2007 8:23 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] Is their a way to find out - when was the last > time a restore was performed for a TSM node. > > Sorry I miss a word... It is for backup only, not restore > > > -Message d'origine- > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la part > > de Andrew Raibeck Envoyé : lundi 12 novembre 2007 16:05 À : > > ADSM-L@VM.MARIST.EDU Objet : Re: [ADSM-L] Is their a way to find out - > > when was the last time a restore was performed for a TSM node. > > > > I am sure I must be missing something obvious, else I am going to > > learn a new trick... how do you determine from QUERY FILESPACE F=D > > when a node last performed a restore? > > > > Regards, > > > > Andy > > > > Andy Raibeck > > IBM Software Group > > Tivoli Storage Manager Client Product Development Level 3 Team Lead > > Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet > > e-mail: [EMAIL PROTECTED] > > > > IBM Tivoli Storage Manager support web page: > > http://www.ibm.com/software/sysmgmt/products/support/IBMTivoli > > StorageManager.html > > > > The only dumb question is the one that goes unasked. > > The command line is your friend. > > "Good enough" is the enemy of excellence. > > > > "ADSM: Dist Stor Manager" wrote on 11/12/2007 > > 07:49:17 AM: > > > > > That did the trick. Thanks for the tip > > > > > > Regards, > > > > > > Kamran > > > > > > -Original Message- > > > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] > > On Behalf > > > Of CAYE PIERRE > > > Sent: Monday, November 12, 2007 4:07 AM > > > To: ADSM-L@VM.MARIST.EDU > > > Subject: Re: [ADSM-L] Is their a way to find out - when was > > the last > > > time a restore was performed for a TSM node. > > > > > > You can also query filespaces : q fi f=d > > > > > > > -Message d'origine- > > > > De : ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] De la > > > > part de Kamran Rao Envoyé : vendredi 9 novembre 2007 21:12 À : > > > > ADSM-L@VM.MARIST.EDU Objet : [ADSM-L] Is their a way to > > find out - > > > > when was the last time a restore was performed for a TSM node. > > > > > > > > Hello, > > > > > > > > > > > > > > > > Just curious to know if their a way to find out - when > > was the last > > > > time a restore was performed for a particular TSM node. > > > > > > > > > > > > > > > > Regards, > > > > > > > > > > > > > > > > Kamran H. Rao > > > > > >
Re: DP for SQL Server mirroring
I don't think you need an external tool. The two ways I can think of are just to run the backup on both nodes, knowing that the backup will fail on the secondary node and succeed on the primary node. Or... in the script, you can use an "osql" command to query the database state and execute the backup only if the database is online. Thanks, Del "ADSM: Dist Stor Manager" wrote on 11/15/2007 05:33:01 AM: > Hoi Del! > I understand that using the same TSM node for backing up the Principal > and the new Principal after a take-over is a solution. > So: if ServerA is the principal, one has to execute the backup script on > this server. After a take-over, ServerB becomes the principal and one > has to execute the backup script (using the same TSM nodename) on > ServerB. If I understand you correctly, one has to use external tools to > determine which server (ServerA of ServerB) is the current Principal? > Thanks again!!! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines
Re: DP for SQL Server mirroring
Hi Del! I think our SQL guys will go for the second solution. We use a third-party scheduling tool (Control-M) and failing backups will create a problem report. I will forward your suggestion to them. Again, thank you very much for your reply! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: donderdag 15 november 2007 13:22 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring I don't think you need an external tool. The two ways I can think of are just to run the backup on both nodes, knowing that the backup will fail on the secondary node and succeed on the primary node. Or... in the script, you can use an "osql" command to query the database state and execute the backup only if the database is online. Thanks, Del "ADSM: Dist Stor Manager" wrote on 11/15/2007 05:33:01 AM: > Hoi Del! > I understand that using the same TSM node for backing up the Principal > and the new Principal after a take-over is a solution. > So: if ServerA is the principal, one has to execute the backup script > on this server. After a take-over, ServerB becomes the principal and > one has to execute the backup script (using the same TSM nodename) on > ServerB. If I understand you correctly, one has to use external tools > to determine which server (ServerA of ServerB) is the current Principal? > Thanks again!!! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: DP for SQL Server mirroring
Hoi Del! I understand that using the same TSM node for backing up the Principal and the new Principal after a take-over is a solution. So: if ServerA is the principal, one has to execute the backup script on this server. After a take-over, ServerB becomes the principal and one has to execute the backup script (using the same TSM nodename) on ServerB. If I understand you correctly, one has to use external tools to determine which server (ServerA of ServerB) is the current Principal? Thanks again!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: woensdag 14 november 2007 13:36 To: ADSM-L@VM.MARIST.EDU Subject: Re: DP for SQL Server mirroring As Steve suggested, test out your scenario using a common nodename. However, you will need to be careful because both servers will have common databases (like master and msdb)... and you do not want those backups for different servers to get mixed in with each other. You could have a separate line in the backup script on both machines that backs up the "mirrored" database on both servers (and point to a similar DSM.OPT file) knowing that the backup on the Mirror machine will fail. You can also look into "Proxy Node". It allows one node to store data on behalf of another node if the correct permissions are granted from the TSM Server side. There are probably a number of other ways to get your desired result. Thanks, Del "ADSM: Dist Stor Manager" wrote on 11/14/2007 04:49:03 AM: > Hi Del! > Let's say ServerA is the Principal and ServerB is the Mirror. > Normally you would schedule a DP backup on ServerA. The > (mirror-)database on ServerB is running in a state which doesn't allow > backing up (restore mode?) Now there is a take-over and ServerB > becomes the new Principal. Now you will have to start backing up the > database on ServerB. > And if everything is switched back to normal, you will be stuck with > backups on the ServerB DP node which never expire, since the backup is > running on ServerA again. > I hope I made myself a little bit more clear? > Again, thank you very much for your reply!!! > Kindest regards, > Eric van Loon > KLM Royal Dutch Airlines ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 **
Re: AW: [ADSM-L] 5.4.2 target release date
Robert Clark wrote: > And still no message level restore of Exchange, without using exmerge? > 2007 you have both mailbox and mailitem retention in exchange, and separate restore volumegroups (or whatever they're called), only an exchange 2000 style exchange admin will need the kind of restores you're looking for. > 2002 called, it wants its restore method back. > > On the up side, the 5.4.1.4 client for Netware appears to address the IC53531 > breakage. > > [RC] > > On Wednesday, November 14, 2007, at 10:04AM, "Wanda Prather" <[EMAIL > PROTECTED]> wrote: >> Yep! >> >> (and 5.3 goes out of service as of April 30, 2008). >> >> >> -- Met vriendelijke groeten, Remco Post SARA - Reken- en Netwerkdiensten http://www.sara.nl High Performance Computing Tel. +31 20 592 3000Fax. +31 20 668 3167 PGP Key fingerprint = 6367 DFE9 5CBC 0737 7D16 B3F6 048A 02BF DC93 94EC "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams
Re: Virtual Volumes & DB Backup
Hello, You should use File Device Class for DB backups. Alper -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of jonesrn Sent: 14 Kasım 2007 Çarşamba 23:44 To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Virtual Volumes & DB Backup I have two TSM 5.4 servers using SATA drives as their targets. (They are named TSM3 and TSM4) I do not have any tape drives or libraries set up. I want to backup the database on TSM3 to TSM4 and vice versa. (As described in an operation suggested in IBM TSM for Linux: Administrator's Guide, ver 5.3, pages 602-607.) However, I get this error: ANR0984I Process 91 for DATABASE BACKUP started in the BACKGROUND at 03:47:08 PM. ANR2280I Full database backup started as process 91. ANR1404W Scratch volume mount request denied - mount failed. ANR4578E Database backup/restore terminated - required volume was not mounted. ANR0985I Process 91 for DATABASE BACKUP running in the BACKGROUND completed with completion state FAILURE at 03:47:09 PM. My strategy was to set up source and target servers for virtual volumes. When I defined the storage pool on the target server I specified the devclass as DISK. As in " define stgpool sourcepool disk". However, on the source server the devclass "targetclass" seems to want a sequential device. I am guessing that this is why it seems to be attempting to mount a scratch volume. Device Class Name: TARGETCLASS Device Access Strategy: Sequential Storage Pool Count: 0 Device Type: SERVER I have not found a way to update the targetclass device from "sequential" to "random" . Is this the best way to achieve my goal? Thanks, Rob +-- |This was sent by [EMAIL PROTECTED] via Backup Central. |Forward SPAM to [EMAIL PROTECTED] +-- Dikkat: Bu elektronik posta mesaji kisisel ve ozeldir. Eger size gonderilmediyse lutfen gondericiyi bilgilendirip mesaji siliniz.Firmamiza gelen ve giden mesajlar virus taramasindan gecirilmekte, guvenlik nedeni ile kontrol edilerek saklanmaktadir.Mesajdaki gorusler gondericiye ait olup HAVELSAN A.S. resmi gorusu olmak zorunda degildir. Attention: This e-mail message is private and privileged.If you are not the recipient for whom this e-mail message is intended, please notify the sender immediately and delete this e-mail message from your system.All sent and received e-mail messages go through a virus scan in our company, and because of security reasons, they are stored after being controlled.Any opinions presented in this e-mail message are solely those of the author and do not necessarily represent HAVELSAN A.S.`s formal and authorized views.