ANR9999D tcpcomm.c(779)
This weekend my server group made some updates to my 4 TSM servers. Since then, every night around midnight 1 or more of the servers are hanging and I have to restart them to restore communications. After they come back I query the actlog and I see the following errors: ANRD tcpcomm.c(779): ThreadId<39> No buffer space is available. The socket cannot be connected.(SESSION: 4193) I start seeing these around prime backup session time. Below are the list of updates that were done to the servers: Firmware upgrades: ESM backplane RAID card Driver upgrades: Network cards RAID card OS upgrades: Service Pack1 Software upgrades: Veritas Storage Foundations 4.3 + MP1 Dell Openmanage 5.0 TSM 5.3.3.1 W2K3 w/SP1 8GB RAM Has anyone had similar problems with this and what have they done to fix this? Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED]
Linux vs. Windows TSM Server Environment
My upper management wants me to provide them with some pros/cons of switching from our current Windows 2K3 TSM server environment to a Linux based one. Is there anyone here that could provide me with a list of pros/cons of both these systems, or know where I could find documentation on this? Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED]
Re: Library & Barcodes
This ability is also available on many ADIC Scalar libraries. There is a volser option that allows you to remove or add the last two digits from the volume label (the part that says L1,L2,L3). I stumbled upon this during a disaster recovery exercise on a scalar 100, and after fumbling around in the menu discovered how to turn it on/off. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard van Denzel Sent: Friday, July 07, 2006 5:44 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Library & Barcodes Hi Gary, I know from Qualstar libraries that this is a feature. On these libraries you are able to switch on or off the reporting of the last 2 characters. I don't know anymore how this was called on the Qualstar but probably you are looking for the same feature on your lib. which probably got reset to default (6 chars) by the actions taken. Best look in the manuals how to change it, I don't know the TS3310 but I will have a look in the manuals too. Met vriendelijke groet, with kind regards, Richard van Denzel. Van: ADSM: Dist Stor Manager namens Matthews, Gary Verzonden: vr 7-7-2006 11:23 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: [ADSM-L] Library & Barcodes Hi, Thanks for the help for a new user so far from you guys, been very useful . Have another for you. We're currently backing up to a TS3310(3576) Library - SAN attached with 2 LTO-3 drives. We had a problem with the touch panel screen on the front - it went dead. IBM engineer reckoned it was a firmware issue, and had us reset the library config, and update to the latest firmware. This cured the panel problem but gave us another. The library is now reporting back to TSM 6 char barcodes not 8 - so we're getting mismatches as the original tapes has internal headers to match the barcodes e.g. IA0010L3 but know TSM sees them as IA0010 until it reads the header. Anyone come across this before?? Is there any config changes I cam make ? ( if this was NetBackup I'd know where lol ) TSM 5.3.3 and W2K3 TIA Gary This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
Re: Deleting a tape that doesn't exist
Those are undocumented options for the delete volhist command that have been available since at least 5.2 (that's when I first had the problem). Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, June 29, 2006 1:24 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Deleting a tape that doesn't exist Thank you for the help. A very interesting command. I just checked my 5.3 Administrators reference and no where does it list "remote" as a valid "type=" option and of course does not list "force=yes" either. But it doesn't include the "volume=" keyword, either. When did these options arrive/appear ? What server level are you running (I am 5.3.2.3). I am not doubting you, but I would like some more info on these non-existant options before I try them, since we have 4-TSM servers interminggled with each other, sharing two library-manager servers across all 4 ? Can Andy or anyone else elighten me ? "Dennis, Melburn W IT743" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 06/29/2006 12:56 PM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Deleting a tape that doesn't exist I had a similar problem once and TSM gave me this nifty command: delete volhist todate=today type=remote volume=volumename force=yes Works well if somehow a tape's status has been lost between server to server communications, where your library manager shows the tape as type remote (meaning that it has been given control over to another server), and the server that is supposed to be using it shows either no info in the volhist or the last entry shows it as being stgdelete. Hope this helps. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, June 29, 2006 12:42 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Deleting a tape that doesn't exist I have this problem tape. The library manager server says the tape is owned/used by a "remote" system/server. When I check the "remote" system, it says it knows nothing about the tape. How can I convince the library manager server that the tape is gone/deleted/kaput so I can relabel the tape and reuse it ? DELETE VOLUME ... DISCARDDATA=YES does nothing. Is there some kind of hidden "force=yes IreallyMeanIt=yes" option I can use ?
Re: Deleting a tape that doesn't exist
Oh and FYI, this command was provided to me by IBM Tivoli Support, so you should be safe ;) Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, June 29, 2006 1:24 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Deleting a tape that doesn't exist Thank you for the help. A very interesting command. I just checked my 5.3 Administrators reference and no where does it list "remote" as a valid "type=" option and of course does not list "force=yes" either. But it doesn't include the "volume=" keyword, either. When did these options arrive/appear ? What server level are you running (I am 5.3.2.3). I am not doubting you, but I would like some more info on these non-existant options before I try them, since we have 4-TSM servers interminggled with each other, sharing two library-manager servers across all 4 ? Can Andy or anyone else elighten me ? "Dennis, Melburn W IT743" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 06/29/2006 12:56 PM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Deleting a tape that doesn't exist I had a similar problem once and TSM gave me this nifty command: delete volhist todate=today type=remote volume=volumename force=yes Works well if somehow a tape's status has been lost between server to server communications, where your library manager shows the tape as type remote (meaning that it has been given control over to another server), and the server that is supposed to be using it shows either no info in the volhist or the last entry shows it as being stgdelete. Hope this helps. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, June 29, 2006 12:42 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Deleting a tape that doesn't exist I have this problem tape. The library manager server says the tape is owned/used by a "remote" system/server. When I check the "remote" system, it says it knows nothing about the tape. How can I convince the library manager server that the tape is gone/deleted/kaput so I can relabel the tape and reuse it ? DELETE VOLUME ... DISCARDDATA=YES does nothing. Is there some kind of hidden "force=yes IreallyMeanIt=yes" option I can use ?
Re: Deleting a tape that doesn't exist
I had a similar problem once and TSM gave me this nifty command: delete volhist todate=today type=remote volume=volumename force=yes Works well if somehow a tape's status has been lost between server to server communications, where your library manager shows the tape as type remote (meaning that it has been given control over to another server), and the server that is supposed to be using it shows either no info in the volhist or the last entry shows it as being stgdelete. Hope this helps. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Thursday, June 29, 2006 12:42 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Deleting a tape that doesn't exist I have this problem tape. The library manager server says the tape is owned/used by a "remote" system/server. When I check the "remote" system, it says it knows nothing about the tape. How can I convince the library manager server that the tape is gone/deleted/kaput so I can relabel the tape and reuse it ? DELETE VOLUME ... DISCARDDATA=YES does nothing. Is there some kind of hidden "force=yes IreallyMeanIt=yes" option I can use ?
Migrating TSM (5.3.2.0) to new Windows box
Our old TSM server is EOL and we are replacing it with a new one. They are both W2K3. What is the safest/best way to migrate? I was planning on installing TSM on the new box and then using a recent database copy on tape to restore the db on the new box using a point in time restore (since the log volumes will not be on the new box). Is this a valid way to do this? Am I missing something? Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED]
Adaptive Subfile backups w/TDP
I have a remote site that has a Lotus notes server with a TDP agent installed to back it up. It backs up across our WAN on a T1 connection. These backups are starting to spill over into business hours and I am having to cancel them in the mornings so that the pipe isn't saturated. I read about adaptive subfile backups and how the work. My question is whether this type of backup works with TDP agents or only with the standard TSM clients. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED]
Re: LTO Drivers for TSM
OK, the only problem I see is what actually happened during our DR Test. I ended up using the TSM device drivers for the HP drives, but the problem is that TSM treats them as GENERICTAPE. All the data that needs to be restored (including the DB tapes) used LTO as the type of device, the problem I had when trying to recover is that it would say the tape is of the wrong device type. So how do I make it so the HP drives are seen as an LTO device in TSM, and not as a GENERICTAPE. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kelly Lipp Sent: Wednesday, May 17, 2006 3:12 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] LTO Drivers for TSM And in the case of HP LTO drives, one uses the TSM device driver rather than the HP native drivers. But I'm sure that the link Richard pointed to discusses that. Kelly J. Lipp VP Manufacturing & CTO STORServer, Inc. 485-B Elkton Drive Colorado Springs, CO 80907 719-266-8777 [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Tuesday, May 16, 2006 8:37 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] LTO Drivers for TSM Dennis - The TSM Support Page http://www.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html contains a Supported Devices area, wherein requirements are enumerated, including device drivers. Richard Sims On May 16, 2006, at 9:25 AM, Dennis, Melburn W IT743 wrote: > Recently our company ran a DR Test with a company called SunGard. Our > contract requested an automated tape library with LTO2 drives in order > for us to execute our TSM portion of the disaster recovery. In our > production environment we use IBM LTO2 drives. When we got there we > found out that they had HP LTO2 drives, and so the drivers that we had > brought with us in our DR tool kits would not work. SunGard was able > to provide us the latest drivers from HP, but those seemed to not be > compatible with TSM, and the generic drivers that come bundled with > TSM did not work either. TSM would recognize the drives as "GENERIC > TAPE" > instead of LTO. In the future we would like to be able to prevent > this in case of a real DR, and have a set of drivers that would work > with all major manufacturers of LTO. What drivers for HP LTO drives > work with TSM, or for that matter any other manufacturer of LTO > besides IBM? > > > Mel Dennis > Systems Engineer - IT743 > Siemens Power Generation > 4400 Alafaya Trail > Orlando, FL 32826 > MC Q1-108 > Tel: (407) 736-2360 > Win: 439-2360 > Fax: (407) 243-0260 > Email: [EMAIL PROTECTED]
Linux vs. Windows TSM servers
My upper management has asked that I compare the performance of a Linux-based TSM server to a Windows-based one in terms of throughput. We currently use Windows TSM servers. Before I start doing any in depth testing and research, has anyone else done this type of comparison and if so, what were your findings? Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED]
Re: LTO Drivers for TSM
Thanks a lot guys for pointing me in the right direction! Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tom Wright Sent: Tuesday, May 16, 2006 11:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] LTO Drivers for TSM Dennis, We have run into this situation as well. I pulled this out of our Gresham Solutions Directory: As you know an IBM LTO drive uses the atape driver on the AIX platform with TSM. However an HP LTO drive is not supported by the atape driver. atape is only for the IBM drive. Therefore in a TSM environment you must configure the HP LTO drive with the "mt" driver, create mt devices in TSM, and use device class LTO with ultrium2c compression. I hope this helps. Tom Wright Director, Product Management Gresham Enterprise Storage www.gresham-computing.com [EMAIL PROTECTED] 512-619-5513
LTO Drivers for TSM
Recently our company ran a DR Test with a company called SunGard. Our contract requested an automated tape library with LTO2 drives in order for us to execute our TSM portion of the disaster recovery. In our production environment we use IBM LTO2 drives. When we got there we found out that they had HP LTO2 drives, and so the drivers that we had brought with us in our DR tool kits would not work. SunGard was able to provide us the latest drivers from HP, but those seemed to not be compatible with TSM, and the generic drivers that come bundled with TSM did not work either. TSM would recognize the drives as "GENERIC TAPE" instead of LTO. In the future we would like to be able to prevent this in case of a real DR, and have a set of drivers that would work with all major manufacturers of LTO. What drivers for HP LTO drives work with TSM, or for that matter any other manufacturer of LTO besides IBM? Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED]
Re: Select statement to find what tape a particular file is on...
First you need to find out what filespace it is assigned to. If you don't already know the filespace that it came from, this can be identified by running the following select statement in the administrative command line: select filespace_name,hl_name,ll_name where node_name='NAME_OF_NODE' and ll_name='V110260.1.65S13M01.MI.16315970.Z' This will identify the filespace name for you. Make sure you use all CAPS for the node_name as well as ll_name fields. Next take that filespace name and run the following select statement: select filespace_name,volume_name from volumeusage where node_name='NAME_OF_NODE' and filespace_name='NAME_OF_FILESPACE' This will identify both onsite and offsite volumes that are assigned to that filespace in particular. Once again use all CAPS for boths fields. Hope this helps. Mel Dennis Systems Engineer Siemens Power Generation Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Wednesday, April 19, 2006 2:52 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Select statement to find what tape a particular file is on... How would I be able to tell what onsite tape the following file is located on? /n03/data/penv/merc/restored/V110260.1.65s13m01.mi.16315970.Z Someone is trying to restore this file and it keeps trying to go to the offsite tape, but I do not see any reference to an onsite tape within the activity log, so I thought I would try to figure out what tape it is on... Any ideas? Thanks in advance! Joni Moyer Highmark Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966 Fax: (717) 302-9826 [EMAIL PROTECTED]
Re: Export Archive files from one TSM server to another
Can't. The old TSM server was a UNIX server. The new server is W2K3. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 243-0260 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of LeBlanc, Patricia Sent: Wednesday, April 05, 2006 12:56 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Export Archive files from one TSM server to another Restore your tsm database to the new server. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis, Melburn W IT743 Sent: Wednesday, April 05, 2006 12:44 PM To: ADSM-L@VM.MARIST.EDU Subject: Export Archive files from one TSM server to another I recently tried exporting just the archived files of a node registered on our old TSM server to the same node on our new TSM server that we are migrating to. On the new server, the node has been backing up without any problems. I executed the below command: export node NODENAME filedata=archive toserver=SERVERNAME mergefilespaces=yes When I did this, it created some new filespaces that existed on the old tsm server onto the new tsm server. Basically I now had 2 c$ filespaces as well as 2 d$ filespaces (one unicode, one not). All of a sudden, the client started to backup to the newly created c$ and d$ filespace that were not unicode and acted as if the client had never backed up before, so it did a full backup. Why is this? I just want to export all of our archived data to the new TSM server so we can shutdown the old one. Any suggestions? Mel Dennis
Export Archive files from one TSM server to another
I recently tried exporting just the archived files of a node registered on our old TSM server to the same node on our new TSM server that we are migrating to. On the new server, the node has been backing up without any problems. I executed the below command: export node NODENAME filedata=archive toserver=SERVERNAME mergefilespaces=yes When I did this, it created some new filespaces that existed on the old tsm server onto the new tsm server. Basically I now had 2 c$ filespaces as well as 2 d$ filespaces (one unicode, one not). All of a sudden, the client started to backup to the newly created c$ and d$ filespace that were not unicode and acted as if the client had never backed up before, so it did a full backup. Why is this? I just want to export all of our archived data to the new TSM server so we can shutdown the old one. Any suggestions? Mel Dennis
APAR IC48731
Is anyone else having issues with this bug in 5.3.2.3? Many of my space reclamation processes and my copy storage pool processes are failing because of this bug. Is there any temporary fix for this that anyone has been able to find? We have a DR test coming up soon, and since some of these copy storage pool processes are failing, the data is not able to be copied for the offsite vaulting and so we may have some issues with our DR because of missing data. Any help would be appreciated. Mel Dennis
Limits to TSM Reporting Tool?
Is there a limit to the number of reports (aka containers) that the reporting tool can handle? I've been seeing problems with the reporting tool not working at all as soon as pass the 60 mark. Anyone else seeing this? Any way to increase this threshold or is this a limitation in the software? Mel Dennis
Restores showing as successful but are not.
Recently we had a drive on one of our servers accidentally deleted, and so a TSM restore process was started to recover the information that was lost. The restore was thought to be a success, but as days went by, more and more users were reporting that files were missing. I queried the summery tables for the restore sessions of that particular server and noticed that even though it says it was successful, it did not finish because for whatever reason the session was lost (network outage, etc). We did not think to look and see if there was a restartable restore at the time, because the restore was reported as being successful. When we opened a ticket IBM support, this is what we got: "If the restore process stops because of a power outage or network failure, the server records the point at which this occurred. This record is known to the client as a restartable restore." -IBM TSM My question is how does the client inform you that there is a restartable restore that needs to be done, and why in the database, is it showing that the restore session was successful, when in fact this is false. Is there something that we missed? Any help in this regards would be greatly appreciated. Mel Dennis
Backing up a MySQL database
Can this be done with the standard TSM 5.3.X client, or do I need a special app for this? Mel Dennis
Enabling the Central Scheduler
Recently I did a test disaster recovery of my TSM development environment. Ever since I restored the environment using the DR Recovery plan file, running a 'q status' shows that the Central Scheduler is disabled, and I am unsure of how to enable it. I've looked at the admin command guide and I don't see any commands to enable it. Mel Dennis
Testing the DRM restore process
I am doing a test disaster recovery, and I am unable to restore the database. I have manually mounted the the db tape into the drive and I have properly configured the device class, library and drives in tsm prior to doing the restore. I stop the tsm service and then run the RECOVERY.SCRIPT.DISASTER.RECOVERY.MODE.CMD file. Everything runs fine until it tries to restore the databaseI get this: ANR4726I The ICC support module has been loaded. ANR8200I TCP/IP driver ready for connection with clients on port 1500. ANR0200I Recovery log assigned capacity is 8 megabytes. ANR0201I Database assigned capacity is 12 megabytes. ANR4600I Processing volume history file T:\TSM\SERVER1\VOLHIST.OUT. ANR4619I Snapshot database backup series 12 using device class LTO2CLASS. ANR4622I Volume 1: DEV014. ANR4634I Starting point-in-time database restore to date 01/16/2006 07:30:04. ANR8772I Moving volume DEV014 from drive LTODRV02 to slot 4102 in library ADIC-DEV. ANR8312E Volume DEV014 could not be located in library ADIC-DEV. ANR1402W Mount request denied for volume DEV014 - volume unavailable. ANR4578E Database backup/restore terminated - required volume was not mounted. Also, before stopping the service I did a checkin libvol command to let TSM know what tapes were in the library, and I've tried running the script with the tape in the home slot as well with similar results. Any ideas as to what I am missing? The TSM guide is very vague as to what steps are involved in actually do the restore. Mel Dennis
Offiste Space Reclamation Issues
Lately I have been having problems with TSM running offiste space reclamation. I have it scheduled to run reclamation on the offsite storage pools in the evening, and it seems that every evening, I start getting read errors as well as tape drive issues. This only occurs after the schedule kicks off. I have copy stgpool processes that run during the day that have no problems, and all the drives function fine during that time, so it does not appear to be a drive issue. Also, it does not appear to be a tape issue either, as I have repeatedly marked the questionable tapes as unavailable, only to have new tapes with problems the next night. Anyone else experiencing this? W2K3 TSM 5.3.2.0 Mel Dennis
How do I restore a database using a virtual volume?
Our configuration manager for our group of tsm servers has gone down and we need to restore the database for it. The thing is, it was backed-up using virtual volumes to one of the other tsm servers. We know which tape it is, but are unsure of how to do the restore. Mel Dennis
Re: Collocation Questions
OK, well that answers a lot of my questions, but is this still the case when your copy storage pool tapes are usually offsite? I tried to do a move nodedata in our test domain for the copy pool and it gave me errors stating that it could not move the data in the storage pool for that particular node, because the tapes were "offsite", which they are. So will the data in the copy storage pools still collocate over time even if the tapes are offsite in a vaulting location? Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Tuesday, January 03, 2006 5:00 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Collocation Questions Yes, you can collocate the copy pool and not the primary pool, no problem. Yes, it will decrease the number of tapes per node. However, If you are sending the copy pool tapes offsite with a manual pull/courier process, it will increase the number of tapes for your courier run (which is why most sites don't collocate the copy pools). In TSM 5.3, you can do collocation by a group of nodes. If you have just a handfull of very important clients, for example, you could put them all in the same collocation group, and just collocate those nodes. As far as doing MOVE NODEDATA, that's up to you. When you turn collocation on, any newly written output is collocated. Any old data stays where it is. So as migration and reclamation occur, the data will gradually, over time, all get collocated, even if you don't do MOVE NODEDATA. So the situation will gradually get better by itself, but not necessarily quickly. An appropriate strategy might be to do MOVE NODEDATA for your most critical clients, and leave the less important ones alone. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Tuesday, January 03, 2006 4:46 PM To: ADSM-L@VM.MARIST.EDU Subject: Collocation Questions I am doing server recovery exercises at all of our sites that have TSM servers (TSM 5.3.2.0 on W2K3). Part of the recovery process is to recall back tapes in our copy storage pools that belong to the node that is being recovered. One of the things I have noticed is that we are not using collocation at our sites, and because of this, I am having to call back a large amount of tapes for just one node. If I turn on collocation on the copy storage pools, will this decrease the number of tapes that are used per node? Do I have to do a move nodedata command after turning collocation on for collocation to work? The reason why I don't want to turn collocation on the primary storage pools is space (we have a small library at most of the sites) and so I just want the copy storage pools to be collocated. Will this work, without having the primary storage pools collocated as well? Mel Dennis
Collocation Questions
I am doing server recovery exercises at all of our sites that have TSM servers (TSM 5.3.2.0 on W2K3). Part of the recovery process is to recall back tapes in our copy storage pools that belong to the node that is being recovered. One of the things I have noticed is that we are not using collocation at our sites, and because of this, I am having to call back a large amount of tapes for just one node. If I turn on collocation on the copy storage pools, will this decrease the number of tapes that are used per node? Do I have to do a move nodedata command after turning collocation on for collocation to work? The reason why I don't want to turn collocation on the primary storage pools is space (we have a small library at most of the sites) and so I just want the copy storage pools to be collocated. Will this work, without having the primary storage pools collocated as well? Mel Dennis
Re: TSM Data Recovery Tests
W2K3 servers, with the clients also being W2K3 or Windows XP prof. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ochs, Duane Sent: Monday, December 19, 2005 4:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Data Recovery Tests No, you don't register the test server at all. What OS are you working with ? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Monday, December 19, 2005 3:04 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM Data Recovery Tests So do I register the test server under a different name? Sorry, I'm relatively new to TSM. I've also heard of granting proxynode, but that doesn't seem to work. I've tried registering the test server in TSM and then granting it proxynode to the server I want to restore from, but when I open the client I don't see the node I was granted proxy to. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ochs, Duane Sent: Monday, December 19, 2005 3:56 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Data Recovery Tests Set the virtualnodename in the dsm.opt of your test server to that of the actual server. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Monday, December 19, 2005 2:54 PM To: ADSM-L@VM.MARIST.EDU Subject: TSM Data Recovery Tests Our site has requested that I conduct random server recovery exercises involving restoring the data from tape onto a spare test server and comparing it to the data that is in my production environment. Where I am running into a problem is when it comes to the test server logging into TSM to restore data from a server that is in production and does nightly scheduled backups. Every time I login via the TSM client and begin the full restore (which can take overnight because of the amount of data) it stops the actual production server from logging in at it's scheduled time to do its backup. Is there a way for my test server to login and do restore of a production server without preventing the production server from doing it's scheduled backups? Mel Dennis
Re: TSM Data Recovery Tests
So do I register the test server under a different name? Sorry, I'm relatively new to TSM. I've also heard of granting proxynode, but that doesn't seem to work. I've tried registering the test server in TSM and then granting it proxynode to the server I want to restore from, but when I open the client I don't see the node I was granted proxy to. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-108 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ochs, Duane Sent: Monday, December 19, 2005 3:56 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Data Recovery Tests Set the virtualnodename in the dsm.opt of your test server to that of the actual server. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Monday, December 19, 2005 2:54 PM To: ADSM-L@VM.MARIST.EDU Subject: TSM Data Recovery Tests Our site has requested that I conduct random server recovery exercises involving restoring the data from tape onto a spare test server and comparing it to the data that is in my production environment. Where I am running into a problem is when it comes to the test server logging into TSM to restore data from a server that is in production and does nightly scheduled backups. Every time I login via the TSM client and begin the full restore (which can take overnight because of the amount of data) it stops the actual production server from logging in at it's scheduled time to do its backup. Is there a way for my test server to login and do restore of a production server without preventing the production server from doing it's scheduled backups? Mel Dennis
TSM Data Recovery Tests
Our site has requested that I conduct random server recovery exercises involving restoring the data from tape onto a spare test server and comparing it to the data that is in my production environment. Where I am running into a problem is when it comes to the test server logging into TSM to restore data from a server that is in production and does nightly scheduled backups. Every time I login via the TSM client and begin the full restore (which can take overnight because of the amount of data) it stops the actual production server from logging in at it's scheduled time to do its backup. Is there a way for my test server to login and do restore of a production server without preventing the production server from doing it's scheduled backups? Mel Dennis
Re: Normal # of failures on tape libraries
Ahh, so it's the fact that they are LTO drives. So as far as LTO drives go then, what I am experiencing is "normal"? Mel Dennis -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Zoltan Forray/AC/VCU Sent: Tuesday, December 13, 2005 2:26 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Normal # of failures on tape libraries I agree. My 3590's (both B and E1A models) have been through major pounding, for many, many years, and like the Energizer Bunny, keep going and going. Yes, they do need some repairs/maintenance, but considering the amount of data/mounts/tapes they go through on a daily basis, they are like tanks. Never had a whole drive, replaced. Usually things like cleaning brushes, sometimes R/W heads, 2-3 card-packs, stuff like that. This in contrast to my [EMAIL PROTECTED]&* IBM 3583/3580 LTO2 drives, which over the 1.5-years I have been using them, all 8-drives have been replaced, at least once, some more. I haven't kept strict tabs on them, but considering I just had 3-replaced over the past 2-weeks, from my experience, LTO2 drives are garbage. They require weekly, if not daily, attention. The 2-LTO libraries have 300-tapes between them, the 3494 library with the 3590 drives has over 3700, with 400+ mounts a day ! FWIW, when I went to a "storage" show-and-tell-and-try-to-sell, the ADIC folks told me they OEM their drives from IBM ! Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 12/13/2005 02:01 PM Please respond to "ADSM: Dist Stor Manager" To ADSM-L@VM.MARIST.EDU cc Subject Re: [ADSM-L] Normal # of failures on tape libraries On Dec 13, 2005, at 11:31 AM, Dennis Melburn W IT743 wrote: > Our sites use ADIC Scalar 1Ks as well as one ADIC 10K. The Scalar 1Ks > have 4 LTO1 drives in each and the 10K has 34 LTO2 drives. We > experience occasional failures on these drives and have to replace > them. > My question is, is it normal for a site that has alot of drives to > experience drive failures about every 1-1.5 months? My manager is > rather annoyed at the fact that it seems that we are constantly > replacing drives even though it doesn't cause any downtime for our TSM > servers while they are being replaced. If this is a normal part of > having tape libraries then that is fine, but I don't have enough > experience in this field to say either way, so that is why I am asking > all of you. Customers with 359x drives (which are never replaced) would certainly find that replacement frequency alarming; and from any perspective, that's rather extreme. Your site may have periodic management-level review meetings with the vendor, where a good explanation should be required of the vendor. Your management might then specify that if a resolution to the problem is not forthcoming, then they might abandon that vendor for another. (A complication there is that ADIC has been the OEM for some name-brand drive resellers.) Make sure they review external factors for cause, such as bad power feeding the drives, excessive contaminants in the local atmosphere, tapes coming back from offsite after rough handling, etc. In any site where drive replacement occurs with any frequency, I would advise chronicling the serial numbers of all such drives. You would like to believe that you are getting new drives as replacements, where the serial number should be nearby or higher than that being replaced - and that you don't find the same drive coming back sometime later. Richard Sims
Normal # of failures on tape libraries
Our sites use ADIC Scalar 1Ks as well as one ADIC 10K. The Scalar 1Ks have 4 LTO1 drives in each and the 10K has 34 LTO2 drives. We experience occasional failures on these drives and have to replace them. My question is, is it normal for a site that has alot of drives to experience drive failures about every 1-1.5 months? My manager is rather annoyed at the fact that it seems that we are constantly replacing drives even though it doesn't cause any downtime for our TSM servers while they are being replaced. If this is a normal part of having tape libraries then that is fine, but I don't have enough experience in this field to say either way, so that is why I am asking all of you. Mel Dennis
DRM Recovery Plan File Implememtation
I am implemention a schedule to execute the prepare command using our dbsnapshots as the source. The dbsnapshots are scheduled to run twice a week to coincide with our biweekly pickup of tapes to be shipped off to our vaulting location for disaster recovery purposes. My question is, how often should I run the schedule to prepare the recovery plan file? Should I only have it run after each dbsnapshot? Should I run it each day? Any help in this matter would be greatly appreciated. Mel Dennis
MAXSCRATCH value in tape storage pools
I migrated our W2K3 TSM server recently from 5.2.1.3 to 5.3.2.0 and I've had to change the MAXSCRATCH parameter on our tape storage pools from 0 to some arbitrary number like 1000 because migrations, as well as backup storage pool commands have been failing. Any reason why this is? Is 0 a valid MAXSCRATCH value in 5.3.2.0? If not, any suggestions as to what value I should set each of the storage pools to? Mel Dennis
Re: Space Reclamation Eating Tapes
Such as? :) Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-110 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Sent: Monday, November 28, 2005 9:53 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Space Reclamation Eating Tapes Things have changed in 5.3. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: maandag 28 november 2005 15:35 To: ADSM-L@VM.MARIST.EDU Subject: Re: Space Reclamation Eating Tapes Don't think that is it, I only have 2 storage pools out of like 12 that have collocation turned on (these storage pools are for large file servers). So collocation shouldn't be affecting most of them. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-110 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Sent: Monday, November 28, 2005 9:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Space Reclamation Eating Tapes Sounds like a collocation problem. Q stg / q node / q collocgroup. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: maandag 28 november 2005 15:22 To: ADSM-L@VM.MARIST.EDU Subject: Space Reclamation Eating Tapes I recently migrated our Windows 2K3 TSM server from 5.2.1.3 to 5.3.2.0 and since then, it seems that whenever I kick off space reclamation for my primary tape storage pools, it eats up scratch tapes, instead of freeing them up. Is there a reason for this? I understand that occasionally TSM will need a scratch tape to combine other tapes, but it should then free those other tapes up and return them to the scratch pool. I've checked the reuse delay on the storage pools, and they are set to 0, so I know that isn't the problem. Mel Dennis
Re: Space Reclamation Eating Tapes
Don't think that is it, I only have 2 storage pools out of like 12 that have collocation turned on (these storage pools are for large file servers). So collocation shouldn't be affecting most of them. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-110 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bos, Karel Sent: Monday, November 28, 2005 9:30 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Space Reclamation Eating Tapes Sounds like a collocation problem. Q stg / q node / q collocgroup. Regards, Karel -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: maandag 28 november 2005 15:22 To: ADSM-L@VM.MARIST.EDU Subject: Space Reclamation Eating Tapes I recently migrated our Windows 2K3 TSM server from 5.2.1.3 to 5.3.2.0 and since then, it seems that whenever I kick off space reclamation for my primary tape storage pools, it eats up scratch tapes, instead of freeing them up. Is there a reason for this? I understand that occasionally TSM will need a scratch tape to combine other tapes, but it should then free those other tapes up and return them to the scratch pool. I've checked the reuse delay on the storage pools, and they are set to 0, so I know that isn't the problem. Mel Dennis
Space Reclamation Eating Tapes
I recently migrated our Windows 2K3 TSM server from 5.2.1.3 to 5.3.2.0 and since then, it seems that whenever I kick off space reclamation for my primary tape storage pools, it eats up scratch tapes, instead of freeing them up. Is there a reason for this? I understand that occasionally TSM will need a scratch tape to combine other tapes, but it should then free those other tapes up and return them to the scratch pool. I've checked the reuse delay on the storage pools, and they are set to 0, so I know that isn't the problem. Mel Dennis
Tape Volumes with ANR1330E & ANR1331E Errors
Recently I have had to restore about a dozen tapes that had the following types of errors: 10/20/2005 11:18:55 ANR1330E The server has detected possible corruption in an object being restored or moved. The actual values for the incorrect frame are: magic 6A626F20 hdr version 15373 hdr length 8252 sequence number 542322445 data length 2044542F server id 541142797 segment id 3467831332459061339 crc 31205220. (SESSION: 18799) 10/20/2005 11:18:55 ANR1331E Invalid frame detected. Expected magic 53454652 sequence number 0004 server id segment id 000179870370. (SESSION: 18799) In a previous inquery to this, I was told to basically restore the corrupted volumes. This has apparently worked, as I no longer get these errors. My question is, are these tapes permanently damaged, or were just the files corrupted? Is it ok for me to reinsert these tapes in as scratch, or is there actually something physically wrong with the tapes that will cause the same errors to reappear? Mel Dennis
Re: Errors when running Space Reclamation
Your right, I am on a Windows 2K3 server and I recently migrated from version 5.2.1.3 to 5.3.2.0. I'll try out those suggestions. Mel Dennis Systems Engineer - IT743 Siemens Power Generation 4400 Alafaya Trail Orlando, FL 32826 MC Q1-110 Tel: (407) 736-2360 Win: 439-2360 Fax: (407) 736-5069 Email: [EMAIL PROTECTED] -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Monday, November 21, 2005 11:13 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Errors when running Space Reclamation When posting PLEASE INCLUDE YOUR SERVER platform & version. If you have recently upgraded to TSM 5.3.x, it may be IC47584. I have a PMR open and am hoping to get a test fix shortly. While annoying, it appears to be harmless. Try cleaning up that volume by doing a MOVE DATA instead of a reclamation. If that doesn't work, see if it is continually trying to mount the same output tape. If so, mark that tape as READONLY until you get past this problem. In every case, by simply changing the combination of input/output tapes, I've been able to get past it. (But then it just pops up in another place a few days later.) I am TSM 5.2.3.0 on Windows. Wanda Prather "I/O, I/O, It's all about I/O" -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Monday, November 21, 2005 9:06 AM To: ADSM-L@VM.MARIST.EDU Subject: Errors when running Space Reclamation I have been recieving Space Reclamation Failures on my TSM server lately and I am not sure why. When I go back to the time of the events, I get the following ANRD log report: (sorry for the length of the report, but I figured it would be best to include it all) 11/20/2005 15:59:12 ANR8337I LTO volume A00541 mounted in drive LTODRV13 (mt4.3.1.3). (SESSION: 25342) 11/20/2005 15:59:12 ANR0510I Session 25342 opened input volume A00541. (SESSION: 25342) 11/20/2005 16:00:28 ANRD afmove.c(5788): ThreadId<43> Unexpected result code (45) from ssCopy. (SESSION: 25342) 11/20/2005 16:00:28 ANRD ThreadId<43> issued message from: (SESSION: 25342) 11/20/2005 16:00:28 (43) Context report (SESSION: 25342) 11/20/2005 16:00:29 (43) Thread SsAuxSinkThread (45) is a child thread related to: 43 (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) (SESSION: 25342) 11/20/2005 16:00:29 (45) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating Database Transaction Table Context: (SESSION: 25342) 11/20/2005 16:00:29 (45) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating SM Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) *** no sessions found *** (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating AS Vol Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No mounted (or mount in progress) volumes. (SESSION: 25342) 11/20/2005 16:00:29 (45) Failed attempt #1 to get SSV->mutex (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating ssSession Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No storage service sessions active. (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating ssOpenSeg Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No storage service segments found. (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating BF Copy Control Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No global copy control blocks. (SESSION: 25342) 11/20/2005 16:00:29 (SESSION: 25342) 11/20/2005 16:00:29 (43) Thread SsAuxSrcThread (46) is a child thread related to: 43 (SESSION: 25342) 11/20/2005 16:00:29 (46) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) (SESSION: 25342) 11/20/2005 16:00:29 (46) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (46) Generating Database Transaction Table Context: (SESSION: 25342) 11/20/2005 16:00:29 (46) Tsn=0:160675859 --> Valid=1, inRollback=0, endNTA=0, State=2, Index=3, LatchCount=0, SavePoint=0, TotLogRecs=0, TotLogBytes=0, UndoLogRecs=0, UndoLogBytes=0, LogReserve=0, PageReserve=0, Elapsed=99 (secs), MinLsn=0.0.0, MaxLsn=0.0.0, LastLsn=0.0.0, UndoNextLsn=0.0.0, logWriter=False, backupTxn=False (SESSION: 25342) 11/20/2005 16:00:29
Errors when running Space Reclamation
I have been recieving Space Reclamation Failures on my TSM server lately and I am not sure why. When I go back to the time of the events, I get the following ANRD log report: (sorry for the length of the report, but I figured it would be best to include it all) 11/20/2005 15:59:12 ANR8337I LTO volume A00541 mounted in drive LTODRV13 (mt4.3.1.3). (SESSION: 25342) 11/20/2005 15:59:12 ANR0510I Session 25342 opened input volume A00541. (SESSION: 25342) 11/20/2005 16:00:28 ANRD afmove.c(5788): ThreadId<43> Unexpected result code (45) from ssCopy. (SESSION: 25342) 11/20/2005 16:00:28 ANRD ThreadId<43> issued message from: (SESSION: 25342) 11/20/2005 16:00:28 (43) Context report (SESSION: 25342) 11/20/2005 16:00:29 (43) Thread SsAuxSinkThread (45) is a child thread related to: 43 (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) (SESSION: 25342) 11/20/2005 16:00:29 (45) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating Database Transaction Table Context: (SESSION: 25342) 11/20/2005 16:00:29 (45) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating SM Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) *** no sessions found *** (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating AS Vol Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No mounted (or mount in progress) volumes. (SESSION: 25342) 11/20/2005 16:00:29 (45) Failed attempt #1 to get SSV->mutex (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating ssSession Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No storage service sessions active. (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating ssOpenSeg Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No storage service segments found. (SESSION: 25342) 11/20/2005 16:00:29 (45) Generating BF Copy Control Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (45) No global copy control blocks. (SESSION: 25342) 11/20/2005 16:00:29 (SESSION: 25342) 11/20/2005 16:00:29 (43) Thread SsAuxSrcThread (46) is a child thread related to: 43 (SESSION: 25342) 11/20/2005 16:00:29 (46) Generating TM Context Report: (struct=tmTxnDesc) (slots=256) (SESSION: 25342) 11/20/2005 16:00:29 (46) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (46) Generating Database Transaction Table Context: (SESSION: 25342) 11/20/2005 16:00:29 (46) Tsn=0:160675859 --> Valid=1, inRollback=0, endNTA=0, State=2, Index=3, LatchCount=0, SavePoint=0, TotLogRecs=0, TotLogBytes=0, UndoLogRecs=0, UndoLogBytes=0, LogReserve=0, PageReserve=0, Elapsed=99 (secs), MinLsn=0.0.0, MaxLsn=0.0.0, LastLsn=0.0.0, UndoNextLsn=0.0.0, logWriter=False, backupTxn=False (SESSION: 25342) 11/20/2005 16:00:29 (46) Open objects: (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AF.Damaged<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->BF.Aggregate.Attributes<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AF.Vol.Segments<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->Restore.Sessions<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->Collocation.Group.Member<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AF.Vol.Clusters<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AS.Volume.Status<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AF.Segments<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AF.Bitfiles<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->AF.Vol.Partial.Bitfiles<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->SS.Volume.Names<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46)name ->SS.Volume.Ids<- (sp=0) (SESSION: 25342) 11/20/2005 16:00:29 (46) *** no transactions found *** (SESSION: 25342) 11/20/2005 16:00:29 (46) Generating SM Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (46) *** no sessions found *** (SESSION: 25342) 11/20/2005 16:00:29 (46) Generating AS Vol Context Report: (SESSION: 25342) 11/20/2005 16:00:29 (46) Mounted (or mount in progress) volumes: (SESSION: 25342) 11/20/2005 16:00:29
Moving a node from one domain to another
Is there a safe way to move one node (and all the corresponding archive and backup data) from one policy domain to another? Mel Dennis
Re: Database backup tapes taking over
I spoke with IBM support concerning this matter and William is right. Apparently since the Full backup tapes are not going offsite, the DRM is technically not managing them, so it is ok to use the delete volhist for those. I have setup a schedule to do this once per day, starting today. All the sites have got back about 40-50 scratch tapes...YAY!! Mel Dennis -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: Wednesday, November 09, 2005 9:55 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Database backup tapes taking over OK...but I was under the impression that you could not set a DB backup expire in DRM AND run a 'delete volhist type=dbb'. Just trying to help, but if I'm wrong, I stand corrected. :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of William Boyer Sent: Wednesday, November 09, 2005 6:55 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Database backup tapes taking over According to his original email, the DBBackup tapes stay ONSITE. For the DBBackup tapes to be expired via DRM and expiration they need to be OFFSITE. He'll have to use the DEL VOLHIST command if he keeps them onsite. Bill Boyer "Some days you're the bug, some days you're the windshield" - ?? -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Bell, Charles (Chip) Sent: Tuesday, November 08, 2005 12:19 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Database backup tapes taking over In DRM, you need to set a value for 'DB Backup Series Expiration Days', I think with the 'set drmdbbackupexpiredays xx', xx being the number of days you wish to retain db backups offsite before returning. Hope this helps! Once you run this command, you will get those tapes back. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Tuesday, November 08, 2005 10:30 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Database backup tapes taking over I have noticed that ever since I started using the DRM, alot of my TSM servers have been steadily decreasing in scratch tapes by alot. My servers are scheduled to run a Full Database backup once per day, with a a Database Snapshot once per week. The full database copies stay on site, while the snapshot gets sent off site weekly. I have the database expire variable in the DRM set to 14 days. The question I have is why do all my sites have like 40-60 database tapes, when there should only be 14. Am I doing something wrong? Mel Dennis - Confidentiality Notice: The information contained in this email message is privileged and confidential information and intended only for the use of the individual or entity named in the address. If you are not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this information is strictly prohibited. If you received this information in error, please notify the sender and delete this information from your computer and retain no copies of any of this information.
Re: SQL query to find expiring archive files
I was planning on writing this script in Java, as I have some practice writing in this language. I have written a program before that was able to access a MySQL database, but that required a JDBC driver that worked with MySQLis there anything similar for TSM? Mel Dennis -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Thursday, November 03, 2005 3:32 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL query to find expiring archive files I don't know if this will help you at all, but when I had to do something similar using the backups table, I found that I could do much better by driving the query from a higher-level script (perl, for example). The archives (and backups) tables are the biggest and ugliest tables you can go after. They are indexed on NODE_NAME (and some other fields). In a host languae script you can first query to get all the node names, then run the query to get your info repetively, one node_name at a time, writing the output to a file. While it is more trouble to write, doing one node at a time may run a lot faster overall than running the query against the entire archives table without using an index. I don't know in your case whether the impact of the join and the CASE statement will be such that it negates the benefit of using the indexes. That's just the only suggestion I have to offer. Wanda Prather "I/O, I/O, It's all about I/O" -(me) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Melburn W IT743 Sent: Thursday, October 27, 2005 2:35 PM To: ADSM-L@VM.MARIST.EDU Subject: SQL query to find expiring archive files Many of the sites that I manage have asked to recieve a quarterly report showing a list of archive files that are going to expire within the next year. I was able to design an SQL query that does this, but my problem is that it takes a really long time. Is there some other way to go about doing this that I am not aware of? Here is the sql query: select - archives.node_name as "NODE_NAME",- archives.filespace_name as "FILESPACE_NAME",- archives.type as "TYPE",- archives.hl_name as "HL_NAME",- archives.ll_name as "LL_NAME",- substr(char(archives.archive_date), 1, 10) as "ARCHIVE_DATE",- case - when ar_copygroups.retver = 'NOLIMIT' then substr(char(archives.archive_date + 100 years), 1, 10) - else substr(char(archives.archive_date + ar_copygroups.retver days), 1, 10) - end as "EXPIRATION_DATE" - from archives, nodes, domains, ar_copygroups - where archives.node_name = nodes.node_name - and nodes.domain_name = domains.domain_name - and domains.defmgmtclass = ar_copygroups.class_name - and ar_copygroups.set_name = 'ACTIVE' - and days(date(case - when ar_copygroups.retver = 'NOLIMIT' then substr(char(archives.archive_date + 100 years), 1, 10) - else substr(char(archives.archive_date + ar_copygroups.retver days), 1, 10) - end)) - days(date(archives.archive_date)) <= 365 BTW, I ran this query against one of my smaller sites that only has about 12 GB of data archived, and it took about 22 minutes. At my main site, I have multiple TSM backup servers that have well into the 3-4 TB range. As you can see, this would take about 5 days to finish at the same rate! Mel
Database backup tapes taking over
I have noticed that ever since I started using the DRM, alot of my TSM servers have been steadily decreasing in scratch tapes by alot. My servers are scheduled to run a Full Database backup once per day, with a a Database Snapshot once per week. The full database copies stay on site, while the snapshot gets sent off site weekly. I have the database expire variable in the DRM set to 14 days. The question I have is why do all my sites have like 40-60 database tapes, when there should only be 14. Am I doing something wrong? Mel Dennis
SQL query to find expiring archive files
Many of the sites that I manage have asked to recieve a quarterly report showing a list of archive files that are going to expire within the next year. I was able to design an SQL query that does this, but my problem is that it takes a really long time. Is there some other way to go about doing this that I am not aware of? Here is the sql query: select - archives.node_name as "NODE_NAME",- archives.filespace_name as "FILESPACE_NAME",- archives.type as "TYPE",- archives.hl_name as "HL_NAME",- archives.ll_name as "LL_NAME",- substr(char(archives.archive_date), 1, 10) as "ARCHIVE_DATE",- case - when ar_copygroups.retver = 'NOLIMIT' then substr(char(archives.archive_date + 100 years), 1, 10) - else substr(char(archives.archive_date + ar_copygroups.retver days), 1, 10) - end as "EXPIRATION_DATE" - from archives, nodes, domains, ar_copygroups - where archives.node_name = nodes.node_name - and nodes.domain_name = domains.domain_name - and domains.defmgmtclass = ar_copygroups.class_name - and ar_copygroups.set_name = 'ACTIVE' - and days(date(case - when ar_copygroups.retver = 'NOLIMIT' then substr(char(archives.archive_date + 100 years), 1, 10) - else substr(char(archives.archive_date + ar_copygroups.retver days), 1, 10) - end)) - days(date(archives.archive_date)) <= 365 BTW, I ran this query against one of my smaller sites that only has about 12 GB of data archived, and it took about 22 minutes. At my main site, I have multiple TSM backup servers that have well into the 3-4 TB range. As you can see, this would take about 5 days to finish at the same rate! Mel