tapes status readonly
Hi, Last week some tapes become READONLY. I tried to move the data to other tape(s) in the same pool and also audit the volume(s). Both processes takes such a long time (several hours and the tapes contains less than 10 GB) that I must cancel the processes. Must I wait longer or are their other possibilities? Thanks in advance. Chris Lenssens ICT A.Z. Sint-Elisabeth Zottegem
Re: tapes status readonly
On Apr 6, 2007, at 6:22 AM, Chris Lenssens wrote: Hi, Last week some tapes become READONLY. I tried to move the data to other tape(s) in the same pool and also audit the volume(s). Both processes takes such a long time (several hours and the tapes contains less than 10 GB) that I must cancel the processes. Must I wait longer or are their other possibilities? That's usually labored retries in the presence of read errors. Query PRocess will show if unreadable files were encountered, and your OS error log will show device/media problems. If you encounter the same struggle on multiple drives, then it suggests the media or whatever happened when that media was being written. Based upon the Last Write Date, see if your Activity Log reflects any issues going on at the time. Depending upon your drive technology, you may have dust or dirt problems on the drive heads: make sure your library has a cleaning tape available. (An AIX Error Log will record cleanings.) Also assure that your drives have recent microcode, as faulty microcode can make for later problems reading tapes. If you can't endure the read struggle, go for a RESTORE Volume, beginning with a Preview=Yes type of invocation to first check for any problems going into that operation. A Move Data is usually preferable, first, to avoid all the mounts usually needed from the copy storage pool. Richard Sims
tdpsqlc restore failing
Hi I try to restore an mssql database backed up at one server, to another. But it fails, see output below. Ony difference is that the server where database was backed up from, runs windows 2003 std x64, with tdpsql klient version 5.3.3.0. Server where I try to restore to, runs windows 2003 std and tdpsql client version 5.2.1.0. Could those differences be an issue? I've done similar earlier without problems. I cannot understand why it will try and replace G:\SQL Server\q500_log.ldf ?? Thank you Best wishes Kjell Kaspersen tdpsqlc restore q500 /fromsqlserver=q5-db01 /object=20070319181808\1BA8 /into=restore /relocate=q500_Data1,q500_log,q500_Data2 /to=e:\db\restore_Data1.mdf,g:\db\restore_log.ldf,e:\db\re store_Data2.ndf /replace /recover=no IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 2, Level 1.0 (C) Copyright IBM Corporation 1997, 2003. All rights reserved. ACO5057I The C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.log log file was pruned s uccessfully. Please enter the password for node Q5-DB01.STH.BASEFARM.NET_MSSQL: * Starting Sql database restore... Querying Tivoli Storage Manager server for a list of database backups, please wa it... Restoring metadata ... Beginning full restore of backup object q500, 1 of 1, to database restore Full: 0 Read: 0 Written: 0 Rate: 0.00 Kb/Sec Waiting for TSM server.. . Full: 1 Read: 3145728 Written: 5632 Rate: 0.02 Kb/Sec Restore of q500 failed. [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'G:\SQL Server\q500_log. ldf' cannot be overwritten. It is being used by database 'Q500'. [Microsoft][ODBC SQL Server Driver][SQL Server]File 'q500_log' cannot be restore d to 'G:\SQL Server\q500_log.ldf'. Use WITH MOVE to identify a valid location fo r the file. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating a bnormally. Total database backups inspected: 1 Total database backups requested for restore: 1 Total database backups restored:0 Total database skipped: 0 Throughput rate:0.02 Kb/Sec Total bytes transferred:5,632 Elapsed processing time:261.48 Secs ACO0151E Errors occurred while processing the request.
Re: tdpsqlc restore failing
Kjell, The machine that restores MUST be at the same level or newer. Thanks, Del ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 04/06/2007 10:42:58 AM: Hi I try to restore an mssql database backed up at one server, to another. But it fails, see output below. Ony difference is that the server where database was backed up from, runs windows 2003 std x64, with tdpsql klient version 5.3.3.0. Server where I try to restore to, runs windows 2003 std and tdpsql client version 5.2.1.0. Could those differences be an issue? I've done similar earlier without problems. I cannot understand why it will try and replace G:\SQL Server\q500_log.ldf ?? Thank you Best wishes Kjell Kaspersen tdpsqlc restore q500 /fromsqlserver=q5-db01 /object=20070319181808\1BA8 /into=restore /relocate=q500_Data1,q500_log,q500_Data2 /to=e:\db\restore_Data1.mdf,g:\db\restore_log.ldf,e:\db\re store_Data2.ndf /replace /recover=no IBM Tivoli Storage Manager for Databases: Data Protection for Microsoft SQL Server Version 5, Release 2, Level 1.0 (C) Copyright IBM Corporation 1997, 2003. All rights reserved. ACO5057I The C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.log log file was pruned s uccessfully. Please enter the password for node Q5-DB01.STH.BASEFARM.NET_MSSQL: * Starting Sql database restore... Querying Tivoli Storage Manager server for a list of database backups, please wa it... Restoring metadata ... Beginning full restore of backup object q500, 1 of 1, to database restore Full: 0 Read: 0 Written: 0 Rate: 0.00 Kb/Sec Waiting for TSM server.. . Full: 1 Read: 3145728 Written: 5632 Rate: 0.02 Kb/Sec Restore of q500 failed. [Microsoft][ODBC SQL Server Driver][SQL Server]The file 'G:\SQL Server\q500_log. ldf' cannot be overwritten. It is being used by database 'Q500'. [Microsoft][ODBC SQL Server Driver][SQL Server]File 'q500_log' cannot be restore d to 'G:\SQL Server\q500_log.ldf'. Use WITH MOVE to identify a valid location fo r the file. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating a bnormally. Total database backups inspected: 1 Total database backups requested for restore: 1 Total database backups restored:0 Total database skipped: 0 Throughput rate:0.02 Kb/Sec Total bytes transferred:5,632 Elapsed processing time:261.48 Secs ACO0151E Errors occurred while processing the request.
Re: TSM backup speed on a Windows server
In our case, we set the speed to the highest speed supported by the port on the switch and the server. If either side is set to auto then we end up with really poor performance. But not in every case, we have a couple of boxes that are set to auto and they are running just fine. Try different settings until you find the right one. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Richard Sims Sent: Thursday, April 05, 2007 10:40 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM backup speed on a Windows server On Apr 5, 2007, at 10:27 AM, Luc Beaudoin wrote: Is it recommend to set the speed to AUTO-NEGOCIATE on my Windows 2K and 2K3 servers ?? The only recommendation is to use whatever works best. Unfortunately, networking equipment is all over the place as to what combination of brands, models, and settings will actually do what you want it to. I've had to make counter-intuitive configuration settings in some cases to get proper operation. Confer with the networking people at your site for best advice for what you have there, then do testing. Richard Sims
q occ on multiple nodes
Hello, How do you do 'q occ' on multiple nodes? I tried to put a comma after each node but I get the following error. I tried a space between the nodes but it does not work. Thank you for your help. tsm: TSMQ occ 23GPD40,4H63D31 ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860) 862-8164 cell (860) 961-6976 ** The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. **
Re: q occ on multiple nodes
Use Wild Cards q occ aps* Or if you have a spcific list use the TSM ODBC driver via MS Excel to the Occupancy Table then you can apply filters in excel etc Charles Hart UHT - Data Protection (763)744-2263 Sharepoint: http://unitedteams.uhc.com/uht/EnterpriseStorage/DataProtection/default.aspx Avy Wong [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 04/06/2007 11:24 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] q occ on multiple nodes Hello, How do you do 'q occ' on multiple nodes? I tried to put a comma after each node but I get the following error. I tried a space between the nodes but it does not work. Thank you for your help. tsm: TSMQ occ 23GPD40,4H63D31 ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860) 862-8164 cell (860) 961-6976 ** The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ** This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
Re: q occ on multiple nodes
On Apr 6, 2007, at 12:24 PM, Avy Wong wrote: Hello, How do you do 'q occ' on multiple nodes? ... You don't, per the syntax of the documented command. But, then, IBM provides Select so we can form our own commands, like: select * from occupancy where node_name in ('23GPD40','4H63D31') Richard Sims
Re: q occ on multiple nodes
Hi, I am trying to start the tsm scheduler in Unix client as root user, but I am getting folloing issues. Please advise where have I gone wrong. $ sudo /etc/init.d/dmcsched start sudo: /etc/init.d/dmcsched: command not found $ Thanks in advance. Dinesh Pahari -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Charles A Hart Sent: Saturday, 7 April 2007 3:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] q occ on multiple nodes Use Wild Cards q occ aps* Or if you have a spcific list use the TSM ODBC driver via MS Excel to the Occupancy Table then you can apply filters in excel etc Charles Hart UHT - Data Protection (763)744-2263 Sharepoint: http://unitedteams.uhc.com/uht/EnterpriseStorage/DataProtection/default. aspx Avy Wong [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 04/06/2007 11:24 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] q occ on multiple nodes Hello, How do you do 'q occ' on multiple nodes? I tried to put a comma after each node but I get the following error. I tried a space between the nodes but it does not work. Thank you for your help. tsm: TSMQ occ 23GPD40,4H63D31 ANR2034E QUERY OCCUPANCY: No match found using this criteria. ANS8001I Return code 11. Avy Wong Business Continuity Administrator Mohegan Sun 1 Mohegan Sun Blvd Uncasville, CT 06382 (860) 862-8164 cell (860) 961-6976 ** The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, or copy of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. ** This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
Re: q occ on multiple nodes
On Apr 6, 2007, at 9:02 PM, Pahari, Dinesh P wrote: Hi, I am trying to start the tsm scheduler in Unix client as root user, but I am getting folloing issues. Please advise where have I gone wrong. $ sudo /etc/init.d/dmcsched start sudo: /etc/init.d/dmcsched: command not found $ Well, you seem to be asking about something which is unique to your site... First, see if that executable exists. (That spelling is odd: maybe dsmcsched?) And, of course, the file needs r-x permissions on it. Then you want it defined in your sudo control file. Further, the #!... at the top of the file needs to name an existing interpreter. Check out: http://www.oucs.ox.ac.uk/hfs/schedbkup/unix/421/ for something comparable to what you're doing. Richard Sims