Detecting Hold on archives
With 6.1 clients, we can use set event to put an archive on hold, stopping the clock for expiration. I need to find any archived items where someone has done this. But I don't see where, in the TSM database, an archived item is marked for hold. Any wisdom? -- Lindsay Morris TSMworks, Inc. 859-539-9900 lind...@tsmworks.com -- Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: Ang: Re: Help tracking down spurious Failed 12
We have the same issue. In our case, it's caused by a corrupt or mismatched dscenu.txt file, causing ANS0106E message index not found for message... in dsmerror.log. To fix it, we stop the TSM scheduler (no need for that if you're using CAD I guess), replace the dscenu.txt file with a good one from a client that is NOT giving you RC 12s, and restart the scheduler. Works for us anyway. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Aug 26, 2011 at 12:37 PM, Andrew Raibeck stor...@us.ibm.com wrote: An in-use file should not cause an RC 12. Either you are running an old client level with some defect that issues the wrong return code (for example, see go to the URL in my sig and search for IC35763); or there is some additional error being thrown that causes the RC to be set to 12. Examine your dsmerror.log and dsmsched.log files very carefully for any other ANSE or ANSS messages that might trigger the RC 12. Also, see my other recent posts on this topic. Best regards, Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2011-08-25 09:26:24: From: Jimou tsm-fo...@backupcentral.com To: ADSM-L@vm.marist.edu Date: 2011-08-26 12:15 Subject: Ang: Re: Help tracking down spurious Failed 12 Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi I wonder why we can have a RC =12 for a skipped file in use, cause there http://www.dsi.upmc.fr/dsi/doc/stockage/clients-tsm/ tsmwin/ans60012.htm i see that it should be RC=4 But i also have a RC=12 and the only message i got is in used file. Someone could explain to me why it is not a RC=4 ?? Ty in advance. +-- |This was sent by jm.fa...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +--
Re: Can you restore a SystemState backup when you have the HP OpenView problem?
Andy, the whole point of VSS is to freeze the activity and get a consistent SystemState backup. Right? So, if this HPOVO issue is going on, then certain files can't get enumerated to VSS. OK. Then the safety-net feature backs them up to the drive instead of to some VSS writer. But aren't they still open and in use at that point? Thus potentially giving us an inconsistent SystemState backup? Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Oct 28, 2011 at 9:35 AM, Andrew Raibeck stor...@us.ibm.com wrote: Hi Lindsay, 1. The ANS1417W messages indicate that the system state files named in those messages are being backed up as part of the drive they reside on, which is a safety net we built into TSM to help ensure a viable system state backup; but they are not a solution. The solution is to take the actions described in the flash http://www.ibm.com/support/docview.wss?uid=swg21462430. The actions are also described in the local fix section of the APAR text. 2. The RC 12 is an indication that some significant error occurred during the backup operation. It might be due to a problem in the system state backup, or it might be due to some other problem occurring during a different part of the backup. The dsmsched.log and dsmerror.log files should be reviewed carefully to find out what is driving the RC 12. It is not due to the ANS1417W messages. Without knowing the cause, I would have to assume the backup is not good until proven otherwise. If indeed the error occurs during system state backup, then the system state backup is NOT good. 3. If the backup is failing during system state backup, but the system state backup indicates a completion date, then a PMR should be opened with IBM TSM support to assist in better understanding the reason. Best regards, Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2011-10-27 21:28:34: From: Lindsay Morris lind...@tsmworks.com To: ADSM-L@vm.marist.edu Date: 2011-10-27 21:30 Subject: Can you restore a SystemState backup when you have the HP OpenView problem? Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi, all. I have a customer running the 6.2.2.2 client on Windows boxes that have HP OpenView installed. (See APAR IC72446, http://www-01.ibm.com/support/docview.wss?uid=swg1IC72446 .) As the APAR says, they see a lot of dsmsched.log messages like this: ANS1417W Protected system state file filename is backed up to the drive file space, not system state file space And they could ignore those. But then the backup says it fails with RC=12. On the other hand, query filespace shows the SystemState filespace as backed up successfully at that time. So they don't know whether to believe the RC=12 failure, or the last-backup date success indicator. And they can't easily find a test case. So, has anybody tested a SystemState restore after a similar backup failure? Or can Andy Raibeck say with authority that the SystemState restore will by golly work, regardless of the RC=12? Thanks for any wisdom. -- Lindsay Morris TSMworks, Inc. lind...@tsmworks.com 1-859-539-9900 -- Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: Can you restore a SystemState backup when you have the HP OpenView problem?
Thanks, Andy. I did find another error that explains the RC=12 result, That pointed me to another PMR concerning SNAPSHOTFSIDLETIMEOUT - but then the problem went away mysteriously, Oh well. Thanks again. On Friday, October 28, 2011, Andrew Raibeck stor...@us.ibm.com wrote: Hi Lindsay, 1. The ANS1417W messages indicate that the system state files named in those messages are being backed up as part of the drive they reside on, which is a safety net we built into TSM to help ensure a viable system state backup; but they are not a solution. The solution is to take the actions described in the flash http://www.ibm.com/support/docview.wss?uid=swg21462430. The actions are also described in the local fix section of the APAR text. 2. The RC 12 is an indication that some significant error occurred during the backup operation. It might be due to a problem in the system state backup, or it might be due to some other problem occurring during a different part of the backup. The dsmsched.log and dsmerror.log files should be reviewed carefully to find out what is driving the RC 12. It is not due to the ANS1417W messages. Without knowing the cause, I would have to assume the backup is not good until proven otherwise. If indeed the error occurs during system state backup, then the system state backup is NOT good. 3. If the backup is failing during system state backup, but the system state backup indicates a completion date, then a PMR should be opened with IBM TSM support to assist in better understanding the reason. Best regards, Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/IBM@IBMUS Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/support/entry/portal/Overview/Software/Tivoli/Tivoli_Storage_Manager ADSM: Dist Stor Manager ADSM-L@vm.marist.edu wrote on 2011-10-27 21:28:34: From: Lindsay Morris lind...@tsmworks.com To: ADSM-L@vm.marist.edu Date: 2011-10-27 21:30 Subject: Can you restore a SystemState backup when you have the HP OpenView problem? Sent by: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Hi, all. I have a customer running the 6.2.2.2 client on Windows boxes that have HP OpenView installed. (See APAR IC72446, http://www-01.ibm.com/support/docview.wss?uid=swg1IC72446 .) As the APAR says, they see a lot of dsmsched.log messages like this: ANS1417W Protected system state file filename is backed up to the drive file space, not system state file space And they could ignore those. But then the backup says it fails with RC=12. On the other hand, query filespace shows the SystemState filespace as backed up successfully at that time. So they don't know whether to believe the RC=12 failure, or the last-backup date success indicator. And they can't easily find a test case. So, has anybody tested a SystemState restore after a similar backup failure? Or can Andy Raibeck say with authority that the SystemState restore will by golly work, regardless of the RC=12? Thanks for any wisdom. -- Lindsay Morris TSMworks, Inc. lind...@tsmworks.com 1-859-539-9900 -- Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com -- Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Can you restore a SystemState backup when you have the HP OpenView problem?
Hi, all. I have a customer running the 6.2.2.2 client on Windows boxes that have HP OpenView installed. (See APAR IC72446, http://www-01.ibm.com/support/docview.wss?uid=swg1IC72446 .) As the APAR says, they see a lot of dsmsched.log messages like this: ANS1417W Protected system state file filename is backed up to the drive file space, not system state file space And they could ignore those. But then the backup says it fails with RC=12. On the other hand, query filespace shows the SystemState filespace as backed up successfully at that time. So they don't know whether to believe the RC=12 failure, or the last-backup date success indicator. And they can't easily find a test case. So, has anybody tested a SystemState restore after a similar backup failure? Or can Andy Raibeck say with authority that the SystemState restore will by golly work, regardless of the RC=12? Thanks for any wisdom. -- Lindsay Morris TSMworks, Inc. lind...@tsmworks.com 1-859-539-9900 -- Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: How to perform Readtest in TSM ??
We think testing restores is good idea, and it sounds like that's what you're trying to do. We have software that helps with that. Contact me off-line if you wish. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Sat, Mar 12, 2011 at 10:42 PM, somu321 tsm-fo...@backupcentral.comwrote: Hi All Previously in our setup we used to take manual backup and do the read test of tapes for a particular backup. But after migrating to TSM we are not getting the idea for how to perform the readtest of aparticular backup. Please help. -Somu321 +-- |This was sent by soumitr...@yahoo.co.in via Backup Central. |Forward SPAM to ab...@backupcentral.com. +--
Re: Validate backup and archives.
Be aware that there are many reasons why you won't be able to restore, even if the backup DID work successfully. For example: ** ** - *Tapes are damaged or unavailable* - It's easy to damage tapes when you transport them to your off-site DR tests. ** - Critical files are excluded - Users (or TSM Admins) can be fooled by the pattern-matching in TSM's include-exclude system. - *Backups are incomplete* - Drive C: may be a standard windows image, drive D: holds the work. A user can change DOMAIN ALL_LOCAL to DOMAIN D:\ to skip the needless drive-C backups That works fine until they add drive E, which TSM will quietly ignore. - *Rogue servers never got registered to TSM* - Gartner says this problem has escalated lately with VMware machines popping up everywhere. - *Restore too slow * - Backups scattered over hundreds of volumes, filesystems with millions of files, and use of compression can all result in restores that are too slow to be usable. - *Poor communication with DBAs* - A database admin can break the incremental logging cycle by doing a full backup manually on Tuesday. The TSM admin then doesn't know how to recover to Wednesday's backup. So I'm with Richard (and most storage auditors): you need to test restorability. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 skype:18595399900?call lind...@tsmworks.com On Fri, Sep 17, 2010 at 7:33 AM, Dwight Cook coo...@cox.net wrote: In general computing you will want to have your production data center with all your production servers and your remote site data center functioning as your production fix / test / development / disaster recovery data center. Wise processing practice is to perform monthly production fix refreshes from your production backups. This type of activity validates the integrity of your production backups along with your restoration process and assists in being SOX compliant. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of wesley.introvigne Sent: Thursday, September 16, 2010 7:03 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Validate backup and archives. Dear friends, how can I validate that the data from a server have been copied successfully. (Backup) Is there any command to validate tsm backup or archive or in the best way to validate a backup. Best Regards
Re: Select statement to only list backups with particular event status
Joni, Query Events has other problems, too: -- You might have a machine that isn't on any schedule, for example. Query Events won't tell you that. -- You might have include-exclude statements, or domain statements, that cause a directory or an entire drive to be skipped. It won't tell you about that. -- You might have retention policies that are way too short (so you can't recover from last week), or way too long (so you're wasting tons of storage). Again, no indication from query events. -- You might even have machines (VMs?) in production that nobody ever registered to TSM. Nothing in TSM will tell you about that. One thing you can do is stop using query backups, and use the filespace table's backup_end field to find backups that are older than a day or two. That solves some (not all) of the above problems. We have a more thorough solution here goog_918866862http://www.tsmworks.com/art. Hope this helps. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 skype:18595399900?call lind...@tsmworks.com On Tue, Jun 29, 2010 at 1:28 PM, Moyer, Joni M joni.mo...@highmark.comwrote: Hi Richard, Is there any other way to do a report that would list missed, failed, in progress and started backups then on a daily basis running it from the prior day at 6PM until the current time the script is run at 9AM? I currently run q event at 9AM which catches the missed failed backups, but nothing that currently accounts for anything that is in progress or has been started. Any suggestions/ideas are appreciated! This one has me stumped! -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Sims Sent: Tuesday, June 29, 2010 12:09 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Select statement to only list backups with particular event status The EVENTS table has been an oddball in TSM, as I note in ADSM QuickFacts, because of the way it was engineered. Using relative timestamp references traditionally doesn't work, so you need to employ an absolute timestamp, as in select * from events WHERE SCHEDULED_START = '2010-06-28' Note also that there is no actual_time column in instances of the EVENTS table that I know of. Use the following to verify column names: select * from syscat.columns where tabname='EVENTS' I haven't seen 'In Progress' as one of the possible status values; but things change over numerous releases. Richard Sims On Jun 29, 2010, at 11:05 AM, Moyer, Joni M wrote: Hello everyone, I am trying to create a select statement that will list all backups for clients in the domain: windows hmig that started after yesterday at 6PM until today at the current date/time that had a status of: Missed, In Progress, Fail%, Started. I tried the below select statement but it is not giving me everything that I am looking for and it's also reporting future events which I don't want. Can anyone tell me what I'm doing wrong? Thanks in advance! select event as Event,date(actual_start) as Date,time(actual_start) as Start,time(Completed) as End, node_name, domain_name,Status from events where domain_name='WINDOWS' or domain_name='HMIG' and status like 'Fail%' or status='Missed' or status='In Progres' or status='Started' and actual_time=current_timestamp-1 day This e-mail and any attachments to it are confidential and are intended solely for use of the individual or entity to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this e-mail without the author's prior permission. The views expressed in this e-mail message do not necessarily represent the views of Highmark Inc., its subsidiaries, or affiliates.
Re: PVU
Well ... you have to install the free ILMT on each node. Right? So it costs no dollars - but a couple of weeks of time... Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Jun 28, 2010 at 3:26 PM, Abbott, Joseph jabb...@partners.orgwrote: Yep. The free ILMT. JoeA Joseph A Abbott MCSE 2003/2000, MCSA2003 Tivoli Storage Manager Architect jabb...@partners.org Cell-617-633-8471 Desk-617-724-4929 Page-# (617) 362-6341 6173391...@usamobility.net Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Avy Wong Sent: Monday, June 28, 2010 2:46 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] PVU Hello, It is too good to be true... but I am going to ask anyway. Is there a way to find out the pvu of each client node being backed up on tivoli without going to each individual box/server to look it up? 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. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
Re: PVU
Nice! Was that all-Windows, or a mix of platforms? And would you care to share the script? Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Jun 28, 2010 at 3:40 PM, Abbott, Joseph jabb...@partners.orgwrote: ILMT can be configured without going out to each box. You just have to know how to script. We did 1800 clients in a day. JoeA Joseph A Abbott MCSE 2003/2000, MCSA2003 Tivoli Storage Manager Architect jabb...@partners.org Cell-617-633-8471 Desk-617-724-4929 Page-# (617) 362-6341 6173391...@usamobility.net Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Monday, June 28, 2010 3:34 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] PVU Well ... you have to install the free ILMT on each node. Right? So it costs no dollars - but a couple of weeks of time... Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Jun 28, 2010 at 3:26 PM, Abbott, Joseph jabb...@partners.org wrote: Yep. The free ILMT. JoeA Joseph A Abbott MCSE 2003/2000, MCSA2003 Tivoli Storage Manager Architect jabb...@partners.org Cell-617-633-8471 Desk-617-724-4929 Page-# (617) 362-6341 6173391...@usamobility.net Be who you are and say what you feel because those who mind don't matter and those who matter don't mind. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Avy Wong Sent: Monday, June 28, 2010 2:46 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] PVU Hello, It is too good to be true... but I am going to ask anyway. Is there a way to find out the pvu of each client node being backed up on tivoli without going to each individual box/server to look it up? 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. The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Partners Compliance HelpLine at http://www.partners.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.
Re: incremental backup of many millions of very small files
You say Been there, done that. You mean with Fastback, not TSM? When you talk about NQR, No Query Restore, I don't think you're talking about Fastback anymore. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jun 24, 2010 at 9:19 AM, Zoltan Forray/AC/VCU zfor...@vcu.eduwrote: Been there - done that - went through a complete restore that took days (could not do NQR for some of it). Why is journaling not feasible? I have a Windows box with 97M total files (including offsite copy) that uses journaling and backs up every day. Granted, it takes 7-hours and uses the minimum memory model (the box is still 2K3 32-bot with 4GB RAM) From: Mehdi Salehi ezzo...@googlemail.com To: ADSM-L@VM.MARIST.EDU Date: 06/24/2010 09:05 AM Subject: [ADSM-L] incremental backup of many millions of very small files Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi, Can TSM Fastback be a good solution to backup an NTFS filesystem (about 500GB) with tens of millions of files? The daily increment of this filesystem is about 10-15 GB. Currently we use full daily image backups with b/a client. Because incremental (even journaling) is not feasible and furthermore restore would take even days, I wonder whether the block-level incremental of FastBack can help in this way? Thanks so much
Re: slowness with Storage Manager Admin Center 6.2
You can watch task manager as you issue a request. If you see IE (or whatever browser you're using) using low CPU for 10 seconds, then see it busy as the page loads, the slowness is somewhere behind that. If you see if busy all 10-15 seconds, then it's your browser, or browser settings. Try Firefox instead of IE; we've seen that make a huge difference on some web apps. You can do similar tricks watching task manager on the Admin Center box. At least you have a repeatable problem. ;-} Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Jun 14, 2010 at 2:19 PM, Tyree, David david.ty...@sgmc.org wrote: I'm running a new install of the 6.2.0.0 version of the Storage Manager Admin Center on a VM box. It's loaded on Windows 2008 R2 Standard (64-bit) with a pair of 2.66 GHz CPUs with 4 gig of memory. It's dedicated to TSM support and nothing else is loaded on the machine. It's pointed to a pair of separate TSM servers, the production system running 5.5.4.1 and a test system running 6.1.0.0. According to the product info screen the WebSphere is at 7.5.1.0, Java is Standard Edition IBM Corporation 1.5.0, VM is IBM J9 VM 2.3. The task manager within the OS says the server is not busy at all and appears to have plenty of available power. The numbers from the ESX server also tell me the box isn't being stressed. When I go into the webpage for the Admin Center via IE or Firefox on my desktop (or others) it's just painfully slow. If I want to modify a client node in Client Nodes and Backup Sets tab I have to wait for 10-15 seconds for the page to refresh. Then if I make a change then I have to wait several more seconds for another refresh. And so on. It doesn't matter if I'm hitting the production server or the test server, both take 10-15 seconds for something to happen. I really like the new look of the Admin Center but this is slowness is killing me. Do I have something wrong here? 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: slowness with Storage Manager Admin Center 6.2
I guess you could watch dsmadmc -console output and see how long TSM is taking to respond to the query. Maybe THAT's the bottleneck. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Jun 14, 2010 at 3:04 PM, Tyree, David david.ty...@sgmc.org wrote: I've watched the task manager server while I'm doing something within the Admin Center and I'm not seeing much of a bump at all. I'm getting a 70% bump on the server when I first log in to admin center but it quickly drop down to about 4-5%. When I go to modify a client and wait for the processing screen to go away I get 40-50% bump on the server when I first hit the modify button then it drops down to background noise. While I'm waiting several seconds for the processing screen to go away the CPU has already dropped down to nothing. I'm seeing bigger bumps on my local machine but nothing really substantially different. I can't really tell any difference between IE or Firefox. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Monday, June 14, 2010 2:34 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] slowness with Storage Manager Admin Center 6.2 You can watch task manager as you issue a request. If you see IE (or whatever browser you're using) using low CPU for 10 seconds, then see it busy as the page loads, the slowness is somewhere behind that. If you see if busy all 10-15 seconds, then it's your browser, or browser settings. Try Firefox instead of IE; we've seen that make a huge difference on some web apps. You can do similar tricks watching task manager on the Admin Center box. At least you have a repeatable problem. ;-} Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Jun 14, 2010 at 2:19 PM, Tyree, David david.ty...@sgmc.org wrote: I'm running a new install of the 6.2.0.0 version of the Storage Manager Admin Center on a VM box. It's loaded on Windows 2008 R2 Standard (64-bit) with a pair of 2.66 GHz CPUs with 4 gig of memory. It's dedicated to TSM support and nothing else is loaded on the machine. It's pointed to a pair of separate TSM servers, the production system running 5.5.4.1 and a test system running 6.1.0.0. According to the product info screen the WebSphere is at 7.5.1.0, Java is Standard Edition IBM Corporation 1.5.0, VM is IBM J9 VM 2.3. The task manager within the OS says the server is not busy at all and appears to have plenty of available power. The numbers from the ESX server also tell me the box isn't being stressed. When I go into the webpage for the Admin Center via IE or Firefox on my desktop (or others) it's just painfully slow. If I want to modify a client node in Client Nodes and Backup Sets tab I have to wait for 10-15 seconds for the page to refresh. Then if I make a change then I have to wait several more seconds for another refresh. And so on. It doesn't matter if I'm hitting the production server or the test server, both take 10-15 seconds for something to happen. I really like the new look of the Admin Center but this is slowness is killing me. Do I have something wrong here? 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: Securing TSM Client
Maybe you could lock all the nodes during the day (LOCK NODE...), and unlock them at night for your scheduled backups ... ? Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, May 11, 2010 at 4:08 PM, Leandro Mazur leandroma...@gmail.comwrote: Hello everyone ! I don't know if somebody has this kind of problem, but I have the following situation in the company I work for: - We have a TSM team to install, configure and maintain the whole backup process, server and client; - We have sysadmins that take care of the operational system and the applications; - When there's a need for any action to do with backup, they should open a ticket for the TSM team; The problem that we have is that the sysadmins are doing backups/archives and restores/retrieves without our knowledge, with great impact on our database (among other things...). We would like to block the access on the client, but we were not successful. If we use password generate on dsm.sys, the password is prompted only at first access. If we use password prompt, the scheduler doesn't work (ANS2050E)... Any sugestions from the experts ? Maybe it could be a improvement to IBM implement on the future... __ Leandro Mazur
Re: Does TSM Have a way to Automatically Determine How many CPU'S aka processors a server has
There's ITLM, IBM Tivoli License Manager. It's kind of bear to install, I hear. (Has anybody done it?) But nobody else has a fully automated solution AFAIK. Contact me off-line and I can give you some other options. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Apr 23, 2010 at 11:30 AM, David W Daniels/AC/VCU dwdan...@vcu.eduwrote: All, Does anyone know if TSM has the capability to count and report how many CPU'S aka processor(s) a server has? I'm asking because it SLA time and this is some of the information we would like and hopefully charge user departments for in regard to TSM support. Also if there's is another way to get this information automatically please share ** Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html
Re: Linux Client failing with ANS1999E error
Ben said TSM backups are great for sniffing out filesystem problems. ;-) I would add and network problems, and application problems , and database performance problems ... The TSM admin is like the canary in the coal mine. (Wait, that's a terrible analogy .. they end up dead...) Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: Running a report on what files will expire in the next sixty days
And like Michael implied, running a select from the BACKUPS table on a production server is liable to kill its performance for a good while. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Apr 13, 2010 at 12:45 PM, John D. Schneider john.schnei...@computercoachingcommunity.com wrote: Well, I am no expert on this, so I am willing to be corrected by somebody if I don't have this right, but here is my understanding. Yes the deactivate_date will tell you when a given backup object became inactive, but that won't reliably tell you when it will expire, because as I said, you don't know what other versions will be coming along. Newer versions can cause it to expire sooner. What if, in my previous example, yoda.txt is in a management class whose backup copygroup policy is 7 versions for 30 days? The file gets backed up on 4/13/2010. The next day yoda.txt changes, so it gets backed up again on 4/14/2010. So at the next 'expire inventory' the 4/13/2010 version of the file becomes inactive, and deactivate_date gets set to 4/13/2010. If the policy says 30 days, it would be easy to think, yeah, it is going to really expire on 5/13/2010, 30 days later. But what if yoda.txt keeps changing every day? Then yoda.txt from 4/13/2010 is going to expire when 7 new versions have backed up, on 4/20/1010. But what if yoda.txt only changes every other day, or not at all? You can do a select to find out all the files that are deactivated, but the best you could determine is the outside window of how many days they might still be around, based on the number of days in the policy. But I am still not sure why it is useful to run such a report? Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721 Original Message Subject: Re: [ADSM-L] Running a report on what files will expire in the next sixty days From: Michael Green mishagr...@gmail.com Date: Tue, April 13, 2010 11:19 am To: ADSM-L@VM.MARIST.EDU John, Please correct me if I'm wrong. select * from syscat.columns where tabname='BACKUPS' shows that there is a column called DEACTIVATE_DATE. I guess if you write a select statement crafted in such a way that it also takes into account current date, the management class (CLASS_NAME from BACKUPS) VERE/VERD/RETE/RETO, then you can conclude if the object is candidate for expiration. Running such a select on a production machine is a whole other story. -- Warm regards, Michael Green On Tue, Apr 13, 2010 at 6:37 PM, John D. Schneider john.schnei...@computercoachingcommunity.com wrote: Because of TSM's incremental backup scheme, there is no way to know what files will expire, because their is no way to know what new versions of files will be taking their place in the future. For example, say there is a file called yoda.txt. If that yoda.txt file is backed up once and is never changed, then the backup for it will never expire because the backup of that file remains the active version of that file. If, however, yoda.txt is changed from time to time, and a backup runs every day, then the older versions of the file become inactive versions of the file. Then the inactive versions will expire when they exceed either the number of days or versions that you defined in the policy. So, when I backup yoda.txt today, there is no way to know when this version of yoda.txt is going to expire, unless I have some way to know how many new versions are going to replace it in the future. Can you tell us why you think it is necessary to predict what files will be expired, or when? Since new backup data will be coming in continuously, is it really important to know? Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721 Original Message Subject: [ADSM-L] Running a report on what files will expire in the next sixty days From: yoda woya yodaw...@gmail.com Date: Tue, April 13, 2010 9:37 am To: ADSM-L@VM.MARIST.EDU Is there a way to find the list of files/amount of data that will expire in the next 60 days?
Re: How are primary sequential storage pools allocated?
If I understand you, with no members in the group, your collocation-by-group acts like collocation-by-node. So TSM will try to put each node's data (small) on a separate tape volume (large), and you get the behavior you're seeing now. Group collocation is what you want, to fill tapes fuller, but you have to put nodes into collocation groups first. See Allen Rout's excellent script from last week for a way to automate this (or just make reasonable guesses). Another note: try to only put ONE Tier-1 node into each collocation group. That way, in a DR exercise, the won't compete for tape volumes and you have a chance of restoring them all in parallel. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Apr 9, 2010 at 9:14 AM, James Choate jcho...@chooses1.com wrote: TSM 5.5.4.1 On Windows 2003 I have a primary disk storage pool that is 500GB called DISKPOOL and a primary sequential storage pool called ONSITE that is defined as the NEXTSTGPOOL for DISKPOOL. What I am noticing is that as I migrate data from DISKPOOL to ONSITE, the tapes are getting allocated to the ONSITE pool, but are not filling all the way up. I was anticipating that as the migration would kick off, tapes would fill until it reached a full status, then the next tape would get allocated. Collocation is set to group, but there aren't any members in the group. Here is a snippet of the volumes, and I have also attached what the stgpool looks like. 000102L3 OFFSITE LTO3CLASS 762,938.01.5 Filling 000103L3 ONSITE LTO3CLASS 762,938.01.6 Filling 000104L3 ONSITE LTO3CLASS 762,938.00.9 Filling 000105L3 ONSITE LTO3CLASS 402,407.2 100.0Full 000106L3 ONSITE LTO3CLASS 762,938.0 38.6 Filling 000107L3 ONSITE LTO3CLASS 762,938.0 37.2 Filling 000108L3 ONSITE LTO3CLASS 398,773.8 100.0Full 000109L3 ONSITE LTO3CLASS 762,938.0 24.4 Filling 000110L3 ONSITE LTO3CLASS 762,938.00.7 Filling 000111L3 ONSITE LTO3CLASS 762,938.00.6 Filling 000112L3 ONSITE LTO3CLASS 762,938.00.5 Filling 000113L3 ONSITE LTO3CLASS 762,938.00.4 Filling 000114L3 ONSITE LTO3CLASS 387,116.8 100.0Full ONSITE stgpool: Storage Pool Name: ONSITE Storage Pool Type: Primary Device Class Name: LTO3CLASS Estimated Capacity: 34,216 G Space Trigger Util: Pct Util: 7.2 Pct Migr: 28.0 Pct Logical: 100.0 High Mig Pct: 95 Low Mig Pct: 90 Migration Delay: 0 Migration Continue: Yes Migration Processes: 1 Reclamation Processes: 1 Next Storage Pool: Reclaim Storage Pool: Maximum Size Threshold: No Limit Access: Read/Write Description: primary onstie storage pool Overflow Location: Cache Migrated Files?: Collocate?: Group Reclamation Threshold: 100 Offsite Reclamation Limit: Maximum Scratch Volumes Allowed: 50 Number of Scratch Volumes Used: 14 Delay Period for Volume Reuse: 0 Day(s) Migration in Progress?: No Amount Migrated (MB): 0.00 Elapsed Migration Time (seconds): 0 Reclamation in Progress?: No Last Update by (administrator): ADMIN Last Update Date/Time: 04/09/2010 07:09:46 Storage Pool Data Format: Native Copy Storage Pool(s): Active Data Pool(s): Continue Copy on Error?: Yes CRC Data: No Reclamation Type: Threshold Overwrite Data when Deleted:
Re: Query for inactive data summary
Debbie, I think the new storage reports on our ART product will help you: http:downloads.tsmworks.com/ARTProductDemo.ppt, slides 27-29. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Mar 26, 2010 at 10:26 AM, Haberstroh, Debbie (IT) habe...@voughtaircraft.com wrote: Good morning, We have a lot of old inactive folders that I would like to delete but I need to gather some information to present to my customer before I can do this. I am looking for a query that will summarize the data, just the inactive folder name and amount of data in it. I can do the dsmc q backup and get a list of all of the files in the folder but was looking for a query that would consolidate the information before going for all of the detail. If someone could point me in the right direction I would appreciate it. We are running TSM 5.5 and our reto policy is no limit, thanks. Debbie Haberstroh Server Support
Re: Query for inactive data summary
Sorry, meant that for Debbie, not the list. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Mar 26, 2010 at 10:35 AM, Lindsay Morris lind...@tsmworks.comwrote: Debbie, I think the new storage reports on our ART product will help you: http:downloads.tsmworks.com/ARTProductDemo.ppt, slides 27-29. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Mar 26, 2010 at 10:26 AM, Haberstroh, Debbie (IT) habe...@voughtaircraft.com wrote: Good morning, We have a lot of old inactive folders that I would like to delete but I need to gather some information to present to my customer before I can do this. I am looking for a query that will summarize the data, just the inactive folder name and amount of data in it. I can do the dsmc q backup and get a list of all of the files in the folder but was looking for a query that would consolidate the information before going for all of the detail. If someone could point me in the right direction I would appreciate it. We are running TSM 5.5 and our reto policy is no limit, thanks. Debbie Haberstroh Server Support
Re: SErvername stanza in dsm.opt in Unix systems
It does, but you have to do it differently. Unix: one big dsm.sys with several stanzas each starting with SERVERNAME; use the -servername switch on dsmc to indicate which stanza to use. Windows: dsm.opt files with only one stanza each use the -optfile switch to indicate which dsm.opt file to use. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Mar 23, 2010 at 8:34 AM, Mehdi Salehi ezzo...@googlemail.comwrote: Thanks for the info, but why B/A client for Windows doesn't have such a flexibility to separate system-wide and user-wide config files? Don't say windows in not multi-user ;)
Re: ANR9999D_2590516390
I've heard of this happening due to library firmware mismatch. The old computer joke: WOM, Write-only media. Another argument for restore testing. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Fri, Feb 19, 2010 at 8:57 AM, Wanda Prather wanda.prat...@jasi.comwrote: This is very bad. magic errors usually indicate physical corruption in the data. It can be due to a physical I/O error on the media, or software, or firmware. I suggest you open a severity 1 PMR with IBM right away, because your backups may be creating MORE unreadable data all the time. IBM can tell you whether an AUDIT of all your storage is needed, or whether there is something else you should do. Here is a similar hit from the IBM data base: http://www-01.ibm.com/support/docview.wss?uid=swg21406169 On Fri, Feb 19, 2010 at 8:44 AM, Pawlos Gizaw pawlos.gi...@sanofi-aventis.com wrote: Has any one seen the below error? I have TMS 5.5.4 running on AIX 6.1 and no issue on all backups except backups pointed to data domain storage pool. Recently when DBA try to restore rman backup getting message ANS0322E (RC40) no text available for this return code. When I check the TSM server side see the below message. After the first incident datadomain/emc swapped out the hardware but we are still getting same error. ANRD_2590516390 NtpValidateComBlockHdr(pvrntp.c:5665) Thread84518: Invalid block header read from NTP drive DRIVE17 (/dev/rmt47).(magic=5A4D4E50, ver=5, Hdr blk=241976 expected 241977, dbytes=262096 262096) (SESSION: 67666, PROCESS: 232) ANRD_2590516390 NtpValidateComBlockHdr(pvrntp.c:5665) Thread84518: Invalid block header read from NTP drive DRIVE17 (/dev/rmt47).(magic=5A4D4E50, ver=5, Hdr blk=241976 expected 241977, dbytes=262096 262096) (SESSION: 67666, PROCESS: 232) ANR0541W Retrieve or restore failed for session - error on input storage Thanks Pawlos
Re: Virtual TSM
Typical of vendors not to support their own product.. !! A little harsh, I think. TSM works in a very complex environment, and people who use (that's us) it try all kinds of tricks. Some corner cases doubtless get exposed, where support rightly refuses to help. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Wed, Feb 3, 2010 at 8:32 AM, Micka tsm-fo...@backupcentral.com wrote: Thanks for the info! That's typical of vendors.. any excuse to not support their own product. Although I can't say I have ever needed to use the support but would be handy if it came to it. The VM guest would be hosted on a VMware ESX Server 3i. So if I did virtualise it and had a tape library connected.. they won't support the TSM server at all? Have you ever got it working on a VMware ESX server? +-- |This was sent by micka...@hotmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +--
Re: SQL Query find nodes associated with management class
We deal with this problem by using the dsmc client, rather than the dsmadmc client. dsmc query backup... seems to be more efficient that dsmadmc select ... from backups.. Requires some clever setup, though, so you don't have to go log on to the client itself to run dsmc. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jan 28, 2010 at 11:28 AM, Huebschman, George J. gjhuebsch...@lmus.leggmason.com wrote: The only way I know to get that directly is from the backups table. Running a select against the backups table for all nodes on a server is not a good thing...believe me (don't ask). If you want to do it, make the select as precise as possible and run it for one node at a time. select distinct node_name, filespace_name, class_name from backups where node_name='NODENAMEXYZ' and filespace_id=x (or filespace_name='whateveryerlookinfer') and type='FILE' and state='ACTIVE' Wanda advised me to limit such queries with index key paramaters as much as possible to keep the select processing as light as possible. George Huebschman -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Timothy Hughes Sent: Thursday, January 28, 2010 11:16 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL Query find nodes associated with management class Hi all, I am trying to find all nodes that are associated with a particular management class, does anyone have a SQL statement that will produce this information? Thanks IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: SQL Query find nodes associated with management class
Right, we did some magic on the dsmc client so it can masquerade as other clients. Then, from our ART restore-testing appliance, we can run dsmc query backup.. masquerading as each production node in turn, and do a restore test on a randomly selected file from that node. So ART can do random-sample restore testing on all 500 machines you back up. (Sorry. Marketing hat off.) But I see this question here repeatedly: how can I list all of my backup files? And the answer is always Don't do that, or tread carefully like Richard just said. But our ART tool DOES have a way to list all the backed-up files, and their sizes, and their management class.. ... for ALL the machines you back up with all your TSM servers ... without hurting your TSM server's performance. So why are people wanting to do this? Hey, you lurkers who think about doing this: will you speak up and say why, please? What are you really after, reducing wasted storage? tuning up retention policies? What? Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jan 28, 2010 at 11:51 AM, Huebschman, George J. gjhuebsch...@lmus.leggmason.com wrote: That is true. The dsmc q backup IS much more efficient. Some server admins don't have access to clients though. In his case he wants to look at all of his clients. I don't know how many he has, but the time to go into each could be considerable. You mention a way of doing it without log on to each client. You got me there. Richard's point is also very important. The query should be limited to certain objects or filespaces that you would expect to be using that MC, or the opposite if you want to be sure that if you want to be sure that the MC is not being used where it shouldn't. For example, if you have one long retention for ComplianceData and another for everything else, you might care if system files are being bound to the Outrageos_Retn MC. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Thursday, January 28, 2010 11:34 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] SQL Query find nodes associated with management class We deal with this problem by using the dsmc client, rather than the dsmadmc client. dsmc query backup... seems to be more efficient that dsmadmc select ... from backups.. Requires some clever setup, though, so you don't have to go log on to the client itself to run dsmc. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Thu, Jan 28, 2010 at 11:28 AM, Huebschman, George J. gjhuebsch...@lmus.leggmason.com wrote: The only way I know to get that directly is from the backups table. Running a select against the backups table for all nodes on a server is not a good thing...believe me (don't ask). If you want to do it, make the select as precise as possible and run it for one node at a time. select distinct node_name, filespace_name, class_name from backups where node_name='NODENAMEXYZ' and filespace_id=x (or filespace_name='whateveryerlookinfer') and type='FILE' and state='ACTIVE' Wanda advised me to limit such queries with index key paramaters as much as possible to keep the select processing as light as possible. George Huebschman -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Timothy Hughes Sent: Thursday, January 28, 2010 11:16 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] SQL Query find nodes associated with management class Hi all, I am trying to find all nodes that are associated with a particular management class, does anyone have a SQL statement that will produce this information? Thanks IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you. IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery
Re: pct idle wait 100
The note Andy refers to (ie search idle wait 100) recommends using accounting log records to get accurate information. I agree fully. In building Servergraph, we tried many different ways to get session information, and the only one that was consistently accurate was the accounting log. Lindsay Morris CEO, TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Wed, Jan 13, 2010 at 8:13 AM, Andrew Raibeck stor...@us.ibm.com wrote: Hi Keith, Go to the link in sig and do a search on idle wait 100 and you should get a hit relevant to the issue you describe. Best regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 01/12/2010 10:44:46 AM: [image removed] pct idle wait 100 Keith Arbogast to: ADSM-L 01/12/2010 10:46 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager What does it mean when Pct. Idle Wait and Pct. Comm Wait are large numbers greater than 100 as in the node below? The TSM server is at version 5.5.2.1, running on RHEL. Thank you, Keith Arbogast tsm: TSMIN01q node bl-sdd-internal f=d Node Name: BL-SDD-INTERNAL Platform: WinNT Client OS Level: 6.00 Client Version: Version 5, release 5, level 2.0 . Compression: Client .. Last Communication Method Used: Tcp/Ip Bytes Received Last Session: 55,104.51 M Bytes Sent Last Session: 150.61 M Duration of Last Session: 0.05 Pct. Idle Wait Last Session: 8,565,047.92 Pct. Comm. Wait Last Session: 67,277,175.00 Pct. Media Wait Last Session: 0.00
Re: Disparate Client Options
We're all right, but not shedding a lot of light at this point. I hope Nick finds a solution to his original problem. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Wed, Jan 6, 2010 at 7:08 AM, Schaub, Steve steve_sch...@bcbst.comwrote: While we're quibbling... What I would like is a single install binary that I could throw at W2K3, W2K8, x86, x64 and have it automatically detect and install what it needs, rather than me having to create multiple install scripts. While we're at it, having a central console to push new clients out in mass would be nice too. Steve Schaub Systems Engineer, Windows BlueCross BlueShield of Tennessee -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Wanda Prather Sent: Tuesday, January 05, 2010 9:37 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Disparate Client Options I could quibble - they have to do all that anyway, right, across the various clients? I don't think so. Consider, how would you map an ACL for a UNIX file in say, an AIX DFS filesystem, to an ACL for a Windows file system? The client is supposed to honor those ACL's, and restore them along with the data. I don't see how that would work. And you can have things in non-text files that simply don't compute when moved from UNIX to Windows and vice-versa. Moving a binary from UNIX to Windows won't make it executeable. And there are file formats that have big-endian vs. little-endian issues (for example, output from Fortran, for which there were UNIX compilers at one time, although I realize there are fewer and fewer such cases these days.). And Richard is correct, when restoring to Windows, TSM doesn't write the files; it calls NTFS to write the files. I don't know that all the filesystem calls translate. For instance, you can create an empty 2GB file in an NTFS filesystem; there is no such thing in a JFS. And there are at least 5 different filesystem types for AIX, at least 4 that I know of for Red Hat, et cetera, et cetera many, many permutations. SO if you say well those aren't the files I'm interested in, I just want flat files...then I think what you are looking for is a different protocol altogether - maybe ask for a bit stream restore, where TSM will restore the bits into a flat file across operating systems, ignoring all the conversion issues, and make you responsible for decoding the result. But I'm still not sure that's desirable from a security point of view, and most people will find it less work to restore the file back to its original O/S and FTP it, thereby taking the responsibility of stripping out the ACL's themselves... W Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 2:22 PM, Richard Sims r...@bu.edu wrote: On Jan 5, 2010, at 12:19 PM, Lindsay Morris wrote: True, unix to unix works, and windows to windows too. Osx and netware are oddballs, but not so common. But we build an appliance that wants to dsmc restore from ALL the nodes on a TSM site, windows and unix both, to spot-check recoverability. Dsmc blocks cross-platfrm restores (windows vs unix at leadt), and for no good reason, AFAIK. Well...consider what's involved. The good reason is that a fully cross-platform client architecture would have to include full programming for the universe of file system types accommodated on all the supported platforms - and additionally would have to adeptly provide a meta layer of emulation of the wealth of system calls associated with the file system which is not native to the receiving platform. That's an enormous amount of development and testing and maintenance. I'd rather that their energies went toward things like 64-bit clients, and administrative API, and long-overdue evolution of the terribly neglected CLI. Richard Sims - Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
Re: Disparate Client Options
Right, but then Nick has to keep dsm.sys files up to date on all his clients. Ick. What he wants is a central way to issue dsmc commands and point them to a different TSM server, with no client-side setup required. Right, Nick? We don't have a good answer for this either. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 11:34 AM, Howard Coles howard.co...@ardenthealth.com wrote: In UNIX use the -optfile= option and specify an opt file that points to a separate Stanza in the dsm.sys file. Another way of doing the same thing essentially. See Ya' Howard Coles Jr. John 3:16! -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Nick Laflamme Sent: Tuesday, January 05, 2010 9:54 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Disparate Client Options Does it annoy or hinder anyone else that the tcpserver and tcpport options supported by the Windows version of dsmadmc aren't supported by the Unix clients? This seems to be a deliberate choice by IBM; the 5.5.2 levels of the client make a point to quit with an error message if I try to use them; in the 5.5.1 level, my attempts to use them are merely ignored. I want them so I can have scripts issue QUERY SERVER commands against a central server and use that output to connect to new (or existing) TSM servers I maintain. Apparently, in the Unix world, I'm supposed to keep dsm.sys up to date on every Unix server on which I might run my scripts instead of dynamically specifying these parameters. Part of it is because of the number of servers on which I might access these scripts; part of is because we anticipate rolling out waves of new servers in the future as we retire older servers. Either way, the thought of keeping dsm.sys up to date just so I can run administrative scripts is annoying, to put it mildly. Anyone else with me on this? Thanks, Nick
Re: Disparate Client Options
Thanks. Really, I wish there was one code base for the dsmc client. As it is now, Windows-dsmc and unix-dsmc have different command-line options and other differences too. And the cross-platform problem with dsmc makes it hard for us to do what we do (ie, restore testing across all platforms). (Cross-platform problem means: from a WINDOWS dsmc client, you can successfully connect to a TSM server, and use -asnode=some-UNIX-node to masquerade as another node; but then query filespaces comes back empty. And vice versa. ) Just grumbling. We dealt with it. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 11:42 AM, Nick Laflamme dplafla...@gmail.com wrote: Got it in one, LIndsay, got it in one. Nick On Jan 5, 2010, at 10:37 AM, Lindsay Morris wrote: Right, but then Nick has to keep dsm.sys files up to date on all his clients. Ick. What he wants is a central way to issue dsmc commands and point them to a different TSM server, with no client-side setup required. Right, Nick? We don't have a good answer for this either. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 11:34 AM, Howard Coles howard.co...@ardenthealth.com wrote: In UNIX use the -optfile= option and specify an opt file that points to a separate Stanza in the dsm.sys file. Another way of doing the same thing essentially. See Ya' Howard Coles Jr.
Re: Disparate Client Options
True, unix to unix works, and windows to windows too. Osx and netware are oddballs, but not so common. But we build an appliance that wants to dsmc restore from ALL the nodes on a TSM site, windows and unix both, to spot-check recoverability. Dsmc blocks cross-platfrm restores (windows vs unix at leadt), and for no good reason, AFAIK. Lindsay Morris TSMworks, Inc. 1-919-403-8260 www.tsmworks.com On Jan 5, 2010, at 11:55 AM, Jánský Vítězslav vitezslav.jan...@t-system S.CZ wrote: TSM is quite good in cross platfrom restores to be honest. Unix-to- unix works like charm (ignore osx ahem). Try to do it in NetWorker for example. Solaris to Linux to HP-UX to AIX or whatever - no way, not supported, you are screwed. V.J. Odesílatel: ADSM: Dist Stor Manager [ads...@vm.marist.edu] za uživat ele Lindsay Morris [lind...@tsmworks.com] Odesláno: 5. ledna 2010 17:51 Komu: ADSM-L@VM.MARIST.EDU Předmět: Re: [ADSM-L] Disparate Client Options Thanks. Really, I wish there was one code base for the dsmc client. As it is now, Windows-dsmc and unix-dsmc have different command-line options and other differences too. And the cross-platform problem with dsmc makes it hard for us to do what we do (ie, restore testing across all platforms). (Cross-platform problem means: from a WINDOWS dsmc client, you can successfully connect to a TSM server, and use -asnode=some-UNIX- node to masquerade as another node; but then query filespaces comes back empty. And vice versa. ) Just grumbling. We dealt with it. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 11:42 AM, Nick Laflamme dplafla...@gmail.com wrote: Got it in one, LIndsay, got it in one. Nick On Jan 5, 2010, at 10:37 AM, Lindsay Morris wrote: Right, but then Nick has to keep dsm.sys files up to date on all his clients. Ick. What he wants is a central way to issue dsmc commands and point them to a different TSM server, with no client-side setup required. Right, Nick? We don't have a good answer for this either. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 11:34 AM, Howard Coles howard.co...@ardenthealth.com wrote: In UNIX use the -optfile= option and specify an opt file that points to a separate Stanza in the dsm.sys file. Another way of doing the same thing essentially. See Ya' Howard Coles Jr.
Re: Disparate Client Options
I could quibble - they have to do all that anyway, right, across the various clients? But you're right about other things being more important for the normal TSM user. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Jan 5, 2010 at 2:22 PM, Richard Sims r...@bu.edu wrote: On Jan 5, 2010, at 12:19 PM, Lindsay Morris wrote: True, unix to unix works, and windows to windows too. Osx and netware are oddballs, but not so common. But we build an appliance that wants to dsmc restore from ALL the nodes on a TSM site, windows and unix both, to spot-check recoverability. Dsmc blocks cross-platfrm restores (windows vs unix at leadt), and for no good reason, AFAIK. Well...consider what's involved. The good reason is that a fully cross-platform client architecture would have to include full programming for the universe of file system types accommodated on all the supported platforms - and additionally would have to adeptly provide a meta layer of emulation of the wealth of system calls associated with the file system which is not native to the receiving platform. That's an enormous amount of development and testing and maintenance. I'd rather that their energies went toward things like 64-bit clients, and administrative API, and long-overdue evolution of the terribly neglected CLI. Richard Sims
Re: Multiple backup scenarios !
Great analysis. Thanks! I have a hard time imagining how file-based restores could be faster than image-based restores. File restores have to create each of the 300,000 files, right? and file-create, during restore, is a lot slower than file-open, during backup. But I guess if you have a lot of tape drives and not so many files it'll balance out. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Wed, Dec 9, 2009 at 2:02 AM, Roger Deschner rog...@uic.edu wrote: The basic principle of backup is that it must be separated from its source. Anything else is just RAID-xx. It should be separated by both distance and time, with time being more important. TSM makes time separation easier, storing multiple previous copies of only the different data with minimal overhead. TSM point-in-time restore is perhaps the miracle that best proves the ingenuity of the basic TSM database-based progressive backup architecture. It has been my experience in actual disaster scenarios, that a restore from traditional TSM progressive backups, will run at network speed from collocated tape with properly grouped collocation groups. (or from disk) Image backups would not increase restore speed much, and could even slow down a restore compared to a restore from TSM collocated tape if you can get several tapes mounted at once. In that disaster I had about 8 years ago, I got 4 tape drives reading tapes at once and pushing files onto the net to the client node. The client couldn't believe it, but restoring individual files was faster than restoring an image. The most frequent thing that real backups protect you from is someone having an oops moment. I am perfectly capable of manually corrupting the config file for a vital app while trying to change it. Going back to last night's backup copy is necessary. That's the time separation. Roger Deschner University of Illinois at Chicago rog...@uic.edu Academic Computing Communications Center === If you open that Pandora's Box, === === all sorts of Trojan Horses will jump out of it. === (from a bad writing competition) On Tue, 8 Dec 2009, Lindsay Morris wrote: Good point. Similarly, we're all happy with lightning-fast restores from remotely mirrored disks. But thinking of that as a BACKUP solution leaves you open to at least these scenarios: -- viruses corrupt the primary disk, and the mirror at the same time; -- A database maintenance script gets run with 2009 instead of 2008 (for example), and trashes the database AND its mirror as above -- brownouts can do similar things (so I've heard; never been through one) Would anybody else offer scenarios where we would need traditional backups even though Mirroring, VCB backups, etc. are in place? Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Dec 8, 2009 at 8:42 AM, Tim Brown tbr...@cenhud.com wrote: I just want to emphasize the importance of having multiple backup scenarios. This includes TSM incremental, image and VCB backups for VMWare servers. We recently incorporated VCB backups. One week after that we had a critical VMEare server fail and the VCB backup saved us !! We could of restored with typical TSM incremental backups but the VCB restore was quicker. Tim Brown Systems Specialist - Project Leader Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. Thank you.
Re: Multiple backup scenarios !
Good point. Similarly, we're all happy with lightning-fast restores from remotely mirrored disks. But thinking of that as a BACKUP solution leaves you open to at least these scenarios: -- viruses corrupt the primary disk, and the mirror at the same time; -- A database maintenance script gets run with 2009 instead of 2008 (for example), and trashes the database AND its mirror as above -- brownouts can do similar things (so I've heard; never been through one) Would anybody else offer scenarios where we would need traditional backups even though Mirroring, VCB backups, etc. are in place? Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Tue, Dec 8, 2009 at 8:42 AM, Tim Brown tbr...@cenhud.com wrote: I just want to emphasize the importance of having multiple backup scenarios. This includes TSM incremental, image and VCB backups for VMWare servers. We recently incorporated VCB backups. One week after that we had a critical VMEare server fail and the VCB backup saved us !! We could of restored with typical TSM incremental backups but the VCB restore was quicker. Tim Brown Systems Specialist - Project Leader Central Hudson Gas Electric 284 South Ave Poughkeepsie, NY 12601 Email: tbr...@cenhud.com mailto:tbr...@cenhud.com Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 This message contains confidential information and is only for the intended recipient. 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, please notify the sender immediately by replying to this note and deleting all copies and attachments. Thank you.
Re: Antwort: Re: Which is the truth? Inconsistencies between Scheduler Log Summary and collected events
You would not be able to match up Objects inspected by scanning the log; You SHOULD be able to match up objects backed up and objects expired; The log numbers are larger than the client statistics, and that makes sense if the log has a lot of sessions, say, over the course of a week. The client statistics are for one particular session only. I don't have time to look through your log, but are you quite sure it only has the one session in it, that matches the statistics? I bet it has many sessions, like David said. Look at the dates in it. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Oct 26, 2009 at 9:37 AM, TSM t...@profi-ag.de wrote: Hi Andrew, you are right: Client: this is Windows TSM Backup-Archive Client Version 5, Release 5, Level 2.2 Server: this is AIX Session established with server TSM01: AIX-RS/6000 Server Version 5, Release 5, Level 3.0 the log file can be dowloaded from http://rapidshare.com/files/298151011/logWith1Session.zip.html MD5: B56F02BA5E6968A98B10BF4A24E1D8E0 Thank you Gernot Andrew Raibeck stor...@us.ibm.com Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 26.10.2009 14:10 Bitte antworten an ADSM: Dist Stor Manager An: ADSM-L@VM.MARIST.EDU Kopie: Thema: Re: Which is the truth? Inconsistencies between Scheduler Log Summary and collected events I think we'd need to see your log file to truly validate the numbers. You also don't mention what client version or platform this is. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/26/2009 08:15:05 AM: [image removed] Which is the truth? Inconsistencies between Scheduler Log Summary and collected events TSM to: ADSM-L 10/26/2009 08:16 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Hi, An incremental client schedule provided the following statistics: 10/18/2009 23:56:38 --- SCHEDULEREC STATUS BEGIN 10/18/2009 23:56:38 Total number of objects inspected: 3,096,554 10/18/2009 23:56:38 Total number of objects backed up:4,856 10/18/2009 23:56:38 Total number of objects updated: 0 10/18/2009 23:56:38 Total number of objects rebound: 0 10/18/2009 23:56:38 Total number of objects deleted: 0 10/18/2009 23:56:38 Total number of objects expired: 27,290 10/18/2009 23:56:38 Total number of objects failed: 6 10/18/2009 23:56:38 Total number of subfile objects: 0 10/18/2009 23:56:38 Total number of bytes transferred:5.43 GB 10/18/2009 23:56:38 Data transfer time: 262.70 sec 10/18/2009 23:56:38 Network data transfer rate:21,698.41 KB/sec 10/18/2009 23:56:38 Aggregate data transfer rate:401.75 KB/sec 10/18/2009 23:56:38 Objects compressed by:0% 10/18/2009 23:56:38 Subfile objects reduced by: 0% 10/18/2009 23:56:38 Elapsed processing time: 03:56:28 A deeper look into the scheduler log (68496 lines) shows different results: # grep Retry log | grep Directory-- | wc -l 206 # grep Retry log | grep Normal File | wc -l 100 # grep Retry log | grep Expiring | wc -l 87 # grep -v Retry log | grep Directory-- | wc -l 7613 # grep -v Retry log | grep Normal File | wc -l 12472 # grep -v Retry log | grep Expiring--| wc -l 47957 I checked twice: There is only one scheduler protocol in the file How do these figures fit together?? Thank you Gernot
Re: Which is the truth? Inconsistencies between Scheduler Log Summary and collected events - Solved
Glad to help. We've seen problems in the summary table and in the client-statistics reporting. For Servergraph, we ended up using the accounting log to analyze client sessions. That has always been rock solid. To use it: SET ACCOUNTING ON, first; do a backup or something; then look for dsmaccnt.log in the ...tsm/server/bin directory, and write scripts to parse it, per the documentation in the TSM Administrator's Guide (or is it the Reference?) (Or get Servergraph to do it for you.) Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Oct 26, 2009 at 11:18 AM, Andrew Raibeck stor...@us.ibm.com wrote: Ah, this came in after I hit send on my second response on this thread, so you have already found what I indicated. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/26/2009 11:15:58 AM: [image removed] Re: Which is the truth? Inconsistencies between Scheduler Log Summary and collected events - Solved TSM to: ADSM-L 10/26/2009 11:16 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Hi Lindsay First item sent: 10/17/2009 20:00:49 Last item sent: 10/18/2009 23:56:35 Elapsed processing time: 03:56:28 In deed, there are two sessions in the log. I missed checking the fist and the last item sent. Scheduler Log Summary and collected events correspond perfectly. Sorry for the set up. and thank you Gernot Lindsay Morris lind...@tsmworks.com Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 26.10.2009 15:07 Bitte antworten an ADSM: Dist Stor Manager An: ADSM-L@VM.MARIST.EDU Kopie: Thema: Re: Antwort: Re: Which is the truth? Inconsistencies between Scheduler Log Summary and collected events You would not be able to match up Objects inspected by scanning the log; You SHOULD be able to match up objects backed up and objects expired; The log numbers are larger than the client statistics, and that makes sense if the log has a lot of sessions, say, over the course of a week. The client statistics are for one particular session only. I don't have time to look through your log, but are you quite sure it only has the one session in it, that matches the statistics? I bet it has many sessions, like David said. Look at the dates in it. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Oct 26, 2009 at 9:37 AM, TSM t...@profi-ag.de wrote: Hi Andrew, you are right: Client: this is Windows TSM Backup-Archive Client Version 5, Release 5, Level 2.2 Server: this is AIX Session established with server TSM01: AIX-RS/6000 Server Version 5, Release 5, Level 3.0 the log file can be dowloaded from http://rapidshare.com/files/298151011/logWith1Session.zip.html MD5: B56F02BA5E6968A98B10BF4A24E1D8E0 Thank you Gernot Andrew Raibeck stor...@us.ibm.com Gesendet von: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 26.10.2009 14:10 Bitte antworten an ADSM: Dist Stor Manager An: ADSM-L@VM.MARIST.EDU Kopie: Thema: Re: Which is the truth? Inconsistencies between Scheduler Log Summary and collected events I think we'd need to see your log file to truly validate the numbers. You also don't mention what client version or platform this is. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Product Development Level 3 Team Lead Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus Internet e-mail: stor...@us.ibm.com IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/ IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. Good enough is the enemy of excellence. ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 10/26/2009 08:15:05 AM: [image removed] Which is the truth? Inconsistencies between Scheduler Log Summary and collected events TSM to: ADSM-L 10/26/2009 08:16 AM Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Please respond to ADSM: Dist Stor Manager Hi, An incremental client schedule provided the following statistics: 10/18/2009 23:56:38
Re: TSM journaling
Right, watch out for the Windows journalling service quietly dying off. TSM then reports successful backups, but doesn't back up anything. One of our customers got a big black eye that way. TSM development is considering abandoning the Windows journaling service for something more reliable; until then, reboot windows nodes weekly, if they are using the JBB trick. Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com On Mon, Oct 26, 2009 at 11:21 AM, David McClelland t...@networkc.co.ukwrote: If nobody has pointed it out already, perhaps this is the article that you're looking for: Steps required to setup the TSM Journaling Service in a MSCS environment http://www-01.ibm.com/support/docview.wss?rs=1019context=SSSQWCcontext=SSG SG7q1=Journal+Service+Clusteruid=swg21167834loc=en_UScs=utf-8lang=en I've worked with TSM Journalling in MSCS clusters in the past, and it's *okay* on the whole, but I'd recommend some good monitoring to make sure the journal service is up/running as expected, and also to run a non-journalled backup at intervals (e.g. once a week, once a month perhaps - iirc the option '-nojournal' might be your friend here) using MEMORYEFFICIENTBACKUP YES as Mr Coles suggests. HTH, /David Mc London, UK -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Johnny Lea Sent: 26 October 2009 15:00 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM journaling Will not the PreserveDBOnExit=1 setting keep the journal active during a failover and prevent a full backup? I hope so cause I just set up journaling on a cluster and was counting on this. Johnny Howard Coles howard.co...@ardenthealth.com 10/26/2009 9:40 AM We tried this for a while, and I can dig up the docs on exactly how to set this up on an older Windows cluster. However, I would highly recommend using the memoryefficient backup with disk cache method instead. Every time the cluster fails over you'll have to do another full normal backup, which may or may not work due to the sheer number of files causing the inventory to fill up memory. With the disk cache method it's a little slower, but it doesn't have to start over every time you fail over or reboot. See Ya' Howard -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Sanju Chacko Sent: Monday, October 26, 2009 4:47 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM journaling Could someone provide me steps to install journaling on cluster? (Windows 2003 cluster) Thanks, Sanju Individuals who have received this information in error or are not authorized to receive it must promptly return or dispose of the information and notify the sender. Those individuals are hereby notified that they are strictly prohibited from reviewing, forwarding, printing, copying, distributing or using this information in any way. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.423 / Virus Database: 270.14.27/2452 - Release Date: 10/24/09 14:31:00
Re: Querying status of a finished process
TSM's query events will report success even though the backup may have skipped some files that were locked or open. I think many people ignore skipped files. But when building Servergraph, we added thorough skipped-file analysis, and were surprised at what our customers found. It turns out that the skipped files alert you to databases that are active during backup (thus can't be backed up consistently). This seems to be a common problem. Your user community doesn't know that databases need special treatment; you DO know that, but you don't know when someone installs a new application and its database. It's (my second-favorite phrase) a built-in organizational disconnect. On Wed, Oct 14, 2009 at 8:55 PM, Tribe tsm-fo...@backupcentral.com wrote: Hello, I'm a beginner with TSM and this question might be very basic. However, I wasn't able to find the answer in the documentation, so here's my question: I'm using TSM 5.5 and want to run all commands through the dsmadmc command line. I'm backing up and restoring NAS nodes. I found ways to start backups and query running processes (query process ID), but I don't know how to query the status of finished processes. I just want a simple way to figure out if a backup / restore was successful. If I use the query process ID after the job finished, it just tells me Process cannot be found. There must be a simple way to do that, right? I know that I can query the actlog, but is there a better / easier way to do this, given a process id? Thanks, Jan +-- |This was sent by m...@janseidel.net via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: instrumentation for the server?
I once saw this when we had set BUFPOOLSIZE way too high.Giving the TSM server lots of memory starved the OS for memory; things slowed down horribly until we set BUFPOOLSIZE back to the Performance-tuning-guide recommendations ( I forget - 1/4 of available memory?) On Mon, Oct 12, 2009 at 7:58 AM, km k...@grogg.org wrote: Hello, I am currently analyzing a TSM server which uses 100% CPU on 4 cores when doing client backups. Almost all of it is privileged times, but there are very few IO's and low disk queues for both stgpools, db and log. Are there any trace flags similar to the client testflag instrument:detail but for the server that will allow me to see what the server is spending time on? I've been looking in the problem determination guide but cant find any flag similar to instrument_detail except for 'instr' which isnt documented and only gives me DB LATCHes. -km -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: TSM 6.1 and the ever expanding DB
they changed some internal tables so tools such as TSMmanager need to catch up on the new layout..TSMmanager reports on size stuff don't work at the moment. Stefan, can you be just a little more specific on this please? Which tables changed, and how? Or, which TSMmanager reports fail? thanks in advance. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Oct5, at 2:25AM, Stefan Folkerts wrote: I have been a member of the TSM 6 in production club since 6.1.2.0 and I am not happy with this release. I am also seeing strange db errors right from the start (clean install and export/import from 5.5 server) looking at the IBM help for these errors I read fairly cryptic steps about changing DB2 setting..step one was Open the DB2 console..what the heck!? I don't want to open the DB2 console, IBM told me I would not need DB2 knowledge and that the DB2 database use would be transparent for me..well..it's not...within the first hours after install until now it is not. DB size has increased about 5 times (using dedupe) and don't even get me started on the log size. Good things are dedupe, I get a 22% reduction of the amount of data stored on disk which is nice. Performance is good, it sucks that they changed some internal tables so tools such as TSMmanager need to catch up on the new layout..TSMmanager reports on size stuff don't work at the moment. More than once the system just stops responding...no lead on where it comes from and I never had this before on v5, it's not the hardware since I run TSM v6 inside a VMware VM and all other vm's are fine. At this point in time I would not recommend using TSM 6.1.2.0 in a production environment. -Oorspronkelijk bericht- Van: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] Namens Zoltan Forray/AC/VCU Verzonden: vrijdag 2 oktober 2009 15:15 Aan: ADSM-L@VM.MARIST.EDU Onderwerp: Re: [ADSM-L] TSM 6.1 and the ever expanding DB Join the club. I am beginning to wonder if anyone is successfully using V6.1, trouble-free. Monday I decided to put my 6.1.2 server into production and am wondering if this was a really bad decision. I have had to bounce it 5-times due to it simply hanging/going non-responsive eventhough the only activity has been exporting a large node from another server. The primary active log has been expanded 3-times (from 20GB to 60GB) eventhough I run 3-full DB backups daily. I had to reserve 300GB for the archivelog space. The DB has grown to 65GB for 4-nodes eventhough the original server with 250-nodes is only 80GB used. The diagnostic information for DB/log errors is fairly useless. The book says to go to DB2 to get it to explain the SQL? errors, eventhough in other places the book says to not mess with DB2 (pay no attention to the man behind the curtain..). I am having to become way more knowledgeable in DB2 than I ever wanted to be (Damn it, Jim.I am the backup/TSM administrator - not a DBA! - apologies to DeForest Kelley) Just got my 5th SQL error this week (10/2/2009 8:49:46 AM ANR0162W Supplemental database diagnostic information: -1:22003:-413 ([IBM] [CLI Driver][DB2/LINUXX8664] SQL0413N Overflow occurred during numeric data type conversion. SQLSTATE=22003) I have to run 3-full DB backups every day (along with the now added 3-BACKUP VOLHIST) just to try to keep ahead of what I consider normal, daily activity (never had to do this on V5.x - daily DB incrementals use to be more than enough - heaven help me if I get this server up to the size of my biggest V5 server which has a 150GB DB - I could never backup the DB fast enough to keep it from crashing). --- How about an informal poll. How many folks are running V6.1.2 servers in production? How big (occupancy? DB size? Number of active nodes?) What platform? From: Gill, Geoffrey L. geoffrey.l.g...@saic.com To: ADSM-L@VM.MARIST.EDU Date: 10/01/2009 08:12 PM Subject: [ADSM-L] TSM 6.1 and the ever expanding DB Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU I'm finding that what I know about how the DB works in 5.5 doesn't really equal how it works in 6.1. On a Linux box I brought up to migrate clients to a 6.1 server I created a 20GB log and 100GB DB. There 'will be' about 150 nodes moved to this instance but currently about 20 are backing up. My 5.5 server, on AIX 5.3, has a 125GB DB about 50% used, a 11GB log and it backs up 500+ clients per day with no issues. Last nights backup on the new box is telling me there is no more space in the database so backups are failing. After backing up systems for 30 days? I find that way out of whack from how 5.5 works and it seems to be telling me I need more than 10 times the space to keep 6.1 up. I can't believe 20 computers have eaten up 100GB of DB space in such a short period of time. I have a case open with IBM to discuss but I'm wondering what others are finding that are using 6.1. Perhaps I'm missing something in my setup
Unsubscribe
Lindsay Morris Principal TSMworks, Inc. 1-919-403-8260 www.tsmworks.com
Re: Time to register for TSM Symposium 2009
Looking at the schedule, you need a name for my exhibitor session: Trimming Junk Storage, Lindsay Morris. Is this my only speaking slot? I thought I had an hour on Monday or Tuesday also. Do I? Lindsay Morris Principal TSMworks, Inc. 1-919-403-8260 www.tsmworks.com On Jun 16, 2009, at 6:49 AM, Claus Kalle ka...@uni-koeln.de wrote: Dear TSM 2009 interests, as you may know, the TSM symposium 2009 will take place at the Grandhotel Petersberg located near Bonn, the former capital of Germany, in the Koeln/Bonn bay area from 27.-30.09.2009. Although many of you will have already registered for participation, today I may remind the others that the time-window for REGISTRATION is CLOSING end of June, because we have to claim room contingents in time and continue preparing for the event. After 30th June you will eventually not be able to register for the event any longer, so act now! So if you consider going to TSM 2009, look at the preliminary program http://tsm2009.uni-koeln.de under Program among much more information on that server and go ahead and REGISTER! Topics covered: TSM6.1 features/experiences, TSM roadmapfuture, TSM functions in real and virtual environments, TSM user experiences: GPFS, NDMP, Exchange, ... Speakers include - Tom O'Brien: TSM product manager - Dave Cannon: TSM chief architect - Colin Dawson: TSM 6.1 server development lead responsible for DB2 implementation - Jim Smith: TSM client architect - Oliver Augenstein: Development lead for TSM for ERP and TSM for Advanced Copy Services - Stefan Bender: Development lead for TSM for Space Management and HSM for Windows - Kurt Gerecke, IBM Germany - Professor Gerhard Schneider - User prespective reports from CERN, INFN, JVNC/FZJülich, RWTH Aach en, ... Enrollment/Registration subpages are ready to be used to register (Registration) right away. Thank you very much for your kind attention. Please excuse any duplicate mailings at this time. -- Claus Kalle, Universitaet zu Koeln, RRZK i i Leiter Abteilung Systeme I I E-Mail: ka...@uni-koeln.deM M Fon: 0221 478 5580 /I\ Fax: 0221 478 86845 MiMiMiM Snail-Mail: Robert-Koch-Str. 10, 50931 Koeln MIMiMiM
Re: when a file has only inactive version in TSM server?
This is a good question, really. We have found some fairly shocking inactive-file statistics lately: * One customer had 98.6% of their 30 TB of TSM backups in INACTIVE files. Their policy was to keep everything forever. * Another customer did full database dumps every day, and kept them for 180 days. They had about 90% of their 35 TB in inactive backups. Interesting that there is so much wasted storage. (BTW, be careful if you try this at home. This is the oft-mentioned query of the contents tables that kills TSM performance. ART trickles in the data as it runs restore tests, so it does NOT kill TSM's performance.) -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Sep17, at 9:07AM, Tchuise, Bertaut wrote: When there is no active version of the file :-) On a serious note, the TSM server will only have inactive versions of a file once the file is deleted from the client and the next incremental backup runs. BERTAUT TCHUISE TSM/NetApp Storage Administrator Legg Mason Technology Services *410-580-7032 btchu...@leggmason.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mehdi Salehi Sent: Thursday, September 17, 2009 9:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] when a file has only inactive version in TSM server? Hi, when does a file have only inactive versions in TSM server? Thanks IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Re: when a file has only inactive version in TSM server?
Certainly. I never meant to suggest that ALL inactive files were a waste; but our ART product often sees EXTREME levels of inactive-to-active ratios. Customers can save money if they trim away some of the unnecessary backups. Show the raw numbers to the bosses, and maybe they will change the extreme retention policies that cause this situation. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Sep17, at 12:16PM, John D. Schneider wrote: Lindsay, I agree that keep everything forever is an extremely expensive policy, even at the relatively low cost of tapes. But I don't agree that keeping inactive files is a waste of space. Perhaps that isn't how you meant it, but some might take it that way. How many versions of files a customer chooses to keep is a design decision, and those are always tradeoffs of cost versus risk. If we allow ourselves to fall into the thinking that the active version is the important one, but the inactive ones are somehow less important, we risk making bad business decision just to save tapes. With database applications especially, sometimes it could take days or weeks before accidental deletion of some data would be detected. So you must keep back enough versions to recover back to the point before the accident occurred. In one of my customer's environment's, they only keep back 14 days of backups of some large Oracle databases. This makes my job easier, because they don't take up much tape in the library. On the other hand, what if a person helped make a bunch of changes to the way a database worked, and then went out on vacation for two weeks, or just got busy with another application, and didn't realize that nightly processing was purging data sooner than it was supposed to? It isn't hard to picture this situation in real life. But since it has been two weeks before the problem was detected, it is too late and the data is gone. Of course, recovering data from that far back, extracting it, then injecting it back into the production database would have been a pain, but at least there would be options. Another scenario like this involves financial applications that do month-end closing. I have seen it happen where the accountants didn't detect a problem that happened with month-end closing until they were getting ready to run the next month-end closing. I usually recommend they keep backups back to 40-45 days, so if necessary, it is possible to restore data back to BEFORE the previous month's closing. Many customers agree it is worthwhile insurance. Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721 Original Message Subject: Re: [ADSM-L] when a file has only inactive version in TSM server? From: lindsay morris lind...@tsmworks.com Date: Thu, September 17, 2009 8:46 am To: ADSM-L@VM.MARIST.EDU This is a good question, really. We have found some fairly shocking inactive-file statistics lately: * One customer had 98.6% of their 30 TB of TSM backups in INACTIVE files. Their policy was to keep everything forever. * Another customer did full database dumps every day, and kept them for 180 days. They had about 90% of their 35 TB in inactive backups. Interesting that there is so much wasted storage. (BTW, be careful if you try this at home. This is the oft-mentioned query of the contents tables that kills TSM performance. ART trickles in the data as it runs restore tests, so it does NOT kill TSM's performance.) -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Sep17, at 9:07AM, Tchuise, Bertaut wrote: When there is no active version of the file :-) On a serious note, the TSM server will only have inactive versions of a file once the file is deleted from the client and the next incremental backup runs. BERTAUT TCHUISE TSM/NetApp Storage Administrator Legg Mason Technology Services *410-580-7032 btchu...@leggmason.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Mehdi Salehi Sent: Thursday, September 17, 2009 9:01 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] when a file has only inactive version in TSM server? Hi, when does a file have only inactive versions in TSM server? Thanks IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy
Re: Colorful console mode output
I just have to say that we took a long thoughtful look at all 3,000-
odd error messages when developing Servergraph.
We decided that the I, E, and W letters are misleading.
Some messages are marked W, Warning, when they indicate really serious
problems, like dead tape drives.
Other messages are marked E, Error, when they indicate minor stuff:
like a client sessoin broke the connection: happens a lot, and retries
may have taken care of it by the time you see the messages.
Servergraph pulls out 200-300 messages that are interesting, and
treats them Warning or Error based on our experience, not the I /E /W
letter.
I just don't want people thinking they can safely ignore the W-messages.
--
Mr. Lindsay Morris
Principal
www.tsmworks.com
919-403-8260
lind...@tsmworks.com
On Aug 24, 2009, at Aug 24, 9:02 AM, Andrew Raibeck wrote:
I took a crack at playing with Michael's script and came up with this
solution. I think the original script uses fancier XTerm colors, but
I've
been able to make this version work on Windows, Mac OS X 10.5, and
SUSE
Linux 9. On Windows, I use CTRL-BREAK to break out of the script.
The colors I used are:
- Informational messages: white on black
- Warning messages: bold yellow on black
- Error messages: bold red on black
- 'D' error messages (ANRD): bold white on red
You can adjust the colors according to the perldoc for the
Term::ANSIColor
module:
perldoc Term::ANSIColor
This will show you the different constants you can use (see the
DESCRIPTION section).
Here is the code (contains no hidden control characters):
#!/usr/bin/perl
use strict;
use POSIX qw(strftime); # This get us a timestamp for every line
that's
processed below.
use Term::ANSIColor qw(:constants);
if ($^O =~ m/^MSWin32/) {
require Win32::Console::ANSI;
}
## This block of three lines is responsible for catching Ctrl-C
my $int_counter = 0;
sub int_handler { $int_counter++ }
$SIG{INT} = 'int_handler';
$SIG{HUP} = 'int_handler';
$SIG{QUIT} = 'int_handler';
$SIG{PIPE} = 'int_handler';
$SIG{STOP} = 'int_handler';
$SIG{ABRT} = 'int_handler';
$SIG{TRAP} = 'int_handler';
$SIG{TERM} = 'int_handler';
## You probably need to edit the three lines below.
my $dsmadmBin = c:\\tsm\\baclient\\dsmadmc; # Path to dsmadmc
my $adminID = admin; # TSM admin
username
my $adminPass = xx;# TSM admin
password
## Invoke the 'dsmadmc' binary with appropriate user/pass (from above)
my $dscl = $dsmadmBin -consolemode -id=$adminID -password=
$adminPass;
open DSCL, $dscl| or die cannot execute dscl: $!;
while (DSCL) {
if ( $int_counter ) {
print Ctrl-C detected, cleaning up...;
last;
}
if(/(?:ANR\d{4}I)\s+(?:[\d\D]+)/) {
print WHITE, ON_BLACK, strftime %m\/%d %H:%M:%S ,
localtime;
print WHITE, ON_BLACK, $_, RESET;
}
elsif (/(?:ANR\d{4}W)\s+(?:[\d\D]+)/) {
print WHITE, ON_BLACK, strftime %m\/%d %H:%M:%S ,
localtime;
print YELLOW, BOLD, ON_BLACK, $_, RESET;
}
elsif (/(?:ANR\d{4}E)\s+(?:[\d\D]+)/) {
print WHITE, ON_BLACK, strftime %m\/%d %H:%M:%S ,
localtime;
print RED, BOLD, ON_BLACK, $_, RESET;
}
elsif (/(?:ANR\d{4}D)\s+(?:[\d\D]+)/) {
print WHITE, ON_BLACK, strftime %m\/%d %H:%M:%S ,
localtime;
print WHITE, BOLD, ON_RED, $_, RESET;
}
else {
print WHITE, ON_BLACK, strftime %m\/%d %H:%M:%S ,
localtime;
print WHITE, ON_BLACK, $_, RESET;
}
}
close DSCL;
print done!\n;
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Hartford/i...@ibmus
Internet e-mail: stor...@us.ibm.com
IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
The only dumb question is the one that goes unasked.
The command line is your friend.
Good enough is the enemy of excellence.
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 08/22/2009
01:44:22 AM:
[image removed]
Re: Colorful console mode output
Yudi Darmadi
to:
ADSM-L
08/22/2009 03:34 AM
Sent by:
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU
Please respond to ADSM: Dist Stor Manager
What about windows console? What modification should i do in order to
make
that script runs?
Best Regards,
Yudi Darmadi
PT Niagaprima Paramitra
Jl. KH Ahmad Dahlan No.25 Kebayoran Baru, Jakarta Selatan 12130
Phone: 021-72799949; Fax: 021-72799950; Mobile: 081905530830
http://www.niagaprima.com
- Original Message -
From: Stef Coene stef.co...@docum.org
To: ADSM-L@VM.MARIST.EDU
Sent: Saturday, August 22, 2009 11:59 AM
Subject: Re: [ADSM-L] Colorful console mode output
On Saturday 22 August 2009, Michael Green wrote:
If you are like me and find it helpful to have administrative
client
Re: Summarizing Tape Utilization
George, aren't you a Servergraph user? Doesn't it give you what you need? I don't know what you're trying to accomplish here, but Servergraph handles the usual culprits... Lindsay Morris Principal TSMworks, Inc. 1-919-403-8260 www.tsmworks.com On Jul 29, 2009, at 2:52 PM, Bob Levad ble...@winnebagoind.com wrote: I think you'll need a separate query for each utilization range. At least, I haven't thought of a good way to iterate. select stgpool_name, count(*) as 60% utilized 70% - from volumes - where devclass_name='LTOCLASS4' - and pct_utilized=60 - and pct_utilized70 - group by stgpool_name - order by stgpool_name Etc... You could maybe nest several of these selects inside another select, but that can be pretty cumbersome. Bob -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Huebschman, George J. Sent: Wednesday, July 29, 2009 10:59 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Summarizing Tape Utilization Greetings everyone, I have a/an SQL Select question. Most of my TSM Servers are at 5.5.1.0, one is at 5.5.2.0 I am trying to count the number of tapes with a percentage utilization in brackets of 10 percent. In other words, how many tapes with utilization between 100 and 90, 90 and 80, and so forth. I first tried: select count(volume_name), pct_utilized, stgpool_name from volumes - where (pct_utilized between 100 and 90) or (pct_utilized between 90 and 80) or (pct_utilized between 70 and 60) or (pct_utilized between 60 and 50) or (pct_utilized50)- group by stgpool_name, pct_utilized Although the statement functions and returns valid data, it is not what I expected. I mistakenly expected it to count all the tapes within each given range. What it really does is count tapes with distinct pct_util. I might as well not have specified the ranges. The only tapes it counted cumulatively were of the exact same pct_util. Unnamed[1] PCT_UTILIZED STGPOOL_NAME --- -- 1 59.4 C_TSMSERVER_TAPE 1 68.7 C_TSMSERVER_TAPE 1 78.2 C_TSMSERVER_TAPE 1 79.5 C_TSMSERVER_TAPE 1 99.9 C_TSMSERVER_TAPE 1100.0 C_TSMSERVER_TAPE 1 66.0 NASPOOL If I select for a count for greater than or less than a particular value, I get the kind of count I expect. I had expected between to do similar work but be less klunky. select count(volume_name) from volumes where pct_utilized100 and pct_utilized89 The other option I tried was CASE, WHEN, THEN: select count(case when pct_utilized between 100 and 91 then 1 else 0) from volumes and, select count(case when (pct_utilized between 100 and 91) then 1 else 0) from volumes Those failed for syntax errors. Is there a clean way to do this? George Huebschman IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Incl/Excl Problem
Wanda your two cents is worth at least a dime! I never knew you could use a MINUS sign in the DOMAIN statement to EXCLUDE a drive/filespace. Perfect, easy solution for all those bad=practice customers who've done this! I hope they lurk here, read this and make the change. Thank you! -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 24, 2009, at Jul 24, 8:34 AM, Wanda Prather wrote: Here's adding my 2c to the confusion: I agree with Lindsay; setting DOMAIN D: is dangerous, because that way all you get is D:, and if someone adds an E: drive later, it will be skipped. So I recommend using Bill's notation: Domain ALL-LOCAL -C: or Domain ALL-LOCAL Domain -C: Domain statements are additive; so if you specify all-local minus C:, if someone adds an E: drive later it will be correctly picked up. However, the original poster wanted to back up a subdirectory on C: If you exclude C: with a Domain statement, or with exclude.dir, you can't back up a subdirectory, because TSM will never traverse the C: drive at all. The only way to backup a subdirectory in C: without backing up all of C: is exclude c:\...\* include c:\...\subdir\...\* And that is going to give you a backup of all the files in subdir, and any subdirectories of subdir, AND a backup of all the other directory objects on C: as well. No way around that. NOW for my quibble, which is with the use of this notation: INCORRECT: exclude c:\...\*.* The include/exclude statements are doing a pattern match against the long file name. If you use the notation *.*, the include/exclude statement will NOT match any files that do not have a . in the name. There aren't a lot, but you will find some files in window with no suffix. I have NEVER seen a case in a real TSM site where the use of this notation was correct, or getting the intended results. The correct notation is c:\...\* the \ ...\ is a wildcard for any number of subdirectories (including 0 subdirectories), and the * is a pattern match for any number of characters, so it always works. Unfortunately the incorrect use of c:\...\*.* persisted in the client manual for a long time, but it was an artifact leftover from prehistoric windows versions, before windows used long file names. And of course, it still persists in web-space (and probably will persist long after we're dead because of that!). But it's still incorrect. W On Thu, Jul 23, 2009 at 11:20 AM, lindsay morris lind...@tsmworks.comwrote: Well, not to quibble, Bill, but you can use exclude.dir to avoid getting the C: directories, right? And the problem of users / admins adding a drive in the future, and TSM then SILENTLY skipping it due to DOMAIN D:, is real. I mean, I've seen this happen, and want to warn against this bad practice. Agree? Disagree? -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 23, 2009, at Jul 23, 10:54 AM, Bill Boyer wrote: I prefer to exclude it from the DOMAIN. That way you won't get the directories on the C: drive. This is from the help. For example, in the following options Tivoli Storage Manager will process all local drives except for the c: drive, systemobject, and systemstate domain: domain ALL-LOCAL -c: -systemobject domain ALL-LOCAL -c: -systemstate Bill Boyer Life is hard. After all, it kills you. - Katharine Hepburn -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of lindsay morris Sent: Thursday, July 23, 2009 10:27 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Incl/Excl Problem Well, there's a problem there: Our ART product has found several customers that shot themselves in the foot by doing this: DOMAIN D: because they don't want to back up C:, a stock image of windows-and- office. That works fine. But months later, the user adds drive E:, and TSM silently skips it. Better to use exclude of C:, IMHO -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 23, 2009, at Jul 23, 10:05 AM, km wrote: Even easier (no OS involvment) would be to use: virtualmountpoint c:\dir domain c:\dir in dsm.opt -km On 23/07, Adrian Compton wrote: Hi Patryk I found the best way to selectively backup directories was to create a share on the directory, and you can then choose that share as a domain to backup in your opt file. Hope this helps Regards Adrian Compton Aspen Pharmacare Port Elizabeth tel: +2741 4072855 Fax: +2741 453 7452 Cell: +27823204495 Email: acomp...@aspenpharma.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Patryk Bobak Sent: 23 July 2009 09:37 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Incl/Excl Problem Hi, I have problem with Incl/Excl list on client. I've searched forum and google but I cant find good solution. I want to backup only one selected folder (with subfolders and files) from C
Re: Incl/Excl Problem
Well, there's a problem there: Our ART product has found several customers that shot themselves in the foot by doing this: DOMAIN D: because they don't want to back up C:, a stock image of windows-and- office. That works fine. But months later, the user adds drive E:, and TSM silently skips it. Better to use exclude of C:, IMHO -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 23, 2009, at Jul 23, 10:05 AM, km wrote: Even easier (no OS involvment) would be to use: virtualmountpoint c:\dir domain c:\dir in dsm.opt -km On 23/07, Adrian Compton wrote: Hi Patryk I found the best way to selectively backup directories was to create a share on the directory, and you can then choose that share as a domain to backup in your opt file. Hope this helps Regards Adrian Compton Aspen Pharmacare Port Elizabeth tel: +2741 4072855 Fax: +2741 453 7452 Cell: +27823204495 Email: acomp...@aspenpharma.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Patryk Bobak Sent: 23 July 2009 09:37 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Incl/Excl Problem Hi, I have problem with Incl/Excl list on client. I've searched forum and google but I cant find good solution. I want to backup only one selected folder (with subfolders and files) from C:. For example C:\test\. I tryed a lot of configurations with exclude, exclude.dir and includes, and it backup my whole C: or dont backup anything. TSM Client: 6.1 Windows, TSM Server: 5.5.0 z/OS Patryk.
Re: Full tapes with low percent utilization
Run reclamation. They're FULL because TSM wrote all the way to the end; they're less than 100% because TSM expired some data, so there are effectively holes in the tape. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 23, 2009, at Jul 23, 10:24 AM, Mario Behring wrote: Hi list, I have several tapes on an IBM ULT-3580 library that show very low percent utilization (see output below) but a FULL statuswhy does that happens and how can I fix this? Volume Name Storage Device Estimated Pct Volume Pool Name Class Name Capacity Util Status --- -- - - PRI126L2 LTOPOOL1LTOCLASS1 201,994.0 96.3 Full PRI154L2 LTOPOOL1LTOCLASS1 200,903.4 51.1 Full PRI159 LTOPOOL1LTOCLASS1 201,804.7 67.3 Full PRI163L2 LTOPOOL1LTOCLASS1 201,364.6 34.5 Full PRI180L2 LTOPOOL1LTOCLASS1 201,747.9 75.3 Full PRI181L2 LTOPOOL1LTOCLASS1 409,600.0 7.2 Filling PRI195L2 LTOPOOL1LTOCLASS1 201,756.5 48.4 Full PRI201L2 LTOPOOL1LTOCLASS1 409,600.0 22.3 Filling PRI231L2 LTOPOOL1LTOCLASS1 199,055.3 89.0 Full PRI232L2 LTOPOOL1LTOCLASS1 199,836.6 24.0 Full PRI235L2 LTOPOOL1LTOCLASS1 199,666.6 90.3 Full PRI239L2 LTOPOOL1LTOCLASS1 200,540.6 66.3 Full PRI240L2 LTOPOOL1LTOCLASS1 201,894.0 8.0 Full PRI242L2 LTOPOOL1LTOCLASS1 409,600.0 3.5 Filling PRI247L2 LTOPOOL1LTOCLASS1 409,600.0 2.8 Filling PRI258L2 LTOPOOL1LTOCLASS1 201,798.0 11.1 Full PRI265L2 LTOPOOL1LTOCLASS1 202,189.0 74.7 Full PRI269L2 LTOPOOL1LTOCLASS1 202,121.1 29.2 Full PRI274L2 LTOPOOL1LTOCLASS1 202,076.6 37.8 Full PRI275L2 LTOPOOL1LTOCLASS1 202,155.3 45.1 Full PRI280L2 LTOPOOL1LTOCLASS1 201,808.0 63.5 Full PRI281L2 LTOPOOL1LTOCLASS1 202,134.7 1.3 Full PRI282L2 LTOPOOL1LTOCLASS1 201,870.9 46.5 Full PRI283L2 LTOPOOL1LTOCLASS1 201,743.3 43.9 Full PRI286L2 LTOPOOL1LTOCLASS1 202,075.0 92.0 Full PRI288L2 LTOPOOL1LTOCLASS1 201,944.3 96.3 Full Thanks Mario
Re: Incl/Excl Problem
Well, not to quibble, Bill, but you can use exclude.dir to avoid getting the C: directories, right? And the problem of users / admins adding a drive in the future, and TSM then SILENTLY skipping it due to DOMAIN D:, is real. I mean, I've seen this happen, and want to warn against this bad practice. Agree? Disagree? -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 23, 2009, at Jul 23, 10:54 AM, Bill Boyer wrote: I prefer to exclude it from the DOMAIN. That way you won't get the directories on the C: drive. This is from the help. For example, in the following options Tivoli Storage Manager will process all local drives except for the c: drive, systemobject, and systemstate domain: domain ALL-LOCAL -c: -systemobject domain ALL-LOCAL -c: -systemstate Bill Boyer Life is hard. After all, it kills you. - Katharine Hepburn -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of lindsay morris Sent: Thursday, July 23, 2009 10:27 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Incl/Excl Problem Well, there's a problem there: Our ART product has found several customers that shot themselves in the foot by doing this: DOMAIN D: because they don't want to back up C:, a stock image of windows-and- office. That works fine. But months later, the user adds drive E:, and TSM silently skips it. Better to use exclude of C:, IMHO -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jul 23, 2009, at Jul 23, 10:05 AM, km wrote: Even easier (no OS involvment) would be to use: virtualmountpoint c:\dir domain c:\dir in dsm.opt -km On 23/07, Adrian Compton wrote: Hi Patryk I found the best way to selectively backup directories was to create a share on the directory, and you can then choose that share as a domain to backup in your opt file. Hope this helps Regards Adrian Compton Aspen Pharmacare Port Elizabeth tel: +2741 4072855 Fax: +2741 453 7452 Cell: +27823204495 Email: acomp...@aspenpharma.com -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Patryk Bobak Sent: 23 July 2009 09:37 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Incl/Excl Problem Hi, I have problem with Incl/Excl list on client. I've searched forum and google but I cant find good solution. I want to backup only one selected folder (with subfolders and files) from C:. For example C:\test\. I tryed a lot of configurations with exclude, exclude.dir and includes, and it backup my whole C: or dont backup anything. TSM Client: 6.1 Windows, TSM Server: 5.5.0 z/OS Patryk.
Re: TSM vs Avamar
Some Avamar wisdom I've collected from customers of ours: If you're image-heavy, the de-dupe feature won't help you much You can use smaller pipes for backup because of the de-duplication. But beware: if you have to do a FULL recovery, as opposed to a single- file restore, you'll need to move more data than that small pipe can handle. Central management of several Avamar grids is a problem. Avamar needs something like TSM's enterprise administration. Now, if you want to change policies consistently across all the grids, you have to do them manually, one by one, and be careful. If you're on the West coast, it's easy to screw up the timezone when you're changing the schedule on an Avamar server that's on the East coast. You have to manually compensate for the three-hour difference. There's no community of customers like this one. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jun 23, 2009, at Jun 23, 5:40 PM, John D. Schneider wrote: Hi! I am just finishing up a multi-month proof-of-concept for Avamar. It has many benefits, but you need to keep in mind these things: 1) It is a disk-only solution, it has no tape backend. You will have to scale your Avamar footprint to completely contain all your backups, for however many days retention you need, so it all fits on one (or more) Avamar grids. If you scale it too small, you are going to be making a disk purchase to keep up. If you let it fill up, you are in trouble! You can't just shove more inexpensive tapes into the library. On the other hand, since Avamar's consumption of disk will be a tiny fraction as much as disk storage pool, you won't have to buy as much disk to get where your job done. Your consumption of disk is space varies widely depending on or mix of filesystem, database, NAS data types, so get help from EMC sizing the solution. 2) Avamar is RAIN technology (Redundant Array of Independent Nodes). Each grid of nodes will require 1 node for administration (called a utility node), and 1 spare. The nodes in the grid can contain either 1TB or 2TB. Redundant copies of that data are distributed across the nodes in the grid. Although it will scale to bigger grids, best practice is to keep the grids to around 14 nodes in size. This is not a terrible thing, but can add significantly to the cost. 3) Avamar comes with replication built in. Replication can be one-one, one-many, many-one. But replication takes time, and you should not plan to do your backups during replication; the performance will be significantly impacted. 4) Avamar also requires regular scheduled garbage-collection. They tell me it typically needs to run 2-4 hours per day. During this time the grid operates in read-only mode; you cannot do backups to it. So if you have hourly Oracle archive log backups, or some such, you will have build them to live without Avamar for these periods of time, because garbage collection is a necessity. 5) Backing up VMs, because they are so similar to each other, sounds like an idea application for deduplication. However, the VMWare VCB proxy solution today is very bad. But in every Avamar presentation I have been to, they completely gloss over how it really works. The way it works today requires each separate VM to be in its own group and its own schedule. In our case, with 600VMs, that was going to be a nightmare. Sometime in the third quarter when VMWare comes out with its next version of VCB, it is supposed to be much better. 6) It is not an Archive solution, so if you have multi-year long-term archive requirements, you will be needing a separage solution for those. Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 Toll Free: (866) 796-9226 Cell: (314) 750-8721 Original Message Subject: Re: [ADSM-L] TSM vs Avamar From: Shawn Drew shawn.d...@americas.bnpparibas.com Date: Tue, June 23, 2009 11:32 am To: ADSM-L@VM.MARIST.EDU They do have hardware at the multiple sites for DR. This is a hot DR site as opposed to a cold site that you can do with tapes. This does fit our environment however. We have multiple data centers that are DR sites for each other. Currently we use TSM with VTLs at multiple sites and just replicate with backup stgpools over the WAN. In reality, we run into more bad tapes than we do with bad disks. I can't remember if I've ever had to run a restore stg on a VTL. We only use tape for long term stuff Regards, Shawn Shawn Drew Internet nrodolf...@cmaontheweb.com Sent by: ADSM-L@VM.MARIST.EDU 06/23/2009 12:07 PM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] TSM vs Avamar What does Avemar offer for DR purposes? I don't know any customers that are ready to totally rely on electrically powered disk drives as a DR solution. The recent CommVault
Re: Dedupe
Short and clear answer about de-dupe: It depends. Hope this helps. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jun 24, 2009, at Jun 24, 11:33 AM, goc wrote: somewhat right but still over the top in my humble opinion ... so, whatever ...you could simply answer with short and clear answer about dedupe if you know anything, or simply ignore the question ... so your behavior is really odd. On Wed, Jun 24, 2009 at 5:09 PM, Allen S. Rout a...@ufl.edu wrote: On Wed, 24 Jun 2009 13:00:52 +0200, madunix madu...@gmail.com said: I was reading the following on the net regarding dedupe, can I have your opinion about the dedupe? You may note that you get a somewhat sparse, even frosty, response from this list. I'll let you know why I, in particular, don't choose to respond to most of your queries. You ask questions in a sufficiently vague manner that the appropriate answer is a long explanatory discourse. But you don't appear to welcome pointers to the authoritative discourse: the docs. This is fairly normal newbie behavior; nothing odd. But your web presence indicates you feel yourself to be enough of a TSM pro to put it on your CV. From someone of that competence level, the right questions are phrased something like: Hi, I'm doing X, with Y sorts of machines, and I encountered Z. Is this what you expect, how are you-all doing this, etc.. The interesting social-group distinction is that, in one communication you are: + offering some advice and feedback to those more newbie than you. This is important: you're giving before you're asking. + going out on a limb a bit, to show you have faith in your past opinions, while offering them for correction + displaying enough context that those contemplating a reply know how to phrase their answer. The terse, broad requests feel more like 'will you do my homework for me?', but I'm a known curmudgeon. So, whatever. - Allen S. Rout - Get off my lawn!
Re: Making sure clientactions start
Randomization doesn't apply when SCHEDMODE is PROMPTED. You know, I've seen this a couple of times: whether it's with CLIENTACTION or just a normal schedule, when you set the schedule's starttime to NOW, it takes a long time for the client to start: 30 seconds, 5 minutes, even longer. Sometimes reproducible, sometimes not. From memory, the client software was running; had schedmode prompted set; had been restarted after that; not firewalled away; up-to-date versions. Is there a tracing flag on client or server that would show us what's happening? On Tue, Jun 23, 2009 at 9:06 AM, AKiT ADSM-L ads...@akit.biz wrote: looking at all replies so far I saw no one mentioning the schedule randomization. default 25% randomization multiplied by default client action duration of 5 days makes 30 hours. see the help SET CLIENTACTDuration and help SET RANDomize commands Zlatko Krastev IT Consultant Lee, Gary D. g...@bsu.edu Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 19.06.2009 18:16 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject [ADSM-L] Making sure clientactions start I have a clientaction defined for a node whose schedmode is set to prompted. However, I have now been waiting for 45 minutes for the action to take place. Is there a way to get the server to kick itself and prompt the client to perform the actions in a clientaction? Gary Lee Senior System Programmer Ball State University phone: 765-285-1310 -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: Internal compression?
Another possible cause: at the beginning of a dsmc inc ... job, the TSM server sends the client lots of metadata, ie, a list of the files it currently has. The client then walks its local disk to see what's changed. If the client has 10 million files, that metadata can be significant. You can sort this out node-by-node using Servergraph, which reports a data type called overhead (maybe [nodename_ovhd?), exactly what you're talking about. So you can see WHICH client is doing this the most. Or you can dig it out yourself from the accounting log ... I forget exactly how... -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jun 11, 2009, at Jun 11, 3:30 PM, Shawn Drew wrote: Wow, it's amazing how much data is caught up in retries. On one of our larger instances, the amount transferred is 2.8TB but only 1.3TB was a part of the storage pool backup! Are retries the only explanation of this? Regards, Shawn Shawn Drew Internet r...@bu.edu Sent by: ADSM-L@VM.MARIST.EDU 06/11/2009 02:33 PM Please respond to ADSM-L@VM.MARIST.EDU To ADSM-L cc Subject Re: [ADSM-L] Internal compression? On Jun 11, 2009, at 2:14 PM, Shawn Drew wrote: Is there any reason that STGPOOL backups and Migrations would only process about half the quantity of data that is reported to be backed up? One commonly encountered reason is retries, evidenced in the full client log. (It's a product deficiency that the summary statistics don't report the retries in any way, so you have to pore over the full log.) Richard Sims This message and any attachments (the message) is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc.
Re: Windows excludes
Do you need quotes around the directory names? I think yes. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jun 8, 2009, at Jun 8, 12:20 PM, Fred Johanson wrote: I'm trying to bring up to date all our cloptsets . I've had some success, but these have me stumped. Directory Name Occurrences \\ad1\c$\Program Files\System Center Operations Manager 2007\Health Service State\Health Service Store\4 \\ad1\c$\WINDOWS\SoftwareDistribution\DataStore \ 1 \\ad1\c$\WINDOWS\SoftwareDistribution\DataStore\Logs \ 2 \\ad1\c$\WINDOWS\SoftwareDistribution\EventCache \ 1 This is what I've tried INCLEXCL86 No exclude.dir c: \Program Files\System Center Operations Manager 2007 INCLEXCL88 No exclude.dir *: \...\Software distribution Where's the error?
Re: TSM Administration Guide Using ISC
The ISC experts say that it's a lot better as of 6.1: better workflow, smaller footprint. So if you've gotten a bad impression in the past, try to keep an open mind. Or are your complaints about the version bundled with 6.1? Lindsay Morris Principal TSMworks, Inc. 1-919-403-8260 www.tsmworks.com On Jun 4, 2009, at 12:05 PM, Sabar Martin Hasiholan Panggabean sabar.hasiho...@metrodata.co.id wrote: Hi Grigori and Arnaud, For someone that has been using TSM from version 5.2 or familiar with TSM we can say that How about to convince new customers that the old thing better that the new one. They prefer use things new (up-to-date) and get satisfied with what they have bought. BR, Martin -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Grigori Solonovitch Sent: 04 Juni 2009 15:58 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Administration Guide Using ISC I agreed completely with that .. I have tried to use ISC a few times with no success. I was using TSM WEB Interface 5.2, which was announced by IBM as a temporary solution for TSM 5.3, with TSM 5.4 and TSM 5.5 successfully. I addition, I am using command line interface dsmadmc. I wonder, is there any possibility to install TSM WEB Interface 5.2 with TSM 6.1 or not? Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com Please consider the environment before printing this Email -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of PAC Brion Arnaud Sent: Thursday, June 04, 2009 11:49 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Administration Guide Using ISC Just wondering if this ISC is as just powerful as previous TSM Web Admin. Surely not, just a waste of time, disk space and energy. I'm still wondering who uses that ... thing. Cheers. Arnaud *** * ** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: arnaud.br...@panalpina.com *** * ** -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Sabar Martin Hasiholan Panggabean Sent: jeudi 4 juin 2009 10:39 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM Administration Guide Using ISC Well .. I'm definetly fine with command line. Just wondering if this ISC is as just powerful as previous TSM Web Admin. BR, Martin -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Remco Post Sent: 04 Juni 2009 15:20 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM Administration Guide Using ISC On 4 jun 2009, at 09:10, Sabar Martin Hasiholan Panggabean wrote: Hi All, Does IBM has documentation on administering TSM using Integrated Solution Console ? Never thought before until I can't find how to add Storage Agent. Usually I'm using previous TSM Web Administration. Wasn't the only use of the ISC to provide us with a command-line when all other options fail? I wouldn't be surprised if you need to use the cli to register storage agents. BR, Martin -- Met vriendelijke groeten/Kind regards, Remco Post No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.52/2152 - Release Date: 06/03/09 05:53:00 Please consider the environment before printing this Email. This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.52/2152 - Release Date: 06/03/09 05 :53:00
Re: TSM Administration Guide Using ISC
Right, GUI doesn't thrill us command-line bigots, does it? Servergraph has web-based management of TSM where you can see what commands it's issuing behind the scenes. Best of both worlds IMHO. (Don't flame me, I no longer work for Servergraph. Thanks.) Lindsay Morris Principal TSMworks, Inc. 1-919-403-8260 www.tsmworks.com On Jun 4, 2009, at 2:07 PM, Remco Post r.p...@plcs.nl wrote: On 4 jun 2009, at 19:31, Lindsay Morris wrote: The ISC experts say that it's a lot better as of 6.1: better workflow, smaller footprint. So if you've gotten a bad impression in the past, try to keep an open mind. I must agree with Lindsay on this. The most recent ISC, as it comes with TSM 6.1 is so much better than the very first version. I managed to install it in minutes on my way underpowered OpenSUSE VM. I've never been a fan of the Webconsole, never been able to find anything, and well, ISC is just as bad :) Really, I prefer the CLI, but when using a GUI, ISC is nothing better than the old webgui... -- Met vriendelijke groeten, Remco Post r.p...@plcs.nl +31 6 248 21 622
Re: Matching Node_name to Class_name
Use the b-trees: add node name and filespace name. select * from columns where tabname='BACKUPS' shuold show you (index_keyseq) where the b-trees are; use as many as you can but always the first one. Hope this helps. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On May 15, 2009, at May 15, 2:43 PM, Huebschman, George J. wrote: I think the answer to this question is, No , but I am going to ask anyway. I want to make a listing of the management classes used by each client. I have been asked to provide a list of applications that use longer than our standard retention policy. TSM will not identify applications for me, but I can look up Client/server names. I know how to write an sql query against the backups table. I have queried particular node_names to see what management classes they use. Thanks to instruction from W, I realize that the backups table is huge. I tried to make a more efficient query by restricting the query to Active objects of type File and running it on the TSM server with the smallest DB, but it was still running when I came back from lunch. select distinct node_name, class_name from backups where type='FILE' AND STATE='ACTIVE_VERSION' Is there a smarter way to find this information out? The owners of these clients for the most part would have no idea and would be no help. Thanks, George Huebschman Let me get this straight. You won't let us delete this node because there is no one left who remembers what the machine used to do? IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
Fwd: [ADSM-L] Website and Call for Papers for TSM Symposium 2009
Sorry, meant that as private; OTOH, I suppose we're all interested in how it's looking... -- Forwarded message -- From: Lindsay Morris lind...@tsmworks.com Date: Sat, May 2, 2009 at 4:32 PM Subject: Re: [ADSM-L] Website and Call for Papers for TSM Symposium 2009 To: ADSM: Dist Stor Manager ADSM-L@vm.marist.edu Claus, can you tell me please, how many people have registered so far? Thanks. On Thu, Apr 9, 2009 at 11:44 AM, Claus Kalle ka...@uni-koeln.de wrote: Updated information about the TSM Symposium 2009 being hosted by University of Cologne in September 2009 and taking place at Grandhotel Petersberg can be found at http://tsm2009.uni-koeln.de/ The CFP area in that webpage may give you some idea what to talk about and other hints for your contribution. You may download a small form to summarize your idea for easy processing. We need your contribution to make the symposium a successful event! The registration subpage is now available for enrollment. Have a nice easter weekend! Best regards, Claus -- Claus Kalle, Universitaet zu Koeln, RRZK i i Leiter Abteilung Systeme I I E-Mail: ka...@uni-koeln.deM M Fon: 0221 478 5580 /I\ Fax: 0221 478 86845 MiMiMiM Snail-Mail: Robert-Koch-Str. 10, 50931 Koeln MIMiMiM -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: Website and Call for Papers for TSM Symposium 2009
Claus, can you tell me please, how many people have registered so far? Thanks. On Thu, Apr 9, 2009 at 11:44 AM, Claus Kalle ka...@uni-koeln.de wrote: Updated information about the TSM Symposium 2009 being hosted by University of Cologne in September 2009 and taking place at Grandhotel Petersberg can be found at http://tsm2009.uni-koeln.de/ The CFP area in that webpage may give you some idea what to talk about and other hints for your contribution. You may download a small form to summarize your idea for easy processing. We need your contribution to make the symposium a successful event! The registration subpage is now available for enrollment. Have a nice easter weekend! Best regards, Claus -- Claus Kalle, Universitaet zu Koeln, RRZK i i Leiter Abteilung Systeme I I E-Mail: ka...@uni-koeln.deM M Fon: 0221 478 5580 /I\ Fax: 0221 478 86845 MiMiMiM Snail-Mail: Robert-Koch-Str. 10, 50931 Koeln MIMiMiM -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: Servers supported on virtual machines--anything new?
We run TSM 5.4 on a Linux VM under VMware. It's just for our test lab so we don't have any stressful throughout stats to report, but it works fine. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Mar 3, 2009, at Mar 3, 11:23 AM, Nancy R. Brizuela wrote: Yes, been there, done that. My boss is looking to consolidate all our servers on one or two platforms, i.e. all Sun and VMware virtual servers, for a less expensive disaster recovery plan. We currently run our TSM server on a pSeries LPAR. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Roger Deschner Sent: Monday, March 02, 2009 11:23 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Servers supported on virtual machines--anything new? . One reason you won't find much about this, is that TSM makes it very easy to run more than one TSM server instance on a single OS image. This will be inherently more efficient than virtualization via VMware, Sun LDOM, IBM z/VM, or IBM pSeries LPAR. Instructions are in the TSM Installation Guide and Administrators Guide. Roger Deschner University of Illinois at Chicago rog...@uic.edu We all live in a Virtual Machine, a Virtual Machine, a Virtual Machine --Sung to the tune of the Beatles Yellow Submarine, from the SHARE songbook. On Mon, 2 Mar 2009, Nancy R. Brizuela wrote: Hi All, I found this document describing the virtual machines supported for TSM servers, below. Is there anything newer on this? I don't see anything about TSM servers and supported virtual machines in the V6 announcement. For instance, is running a TSM server on a Sun Solaris LDOM supported? Or running a TSM server as a VMware guest? Anyone doing anything like this? http://www-01.ibm.com/support/docview.wss?rs=0uid=swg21239546 Thanks! Nancy Brizuela
Re: Experiences with tsmreports.com
Servergraph forecasts when you'll run out of space in your storage pools, database, and tape library. This is a step beyond trending, and I don't think the other reporting tools do that. Fwiw. Lindsay Morris Principal TSMworks, Inc. 1-919-403-8260 www.tsmworks.com On Mar 3, 2009, at 3:33 PM, Howard Coles howard.co...@ardenthealth.com wrote: Me too. I have customized it for a few things as well. (like a 30 and 90 day health check trend chart, and as I've mentioned before DRM tape handling). See Ya' Howard -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Bell, Charles (Chip) Sent: Tuesday, March 03, 2009 2:29 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Experiences with tsmreports.com I use Servergraph for trending. Works for me. :) -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Rafa Sent: Tuesday, March 03, 2009 2:26 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Experiences with tsmreports.com Hello Thanks for the sugestion. I'm currently using its 30 day trial. I like it so far, but I wanted to know if anybody has had any experience with any alternative to it. TSM's own operational report falls rather short of what I need for trending purposes. Managing is not much of an issue. ISC might be bloated but it's quite user friendly. Regards On Tue, Mar 3, 2009 at 10:59 AM, Stephan26 tsm- fo...@backupcentral.com wrote: Rafa wrote: Does anybody uses the services of http://www.tsmreports.com/ ? I'm looking for a way to improve the taking of metrics from my TSM environment but I'm wary of sending my data to a third party. Thanks Have you taken a look at TSMManager? I've been using it now for ~2 years. You can manage, report and monitor through this app. www.tsmmanager.us Steph +-- -- -- |This was sent by d...@rona.ca via Backup Central. |Forward SPAM to ab...@backupcentral.com. +-- -- --
THANKS! All you lurkers on ADSM-L - RESULTS (was: Tracking who owns a node)
Many thanks; about 60 responses, statistically significant I guess: Short answer: most everybody uses the contact field in some way. Someone suggested using TSM 6.1's extensible database schema. Sure, but ouch: I envision each of us extending the schema in a different way. There might be some benefit in being public about our plans to extend the schema; then people with similar ideas could cooperate and give their extensions to the rest of us. Sort of an Open Schema Development model ;-} Details: Count How do you track who owns a node? 12 0. We don't. 12 1. We put an email address in the node's CONTACT field. 17 2. We put structured info (like j...@foo.org; Joe Jones; HR; 212-223-) in the CONTACT field 8 3. We put un-structured stuff in the CONTACT field, like name, phone number, email, or whatever we have 0 4. We put the email address in the node's EMAIL_ADDRESS field 5 5. We use home-grown spreadsheets or databases or shell scripts 4 6. We use 3rd-party apps like Servergraph, or Bocada, etc. 6 7. None of the above -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Feb 23, 2009, at Feb 23, 8:50 AM, Lindsay Morris wrote: A little help please? I want more responses to my poll, about how you track who owns a node. THIS MEANS YOU! It'll take you JUST THREE CLICKS, starting here: http://www.surveymonkey.com/s.aspx?sm=ojC0QfiSbYEcc2B246nO_2bA_3d_3d Why should you do this? Guilt: After all the great advice you've gotten off this list, isn't it time to help a little? Logic: Many people write software to make TSM better. Help them to help you! Greed: I'll buy beer at the next TSM symposium for anyone who responds. Come on, share the knowledge please. http://www.surveymonkey.com/s.aspx?sm=ojC0QfiSbYEcc2B246nO_2bA_3d_3d And thanks! -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com _ From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Thursday, February 19, 2009 10:09 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Tracking who owns a node For every node we back up, there is someone who uses it. This person knows that: * They want it backed up ONLY between 2AM and 4AM; * They can't afford TDP so please back up the flat-file database dump and ignore the true DB directories; * They prefer to exclude drive C: * For recovery, the application depends on 3 other nodes too and so on. It helps us do a better job, if we know who these people are. So, how do you map people to nodes? I'm trying to see what's common, so our bolt-on software can discover this mapping if it's there, or help you set it up if it's not. Reply to me off-list and I'll report back the results to the community here. Just pick a number below (I'm trying to make this so easy ;-} ), and/ or discuss in detail. Phone calls welcome too. How do you know who owns a node? __ Thanks!
Re: How do you keep track of DB Backup
we sell (shameless plug) Good luck with your product; Dan Kim would love to have your banner ad on adsm.org. You're no longer allowed to complain about getting emails from my sales guy. ;-} -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Feb 26, 2009, at Feb 26, 2:08 PM, Remco Post wrote: On Feb 26, 2009, at 19:51 , Christian Svensson wrote: Hi, I got a generic question for you all. How do you keep in track of your Database Backup Tape Volumes? I know you can see in Volhist the label of the volume, but how do you keep in track to get it back from the vault? Do you have a script or do you call it back one day in advance? we sell (shameless plug) TSM MediaManager, because we identified this problem. Basically, MediaManager wraps all TSM interaction in a GUI, maintains the vault inventory and does everything needed to allow the courier, just any operator, your secretary or anyone else you trust with your data to check the tapes in and out Please, I'm really interested of your feedback and how you deal with it? If you're interested, you know how to find us, I'm non-grate on the list after this shameless plug, so we'll have this off list if you want more details ;-) Best Regards Christian Svensson Cell: +46-70-325 1577 E-mail: christian.svens...@cristie.se Skype: cristie.christian.svensson -- Met vriendelijke groeten, Remco Post r.p...@plcs.nl +31 6 248 21 622
HEY! All you lurkers on ADSM-L! (was: Tracking who owns a node)
A little help please? I want more responses to my poll, about how you track who owns a node. THIS MEANS YOU! It'll take you JUST THREE CLICKS, starting here: http://www.surveymonkey.com/s.aspx?sm=ojC0QfiSbYEcc2B246nO_2bA_3d_3d Why should you do this? Guilt: After all the great advice you've gotten off this list, isn't it time to help a little? Logic: Many people write software to make TSM better. Help them to help you! Greed: I'll buy beer at the next TSM symposium for anyone who responds. Come on, share the knowledge please. http://www.surveymonkey.com/s.aspx?sm=ojC0QfiSbYEcc2B246nO_2bA_3d_3d And thanks! -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com _ From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Thursday, February 19, 2009 10:09 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Tracking who owns a node For every node we back up, there is someone who uses it. This person knows that: * They want it backed up ONLY between 2AM and 4AM; * They can't afford TDP so please back up the flat-file database dump and ignore the true DB directories; * They prefer to exclude drive C: * For recovery, the application depends on 3 other nodes too and so on. It helps us do a better job, if we know who these people are. So, how do you map people to nodes? I'm trying to see what's common, so our bolt-on software can discover this mapping if it's there, or help you set it up if it's not. Reply to me off-list and I'll report back the results to the community here. Just pick a number below (I'm trying to make this so easy ;-} ), and/ or discuss in detail. Phone calls welcome too. How do you know who owns a node? 0. We don't. 1. We put an email address in the node's CONTACT field. 2. We put structured info (like j...@foo.org; Joe Jones; HR; 212-223-) in the CONTACT field 3. We put un-structured stuff in the CONTACT field, like name, phone number, email, or whatever we have 4. We put the email address in the node's EMAIL_ADDRESS field 5. We use home-grown spreadsheets or databases or shell scripts 6. We use 3rd-party apps like Servergraph, or Bocada, etc. 7. None of the above __ Thanks!
Re: AIX to RHEL command
Every unix user should know about the Rosetta Stone! http://bhami.com/rosetta.html On Feb 20, 2009, at Feb 20, 8:12 AM, Keith Arbogast wrote: Larry, This Website is a UNIX command translation table. http:// www.opennet.ru/soft/linux2unix.html . It cross references commands' syntax for AIX, FreeBSD, HP-UX, Linux (RedHat), Solaris and Tru64. It also says DMESG is the equivalent Linux command for errpt. One can run dmesg from the command line. Just pipe it through 'less' or 'grep' as appropriate, e.g. #dmesg | less . Best wishes, Keith Arbogast
Tracking who owns a node
For every node we back up, there is someone who uses it. This person knows that: * They want it backed up ONLY between 2AM and 4AM; * They can't afford TDP so please back up the flat-file database dump and ignore the true DB directories; * They prefer to exclude drive C: * For recovery, the application depends on 3 other nodes too and so on. It helps us do a better job, if we know who these people are. So, how do you map people to nodes? I'm trying to see what's common, so our bolt-on software can discover this mapping if it's there, or help you set it up if it's not. Reply to me off-list and I'll report back the results to the community here. Just pick a number below (I'm trying to make this so easy ;-} ), and/ or discuss in detail. Phone calls welcome too. How do you know who owns a node? 0. We don't. 1. We put an email address in the node's CONTACT field. 2. We put structured info (like j...@foo.org; Joe Jones; HR; 212-223-) in the CONTACT field 3. We put un-structured stuff in the CONTACT field, like name, phone number, email, or whatever we have 4. We put the email address in the node's EMAIL_ADDRESS field 5. We use home-grown spreadsheets or databases or shell scripts 6. We use 3rd-party apps like Servergraph, or Bocada, etc. 7. None of the above __ Thanks! -- Mr. Lindsay Morris Principal http://www.tsmworks.com 919-403-8260 lind...@tsmworks.com
Re: arbitrary schedule start
I have often seen the same problem. Once, I turned on some tracing and found that dsmserv checks every 30 seconds for events it should be starting, but it still didn't start the event until 10 minutes later. Using schedmode prompted, not polling; dsmc has recently stopped and started; it's an annoying mystery to me. I bet Mr. Raibeck might have an answer. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jan 9, 2009, at Jan 9, 2:17 PM, Keith Arbogast wrote: Richard, Thank you for the suggestions. We corrected the Managedservices option, and reran the backup attempt by updating starttime to 'now'. Still no activity. Here is the client's dsm.sys file after the correction. Keith cat dsmwebcl.log 01/09/2009 09:36:49 (dsmcad) IBM Tivoli Storage Manager 01/09/2009 09:36:49 (dsmcad) Client Acceptor - Built Nov 28 2008 14:16:06 01/09/2009 09:36:49 (dsmcad) Version 5, Release 5, Level 1.10 01/09/2009 09:36:49 (dsmcad) ANS3000I TCP/IP communications available on port 60857. 01/09/2009 09:36:49 (dsmcad) Dsmcad is working in Webclient mode. 01/09/2009 09:36:49 (dsmcad) ANS3000I HTTP communications available on port 1581. SErvername tsmin01 Nodename ipasgw ERRORLOGName /opt/adsm/dsmerror.log errorlogretention 5 D domain ALL-LOCAL Inclexcl /etc/adsm.inclexcl SCHEDLOGName /opt/adsm/dsmsched.log schedlogretention 3 D COMMmethod TCPip Passwordaccess generate Passworddir/etc/security/adsm TCPPort1500 TCPServeraddress tsmin01.uits.iupui.edu schedmod prompted managedservicesschedule encryptiontype aes128 encryptkey save
Re: arbitrary schedule start
Hmmm. Bet you haven't seen the end of this yet. I mean, I could always get the schedule to start up immediately if I bypassed dsmcad and ran dsmc sched on the client. -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jan 9, 2009, at Jan 9, 2:53 PM, Keith Arbogast wrote: Richard, I hadn't restarted dsmcad. Once I did, and reset the starttime to 'now', the schedule started immediately. With thanks and all my very best wishes, Keith Arbogast
Re: I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them
Servergraph shows you the occupancy by node, for on-site and offsite pools. If you measure these two things right after a backup stgpool completes, they ought to match. (if you let a backup run, then they won't, of course.) You don't need Servergraph to do this, just a query occupancy with some grouping. So does this give you what you want, which I'm guessing is a verification that each node is indeed completely backed up off-site? -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jan 9, 2009, at Jan 9, 3:45 PM, Kauffman, Tom wrote: Specifically, I'd like to get the byte-count backed up to my off- site copygroups by node name withing storage pool. The file count would be nice, but I'll setlle for the byte count. I'd also like to be able to get the start/end times and total data transfer by process. Is any of this readily available? (I'm currently getting the start/end time and total by process with a series of 'query actlog' and manual processes; I'm not pleased that the storage pool name isn't in the 0986 message with the counts). TIA Tom Kauffman CONFIDENTIALITY NOTICE: This email and any attachments are for the exclusive and confidential use of the intended recipient. If you are not the intended recipient, please do not read, distribute or take action in reliance upon this message. If you have received this in error, please notify us immediately by return email and promptly delete this message and its attachments from your computer system. We do not waive attorney-client or work product privilege by the transmission of this message.
Re: I'm missing something somewhere -- I need statistics on storage pool backup and can't seem to find them
Bingo, Wanda! -- Mr. Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Jan 9, 2009, at Jan 9, 4:01 PM, Wanda Prather wrote: On Fri, Jan 9, 2009 at 3:45 PM, Kauffman, Tom kauffm...@nibco.com wrote: Specifically, I'd like to get the byte-count backed up to my off-site copygroups by node name withing storage pool. The file count would be nice, but I'll setlle for the byte count. tsm: TSMSERVER1select stgpool_name,node_name, cast(sum(logical_mb/ 1024) as decimal(10,1)) as GB , sum(num_files) as #Objects from occupancy where stgpool_name in (select stgpool_name from stgpools where pooltype='COPY') group by stgpool_name, node_name order by 1,2 I'd also like to be able to get the start/end times and total data transfer by process. You can get that pretty easily from the SUMMARY table. You'll have to play with it though, to pick out specifically which stgpool process you want. Start here with: select * from summary where activity='STGPOOL BACKUP' Wanda
Re: 5.4 -- 6.0 (server)
They told us the same, but that if you had 5.4, the upgrade process would magically take it to 5.5 and thence to 6.1 under the covers. On Fri, Dec 19, 2008 at 12:17 PM, Richard Rhodes rrho...@firstenergycorp.com wrote: Recently (3 weeks ago) we had a meeting with IBM folks about TSM issues. In talking about the coming v6.1 they said that TSM v5.5 would be rquired for the upgrade to v6.1. Take it with a large grain of salt, but that's what they said. Rick Remco Post r.p...@plcs.nl Sent by: ADSM:To Dist Stor ADSM-L@VM.MARIST.EDU Manager cc ads...@vm.marist .EDU Subject Re: 5.4 -- 6.0 (server) 12/19/2008 11:35 AM Please respond to ADSM: Dist Stor Manager ads...@vm.marist .EDU Hi Goc?, well, 6.0 will never exist, IBM starts counting at 1, so it'll be 6.1 :) Ss for the path, currently the beta-manual says that 5.3, 5.4 and 5.5 will be supported as a starting-point for an upgrade to 6.1, but IBM might change their mind. There is a note that the upgrade tools have the same system requirements as 5.5, so if your os is unsupported for 5.5, so will the upgrade tool be (anything I say is subject to change until the product has been released, I'm not an IBM employee, so I don't speak on their behalf). On 19 dec 2008, at 17:09, goc wrote: will it be possible ? -- Fred Allen - I like long walks, especially when they are taken by people who annoy me. -- Remco Post r.p...@plcs.nl +31 6 24821 622 - The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. -- Lindsay Morris Principal TSMworks Tel. 1-859-539-9900 lind...@tsmworks.com
Re: The Intergrated Solutions Console BAD performance.
The 6.1 version is supposed to be much improved, both in performance and in usability. Guess that doesn't help you today... all I got though. -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 16, 2008, at Dec 16, 9:29 AM, Minns, Farren - Chichester wrote: Hi all (running TSM 5.4.1.2 on Solaris) ... Solutions Console 6.0.1 Whilst I try to use the ISC as little as often there are times when it would be handy, especially when I'm out of the office and someone is covering me. At present I have it running on a Solaris box with lots of free memory and the performance of it is so bad as to be almost a joke. Do other people have similar issues? If so, does anyone have any tips with regards to making it run acceptable? Any help would be much appreciated. Many thanks Farren Minns This email (and any attachment) is confidential, may be legally privileged and is intended solely for the use of the individual or entity to whom it is addressed. If you are not the intended recipient please do not disclose, copy or take any action in reliance on it. If you have received this message in error please tell us by reply and delete all copies on your system. Although this email has been scanned for viruses you should rely on your own virus check as the sender accepts no liability for any damage arising out of any bug or virus infection. Please note that email traffic data may be monitored and that emails may be viewed for security reasons. John Wiley Sons Limited is a private limited company registered in England with registered number 641132. Registered office address: The Atrium, Southern Gate, Chichester, West Sussex, PO19 8SQ.
Re: Restore Testing stories
Wow, good point, Andy: gotta have the same Service Pack level before trying a bare metal restore. But our whitepaper doesn't address that, because we don't (yet) help with full, bare-metal DR tests. We help with the 99% of systems you DON'T have time to do a DR test on, by random-sampling the backed-up files and restoring one or two of them. Glad you found it intriguing. I don't think anybody has ever tried to do this before. So I continue to ask for horror stories about restores that failed, and why. (Keep the customer anonymous, please - some stories could be embarassing!) Come on, folks: got more? -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 12, 2008, at Dec 12, 5:53 PM, Huebner,Andy,FORT WORTH,IT wrote: The product looks intriguing. The paper did not address my biggest problem, restoring the Windows OS. Our issue is verifying the SP level of the server prior to restore. We have had very little success restoring the OS if the target OS is a different SP level than the backup. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of lmorris99 Sent: Friday, December 12, 2008 3:17 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restore Testing stories Would you be so kind as to share your stories about why restores fail, when they do? We are working on a way to prevent such failures. (Our whitepaper is at http://www.tsmworks.com/downloads/art-whitepaper.pdf , if you're curious.) Your real-world anecdotes are helpful! Stories like: * we found that the node had not been backed up in 3 months * the user's exclude list had excluded the file he needed * the tape volume TSM needed was missing / damaged / etc. are what we're looking for. Got some? Respond here, mail me, call me - all good. Thanks! --- Lindsay Morris Principal TSMworks, Inc. lind...@tsmworks.com 919-403-8260 + -- |This was sent by lindsay.mor...@tsmworks.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. + -- This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you.
Re: Restore Testing stories
So, Bob, are you saying that your back-level TSM client failed to restore your Active Directory? Even though it backed it up OK? And was this a known problem with the TSM client? -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 15, 2008, at Dec 15, 10:49 AM, Bob Levad wrote: Our biggest restore failure was for a small windows domain controller. It was not replicated and we were slightly backleveled on the client. When the vmware disk became corrupted, we had to rebuild the client list as we were not able to correctly restore the active directory. The moral is to keep your TSM clients up to date and read the release notes on what the product will NOT do. Another good practice is to back things up in more than one way. Then, when your primary restore method fails, you will have another option. Don't forget to test! Bob. -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Lindsay Morris Sent: Monday, December 15, 2008 8:57 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Restore Testing stories Wow, good point, Andy: gotta have the same Service Pack level before trying a bare metal restore. But our whitepaper doesn't address that, because we don't (yet) help with full, bare-metal DR tests. We help with the 99% of systems you DON'T have time to do a DR test on, by random-sampling the backed-up files and restoring one or two of them. Glad you found it intriguing. I don't think anybody has ever tried to do this before. So I continue to ask for horror stories about restores that failed, and why. (Keep the customer anonymous, please - some stories could be embarassing!) Come on, folks: got more? -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 lind...@tsmworks.com On Dec 12, 2008, at Dec 12, 5:53 PM, Huebner,Andy,FORT WORTH,IT wrote: The product looks intriguing. The paper did not address my biggest problem, restoring the Windows OS. Our issue is verifying the SP level of the server prior to restore. We have had very little success restoring the OS if the target OS is a different SP level than the backup. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of lmorris99 Sent: Friday, December 12, 2008 3:17 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Restore Testing stories Would you be so kind as to share your stories about why restores fail, when they do? We are working on a way to prevent such failures. (Our whitepaper is at http://www.tsmworks.com/downloads/art-whitepaper.pdf , if you're curious.) Your real-world anecdotes are helpful! Stories like: * we found that the node had not been backed up in 3 months * the user's exclude list had excluded the file he needed * the tape volume TSM needed was missing / damaged / etc. are what we're looking for. Got some? Respond here, mail me, call me - all good. Thanks! --- Lindsay Morris Principal TSMworks, Inc. lind...@tsmworks.com 919-403-8260 + -- |This was sent by lindsay.mor...@tsmworks.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. + -- This e-mail (including any attachments) is confidential and may be legally privileged. If you are not an intended recipient or an authorized representative of an intended recipient, you are prohibited from using, copying or distributing the information in this e-mail or its attachments. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete all copies of this message and any attachments. Thank you. This electronic transmission and any documents accompanying this electronic transmission contain confidential information belonging to the sender. This information may be legally privileged. The information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on or regarding the contents of this electronically transmitted information is strictly prohibited.
Re: Anybody test Servergraph ..
I just saw a demo of that. It keeps getting better, but still doesn't compare to Servergraph. It doesn't predict when things are going to fill up, for example. It doesn't have a server-by-server comparison table (eg, which of your 10 TSM servers is closest to filling up its database, which one moves the most data, etc - good for load balancing). etc. My 2 cents. -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 [EMAIL PROTECTED] On Dec 5, 2008, at Dec 5, 10:23 AM, km wrote: I would recommend waiting for TSM 6.1 and evalutating the new included reporting tool. On 05/12, hshahizul wrote: Hi, Anybody has ever test Servergraph. I wish to test this Servergraph but than. so terrible in getting the trail version. I wish to test this product before recommend to customer. By the way, I am freelancer doing TSM Installation TSM Support to several customer. They want to know who is your customer, do they have money to pay .and yet never tell you how much is their product. Is this product really good ? Tq
Re: Offsite reclamation problem
Lots of people have a best-practice of always keeping at least one drive free for user restores. That minimizes the problem. It makes users happy too, because even though a restore does pre-empt another task, it may take TSM 40 minutes to finish the reclamation it was working on and give up the drive. So the user has to sit waiting for far too long (in some cases). -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 [EMAIL PROTECTED] On Nov 4, 2008, at Nov 4, 12:21 PM, Bos, Karel wrote: No :) -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thomas Denier Sent: dinsdag 4 november 2008 18:14 To: ADSM-L@VM.MARIST.EDU Subject: Offsite reclamation problem We have a 5.4.2.0 TSM server running under mainframe Linux. We have five tape drives available for our primary tape storage pool and five tape drives available for our copy storage pool. We run offsite tape reclaimation with 'maxproc=5'. If a client runs a restore while off reclamation is going on, TSM will take a tape drive away from reclamation. This is done by cancelling a reclamation process, rather than having a process go into mount point wait. TSM does not start a replacement process when this happens. A restore that runs for a couple of minutes can leave a pair of tape drives sitting idle for hours. Is there any configuration setting or release level upgrade that will cause TSM to handle this situation more intelligently? disclaimer.txt
Re: Why does this Exclude not work?
If you can get to the client to create a file, can't you just run dsmc query inclexcl ? Oh, I see - Richard's trick lets you see what the CURRENTLY RUNNING client used, when it woke up a month ago or whenever. But you could just restart dsmc and try again. -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 [EMAIL PROTECTED] On Oct 31, 2008, at Oct 31, 2:08 PM, Richard Sims wrote: Zoltan - As you indicate, the reality seems to contradict the include-exclude options shown by a current query. Whereas you are running the TSM scheduler directly, rather than via CAD, you have a persistent dsmc scheduler process performing your backups, using option values which it grabbed when it initated. It would be desirable to see what those actual settings are, to fully verify the situation. That's somewhat challenging, but can be accomplished via the following procedure: - Create an ASCII file on the client, giving it a name such as /tmp/ tsmcmd, containing: Query SYSTEMInfo -FILEName=/tmp/TSM.systeminfo - On the TSM server, invoke the command: define clientaction YourNodename action=macro objects=/tmp/ tsmcmd After the client action completes, the resulting /tmp/TSM.systeminfo file will contain an INCLEXCL section which will show what the prevailing dsmc process is using for includes and excludes. Richard Sims
Re: Restore testing for Tivoli Storage Manager
Remco, it's me. Lindsay Morris. We've met, in Amsterdam a few years ago. Mike's working for me. Sorry I didn't email you personally. I think it's OK if we contact people I've met and worked with to tell them I have a new product. But we'll take you off the list. Sorry to have ruffled you. -- Lindsay Morris Principal www.tsmworks.com 919-403-8260 [EMAIL PROTECTED] On Oct 30, 2008, at Oct 30, 4:21 PM, Remco Post wrote: Hi Mike, to be frankly, I don't appreciate being contacted directly with unsolicited commercial e-mail. I do appreciate that you're not spamming the adsm-l. If I ever feel the need for software solutions like yours, I'll try to find alternatives before looking into your software. Kind regards, On Oct 30, 2008, at 21:14 , Mike Dunn wrote: Hi Remco, snap Would you like to learn more about the ART Software? Please advise, Regards, Mike Mike Dunn Director of Sales TSMworks, Inc. [EMAIL PROTECTED] (512)689-3051 W (512)832-6007 F “Restores – Trust? Or Verify?” art-brochure.pdf -- Met vriendelijke groeten, Remco Post [EMAIL PROTECTED] +31 6 248 21 622
Re: SNMP on Windows2003
Well, you *can* use Servergraph to send SNMP traps to TEC or OpenView, etc. It's nice because your TEC people don't have to figure out which of the 3,000 error messages they need to handle - Servergraph only sends 220 or so different messages, with suggestions as to how to handle each one. Hope this helps. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6137 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Brian Ipsen Sent: Tuesday, July 06, 2004 2:22 AM To: [EMAIL PROTECTED] Subject: Re: SNMP on Windows2003 Hi, Forget SNMP support on a Windows based TSM server. Some time ago, when a major security-flaw was discovered in almost all SNMP implementations, it seemed like IBM decided not to update the required component for Windows - together with a statement, that SNMP v1 is insecure. I don't know why they haven't implemented SNMP v3 or similar, but I've had quite a support-struggle with my supplier, because the manual and also the course material (for 5.1) says SNMP is supported - they just forget to write, that it isn't possible on a windows based server. Regards, Brian -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Bill Boyer Sent: 6. juli 2004 01:09 To: [EMAIL PROTECTED] Subject: SNMP on Windows2003 Anyone out there (succesfully) set up a TSM 5.2.2.5 server on Windows2003 with SNMP to talk to an HP OpenView server?? The documentation it somewhat vague on how to accomplish this. Bill Boyer An Optimist is just a pessimist with no job experience. - Scott Adams --- This mail was scanned for virus and spam by Progressive IT A/S. --- --- This mail was scanned for virus and spam by Progressive IT A/S. ---
Re: TSM DB growing, but number of files remains the same ...
I heartily agree with Richard's note about using the ACCOUNTING (not the activity) log. We tried several things with Servergraph, and found that: -- activity log messages are sometimes erroneous -- summary table data is sometimes unreliable -- frequent queries against these tables can impact the TSM server's performance. Servergraph uses the accounting log extensively for these reasons. Rock solid data there, because it's written by the TSM server, not by the client software. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6137 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Ted Byrne Sent: Tuesday, May 04, 2004 9:16 AM To: [EMAIL PROTECTED] Subject: Re: TSM DB growing, but number of files remains the same ... Arnaud, I believe what I have to do now is to build some solid queries to explore our activity log... Unless I'm mistaken, I believe that you may have misread Richard's advice. (Correct me if I'm wrong, Richard.) His recommendation: I stress accounting log reporting because it is the very best, detailed handle on what your clients are throwing at the server Accounting log records are comma-delimited records written to a flat file called dsmaccnt.log, assuming that you have accounting turned on. If you don't, I would recommend that you turn it on now... The accounting log records give a very detailed, session-by-session picture of the activity between the server and clients. It will be easier to parse and process than what you can get out of the activity log. Ted
Re: Querying only errors?
We (Servergraph) have a completely different trick: we filter out the NORMAL messages, and display everything ELSE as a possible error (and we boil them down so the volume is not overwhelming). This is a lot smarter (IMHO), because, for example, when a TSM admin fat-fingers a command, THAT gets an ANRxxxE message - an error - but it's NOT really an error that matters. OTOH, when a tape drive dies, THAT's and ANRW message - just a warning, but most of us would prefer to treat it as an error. So you might try developing something like that. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Karel Bos Sent: Wednesday, March 17, 2004 9:22 AM To: [EMAIL PROTECTED] Subject: Re: Querying only errors? q act s=anre for errors and w for warnings. Regards, Karel -Oorspronkelijk bericht- Van: Mike Bantz [mailto:[EMAIL PROTECTED] Verzonden: woensdag 17 maart 2004 15:20 Aan: [EMAIL PROTECTED] Onderwerp: Querying only errors? Does anyone know how I'd filter out the activity log to only give me errors? I have a drive that keeps taking itself offline in the middle of the night (when I really don't want to be here) but I can't seem to dig out that time from the activity log. All I know is I'm coming in, taking a gander at the 3583 and seeing a Drive or Media Error message on the display, hoping that TSM is reflecting this as well. TIA, Mike Bantz Systems Administrator Research Systems, Inc
Re: Anyone using Servergraph?
(Trying not to slide into touting products here ...) Smaller customers seem to like tsmmanager, perhaps because it's cheaper; windows-only customers also liked it because Servergraph/Windows wasn't available until recently. Larger sites with tougher problems and more demanding requirements have looked at both, and universally like Servergraph better. Our sales group can offer point-by-point comparisons (offline please). Also, Bill Mansfield hosted a birds-of-a-feather session on TSM reporting products at Oxford last year - he may have a write-up on that posted somewhere. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Karel Bos Sent: Monday, February 23, 2004 2:51 AM To: [EMAIL PROTECTED] Subject: Re: Anyone using Servergraph? Just compaire Servergraph with TSMmanager (www.tsmmanager.com) before buying Servergraph. We did and went for TSMmanager. Regard, Karel -Oorspronkelijk bericht- Van: Nancy Reeves [mailto:[EMAIL PROTECTED] Verzonden: donderdag 19 februari 2004 18:05 Aan: [EMAIL PROTECTED] Onderwerp: Anyone using Servergraph? I have Servergraph/TSM on a trial right now and would like first hand opinions from other sites using it. Please reply privately. Nancy Reeves Technical Support, Wichita State University [EMAIL PROTECTED] 316-978-3860
Re: Anyone using Servergraph?
Our customers generally give us VERY high marks for support! But our customer base has been growing very fast. We recently installed an automated help-desk application, But is didn't work well at first; it's fixed now. If we knew who rh was, we'd be glad to resolve any problems. Our Windows build has been available for a few months now; perhaps it was not ready when he/she called. Growing pains ... but we always appreciate customer feedback. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 --- rh [EMAIL PROTECTED] wrote: I found Servergraph to be unresponsive to my questions when I was investigating their products. I've asked multiple times about information on their lite and their Windows offerings without any response. --- Pearson, Dave DCPearson AT SNOPUD DOT COM wrote: We use it too.. Very helpful product and very supportive support too... ~David Pearson~ -Original Message- From: Crespo, Pedro A. [mailto:Pedro.Crespo AT INTEGRIS-HEALTH DOT COM] Sent: Thursday, February 19, 2004 9:17 AM To: ADSM-L AT VM.MARIST DOT EDU Subject: Re: Anyone using Servergraph? Great product and awesome support - as you can tell, we have had a very positive experience with both. Pedro A. Crespo Technology Architect Integris Health - IT N. Grand, Ste. 100 Oklahoma City, OK 73112 Pedro.Crespo AT Integris-Health DOT com 405-951-9800 -fax 405-949-6996 -voice -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of Nancy Reeves Sent: Thursday, February 19, 2004 11:05 AM To: ADSM-L AT VM.MARIST DOT EDU Subject: Anyone using Servergraph? I have Servergraph/TSM on a trial right now and would like first hand opinions from other sites using it. Please reply privately. Nancy Reeves Technical Support, Wichita State University Nancy.Reeves AT wichita DOT edu 316-978-3860
Re: Upgraded to TSM 5.2.1.2
Amen to that! - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Robin Sharpe Sent: Wednesday, December 10, 2003 11:14 AM To: [EMAIL PROTECTED] Subject: Re: Upgraded to TSM 5.2.1.2 This is a problem that keeps getting fixed and then coming back in almost every release! IMHO, the real problem is the way the STATUS field is formatted in the PROCESSES table. It's formatted to be readable by humans. It's very difficult to parse in scripts because it contains new lines to make it look nice on screen. Some of the information in STATUS is not available anywhere else (Like current input and output volume, waiting for mount of whatever volume, etc.), and some is redundant (files processed and bytes processed)... however I have found that the files and bytes in the STATUS field gets updated before (maybe more frequently than) the FILES_PROCESSED and BYTES_PROCESSED fields. I wish all of the info in the STATUS field could be placed in individual fields in the PROCESSES table, and fix this problem once and for all. It would save us script writers lots of rework time for each new release! Robin Sharpe Berlex Labs |-+--- | | Ben Bullock | | | [EMAIL PROTECTED]| | | .COM | | | Sent by: ADSM: | | | Dist Stor | | | Manager| | | [EMAIL PROTECTED]| | | T.EDU | | | | | | | | | 12/10/03 10:10 | | | AM | | | Please respond | | | to ADSM: Dist | | | Stor Manager | | | | |-+--- - | | | | | |To: [EMAIL PROTECTED] | |cc: | |Subject: | |Re: Upgraded to TSM 5.2.1.2 | - | Yes, we upgraded to 5.2.1.3 on AIX and have the odd formatting in the q proc output. No fix that I know of, luckily it is just cosmetic as far as I can tell. Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Kamp, Bruce Sent: Wednesday, December 10, 2003 5:58 AM To: [EMAIL PROTECTED] Subject: Upgraded to TSM 5.2.1.2 I just upgraded to TSM 5.2.1.2 from 5.1.1.6 on AIX 5.1ML5 64bit. One thing I noticed is that when I do a Q PR it is not formated correctly on the screen. Has anybody else seen this is there a fix for it? Also is there anything else I need to watch out for? Thanks, - Bruce Kamp Midrange Systems Analyst II Memorial Healthcare System E-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Phone: (954) 987-2020 x4597 Pager: (954) 286-9441 Alphapage: [EMAIL PROTECTED] Fax: (954) 985-1404 -
Re: last backup info
We have found that many TDP agents, especially older ones, don't bother loading last-backup-date info into the TSM database when they complete. I think I've also seen this with some Mac clients. But almost all the filesystem clients DO load these fields correctly. Another reason they're empty is because the schedule included something in the objects field. If you do an incremental backup, but limit it using the object= feature on the schedule, dsmc does not load these fields, presumably because it can't be sure that things were fully backed up. We have workarounds within Servergraph to get accurate backup status reporting - contact me offline if that's your concern. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Gill, Geoffrey L. Sent: Monday, December 01, 2003 10:55 AM To: [EMAIL PROTECTED] Subject: last backup info Can anyone explain why the last backup start date/time, last backup completion date/time, and deletion occurred in filespace date/time would have no information in them for filespaces reported on some nodes? The capacity and percent util register data. Yesterday we had a SAN controller firmware upgrade and it seems one of the nodes on the SAN lost the data and a recovery is necessary. I'm not the one restoring the data nor do I have access to the node. I'm just looking from the TSM server side to see what is hopefully in TSM. I don't want to say I have a bad feeling something hasn't been backed up but I do want to have an educated answer if in fact there is no data. I understand the inclexcl list tells TSM what to back up, and I have no control of it. I have not asked to see this one yet but have a feeling I might need to. This particular node reports it is at 5.1.5.0, it is on Tru64 platform. The server is on AIX 4.3.3, TSM 5.1.6.3. I see this same phenomenon for other filespaces on other nodes, although it has never struck me to ask why it is blank. Thanks for the help, Node Name CP-ITS-DWPROD Filespace Name /san2 FSID 49 Filespace Type ADVFS Capacity (MB) 416687.2 Pct Util 1.3 Last Backup Start Date/Time - Last Backup Completion Date/Time - Deletion occurred in Filespace Date/Time - Is Filespace Unicode? NO Hexadecimal Filespace Name - Geoff Gill TSM Administrator NT Systems Support Engineer SAIC E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (877) 905-7154
Re: [tsm] Summarizing use by unix group?
Our chargeback logic goes down to the filespace level; most customers we've spoken to want to have chargeback by application, rather than by unix group. They can say application X is made up of filespaces A,B, and C, so that's how we've been working it. Would this work for you? Also be aware that TSRM, and most SRM products, show you only what's on the client's local disk; they don't show you what's in TSM storage. Also, the idea of using unix groups for chargeback would break when you're backing up windows boxes, right? Appreciate your thoughts, Patrick (and everyone). - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Patrick Audley Sent: Sunday, November 09, 2003 2:49 PM To: [EMAIL PROTECTED] Subject: Re: [tsm] Summarizing use by unix group? Lindsay Are you looking at doing chargeback by unix groups? Yes, that's the primary reason. We can certainly do it via owner but it's not as convenient. We have TSRM installed but it seems not to be able to see our GPFS partitions though I haven't played that much with it yet. -- Patrick Audley [EMAIL PROTECTED] High Performance Computing Manager Computational Biology Bioinformatics http://www.compbio.dundee.ac.uk University of Dundeehttp://blackcat.ca Dundee, Scotland+44 1382 348721
Re: Summarizing use by unix group?
I think not, at least not without expensive queries against the contents table. Still, if this is only a monthly snapshot, that might be doable. Are you looking at doing chargeback by unix groups? - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Patrick Audley Sent: Sunday, November 09, 2003 11:41 AM To: [EMAIL PROTECTED] Subject: Summarizing use by unix group? Does anyone know a query to do this? I can do it by owner but it's really the groups that I'm interested in. I'd like to be able to get a list of MB in storage pools used broken down by storage pool and group. Is this possible? Thanks, Patrick. -- Patrick Audley [EMAIL PROTECTED] High Performance Computing Manager Computational Biology Bioinformatics http://www.compbio.dundee.ac.uk University of Dundeehttp://blackcat.ca Dundee, Scotland+44 1382 348721
[no subject]
Winchester IO is really any block-device IO: disk or tape. So it's not abnormal to see that; but it does look pretty high. Are you getting the performance you expect? Does vmstat say you're paging at these times? - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Juan Manuel Lopez Azanon Sent: Friday, November 07, 2003 4:53 AM To: [EMAIL PROTECTED] Subject: Hi all. I need your help for this. We have a HPUX 11.0 and TSM Server 5.1.5 running with an IBM library 3584 connected to server with IBM switch, fibre channel and tachyon cards. Every time the Tsm server make the disk migration or stgp reclamation, hpux server is full wio: 10:44:31%usr%sys%wio %idle 10:44:32 14 1 85 0 10:44:33 12 4 84 0 10:44:34 16 2 82 0 10:44:35 7 0 93 0 10:44:36 18 3 79 0 10:44:37 8 4 88 0 10:44:38 3 0 97 0 10:44:39 10 1 89 0 10:44:40 25 2 73 0 10:44:41 23 0 77 0 Is it normal ?.
Re: Perl TSM daily reporting script.
Nice job! Hope you aren't planning to add real-time alerts, trending/predictions, backup status without q events, graphical display of server info, and stuff like that... ;-} - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Patrick Audley Sent: Thursday, November 06, 2003 8:14 AM To: [EMAIL PROTECTED] Subject: Perl TSM daily reporting script. I'm designing a TSM daily reporting script in perl and would like some feedback from anyone who has similar scripts or would like to use one. I've put up a sample of the report that it generates at: http://blackcat.ca/tsm_report.txt If you have any suggestions, comments, or flames please pass them on. The script is public domain so if you'd like a copy, just drop me an email. -- Patrick Audley [EMAIL PROTECTED] High Performance Computing Manager Computational Biology Bioinformatics http://www.compbio.dundee.ac.uk University of Dundeehttp://blackcat.ca Dundee, Scotland+44 1382 348721
Re: Query Event for Previous day shows status In Progress
Am I off base in suggesting that query events is not a reliable way to check backup status? We've found that you can have: --events that say Missed, but you DO have a good backup (it started late, or was run manually, etc, but it WAS done) --events that say Completed, but you DON'T have a good backup (it Completed the kickoff of a TDP agent; the agent failed an hour later) --NO events at all for some nodes (your DBA may want to control the timing with crontab, rather than the TSM scheduler do it) --skipped files, and events doesn't help you there. (outlook.pst, for example, usually stays open/locked, so TSM misses it. The event status is Completed, because it's only one file...!!) This is old news to some people, but maybe useful for others. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of James Choate Sent: Wednesday, November 05, 2003 8:23 AM To: [EMAIL PROTECTED] Subject: Query Event for Previous day shows status In Progress Can someone tell me what is going on with a client(s) that has a status of In Progress when I query the event? When I query the event for the previous day, the status indicates that the event is in progress. When I query the event for the current day, the event status shows future. When I query the session and the process on the tsm server, I do not see anything going on with respect to this event. I have attached the output. Any help/guidance is appreciated. tsm: TSMq event nt_servers nt_backups begint=00:00 begind=11/03/2003 Scheduled Start Actual Start Schedule Name Node Name Status - - - 11/03/03 22:30:00 11/03/03 22:45:00 NT_BACKUPS IBS In Progr- ess 11/03/03 22:30:00 11/04/03 00:18:12 NT_BACKUPS FS_VSICompleted 11/03/03 22:30:00 11/03/03 22:30:41 NT_BACKUPS PLUS_2000 In Progr- ess 11/03/03 22:30:00 11/04/03 00:15:34 NT_BACKUPS ID_CARD Completed 11/03/03 22:30:00 11/04/03 00:16:36 NT_BACKUPS FS_DEVII Completed 11/03/03 22:30:00 11/04/03 00:15:41 NT_BACKUPS POWERFAIDSCompleted 11/03/03 22:30:00 11/04/03 00:15:44 NT_BACKUPS TPG Completed 11/03/03 22:30:00 11/04/03 00:17:13 NT_BACKUPS FS_VSJCompleted 11/03/03 22:30:00 11/04/03 00:16:42 NT_BACKUPS FS-HEAT Completed 11/03/03 22:30:00 11/03/03 22:30:33 NT_BACKUPS FS-LIBIn Progr- ess 11/03/03 22:30:00 11/04/03 00:07:09 NT_BACKUPS TNVOICE Completed 11/03/03 22:30:00 11/04/03 00:16:34 NT_BACKUPS FS_ACTCompleted 11/03/03 22:30:00 11/03/03 23:16:54 NT_BACKUPS MERLIN2 In Progr- ess 11/03/03 22:30:00 11/03/03 22:40:38 NT_BACKUPS MERCYWEBSRV In Progr- ess 11/03/03 22:30:00 11/04/03 00:28:27 NT_BACKUPS W2KDC Completed 11/03/03 22:30:00 11/04/03 00:15:36 NT_BACKUPS FS-XTDCompleted tsm: TSMq sess Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name Number Method StateTimeSent Recvd Type -- -- -- -- --- --- - 1 ShMem Run 0 S 112.8 K 139 Admin AIX ADMIN 17,411 ShMem Run 0 S 45.9 M 139 Admin AIX ADMIN 19,029 ShMem Run 0 S1.0 M 1,018 Admin AIX UHO tsm: TSMq pr Process Process Description Status Number - 2,917 Space Reclamation
Re: TSMManager vs. TSM Operational Reporting
The Operational Reporting beta-testers (of which we are one) work under a confidentiality agreement, so detailed comparisons might not be available. But to us, the two products look pretty similar. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Gray, Alastair Sent: Monday, June 30, 2003 9:48 AM To: [EMAIL PROTECTED] Subject: TSMManager vs. TSM Operational Reporting Has anyone out there done a comparison of TSMManager against TSM Operational Reporting (still in Beta), from which they might be willing to share some of the results? Question prompted by short time scales and a steep learning curve. Alastair Gray Systems Type
Re: A query and some code...
Allen, 2 points:
1. reclamation can busy out your tape drives in a very artificial way.
That is, if you set the reclamation threshold very aggressively, the library
will copy tape-to-tape continually trying to squeeze out wasted space.
2. If mount retention is set to 60 minutes (the default), then every mount
looks up to an hour longer than it really is.
But assuming everybody uses the standard recl treshhold of 60/40, and has
reset mount retentions, then we have dozens of samples from customer showing
average percent mount rate.
Without going back through them, 65% is on the high end, 15% the low end.
If there's enough interest, I'll go count
-
Mr. Lindsay Morris
Lead Architect
www.servergraph.com
512-482-6138 ext 105
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 1:40 PM
To: [EMAIL PROTECTED]
Subject: A query and some code...
I'm trying to collect data on what average utilization rates are on tape
devices. I'm attempting to support or erode the case We need more :)
One thing that would be an interesting number (I decided) was the percent
utilization of tape mount points. So I whipped out my PERL, and...
Submitted for your approval (and hopefully execution!) please
find enclosed
mountpct, a script that takes the output of a 'q actlog', and
makes a rough
calculation of the tape mount time available and used.
I start counting with the first recorded mount, and stop at the
last recorded
unmount.
Anyone who's willing, please consider running this against a
sizable chunk of
q actlog with tab formatting. I collect the actlogs every day
and ferret
them away, so I've got gobs of them, but you can do something like
dsmadmc -id=[something] \
-password=[something] \
-tab \
q actlog begint=00:00 begind=-14 days \
| ./mountpct
here's mine... (I'm only retaining 10 days at the moment)
DRIVE_A: 12351.100 minutes.
DRIVE_B: 11503.333 minutes.
DRIVE_C: 11421.667 minutes.
DRIVE_D: 11531.550 minutes.
Earliest mount occurred : Mon Jun 16 9:00:12 EDT 2003
Last unmount occurred : Thu Jun 26 14:19:48 EDT 2003
Actlog covers 14719.600 minutes.
With 4 devices, 58878.4 device-minutes available.
of which 46807.65 used. (79.499 %)
- Allen S. Rout
#!/usr/local/bin/perl -- -*-Perl-*-
use Time::ParseDate;
use Time::CTime;
my $verbose = 1;
my $spans = {};
my $working = {};
my $firstmount = 60;
my $lastunmount = 0;
while ()
{
#print;
next unless /ANR8468I|ANR8337I/;
my @f = split(/\s+/);
my $t = parsedate($f[0] $f[1]);
my $to = ctime($t);
if ($f[2] eq ANR8337I)
{# Mount req.
$drive = $f[9];
if ($working-{$drive})
{ warn dual mount recorded?\n; }
else
{
$working-{$drive} = $t;
$firstmount = $t if ( $t $firstmount ) ;
}
}
elsif ( $f[2] eq ANR8468I)
{# Dismount
$drive = $f[9];
if ($working-{$drive})
{
my $begin = $working-{$drive};
my $end = $t;
$lastunmount = $t if ($t $lastunmount);
my $run = $end - $begin;
$spans-{$drive} = 0 unless defined ($spans-{$drive});
$spans-{$drive} += $run;
delete $working-{$drive}
}
else
{ warn dual (or initial) dismount recorded?\n; }
}
else
{
#Huh?
die How'd we get here?\n;
}
};
my $count = 0;
my $tmin = 0;
foreach $s ( sort keys %$spans )
{
$count++;
my $c = $spans-{$s};
my $min = sprintf(%.3f,$c / 60);
$tmin += $min;
print $s: $min minutes.\n;
}
print Earliest mount occurred : ,ctime($firstmount);
print Last unmount occurred : ,ctime($lastunmount);
my $range;
$range = $lastunmount - $firstmount;
$range /= 60;
$range = sprintf(%.3f,$range);
my $pct;
$pct = sprintf(%.3f,$tmin/($range * $count) * 100);
print Actlog covers $range minutes.\n;
print With $count devices, ,$range * $count, device-minutes
available.\n;
print of which $tmin used. ($pct %)\n;
sub pm
{
my $n = shift;
}
Re: Verify lan-free transfer???
Look in the accounting logs. If it went LAN-free, there'll be a record for that session in the dsmaccnt.log file on the CLIENT; If it went over the LAN, there'll be a record for that session in the dsmaccnt.log file on the SERVER. These files usually live in /usr/tivoli/tsm/server/bin or something like that. You can use our viewacct program to turn the accounting log data into something more readable. http://www.servergraph.com/techtip3.htm Hope this helps. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Joni Moyer Sent: Tuesday, June 24, 2003 8:04 AM To: [EMAIL PROTECTED] Subject: Verify lan-free transfer??? Hello everyone! I am still having issues with the lan-free verification. I cannot tell if the data went lan-free or if it just went directly to tape due to the management class that was specified. Below I have included the activity log and output from the storage agent. It seems that the storage agent then starts a session and mounts a tape to the LTO2_Drive-1 (2st), but I still am not sure how to tell if it went lanfree. Shouldn't lanfree data bytes have the approximate size of the file? In our output it is 0B. Thank you for any suggestions you may have! 06/20/03 08:57:56 ANR0406I Session 4406 started for node PGSU017 (SUN SOLARIS) (Tcp/Ip 157.154.43.36(44700)). 06/20/03 08:57:58 ANR0406I Session 4407 started for node PGSU017 (SUN SOLARIS) (Tcp/Ip 157.154.43.36(44702)). 06/20/03 08:57:58 ANR0406I (Session: 4297, Origin: STORAGENT) Session 10 started for node PGSU017 (SUN SOLARIS) (Tcp/Ip 127.0.0.1(44703)). 06/20/03 08:58:02 ANR0408I Session 4408 started for server STORAGENT (Solaris 2.6/7/8 ) (Tcp/Ip) for library sharing. 06/20/03 08:58:02 ANR8336I Verifying label of LTO volume 331ABJ in drive LTO2_DRIVE-1 (/dev/rmt/3st). 06/20/03 08:58:02 ANR8468I (Session: 4297, Origin: STORAGENT) LTO volume 331ABJ dismounted from drive LTO2_DRIVE-1 (/dev/rmt/2st) in library 3584_LTO2. 06/20/03 08:58:02 ANR0409I Session 4408 ended for server STORAGENT (Solaris 2.6/7/8 ). 06/20/03 08:58:03 ANR0408I Session 4409 started for server STORAGENT (Solaris 2.6/7/8 ) (Tcp/Ip) for library sharing. 06/20/03 08:58:03 ANR8337I (Session: 4297, Origin: STORAGENT) LTO volume 331ABJ mounted in drive LTO2_DRIVE-1 (/dev/rmt/2st). 06/20/03 08:58:03 ANR0409I Session 4409 ended for server STORAGENT (Solaris 2.6/7/8 ). 06/20/03 08:58:37 ANR0408I Session 4410 started for server STORAGENT (Solaris 2.6/7/8 ) (Tcp/Ip) for library sharing. 06/20/03 08:58:37 ANR0409I Session 4410 ended for server STORAGENT (Solaris 2.6/7/8 ). 06/20/03 08:59:28 ANR0403I Session 4407 ended for node PGSU017 (SUN SOLARIS). 06/20/03 08:59:29 ANR0403I (Session: 4297, Origin: STORAGENT) Session 10 ended for node PGSU017 (SUN SOLARIS). 06/20/03 08:59:30 ANE4952I (Session: 4406, Node: PGSU017) Total number of objects inspected: 286 06/20/03 08:59:30 ANE4953I (Session: 4406, Node: PGSU017) Total number of objects archived: 284 06/20/03 08:59:30 ANE4958I (Session: 4406, Node: PGSU017) Total number of objects updated: 0 06/20/03 08:59:30 ANE4960I (Session: 4406, Node: PGSU017) Total number of objects rebound: 0 06/20/03 08:59:30 ANE4957I (Session: 4406, Node: PGSU017) Total number of objects deleted: 0 06/20/03 08:59:30 ANE4970I (Session: 4406, Node: PGSU017) Total number of objects expired: 0 06/20/03 08:59:30 ANE4959I (Session: 4406, Node: PGSU017) Total number of objects failed: 0 06/20/03 08:59:30 ANE4961I (Session: 4406, Node: PGSU017) Total number of bytes transferred: 774.74 MB 06/20/03 08:59:30 ANE4971I (Session: 4406, Node: PGSU017) LanFree data bytes: 0 B 06/20/03 08:59:30 ANE4963I (Session: 4406, Node: PGSU017) Data transfer time: 40.23 sec 06/20/03 08:59:30 ANE4966I (Session: 4406, Node: PGSU017) Network data transfer rate:19,716.33 KB/sec 06/20/03 08:59:30 ANE4967I (Session: 4406, Node: PGSU017) Aggregate data transfer rate
Re: Verify lan-free transfer???
My advice about using accounting logs to verify lan-free or not has nothing to do with Servergraph. We're big fans of TSM - I hope that advice was helpful to Joni. The viewacct script is a free offering - it helps to see what's in the activity log. Yes, it's on our website - I'm too lazy to cut and paste it into each email. Maybe I should put it on coderelief, or adsm.org somewhere. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Lambelet,Rene,VEVEY,GL-CSC Sent: Tuesday, June 24, 2003 10:27 AM To: [EMAIL PROTECTED] Subject: Re: Verify lan-free transfer??? Hi Lindsay, I appreciate your help in this forum. But this place should not be used to sell any goods (servergraph for instance), it is a technical forum. Regards, Reni LAMBELET NESTEC SA GLOBE - Global Business Excellence Central Support Center Information Technology Av. Nestli 55 CH-1800 Vevey (Switzerland) til +41 (0)21 924 35 43 fax +41 (0)21 703 30 17 local K4-404 mailto:[EMAIL PROTECTED] -Original Message- From: Mr. Lindsay Morris [mailto:[EMAIL PROTECTED] Sent: Tuesday,24. June 2003 17:17 To: [EMAIL PROTECTED] Subject: Re: Verify lan-free transfer??? Look in the accounting logs. If it went LAN-free, there'll be a record for that session in the dsmaccnt.log file on the CLIENT; If it went over the LAN, there'll be a record for that session in the dsmaccnt.log file on the SERVER. These files usually live in /usr/tivoli/tsm/server/bin or something like that. You can use our viewacct program to turn the accounting log data into something more readable. http://www.servergraph.com/techtip3.htm Hope this helps. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Joni Moyer Sent: Tuesday, June 24, 2003 8:04 AM To: [EMAIL PROTECTED] Subject: Verify lan-free transfer??? Hello everyone! I am still having issues with the lan-free verification. I cannot tell if the data went lan-free or if it just went directly to tape due to the management class that was specified. Below I have included the activity log and output from the storage agent. It seems that the storage agent then starts a session and mounts a tape to the LTO2_Drive-1 (2st), but I still am not sure how to tell if it went lanfree. Shouldn't lanfree data bytes have the approximate size of the file? In our output it is 0B. Thank you for any suggestions you may have! 06/20/03 08:57:56 ANR0406I Session 4406 started for node PGSU017 (SUN SOLARIS) (Tcp/Ip 157.154.43.36(44700)). 06/20/03 08:57:58 ANR0406I Session 4407 started for node PGSU017 (SUN SOLARIS) (Tcp/Ip 157.154.43.36(44702)). 06/20/03 08:57:58 ANR0406I (Session: 4297, Origin: STORAGENT) Session 10 started for node PGSU017 (SUN SOLARIS) (Tcp/Ip 127.0.0.1(44703)). 06/20/03 08:58:02 ANR0408I Session 4408 started for server STORAGENT (Solaris 2.6/7/8 ) (Tcp/Ip) for library sharing. 06/20/03 08:58:02 ANR8336I Verifying label of LTO volume 331ABJ in drive LTO2_DRIVE-1 (/dev/rmt/3st). 06/20/03 08:58:02 ANR8468I (Session: 4297, Origin: STORAGENT) LTO volume 331ABJ dismounted from drive LTO2_DRIVE-1 (/dev/rmt/2st) in library 3584_LTO2. 06/20/03 08:58:02 ANR0409I Session 4408 ended for server STORAGENT (Solaris 2.6/7/8 ). 06/20/03 08:58:03 ANR0408I Session 4409 started for server STORAGENT (Solaris 2.6/7/8 ) (Tcp/Ip) for library sharing. 06/20/03 08:58:03 ANR8337I (Session: 4297, Origin: STORAGENT) LTO volume 331ABJ mounted in drive LTO2_DRIVE-1 (/dev/rmt/2st). 06/20/03 08:58:03 ANR0409I Session 4409 ended for server STORAGENT (Solaris 2.6/7/8 ). 06/20/03 08:58:37 ANR0408I Session 4410 started for server STORAGENT (Solaris 2.6/7/8 ) (Tcp/Ip) for library sharing. 06/20/03 08:58:37 ANR0409I Session 4410 ended for server STORAGENT (Solaris 2.6/7/8 ). 06/20/03 08:59:28 ANR0403I Session 4407 ended for node PGSU017 (SUN SOLARIS). 06/20/03 08:59:29 ANR0403I (Session: 4297, Origin: STORAGENT) Session 10 ended for node PGSU017 (SUN SOLARIS). 06/20/03 08:59:30 ANE4952I (Session: 4406
Re: Work arounds for files deleted in flight?
Chuck, would a missed-files report that grouped them by reason-missed help you? eg: Files Missed for Nodexxx Not found: 562 Changing: 2 Locked: 132 Then of course you'd want to be able to click each line, and drill down to see the actual file names. If you did that, do you think you'd want to see (for the Locked list ,say) all 132 files, or just the file NAMES that differ - that is, cut off the directory part? - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Chuck Mattern Sent: Monday, June 23, 2003 7:55 AM To: [EMAIL PROTECTED] Subject: Work arounds for files deleted in flight? Ever since we transitioned from adsm v3 to adsm v4 we have encountered an extremely high failure rate. Essentially when adsm went from backing up Unix filesystems like tar (see a file; get a file) to doing ti like dump (build a list of files; go back and backup the list) we began taking what I do not consider true failures. Since we do not have the ability to quiesce our systems for backup many files that adsm identifies as backup candidates are deleted before they can be backed. To avoid wasting many hours of engineer time logging into several hundred servers to investigate this I am writing a Perl utility to parse the logs, totalling the file not found failures and only reporting a failure back to us if there are more errors than the total number of file not found errors. I took the issue up with ADSM support and essentially got that's the way it is now, sorry Is anyone else having problem like this and if so can you offer any better solutions than the one I am working on? Thanks, Chuck Chuck Mattern The Home Depot Phone: 770-433-8211 x11919 Email: [EMAIL PROTECTED] Pager: 770-201-1626
Re: SELECT equivalent for QUERY EVENT
Richard, thanks for the performance note re select vs. query. IMHO, a larger concern, if you're writing programs to analyze TSM's data, is that the layout of the queries may change when you upgrade TSM, but the field names in the database won't. So your programs won't break when you upgrade TSM. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Richard Sims Sent: Monday, June 23, 2003 2:37 PM To: [EMAIL PROTECTED] Subject: Re: SELECT equivalent for QUERY EVENT as our VM mainframe is soon going to die I'm rewriting all my CMS REXX programs using REGINA and REXXSQL on Windows XP. As I have to rewrite the code I would like to brush it up and replace those QUERYs with SELECTs. Thomas - A couple of observations... - I would caution avoiding going to Selects, which seem the chic thing to do these days. Query commands are more optimized for directly going into the TSM database to rapidly return results: Selects go through an artificial SQL construct on top of the actual B-tree database and entail considerable overhead - including database workspace. For example, contrast a Query CONTent with Select ... From Contents. Query commands are not passe: they are simply pre-programmed and that much less flexible. - Your VM mainframe went away because of obsolescence. REXX is in the same category. (And I say this having been a VM guy and huge fan of REXX.) I would encourage you to get into Perl, which is available on every platform, and is now intrinsically supplied with more open operating systems these days. Richard Sims, BU
Re: Work arounds for files deleted in flight?
Tony, doesn't the Unexpected events page in Servergraph let you click on each of the ANE messages, and see every individual filename that was missed / retried/ locked / etc? I initially responded because I was looking for advice about how we could better do this, but I think the way we do it now is exactly what you want. Contact me off-line if not, and we'll discuss. Thanks. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Garrison, Tony Sent: Monday, June 23, 2003 3:33 PM To: [EMAIL PROTECTED] Subject: Re: Work arounds for files deleted in flight? Sounds good to me also. Anthony A. Garrison Jr. Sr. Systems Programmer USAA (210 456-5755 -Original Message- From: Chuck Mattern [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 11:34 AM To: [EMAIL PROTECTED] Subject:Re: Work arounds for files deleted in flight? Lindsay, This sounds great. We would need full path names to evaluate the consequences of the event. Is something like this already floating around? Chuck Mattern The Home Depot Phone: 770-433-8211 x11919 Email: [EMAIL PROTECTED] Pager: 770-201-1626 Mr. Lindsay Morris To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: aph.com Subject: Re: Work arounds for files deleted in flight? Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] .edu 06/23/2003 09:22 AM Please respond to lmorris Chuck, would a missed-files report that grouped them by reason-missed help you? eg: Files Missed for Nodexxx Not found: 562 Changing: 2 Locked: 132 Then of course you'd want to be able to click each line, and drill down to see the actual file names. If you did that, do you think you'd want to see (for the Locked list ,say) all 132 files, or just the file NAMES that differ - that is, cut off the directory part? - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Chuck Mattern Sent: Monday, June 23, 2003 7:55 AM To: [EMAIL PROTECTED] Subject: Work arounds for files deleted in flight? Ever since we transitioned from adsm v3 to adsm v4 we have encountered an extremely high failure rate. Essentially when adsm went from backing up Unix filesystems like tar (see a file; get a file) to doing ti like dump (build a list of files; go back and backup the list) we began taking what I do not consider true failures. Since we do not have the ability to quiesce our systems for backup many files that adsm identifies as backup candidates are deleted before they can be backed. To avoid wasting many hours of engineer time logging into several hundred servers to investigate this I am writing a Perl utility to parse the logs, totalling the file not found failures and only reporting a failure back to us if there are more errors than the total number of file not found errors. I took the issue up with ADSM support and essentially got that's the way it is now, sorry Is anyone else having problem like this and if so can you offer any better solutions than the one I am working on? Thanks, Chuck
Re: Schedule for the last day of the month...every month
Curtis, if I may ask: how can you monitor backup status (ie success or failure of all your nodes) if you use autosys? - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Curtis Stewart Sent: Thursday, June 19, 2003 11:10 PM To: [EMAIL PROTECTED] Subject: Re: Schedule for the last day of the month...every month We've just decided to get rid of the whole TSM scheduler for the most part and go with an external schedular for TSM backups (AutoSys). It fixes the whole last day of the month, or quarter or whatever problem easily. It also lets us quit using the TSM scheduler on our clients. This may not be the right answer for you, but it looks like it's going to work fine for us. curtis stewart Kent Monthei wrote: You might be able to develop schedule a little script which a) does a 'delete schedule' b) goes through a loop that performs a 'define schedule' for the 31st/30th/29th/28th (in that order) c) after each 'define schedule' attempt, checks the Return Code (or output of 'q sched') d) exit if/when the 'define schedule' is successful. Then schedule the script to run on any of the 1st through 28th day of the month. Kent Monthei GlaxoSmithKline Bill Boyer [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 19-Jun-2003 13:14 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: ADSM-L cc: Subject:Schedule for the last day of the month...every month I have a client that wants to do monthly backups on the last day of the month. A co-worker did some testing and creating a schedule for say 5/31/3002 with PERU=MONTH. The June event gets scheduled for 6/30, but then remains the 30th day from then on. Until Feb next year when it moves to the 29th. Outside of creating a schedule for each month with a PERU=YEAR, is there a way to do a schedule on the last day of every month?? TIA, Bill Boyer Some days you are the bug, some days you are the windshield. - ??
Re: Schedule for the last day of the month...every month
Thanks, Alex - brilliant idea - and that's how Servergraph already does it. We give the TSM admins visibility into the status, checked daily, fo how old the backups are. So they need not care about schedules - just whether things are current or not. The really great side benefit from this is finding wasted space. That is, if a filespace ahs not backed up in 90 days, does it still exist? Probably not, except on TSM tapes. Delete it. We had one customer free up 4 TB of defunct filespaces. Anybody who's short on library space should check for that one way or another. (IMHO) - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: Alex Paschal [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:25 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: Schedule for the last day of the month...every month Hi, Lindsay. I would suggest also monitoring backup status using a select statement to pull out filespaces that didn't complete backup within x amount of time, even if you use the TSM scheduler. This is useable with autosys. Also, autosys scripts can report based on RC, and since we now have meaningful RC's from the client, that probably provides autosys reasonable success/failure notification. My autosys controlled backups email me on failure, but I'm using scripts to parse the dsmc output for some weird things, rather than using the dsmc RC. The problem we run into is that our TSM admins don't have visibility into the Autosys schedules for load balancing purposes. I'm still trying to figure that one out. Maybe a weekly autosys report? Hmm... Alex Paschal Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Mr. Lindsay Morris [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2003 12:25 AM To: [EMAIL PROTECTED] Subject: Re: Schedule for the last day of the month...every month Curtis, if I may ask: how can you monitor backup status (ie success or failure of all your nodes) if you use autosys? - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Curtis Stewart Sent: Thursday, June 19, 2003 11:10 PM To: [EMAIL PROTECTED] Subject: Re: Schedule for the last day of the month...every month We've just decided to get rid of the whole TSM scheduler for the most part and go with an external schedular for TSM backups (AutoSys). It fixes the whole last day of the month, or quarter or whatever problem easily. It also lets us quit using the TSM scheduler on our clients. This may not be the right answer for you, but it looks like it's going to work fine for us. curtis stewart Kent Monthei wrote: You might be able to develop schedule a little script which a) does a 'delete schedule' b) goes through a loop that performs a 'define schedule' for the 31st/30th/29th/28th (in that order) c) after each 'define schedule' attempt, checks the Return Code (or output of 'q sched') d) exit if/when the 'define schedule' is successful. Then schedule the script to run on any of the 1st through 28th day of the month. Kent Monthei GlaxoSmithKline Bill Boyer [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 19-Jun-2003 13:14 Please respond to ADSM: Dist Stor Manager [EMAIL PROTECTED] To: ADSM-L cc: Subject:Schedule for the last day of the month...every month I have a client that wants to do monthly backups on the last day of the month. A co-worker did some testing and creating a schedule for say 5/31/3002 with PERU=MONTH. The June event gets scheduled for 6/30, but then remains the 30th day from then on. Until Feb next year when it moves to the 29th. Outside of creating a schedule for each month with a PERU=YEAR, is there a way to do a schedule on the last day of every month?? TIA, Bill Boyer Some days you are the bug, some days you are the windshield. - ??
Re: TSM Decision support 4.2.0 tools
Gee, we've talked to a lot of people about TDS, of course - it used to be considered competition for Servergraph - and most say it's hard to install hurts performance on the TSM server doesn't give them the info they want. You might want some comments from former TDS users before you go too far down this path. - Mr. Lindsay Morris Lead Architect www.servergraph.com 512-482-6138 ext 105 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Lawrence Clark Sent: Thursday, June 12, 2003 1:24 PM To: [EMAIL PROTECTED] Subject: TSM Decision support 4.2.0 tools Problem: Loaded TSM Decision Support V4.2.0 Loaded and configured and populated a MSSQL DB with the 1st set of data. Tried installing Decision Support for Storage Management Analysis V 4.2.0 and I get message: UNABLE TO FIND REGISTRY ENTRY FOR TDS GUIDES CANNOT BE INSTALLED. Workaround anyone? Also, anyone use the loader and analysis tools, and any comments? Larry Clark NYS Thruway Authority (518)-471-4202 Certified: Aix 4.3 System Administration Aix 4.3 System Support Tivoli ADSM/TSM V 3 Consultant
