ACO5423E TDPsql error
I am getting an error on a couple of Windows 2003 SP2 servers - one has MS 2005 SQL Express and the other has the full MS 2005 SQL installed. The TDP SQL client software is version 5.3.3.0 and I have also installed the 22699_4 patch. The error is - ACO5423E Microsoft ODBC SQL Server Driver DBNETLIB SQL Server does not exist or access denied. I have gone into SQL Surface area configuration for Services and Connections and ensured that Remote Connections are enabled. Any suggestions? Thanks Regards Paul Paul Dudley Senior IT Systems Administrator ANL Container Line Pty Limited Email: pdud...@anl.com.au ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
Re: TSM 6.2 DB restore not working
Hi, I had the same problem. Try define everything without any sn or wwn numbers, in this direction: Define library Define drive Define path (to library) Define path (drive) ... Regards, Jakub -- Jakub Głębicki Senior IT Administrator Bank DnB NORD Polska S.A. _ ul. Postępu 15C, 02-676 Warszawa tel. 022 524 1618, fax. 022 524 1001 http://www.dnbnord.pl/ -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of TSM User Sent: Wednesday, May 05, 2010 7:24 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM 6.2 DB restore not working I'm trying to restore a database backup to a new server. It's 6.2 on Windows 2008 64-bit, with an HP library and LTO3 drives. I cannot get the library to see the TSM device driver, and it shows up as Unknown Medium Changer. I tried deleting the devices and installing the driver, but it came back the same way. Any attempts to install it just return a message that it's at the most current level. Thing is, yesterday I was able to work around it. I was able to change devconf.out to make the library a manual one, and it would mount tapes. I had to do some other stuff that necessitated switching back to the old server and taking a new database backup, and when we came back up on the new server, the devconf.out was basically wiped, probably on reboot. Now, when I try to make the library a manual one, I'm getting an error message that the device parameter in the define path line is not valid for a 349x library. I have no clue why it's trying to make it that kind of library. I've tried a number of different configs, and I'm beating my head against a wall at this point. Original devconf.out (modified for privacy): /* Device Configuration */ DEFINE DEVCLASS LT03 DEVTYPE=LTO FORMAT=DRIVE MOUNTLIMIT=DRIVES MOUNTWAIT=60 MOUNTRETENTION=60 PREFIX=ADSM LIBRARY=owner-LT03 WORM=NO DRIVEENCRYPTION=ALLOW SET SERVERNAME name_SERVER1 SET SERVERPASSWORD 21461293e7e722dfc44b1113c588ad1240 DEFINE LIBRARY owner-LT03 LIBTYPE=SCSI WWN=4000 SERIAL=xx000M SHARED=NO AUTOLABEL=NO RESETDRIVE=NO DEFINE DRIVE owner-LT03 TAPE0 ELEMENT=480 ONLINE=Yes WWN=4F22 SERIAL=xx74J9 DEFINE DRIVE owner-LT03 TAPE1 ELEMENT=481 ONLINE=Yes WWN=6812 SERIAL=xx74F1 /* LIBRARYINVENTORY bunch of tapes*/ DEFINE PATH name_SERVER1 owner-LT03 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=lb0.0.0.2 ONLINE=YES DEFINE PATH name_SERVER1 TAPE0 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=owner-LT03 DEVICE=mt0.1.0.2 ONLINE=YES DEFINE PATH name_SERVER1 TAPE1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=owner-LT03 DEVICE=mt0.2.0.2 ONLINE=YES SERVERBACKUPNODEID 129 The logical device names did change, and I modified them accordingly in my new devconf.out, but it didn't help. I need to get this library visible in some way so that this database can be restored. I've been all over the internet, but my Windows skills are limited, so I might be missing something. TIA ** Bank DnB NORD Polska Spolka Akcyjna z siedziba w Warszawie, ul. Postepu 15C, 02-676 Warszawa, zarejestrowana w Sadzie Rejonowym dla m.st. Warszawy, XIII Wydzial Gospodarczy KRS pod nr KRS 022156, NIP: 525-22-12-939, REGON: 017296065, Kapital zakladowy 625.200.000 zl (wplacony w calosci)
ANE4018E again !!!!
Hi I though this error was behind me … but not, I got an error message ANE4018E (Session: 125660, Node: SCIF) Error processing '/media/nss/DATA/Math/Mportnov/.. : file name too long I double check that I had USEUNICODEFILENAMES NO in my dsm.opt but still got the error. TSM Client Version: Version 5, release 5, level 1.10 My OS: Linux86 2.6.5-7.2 Any other option need to be changed Regards Robert Ouzen
Overview NDMP Backups?
Hi, Just a quick question. How do you overview your NDMP backuper? I have a TSM Server 6.1.3.1 based on Windows and 3 NetApp Servers. What version of OS on the NetApp do I have no idea about. But on each NetApp do I have everything from 7 Volumes to 25 Volumes to backup every night. And my Script looks like this to backup them up NetApp1 Script backup node NETAPP1 /vol/vol01 toc=yes type=full wait=yes backup node NETAPP1 /vol/vol02 toc=yes type=full wait=yes backup node NETAPP1 /vol/vol03 toc=yes type=full wait=yes ... ... NetApp2 Script backup node NETAPP2 /vol/app01 toc=yes type=full wait=yes backup node NETAPP2 /vol/app02 toc=yes type=full wait=yes backup node NETAPP2 /vol/app03 toc=yes type=full wait=yes ... ... NetApp3 Script backup node NETAPP3 /vol/cifs01 toc=yes type=full wait=yes backup node NETAPP3 /vol/nfs01 toc=yes type=full wait=yes backup node NETAPP3 /vol/cifs02 toc=yes type=full wait=yes ... ... The problem I have is, even if the script tells me completed, that doesn't mean NDMP have backup all volumes. When I compare query nasbackup NETAPP1 * begind=-1 endd=today and compare with my NetApp1 Script. I can see that many of my Volumes haven't been backed up. What I'm wondering is how do you overview your NetApp backups, and can confirm that they have been 100% completed. Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms
Re: Overview NDMP Backups?
I've been using QUERY FILESPACES and comparing the start of backup and end of backup times, as well as a QUERY PROCESS. If the NAS Backup processes aren't running, then QUERY FILESPACES will show filespaces that were backed up with end times that are the same as or later than the begin times. The SUMMARY table is also good for showing results of NAS Backups. This works on V5 and V6 in my experience. Nick On May 6, 2010, at 4:30 AM, Christian Svensson wrote: Hi, Just a quick question. How do you overview your NDMP backuper? I have a TSM Server 6.1.3.1 based on Windows and 3 NetApp Servers. What version of OS on the NetApp do I have no idea about. But on each NetApp do I have everything from 7 Volumes to 25 Volumes to backup every night. And my Script looks like this to backup them up NetApp1 Script backup node NETAPP1 /vol/vol01 toc=yes type=full wait=yes backup node NETAPP1 /vol/vol02 toc=yes type=full wait=yes backup node NETAPP1 /vol/vol03 toc=yes type=full wait=yes ... ... NetApp2 Script backup node NETAPP2 /vol/app01 toc=yes type=full wait=yes backup node NETAPP2 /vol/app02 toc=yes type=full wait=yes backup node NETAPP2 /vol/app03 toc=yes type=full wait=yes ... ... NetApp3 Script backup node NETAPP3 /vol/cifs01 toc=yes type=full wait=yes backup node NETAPP3 /vol/nfs01 toc=yes type=full wait=yes backup node NETAPP3 /vol/cifs02 toc=yes type=full wait=yes ... ... The problem I have is, even if the script tells me completed, that doesn't mean NDMP have backup all volumes. When I compare query nasbackup NETAPP1 * begind=-1 endd=today and compare with my NetApp1 Script. I can see that many of my Volumes haven't been backed up. What I'm wondering is how do you overview your NetApp backups, and can confirm that they have been 100% completed. Best Regards Christian Svensson
Re: disk / file pool on SAN without SANergy or GPFS?
Thanks for the information. It seems that SANergy gets fairly bad press on this forum, or are there success stories out there too? And the software seems ancient (last release in 2002?) Is it still a viable solution? I was hoping that a FILE library shared and managed by the TSM server would handle locking, but this kind of storage is new to me. Thanks... Ken From: Gary Bowers gbow...@itrus.com To: ADSM-L@VM.MARIST.EDU Date: 05/05/2010 09:17 PM Subject: Re: disk / file pool on SAN without SANergy or GPFS? In short no. Sanergy is what allows you to share the filesystem amongst multiple servers. GPFS is a an alternative to SANergy that also provides the file and block locking necessary to share a physical device among multiple hosts. I may be wrong, but I believe that the only two supported LAN free protocols are GPFS and SANergy. If TSM supported CIFS or NFS shares as stgpools it might be able to do something similar with a filer, but I'm pretty confident that is not supported. You definitely cannot do it with iSCSI, because that is a block device, not a file share. Hope this helps. I have not done a SANergy install in 4 years, so things may have changed. Gary Itrus Technologies On May 5, 2010, at 5:30 PM, WHEDA TSM wrote: Hello... we will be implementing an iSCSI SAN in the near future. The TSM server needs more disk storage pool space. I want to build new storage pools (FILE type, but perhaps also DISK type) on SAN storage. I don't need SANergy for this... correct? Some of the TSM clients that will reside on the SAN would benefit from LAN-free backups. All TSM clients and the TSM server are Windows 2003 / 2008, we have no other client platforms. Without using SANergy or GPFS, can I create a FILE type storage pool on SAN storage and define a shared FILE type library so that the TSM server and the TSM SAN storage agents can both write to the pool? Thanks... Ken
reclamation no longer working
TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: reclamation no longer working
When you query the process or mounts does it state that it is waiting on a volume (input or output)? It is possible that one of them is unavailable, and/or mounted by another process. Thank you, ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Thursday, May 06, 2010 11:12 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] reclamation no longer working TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: reclamation no longer working
I recomend you do a move data with 99% tapes. Regards Jorge Date: Thu, 6 May 2010 11:11:34 -0400 From: david.ty...@sgmc.org Subject: [ADSM-L] reclamation no longer working To: ADSM-L@VM.MARIST.EDU TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _ Diseñar aplicaciones tiene premio. ¡Si eres desarrollador no esperes más! http://www.imaginemobile.es
Re: disk / file pool on SAN without SANergy or GPFS?
SANergy, SAN-FS, SVC...Some products IBM brings to market are hits, some aren't. The two aggrivations we had with SANergy (and I'm not talking about my current employer) were that it required a Windows host for CIFS, and a UNIX host for NFS. (I think Solaris was the preferred UNIX at the time for SANergy.) The second aggrivation was that it didn't perform well enough to be worth the trouble, at least in our tests. I think these days, if you have a NFS/CIFS or iSCSI target to back up to, you create one or more disk storage pools on it and have one or more TSM server instances handle keeping track of who is using what. [RC] From: WHEDA TSM wheda@wheda.com To: ADSM-L@VM.MARIST.EDU Date: 05/06/2010 07:14 AM Subject: Re: [ADSM-L] disk / file pool on SAN without SANergy or GPFS? Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Thanks for the information. It seems that SANergy gets fairly bad press on this forum, or are there success stories out there too? And the software seems ancient (last release in 2002?) Is it still a viable solution? I was hoping that a FILE library shared and managed by the TSM server would handle locking, but this kind of storage is new to me. Thanks... Ken From: Gary Bowers gbow...@itrus.com To: ADSM-L@VM.MARIST.EDU Date: 05/05/2010 09:17 PM Subject: Re: disk / file pool on SAN without SANergy or GPFS? In short no. Sanergy is what allows you to share the filesystem amongst multiple servers. GPFS is a an alternative to SANergy that also provides the file and block locking necessary to share a physical device among multiple hosts. I may be wrong, but I believe that the only two supported LAN free protocols are GPFS and SANergy. If TSM supported CIFS or NFS shares as stgpools it might be able to do something similar with a filer, but I'm pretty confident that is not supported. You definitely cannot do it with iSCSI, because that is a block device, not a file share. Hope this helps. I have not done a SANergy install in 4 years, so things may have changed. Gary Itrus Technologies On May 5, 2010, at 5:30 PM, WHEDA TSM wrote: Hello... we will be implementing an iSCSI SAN in the near future. The TSM server needs more disk storage pool space. I want to build new storage pools (FILE type, but perhaps also DISK type) on SAN storage. I don't need SANergy for this... correct? Some of the TSM clients that will reside on the SAN would benefit from LAN-free backups. All TSM clients and the TSM server are Windows 2003 / 2008, we have no other client platforms. Without using SANergy or GPFS, can I create a FILE type storage pool on SAN storage and define a shared FILE type library so that the TSM server and the TSM SAN storage agents can both write to the pool? Thanks... Ken U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. -
Re: Overview NDMP Backups?
If your intent is to backup all the volumes on the filer, it may be good to periodically backup the filer without an explicit list, so any new filesystems are picked up. For example on a Saturday. Then on Monday query the filesystems on the node and see if any haven't backed up in the last day. Any that implicitly are picked up, but not on the explicit list, will show up as having missed a day. I think we also queried the occupancy, as there would be one object per file system per completed backup in both the onsite and offsite pools. So in our case we'd see 90 objects in the onsite pool, and 89 in the offsite pool if the copy storage pool job was still running. If one of the filessytems came back with only 80 objects, the filer admin may have retired a volume and forgotten to tell us. [RC] From: Christian Svensson christian.svens...@cristie.se To: ADSM-L@VM.MARIST.EDU Date: 05/06/2010 02:31 AM Subject: [ADSM-L] Overview NDMP Backups? Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi, Just a quick question. How do you overview your NDMP backuper? I have a TSM Server 6.1.3.1 based on Windows and 3 NetApp Servers. What version of OS on the NetApp do I have no idea about. But on each NetApp do I have everything from 7 Volumes to 25 Volumes to backup every night. And my Script looks like this to backup them up NetApp1 Script backup node NETAPP1 /vol/vol01 toc=yes type=full wait=yes backup node NETAPP1 /vol/vol02 toc=yes type=full wait=yes backup node NETAPP1 /vol/vol03 toc=yes type=full wait=yes ... ... NetApp2 Script backup node NETAPP2 /vol/app01 toc=yes type=full wait=yes backup node NETAPP2 /vol/app02 toc=yes type=full wait=yes backup node NETAPP2 /vol/app03 toc=yes type=full wait=yes ... ... NetApp3 Script backup node NETAPP3 /vol/cifs01 toc=yes type=full wait=yes backup node NETAPP3 /vol/nfs01 toc=yes type=full wait=yes backup node NETAPP3 /vol/cifs02 toc=yes type=full wait=yes ... ... The problem I have is, even if the script tells me completed, that doesn't mean NDMP have backup all volumes. When I compare query nasbackup NETAPP1 * begind=-1 endd=today and compare with my NetApp1 Script. I can see that many of my Volumes haven't been backed up. What I'm wondering is how do you overview your NetApp backups, and can confirm that they have been 100% completed. Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson Supported Platform for CPU2TSM:: http://www.cristie.se/cpu2tsm-supported-platforms U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. -
Re: reclamation no longer working
Not necessarily related to the problem, but 5.4.5 includes a change to the way the TSM serrver selects which offsite volumes to reclaim: http://www-01.ibm.com/support/docview.wss?uid=swg1IC57009 [RC] From: Tyree, David david.ty...@sgmc.org To: ADSM-L@VM.MARIST.EDU Date: 05/06/2010 08:12 AM Subject: [ADSM-L] reclamation no longer working Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. -
Re: reclamation no longer working
Nope, no mention of waiting on a tape and/or volume -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rick Adamson Sent: Thursday, May 06, 2010 11:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working When you query the process or mounts does it state that it is waiting on a volume (input or output)? It is possible that one of them is unavailable, and/or mounted by another process. Thank you, ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Thursday, May 06, 2010 11:12 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] reclamation no longer working TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: reclamation no longer working
David, Seeing as there have been many, many, fixes since you release I would consider an upgrade to at least the most recent version of 5.4 As a matter of fact a couple of the 5.4.1.1 apars were reclamation related. http://www-01.ibm.com/support/docview.wss?uid=swg21273797 Thank you, ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Thursday, May 06, 2010 1:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working Nope, no mention of waiting on a tape and/or volume -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rick Adamson Sent: Thursday, May 06, 2010 11:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working When you query the process or mounts does it state that it is waiting on a volume (input or output)? It is possible that one of them is unavailable, and/or mounted by another process. Thank you, ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Thursday, May 06, 2010 11:12 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] reclamation no longer working TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: reclamation no longer working
It's on the calender -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rick Adamson Sent: Thursday, May 06, 2010 1:20 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working David, Seeing as there have been many, many, fixes since you release I would consider an upgrade to at least the most recent version of 5.4 As a matter of fact a couple of the 5.4.1.1 apars were reclamation related. http://www-01.ibm.com/support/docview.wss?uid=swg21273797 Thank you, ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Thursday, May 06, 2010 1:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working Nope, no mention of waiting on a tape and/or volume -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rick Adamson Sent: Thursday, May 06, 2010 11:29 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working When you query the process or mounts does it state that it is waiting on a volume (input or output)? It is possible that one of them is unavailable, and/or mounted by another process. Thank you, ~Rick -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Tyree, David Sent: Thursday, May 06, 2010 11:12 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] reclamation no longer working TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Re: reclamation no longer working
I'm doing a move data now. Or trying too. The process has been running for about 30 minutes with zero bytes moved. Nothing showing from a q request, nothing showing from a q mount. All drives online and plenty of mount points. I would expect it to mount a scratch tape and start moving data primary pool to the tape. I guess I'll go ahead and do the update to version 5.5.x sooner than I planned.. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Jorge Amil Sent: Thursday, May 06, 2010 11:59 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working I recomend you do a move data with 99% tapes. Regards Jorge Date: Thu, 6 May 2010 11:11:34 -0400 From: david.ty...@sgmc.org Subject: [ADSM-L] reclamation no longer working To: ADSM-L@VM.MARIST.EDU TSM server 5.4.1.0 running on Windows 2003. I have an offsite copypool that has decided to no longer do reclamation. I noticed that I had far more tapes in that pool that I would have expected. I checked the pct_utilized numbers and saw that the tapes varied from 99% down to just 5-6% utilized. When I manually run the reclamation process and then do q process I see that I have the right number of processes that start up. But the status never changes from showing zero moved files. It just sits there like it's thinking about it but never mounts anything. It runs for the duration I set then closes out. I also moved the duration back and forth from a few minutes to a couple of hours and that didn't help either. I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. I have another onsite tapepool that is identical. But it will do reclamation just fine. Just for the heck of it I created a new offsite tapepool using essentially the same settings as the old pool and it's appears to run reclamations just fine. Nothing has been changed in the settings for the offsite copypool and the onsite copypool either. David Tyree Interface Analyst South Georgia Medical Center 229.333.1155 Confidential Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. _ Diseñar aplicaciones tiene premio. ¡Si eres desarrollador no esperes más! http://www.imaginemobile.es
Re: reclamation no longer working
On May 6, 2010, at 1:48 PM, Tyree, David wrote: I'm doing a move data now. Or trying too. The process has been running for about 30 minutes with zero bytes moved. Nothing showing from a q request, nothing showing from a q mount. All drives online and plenty of mount points. I would expect it to mount a scratch tape and start moving data primary pool to the tape. In my experience, that is a manifestation of the TSM server running through the database (you should see a lot of disk activity there) compiling a list of all the onsite tapes necessary to represent all the files on the offsite tape which is to be reclaimed. Eventually, this would result in a list of such onsite volumes, in ANR1157I messages - if all goes well. The higher the capacity of the offsite tape, and the more remaining unexpired data on it, the longer this can take. Watch for the conclusion of the Move Data in the Activity Log, one way or the other; and check for abnormalities reflected in that log during the discovery process. There may be some database problems or unavailable onsite tapes thwarting this process. Bringing offsite tapes back and reclaiming them onsite is much faster; but, of course, then that data is not offsite. Richard Sims http://people.bu.edu/rbs/
Re: reclamation no longer working
On Thu, 6 May 2010 11:11:34 -0400, Tyree, David david.ty...@sgmc.org said: I've run the threshold up and down from a few percentage points up to 80-90% hoping something would change but no difference. I have plenty of scratch tapes and mount points. Try running one at 99% and _no_ time limit, and expect it to run for days. There's a huge amount of bookkeeping work TSM does at the outset. If you've gotten yourself stuck somewhere, and lots of time has passed, you may have a large backlog. In that case, trying little nibbles is the only way to go. You could also approach this from the -OFFSITERECLAIMLimit--=--number_of_volumes- side, limiting it to just a few at a time. - Allen S. Rout
Re: reclamation no longer working
After about an hour of waiting the move data finally got rolling. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: Thursday, May 06, 2010 2:12 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] reclamation no longer working On May 6, 2010, at 1:48 PM, Tyree, David wrote: I'm doing a move data now. Or trying too. The process has been running for about 30 minutes with zero bytes moved. Nothing showing from a q request, nothing showing from a q mount. All drives online and plenty of mount points. I would expect it to mount a scratch tape and start moving data primary pool to the tape. In my experience, that is a manifestation of the TSM server running through the database (you should see a lot of disk activity there) compiling a list of all the onsite tapes necessary to represent all the files on the offsite tape which is to be reclaimed. Eventually, this would result in a list of such onsite volumes, in ANR1157I messages - if all goes well. The higher the capacity of the offsite tape, and the more remaining unexpired data on it, the longer this can take. Watch for the conclusion of the Move Data in the Activity Log, one way or the other; and check for abnormalities reflected in that log during the discovery process. There may be some database problems or unavailable onsite tapes thwarting this process. Bringing offsite tapes back and reclaiming them onsite is much faster; but, of course, then that data is not offsite. Richard Sims http://people.bu.edu/rbs/
Re: Does TSM Have a way to Automatically Determine How many CPUS
I found a freeware utility called WinAudit.exe It collects system information on Windows Servers, including processor information. It took me about 20 minutes to automate the collection on all my clients using a simple batch file run from my workstation. The utility collects a huge amount of info, but has switches to limit what it collects, and can output in text, Html, CSV etc. Here is a sample from the output: The first section of the output (System Overview) shows the number of processors. (Two on this server) -- | Item | Value | -- | Computer Name | X | | Domain Name | X | | Site Name | X | | Roles | Workstation, Server, Non-Domain Controller Server, Backup Browser | | Description | - | | Operating System | Microsoft Windows Server 2003 R2 Standard Edition 32-Bit | | Manufacturer | HP | | Model | ProLiant DL380 G4 | | Serial Number | | | Asset Tag | | | Number Of Processors | 2 | | Processor Description | Intel(R) Xeon(TM) CPU 3.40GHz | | Total Memory | 3072MB | | Total Hard Drive | 437GB | | Display | Minicom LTD Smart Plus, 15.7 (32cm x 24cm) | | BIOS Version | HP - 2 | | User Account | | | System Uptime | 57 Days, 8 Hours, 16 Minutes | | Local Time| 2010-05-06 10:20:00 | -- Then in the Detailed Information Section, it tells how many Logical processors and how many cores for each processor. Detailed Information | Item | Value | | Processor Number | 1 | | Logical Processors | 2 | | Number Cores | 1 | | Vendor String| GenuineIntel | | Family | 15| | Model| 4 | | Stepping | 1 |
TSM 6.1 ODBC
Hi, in TSM 6.1 I have had to updated the ODBC from TSM to DB2 ODBC and what is my surprise the tables in DB2 are different than previous version, for example auditocc doesn't exist any more. I have created a lot of queries and I would like to know if IBM has provided the views or the db Schema in order to create my reportings or something like that. It is curisous because select * from auditocc works for TSM but from DB2 we get a error becuase the table doesn't exist. Any suggestion ? Regards, Fran
Re: TSM 6.1 ODBC
On May 6, 2010, at 5:12 PM, Francisco Molero wrote: Hi, in TSM 6.1 I have had to updated the ODBC from TSM to DB2 ODBC and what is my surprise the tables in DB2 are different than previous version, for example auditocc doesn't exist any more. I have created a lot of queries and I would like to know if IBM has provided the views or the db Schema in order to create my reportings or something like that. It is curisous because select * from auditocc works for TSM but from DB2 we get a error becuase the table doesn't exist. Any suggestion ? See Learning what information is available: system catalog tables in the Admin Guide manual.