Re: select node_name,archive_mb from auditocc
Hi Luc, For documentation on SELECT commands and options; TSM provides a subset of SQL for querying it's database. The SELECT commands are generally the same as SQL SELECT commands, so looking at SQL docs will help there. Also, 'help select' on the TSM server may help a little. To see what information is 'selectable' try this from the tsm server Select * from syscat.tables Select * from syscat.columns You can select on any of the tables and column names listed. Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin Sent: Thursday, May 19, 2005 9:34 PM To: ADSM-L@VM.MARIST.EDU Subject: select node_name,archive_mb from auditocc Hi all Is there a way to run that command ... plus be able to see each archives sessions from each node Is there a document for all the SELECT commands and options ...??? thanks Luc ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
Virtual tape libraries
I have been experimenting with a virtual tape library connected to TSM (Windows 2k3 5.1.6.3 server) All seems to work perfectly and TSM is none the wiser. However, The maximum cartridge size in this virtual library is 2GB. I am currently using LTO1 and getting upto 100 times this amount of data on one tape. My database is 56GB and I currently have approx 600 volumes My question is.. if I were to move to a virtual library and had to increase the number of my volumes by up to 10 times What impact would this have on my database ? Thanks in advance Jon Evans Storage Consultant KBR
Re: select node_name,archive_mb from auditocc
On May 19, 2005, at 4:34 PM, Luc Beaudoin wrote: Is there a document for all the SELECT commands and options ...??? In http://people.bu.edu/rbs/ADSM.QuickFacts see topics "Select" and "SQL", and the "SQL" references near the bottom of the QuickFacts. Your server install also provided you with a scripts.smp file with a variety of sample Selects. Richard Sims
Re: *URGENT* Windows OS Auditing
On May 19, 2005, at 5:05 PM, David Nicholson wrote: ...The Intel folks tell me they recently turned on "O/S level Auditing" of the DATA drive on almost all of the Windows servers. ... This is an issue for site management to address. If those wonderful Windows administrators capriciously made a major change in the way site servers are operating, and did not communicate it to the organization, then they are out of control and need some "parental guidance". Site management should realize the damage they are doing and take action. It's not just your backup system that it being affected, but also the performance of all the servers and overload on the network. An organization has to function in a team manner...as a cohesive whole. Things go to pot when that doesn't happen, and it isn't happening at your site. Richard Sims
Re: Node parameters
On May 19, 2005, at 4:35 PM, Sung Y Lee wrote: The value for tcp_name does not appear to be depended on the dsm.sys/dsm.opt. Anyone else seeing samething I am seeing? See the client manuals' description of the Nodename option, which explains derivation. Earlier TSM client programming leaves the TCP_NAME null in the NODES table. Richard Sims
long time to expire files
have a server with over a folder that has about 860,000 text files that had been created by an application when the users were trying to debug a problem, i hadnt coded the excude for the files originally since i wanst aware that there were being created and that there were so many of them i added them to the exclude list yesterday but whenever the client backs up it spends hours expiring the files and the backup doesnt complete, i know it will eventually but is there any options i can code to prevent or streamline this expiration process Tim Brown Systems Specialist Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: [EMAIL PROTECTED] Phone: 845-486-5643 Fax: 845-486-5921
Re: *URGENT* Windows OS Auditing
Hi Rich, For the record, this change was communicated we just didn't fully appreciate the impact it would have. Thanks for your concern. Dave Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 05/20/2005 07:13 AM Please respond to "ADSM: Dist Stor Manager" To: ADSM-L@VM.MARIST.EDU cc: Subject:Re: *URGENT*Windows OS Auditing On May 19, 2005, at 5:05 PM, David Nicholson wrote: > ...The Intel folks tell me they > recently turned on "O/S level Auditing" of the DATA drive on almost > all of > the Windows servers. ... This is an issue for site management to address. If those wonderful Windows administrators capriciously made a major change in the way site servers are operating, and did not communicate it to the organization, then they are out of control and need some "parental guidance". Site management should realize the damage they are doing and take action. It's not just your backup system that it being affected, but also the performance of all the servers and overload on the network. An organization has to function in a team manner...as a cohesive whole. Things go to pot when that doesn't happen, and it isn't happening at your site. Richard Sims
Re: *URGENT* Windows OS Auditing
THANKS WANDA!! Your awesome...sure is nice to know what is going on! It all makes perfect sense...now... :( Based on what little I know about OS Level Auditing, I am thinking this is a 1 time blip for all the servers to get backed up because of this attribute change, but once I get through this initial backup things should return to normal for me . is this a correct assumption? Thanks again! "Prather, Wanda" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 05/19/2005 05:17 PM Please respond to "ADSM: Dist Stor Manager" To: ADSM-L@VM.MARIST.EDU cc: Subject:Re: *URGENT*Windows OS Auditing You betcha. Been there, done that (or had it done to me!) A change in the auditing options appears to TSM like a permission change. And like any other type of file change; you'll get a backup of the file (or all the files). There is a parm you can put in dsm.opt: SKIPNTPERMISSIONS YES But I haven't found any way to work with it. It tells TSM to ignore the NTFS permissions, but then it doesn't back them up or restore them at all. SO, unless you can rely STRICTLY on permission inheritance for ALL subdirectories from the root, you gotta back the permissions up. Go have that gin and tonic -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Nicholson Sent: Thursday, May 19, 2005 5:05 PM To: ADSM-L@VM.MARIST.EDU Subject: *URGENT* Windows OS Auditing Hi List, I am seeing a tremendous and sudden increase in the amount of data I am backing up from my Intel servers. The Intel folks tell me they recently turned on "O/S level Auditing" of the DATA drive on almost all of the Windows servers. I am wondering if this has resulted in TSM perceiving all the data to have changed and he is therefore taking a full backup. I am quickly running out of DB space and I'm beginning to panic (in a gin and tonic kind of way).. Can anybody comment? Thanks in advance Dave
Re: *URGENT* Windows OS Auditing
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Nicholson >For the record, this change was communicated we just >didn't fully >appreciate the impact it would have. A bit OT, but we're seeing this more and more these days. Administrators who don't *really* understand the OSs they administer implement changes because they're told to (or read about them somewhere) without *really* understand what those changes will entail. I have customers who remove all permissions for the SYSTEM ID on their Windows servers, not realizing that doing so means that a scheduled TSM backup using the TSM scheduler service employing the SYSTEM ID will miss those files that SYSTEM can't read or write--sometimes with disastrous consequences. -- Mark Stapleton ([EMAIL PROTECTED]) IBM Certified Advanced Deployment Professional Tivoli Storage Management Solutions 2005 IBM Certified Advanced Technical Expert (CATE) AIX Office 262.521.5627
Re: Regarding TSM db and log mirroring
==> On Thu, 19 May 2005 08:38:38 -0400, Richard Sims <[EMAIL PROTECTED]> said: > Recovery is documented in the Admin Guide topic "Restoring Your > Server Using Mirrored Volumes". I've been unable to find docs on starting a server on only one half of a mirror. Anybody ever done this? For most of the operations which begin with "Take another backup of your database", I've often wanted to replace that with "Break the mirror, and work with one half of it". You could do that indefinitely, so long as between botched operations you re-mirror the volumes. The obvious path (halt the server, edit the .dsk file) seems to have no effect: evidently the list of volumes is squirreled away somewhere else too. You get a happy running server with all mirrors present and accounted for. - Allen S. Rout
Tape Stuck in Remote Status
I have two tapes that are in volume history as status "Remote". The instance of TSM they are supposedly remote on no longer have any information about these volumes. When I try to enter them as scratch, they are rejected: ANR8443E CHECKIN LIBVOLUME: Volume 110330 in library 3584LIB cannot be assigned a status of SCRATCH. I am assuming this is because it is in volume history as remote. How do I change this and get it checked in as a scratch? Thanks for any information. -- Andy Carlson - Senior Technical Specialist BJC Healtcare --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
Re: Virtual tape libraries
Hi, Most VTL's that I have encountered emulate a real tape drive (ie. Brand and model) and thus their cartridge size is based on this (ie. 200 GB for LTO1, etc). I would find out why this vtl has this limitation. As to the db growth, others may have a better idea, but I have always found that adding volumes wasn't nearly as big a deal as adding more backed up data (ie. If I bring in 20 more servers with 10,000's each, that overshadows anything else as far as the db is concerned). Michael Wheelock Integris Health -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jon Evans Sent: Friday, May 20, 2005 5:02 AM To: ADSM-L@VM.MARIST.EDU Subject: Virtual tape libraries I have been experimenting with a virtual tape library connected to TSM (Windows 2k3 5.1.6.3 server) All seems to work perfectly and TSM is none the wiser. However, The maximum cartridge size in this virtual library is 2GB. I am currently using LTO1 and getting upto 100 times this amount of data on one tape. My database is 56GB and I currently have approx 600 volumes My question is.. if I were to move to a virtual library and had to increase the number of my volumes by up to 10 times What impact would this have on my database ? Thanks in advance Jon Evans Storage Consultant KBR ** This e-mail may contain identifiable health information that is subject to protection under state and federal law. This information is intended to be for the use of the individual named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited and may be punishable by law. If you have received this electronic transmission in error, please notify us immediately by electronic mail (reply).
Re: Regarding TSM db and log mirroring
Allen, As I understand it, the list of all db and log volumes is maintained on each and every db and log volume. The dsmserv.dsk file only needs to point to one of these volumes. When TSM comes up, it will read that volume, obtain the full list, and access the others. Someone from IBM can correct me if I am wrong, or if this has changed over the years. Years ago, I actually went through the scenario you describe. We split the DB mirror, and brought up TSM on only half of the mirrors, while we ran an auditdb on the other half of the mirrors. We run TSM as non-root. We just changed the ownership of the split mirrors so that TSM could not access them. ..Paul At 09:34 AM 5/20/2005, Allen S. Rout wrote: I've been unable to find docs on starting a server on only one half of a mirror. Anybody ever done this? For most of the operations which begin with "Take another backup of your database", I've often wanted to replace that with "Break the mirror, and work with one half of it". You could do that indefinitely, so long as between botched operations you re-mirror the volumes. The obvious path (halt the server, edit the .dsk file) seems to have no effect: evidently the list of volumes is squirreled away somewhere else too. You get a happy running server with all mirrors present and accounted for. - Allen S. Rout -- Paul Zarnowski Ph: 607-255-4757 719 Rhodes Hall, Cornell UniversityFx: 607-255-8521 Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED]
Re: Tape Stuck in Remote Status
On Fri, May 20, 2005 at 08:39:58AM -0500, Andrew Carlson wrote: > I have two tapes that are in volume history as status "Remote". The > instance > of TSM they are supposedly remote on no longer have any information about > these volumes. When I try to enter them as scratch, they are rejected: > > ANR8443E CHECKIN LIBVOLUME: Volume 110330 in library 3584LIB cannot be > assigned > a status of SCRATCH. > > I am assuming this is because it is in volume history as remote. How do I > change this and get it checked in as a scratch? > > Thanks for any information. Does the volume still contain data? If it does, you need to check it in as private. TSM will not allow you to check in a tape as scratch if it is still defined in the database. checkin libv LIBNAME VOLNAME checkl=no status=private devt=DEVT hth, bob
Re: Tape Stuck in Remote Status
On Fri, 20 May 2005 09:02:29 -0500, Bob Booth - CITES <[EMAIL PROTECTED]> wrote: On Fri, May 20, 2005 at 08:39:58AM -0500, Andrew Carlson wrote: I have two tapes that are in volume history as status "Remote". The instance of TSM they are supposedly remote on no longer have any information about these volumes. When I try to enter them as scratch, they are rejected: ANR8443E CHECKIN LIBVOLUME: Volume 110330 in library 3584LIB cannot be assigned a status of SCRATCH. I am assuming this is because it is in volume history as remote. How do I change this and get it checked in as a scratch? Thanks for any information. Does the volume still contain data? If it does, you need to check it in as private. TSM will not allow you to check in a tape as scratch if it is still defined in the database. checkin libv LIBNAME VOLNAME checkl=no status=private devt=DEVT hth, bob There is no useful data on the tape - it is gone from the remote TSM instance. I could check it in as private, but then what? It ultimately needs to be scratch. -- Andy Carlson - Senior Technical Specialist BJC Healtcare --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
Re: Tape Stuck in Remote Status
>There is no useful data on the tape - it is gone from the remote TSM >instance. I could >check it in as private, but then what? It ultimately needs to be scratch. > Check it in as private, then 'del vol xx discarddata=yes' to get rid of the data obsolete data references. David Ehresman
Re: Regarding TSM db and log mirroring
==> On Fri, 20 May 2005 09:44:58 -0400, Paul Zarnowski <[EMAIL PROTECTED]> said: > Years ago, I actually went through the scenario you describe. We split the > DB mirror, and brought up TSM on only half of the mirrors, while we ran an > auditdb on the other half of the mirrors. [ And I mused about lvs... ...] Or I could just do chlv -n [newname] [oldname]. yeah, that'd work. - Allen S. Rout
Re: Tape Stuck in Remote Status
You can do a delete volume ## discard=yes. This will delete all references to data on that volume from the TSM database. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Carlson Sent: Friday, May 20, 2005 9:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Tape Stuck in Remote Status On Fri, 20 May 2005 09:02:29 -0500, Bob Booth - CITES <[EMAIL PROTECTED]> wrote: > On Fri, May 20, 2005 at 08:39:58AM -0500, Andrew Carlson wrote: >> I have two tapes that are in volume history as status "Remote". The >> instance of TSM they are supposedly remote on no longer have any >> information about >> these volumes. When I try to enter them as scratch, they are rejected: >> >> ANR8443E CHECKIN LIBVOLUME: Volume 110330 in library 3584LIB cannot >> be assigned a status of SCRATCH. >> >> I am assuming this is because it is in volume history as remote. How >> do I change this and get it checked in as a scratch? >> >> Thanks for any information. > > Does the volume still contain data? If it does, you need to check it > in as private. TSM will not allow you to check in a tape as scratch > if it is still defined in the database. > > checkin libv LIBNAME VOLNAME checkl=no status=private devt=DEVT > > hth, > > bob > > There is no useful data on the tape - it is gone from the remote TSM instance. I could check it in as private, but then what? It ultimately needs to be scratch. -- Andy Carlson - Senior Technical Specialist BJC Healtcare --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
Re: select node_name,archive_mb from auditocc
There is an excellent document on using TSM with SQL in Appendix A of the TSM 5.1 Technical Guide. Go to www.redbooks.ibm.com and search on SG24-6554. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Warren, Matthew (Retail) Sent: Friday, May 20, 2005 5:38 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: select node_name,archive_mb from auditocc Hi Luc, For documentation on SELECT commands and options; TSM provides a subset of SQL for querying it's database. The SELECT commands are generally the same as SQL SELECT commands, so looking at SQL docs will help there. Also, 'help select' on the TSM server may help a little. To see what information is 'selectable' try this from the tsm server Select * from syscat.tables Select * from syscat.columns You can select on any of the tables and column names listed. Matt. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Luc Beaudoin Sent: Thursday, May 19, 2005 9:34 PM To: ADSM-L@VM.MARIST.EDU Subject: select node_name,archive_mb from auditocc Hi all Is there a way to run that command ... plus be able to see each archives sessions from each node Is there a document for all the SELECT commands and options ...??? thanks Luc ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
Re: Tape Stuck in Remote Status
On Fri, 20 May 2005 09:24:08 -0500, David E Ehresman <[EMAIL PROTECTED]> wrote: There is no useful data on the tape - it is gone from the remote TSM instance. I could check it in as private, but then what? It ultimately needs to be scratch. Check it in as private, then 'del vol xx discarddata=yes' to get rid of the data obsolete data references. David Ehresman Which TSM instance do I do this on? I suspect that doing it on the library manager will not work, and the volume no longer exists on the remote TSM instance, so I'm not sure it will work there? I will try one and see. -- Andy Carlson - Senior Technical Specialist BJC Healtcare --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
Re: *URGENT* Windows OS Auditing
>>Based on what little I know about OS Level Auditing, I am thinking this is a 1 time blip for all the servers to get backed up because of this attribute change, but once I get through this initial backup things should return to normal for me . is this a correct assumption? That's correct. Have a peaceful weekend~! "Prather, Wanda" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" 05/19/2005 05:17 PM Please respond to "ADSM: Dist Stor Manager" To: ADSM-L@VM.MARIST.EDU cc: Subject:Re: *URGENT*Windows OS Auditing You betcha. Been there, done that (or had it done to me!) A change in the auditing options appears to TSM like a permission change. And like any other type of file change; you'll get a backup of the file (or all the files). There is a parm you can put in dsm.opt: SKIPNTPERMISSIONS YES But I haven't found any way to work with it. It tells TSM to ignore the NTFS permissions, but then it doesn't back them up or restore them at all. SO, unless you can rely STRICTLY on permission inheritance for ALL subdirectories from the root, you gotta back the permissions up. Go have that gin and tonic -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of David Nicholson Sent: Thursday, May 19, 2005 5:05 PM To: ADSM-L@VM.MARIST.EDU Subject: *URGENT* Windows OS Auditing Hi List, I am seeing a tremendous and sudden increase in the amount of data I am backing up from my Intel servers. The Intel folks tell me they recently turned on "O/S level Auditing" of the DATA drive on almost all of the Windows servers. I am wondering if this has resulted in TSM perceiving all the data to have changed and he is therefore taking a full backup. I am quickly running out of DB space and I'm beginning to panic (in a gin and tonic kind of way).. Can anybody comment? Thanks in advance Dave
Windows Storage Server NAS device
Anyone backing up one of these? I'm getting the impression that it's just a Windows box tuned for file sharing, and that a regular TSM Windows client will do nicely for backing it up...but I'd like to hear from anyone else who's done it. Also, anyone know if it is NDMP capable? I didn't find much about it on the MS site, unless I missed it. -Lloyd
Re: Expiration / deletion of inactive files do not appear to be working for SQL-BACKTRACK
In TSM for Databases, each backup file has a unique name and rman is responsible for "deleting" them, thus triggering the TSM expiration cycle. Does Backtrack work the same way? >>> [EMAIL PROTECTED] 05/19/05 2:34 PM >>> Hi: We've just discovered q peculiar problem with expiration involing the SQL-BACKTRACK product and SYBASE and ORACLE databases. They do not appear to be expiring. The managment class rules are: DOMAIN_NAME CLASS_NAME VEREXISTS VERDELETED RETEXTRA RETONLY DESTINATION SPAIX DBBKUP1 60 0 30 0 AIXDISKBACK And a "query backup /BACKTRACK:obackups.physical/*/* -inactive" returns a HUGE list of files that are inactive. They should all have been deleted with the RETONLY set to 0. Am I missing something? A DB called SQL-BACKTRACK support and the responce was SQL-BACKTRACK marked them inactive; at that point TSM is not correctly removing them per the definitions. Flat files in other management groups are behaving correctly. API 5,242,880 B 10/15/03 02:54:53DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-10-2003.02:55:41-21544 API 5,242,880 B 11/15/03 02:59:13DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-11-2003.02:59:04-43356 API 5,242,880 B 12/15/02 02:55:59DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-12-2002.02:55:42-31662 API 5,242,880 B 12/15/03 02:50:43DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-12-2003.02:50:28-19182 API 5,242,880 B 01/16/03 03:03:22DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-01-2003.03:03:16-32618 API 5,242,880 B 01/16/04 02:57:23DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-01-2004.02:57:00-28874 API 5,242,880 B 02/16/03 02:48:22DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-02-2003.02:48:26-21274 API 5,242,880 B 02/16/04 02:48:41DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-02-2004.02:48:10-39458 API 5,242,880 B 03/16/03 02:50:47DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-03-2003.02:50:59-32472 API 5,242,880 B 03/16/04 02:54:33DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-03-2004.02:54:33-33320 API 5,242,880 B 04/16/03 03:04:45DBBKUP1 A /BACKTRACK:obackups.phy >>> [EMAIL PROTECTED] 05/10/2005 9:27:12 AM >>> Mario, We've been using St. Bernard OFM 9 in conjuction with TSM 5.2.2 (client vers. of course) to backup both our GroupWise 6, and now GroupWise 6.5 servers in the last year without problems. We've also done successful restores of the GroupWise servers. >>> [EMAIL PROTECTED] 05/09/05 3:41 PM >>> Hi list, I need to perform an online backup of a Novell Groupwise environment using TSM ... does anybody knows how can I accomplish this ? Thanks. Mario Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html
Re: Tape Stuck in Remote Status
On Fri, 20 May 2005 09:27:39 -0500, Ochs, Duane <[EMAIL PROTECTED]> wrote: You can do a delete volume ## discard=yes. This will delete all references to data on that volume from the TSM database. I had the volume checked in. The volume now shows up in q libv: tsm: TSMLIBM>q libv 3584lib 110544 Library Name Volume Name Status Owner Last Use Home Device Element Type --- -- -- - --- -- 3584LIB 110544 Private TSMJ 1,0953592 But, since the volume does not show up in TSMJ (actually it was a database backup tape), I cannot delete it. Any ideas? -- Andy Carlson - Senior Technical Specialist BJC Healtcare --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
q backup for SQL-BACKTRACK
We have two clients on NT boxes with oracle databses. (One TSM install). One is the flat file backup, the 2nd with its own dsm.opt file is for SQl-BACKTRACK. We cannot query the backups on SQL-BACTRACK since the dsmc invokes with the flat file client dsm.opt ( and hence can't do a set access for SQL-BACKTRACK. Is there a way of invoking the dsmc for the SQL-BACTRACK client?
Re: Expiration / deletion of inactive files do not appear to be working for SQL-BACKTRACK
Yes, SQL-BACKTRACK is responsible for updating the status of the uniquely name file. >>> [EMAIL PROTECTED] 05/20/2005 10:43:53 AM >>> In TSM for Databases, each backup file has a unique name and rman is responsible for "deleting" them, thus triggering the TSM expiration cycle. Does Backtrack work the same way? >>> [EMAIL PROTECTED] 05/19/05 2:34 PM >>> Hi: We've just discovered q peculiar problem with expiration involing the SQL-BACKTRACK product and SYBASE and ORACLE databases. They do not appear to be expiring. The managment class rules are: DOMAIN_NAME CLASS_NAME VEREXISTS VERDELETED RETEXTRA RETONLY DESTINATION SPAIX DBBKUP1 60 0 30 0 AIXDISKBACK And a "query backup /BACKTRACK:obackups.physical/*/* -inactive" returns a HUGE list of files that are inactive. They should all have been deleted with the RETONLY set to 0. Am I missing something? A DB called SQL-BACKTRACK support and the responce was SQL-BACKTRACK marked them inactive; at that point TSM is not correctly removing them per the definitions. Flat files in other management groups are behaving correctly. API 5,242,880 B 10/15/03 02:54:53DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-10-2003.02:55:41-21544 API 5,242,880 B 11/15/03 02:59:13DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-11-2003.02:59:04-43356 API 5,242,880 B 12/15/02 02:55:59DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-12-2002.02:55:42-31662 API 5,242,880 B 12/15/03 02:50:43DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-12-2003.02:50:28-19182 API 5,242,880 B 01/16/03 03:03:22DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-01-2003.03:03:16-32618 API 5,242,880 B 01/16/04 02:57:23DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-01-2004.02:57:00-28874 API 5,242,880 B 02/16/03 02:48:22DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-02-2003.02:48:26-21274 API 5,242,880 B 02/16/04 02:48:41DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-02-2004.02:48:10-39458 API 5,242,880 B 03/16/03 02:50:47DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-03-2003.02:50:59-32472 API 5,242,880 B 03/16/04 02:54:33DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-03-2004.02:54:33-33320 API 5,242,880 B 04/16/03 03:04:45DBBKUP1 A /BACKTRACK:obackups.phy >>> [EMAIL PROTECTED] 05/10/2005 9:27:12 AM >>> Mario, We've been using St. Bernard OFM 9 in conjuction with TSM 5.2.2 (client vers. of course) to backup both our GroupWise 6, and now GroupWise 6.5 servers in the last year without problems. We've also done successful restores of the GroupWise servers. >>> [EMAIL PROTECTED] 05/09/05 3:41 PM >>> Hi list, I need to perform an online backup of a Novell Groupwise environment using TSM ... does anybody knows how can I accomplish this ? Thanks. Mario Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html
Re: Regarding TSM db and log mirroring
When our array went down, we were able to simply start TSM. It came up with half of the mirrors off-line and ran fine. We did not do anything special. I do not know were it is documented. Andy Huebner -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Allen S. Rout Sent: Friday, May 20, 2005 8:35 AM To: ADSM-L@VM.MARIST.EDU Subject:Re: [ADSM-L] Regarding TSM db and log mirroring ==> On Thu, 19 May 2005 08:38:38 -0400, Richard Sims <[EMAIL PROTECTED]> said: > Recovery is documented in the Admin Guide topic "Restoring Your > Server Using Mirrored Volumes". I've been unable to find docs on starting a server on only one half of a mirror. Anybody ever done this? For most of the operations which begin with "Take another backup of your database", I've often wanted to replace that with "Break the mirror, and work with one half of it". You could do that indefinitely, so long as between botched operations you re-mirror the volumes. The obvious path (halt the server, edit the .dsk file) seems to have no effect: evidently the list of volumes is squirreled away somewhere else too. You get a happy running server with all mirrors present and accounted for. - Allen S. Rout
Re: Tape Stuck in Remote Status
On Fri, May 20, 2005 at 09:59:06AM -0500, Andrew Carlson wrote: > On Fri, 20 May 2005 09:27:39 -0500, Ochs, Duane <[EMAIL PROTECTED]> wrote: > > >You can do a delete volume ## discard=yes. This will delete all > >references to data on that volume from the TSM database. > > > > I had the volume checked in. The volume now shows up in q libv: > > tsm: TSMLIBM>q libv 3584lib 110544 > > Library Name Volume Name Status Owner Last Use Home > Device > Element Type > --- -- -- - --- > -- > 3584LIB 110544 Private TSMJ 1,0953592 > > But, since the volume does not show up in TSMJ (actually it was a database > backup tape), I cannot delete it. Any ideas? > Does the volume show up in the volume history file? q volh type=dbb (if it is part of a backup series) or q volh type=dbs (if it is a database snapshot) if it is, and it is an old series, or an old dbs, you can delete the volume using the del volh command (I refer you to the help del volh for further detail). bob
Poor LanFree performance / mixed LAN xfer??
Hello *SM'ers, Has anyone observed the following; We are experienceing performance problems with LanFree backups. The issue goes away with a retsart of the storage agent, but at some point in the future comes back, requiring another restart of the stoarge agent etc.. Now, when the backups are going OK, the following steps are observed, take note of what happens to the ByteCount (IE: the small cumulative indicator in the square brackets at the command line, '[12.3 G]') ; Backup started First directory entry sent Backup pauses, while byte count increments Backup generates 'unsuccesful' line, and then 'waiting for mount of offline media' ByteCount PAUSES When tape is mounted and wound, BYTECOUNT increases Very Fast. (+100 - 200MB / 'tick' ) Then end stats show simlar to; Total number of objects inspected:3 Total number of objects backed up:3 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted: 0 Total number of objects expired: 0 Total number of objects failed: 0 Total number of bytes transferred: 4.70 GB LanFree data bytes:4.70 GB Data transfer time: 153.13 sec Network data transfer rate:32,229.74 KB/sec Aggregate data transfer rate: 28,567.48 KB/sec Objects compressed by:0% Elapsed processing time: 00:02:52 ..NOTE, ALL data has gone LanFree Now, when the backups are performing slowly, the following occurrs; Backup started First directory entry sent Backup pauses, while byte count increments Backup generates 'unsuccesful' line, and then 'waiting for mount of offline media' ByteCount CONTINUES TO INCREMENT SLOWLY (+15-20 MB / 'tick') When tape is mounted and wound, BYTECOUNT INCREMENTS SLOWLY (+15 - 20MB / 'tick') At the end of backup, we see this; Total number of objects inspected:6 Total number of objects backed up:2 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted: 0 Total number of objects expired: 0 Total number of objects failed: 0 Total number of bytes transferred: 4.18 GB LanFree data bytes:2.37 GB Data transfer time: 42.01 sec Network data transfer rate:104,402.77 KB/sec Aggregate data transfer rate: 15,331.31 KB/sec Objects compressed by:0% Elapsed processing time: 00:04:46 Does this indicate, that in this instance some data went LanFree while some went LAN?? .. and what significance is the fact that the BYTECOUNT increases slowly while waiting for a mediamount, but it doesn't when the backup performs well? Puzzled; Matthew. Computer says 'No'.. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
Multiple TSM servers and their databases
Hi all Quick question, which I know is in the manuals somewhere, but I need a quick answer and don't have time to look just now, so was hoping someone could point me in the right direction.. If I deployed multiple TSM servers all sharing the same Library, do they all have their own independent databases, or can they be configured with one as a master and the others all linked in somehow? I'm presuming that they are all independent and that data can only be moved between them via some move media or export / import function. Would that be a correct assumption? Many thanks in advance.. Jon Evans Storage Consultant KBR
Re: Multiple TSM servers and their databases
If not clustered, they have separate databases and configured separately. One owns the library to the extent that it controls the robot. At least that is my understanding. I haven't done it. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jon Evans Sent: Friday, May 20, 2005 11:04 AM To: ADSM-L@VM.MARIST.EDU Subject: Multiple TSM servers and their databases Hi all Quick question, which I know is in the manuals somewhere, but I need a quick answer and don't have time to look just now, so was hoping someone could point me in the right direction.. If I deployed multiple TSM servers all sharing the same Library, do they all have their own independent databases, or can they be configured with one as a master and the others all linked in somehow? I'm presuming that they are all independent and that data can only be moved between them via some move media or export / import function. Would that be a correct assumption? Many thanks in advance.. Jon Evans Storage Consultant KBR
Re: Multiple TSM servers and their databases
Yes, they should be having their own databases and data movement between them has to be done using export/import commands... rgds, Aleem On 5/20/05, Jon Evans <[EMAIL PROTECTED]> wrote: > Hi all > > > > Quick question, which I know is in the manuals somewhere, but I need a > quick answer and don't have time to look just now, so was hoping someone > could point me in the right direction.. > > If I deployed multiple TSM servers all sharing the same Library, do they > all have their own independent databases, or can they be configured with > one as a master and the others all linked in somehow? > > I'm presuming that they are all independent and that data can only be > moved between them via some move media or export / import function. > Would that be a correct assumption? > > > > Many thanks in advance.. > > > > Jon Evans > > Storage Consultant > > KBR >
Re: Regarding TSM db and log mirroring
I guess "chlv -n ..." would work. In our environment, the /dev/r... files are owned by the same userid that runs the TSM server image that accesses them, so we just had to change the ownership of these (as I recall - it was many years ago). At 10:25 AM 5/20/2005, Allen S. Rout wrote: ==> On Fri, 20 May 2005 09:44:58 -0400, Paul Zarnowski <[EMAIL PROTECTED]> said: > Years ago, I actually went through the scenario you describe. We split the > DB mirror, and brought up TSM on only half of the mirrors, while we ran an > auditdb on the other half of the mirrors. [ And I mused about lvs... ...] Or I could just do chlv -n [newname] [oldname]. yeah, that'd work. - Allen S. Rout -- Paul Zarnowski Ph: 607-255-4757 719 Rhodes Hall, Cornell UniversityFx: 607-255-8521 Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED]
Re: Multiple TSM servers and their databases
Yes, that is correct. Each TSM server has it's own database. At 12:08 PM 5/20/2005, Coats, Jack wrote: If not clustered, they have separate databases and configured separately. One owns the library to the extent that it controls the robot. At least that is my understanding. I haven't done it. -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jon Evans Sent: Friday, May 20, 2005 11:04 AM To: ADSM-L@VM.MARIST.EDU Subject: Multiple TSM servers and their databases Hi all Quick question, which I know is in the manuals somewhere, but I need a quick answer and don't have time to look just now, so was hoping someone could point me in the right direction.. If I deployed multiple TSM servers all sharing the same Library, do they all have their own independent databases, or can they be configured with one as a master and the others all linked in somehow? I'm presuming that they are all independent and that data can only be moved between them via some move media or export / import function. Would that be a correct assumption? Many thanks in advance.. Jon Evans Storage Consultant KBR -- Paul Zarnowski Ph: 607-255-4757 719 Rhodes Hall, Cornell UniversityFx: 607-255-8521 Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED]
select syntax
Hello everyone! I run the report below to see the level of our nas toc disk pool and I was wondering if there is a way to also have another column called GB Utilized which multiplies total gb x percent utilized? I have tried this in so many different ways and I have not been successful. I'm not sure what I have been doing wrong, but it just won't work. Thank you in advance! select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized" from stgpools where stgpool_name='NAS_TOC' Results of report: Storage Pool Total GB Percent Utilized -- NAS_TOC 64 63.1 Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
weird request
Hi All, I received a weird request from potential customer. Because we will charge him per space occupied on our server, he wants to backup only files less than a year old. He doesn't want to go into each folder and try to find files that meet the criteria. I know that Arcserve has that filter option. I don't think that we can do it with TSM, but before give him an answer I thought I would check opinion of The List. Thanks in advance, Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com
Re: Virtual tape libraries
A 2 GB limit seems a bit restrictive, I wonder if that is a file system limit on the VTL. My VTL has no such restriction. When I installed my VTL I did not notice any change in TSM DB size due to an increase in the number of volumes. The amt of data per volume seems minimal. H. Milton Johnson -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Jon Evans Sent: Friday, May 20, 2005 5:02 AM To: ADSM-L@VM.MARIST.EDU Subject: Virtual tape libraries I have been experimenting with a virtual tape library connected to TSM (Windows 2k3 5.1.6.3 server) All seems to work perfectly and TSM is none the wiser. However, The maximum cartridge size in this virtual library is 2GB. I am currently using LTO1 and getting upto 100 times this amount of data on one tape. My database is 56GB and I currently have approx 600 volumes My question is.. if I were to move to a virtual library and had to increase the number of my volumes by up to 10 times What impact would this have on my database ? Thanks in advance Jon Evans Storage Consultant KBR
Re: select syntax
Sure, just add a column that multiples the two columns together (est_capacity_mb * pct_utilized) and divide by 1024.0 to get GB, and again by 100 (to express the pct_utilized as a fractional value): cast(est_capacity_mb * pct_utilized / 102400.0 as decimal(6,0)) as "Used GB" Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2005-05-20 10:16:40: > Hello everyone! > > I run the report below to see the level of our nas toc disk pool and I was > wondering if there is a way to also have another column called GB Utilized > which multiplies total gb x percent utilized? I have tried this in so many > different ways and I have not been successful. I'm not sure what I have > been doing wrong, but it just won't work. Thank you in advance! > > select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as > decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized" from > stgpools where stgpool_name='NAS_TOC' > > Results of report: > Storage Pool Total GB Percent Utilized > -- > NAS_TOC 64 63.1 > > > Joni Moyer > Highmark > Storage Systems > Work:(717)302-6603 > Fax:(717)302-5974 > [EMAIL PROTECTED] >
Re: select syntax
Try this, select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized", cast((EST_CAPACITY_MB*pct_utilized/100/1024) as decimal(15,2)) "total_data_by_GB" from stgpools where stgpool_name='NAS_TOC' I will throw out one i use for list of volumes select volume_name,stgpool_name,status,access,cast((EST_CAPACITY_MB/1024) as decimal(5,2)) as "Est_GB",pct_utilized, cast((EST_CAPACITY_MB*pct_utilized/100/1024) as decimal(5,2)) "total_data_by_GB" from volumes where STGPOOL_NAME='insert_ur_stg_pool' order by pct_utilized Sung Y. Lee "ADSM: Dist Stor Manager" wrote on 05/20/2005 01:16:40 PM: > Hello everyone! > > I run the report below to see the level of our nas toc disk pool and I was > wondering if there is a way to also have another column called GB Utilized > which multiplies total gb x percent utilized? I have tried this in so many > different ways and I have not been successful. I'm not sure what I have > been doing wrong, but it just won't work. Thank you in advance! > > select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as > decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized" from > stgpools where stgpool_name='NAS_TOC' > > Results of report: > Storage Pool Total GB Percent Utilized > -- > NAS_TOC 64 63.1 > > > Joni Moyer > Highmark > Storage Systems > Work:(717)302-6603 > Fax:(717)302-5974 > [EMAIL PROTECTED] >
Re: select syntax
Thanks Andy! It worked like a charm! I appreciate the help! Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] "Andrew Raibeck" <[EMAIL PROTECTED] OM>To Sent by: "ADSM: ADSM-L@VM.MARIST.EDU Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> Re: select syntax 05/20/2005 01:38 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> Sure, just add a column that multiples the two columns together (est_capacity_mb * pct_utilized) and divide by 1024.0 to get GB, and again by 100 (to express the pct_utilized as a fractional value): cast(est_capacity_mb * pct_utilized / 102400.0 as decimal(6,0)) as "Used GB" Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2005-05-20 10:16:40: > Hello everyone! > > I run the report below to see the level of our nas toc disk pool and I was > wondering if there is a way to also have another column called GB Utilized > which multiplies total gb x percent utilized? I have tried this in so many > different ways and I have not been successful. I'm not sure what I have > been doing wrong, but it just won't work. Thank you in advance! > > select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as > decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized" from > stgpools where stgpool_name='NAS_TOC' > > Results of report: > Storage Pool Total GB Percent Utilized > -- > NAS_TOC 64 63.1 > > > Joni Moyer > Highmark > Storage Systems > Work:(717)302-6603 > Fax:(717)302-5974 > [EMAIL PROTECTED] >
Re: weird request
There is no filtering option in TSM to do this. Using the age of a file to determine whether to back it up is, in my own opinion, ill-advised. If the customer does not care to back up these files, then why not simply "cut to the chase" and delete them? After all, if the disk were to be lost tomorrow, they wouldn't be recoverable. If the customer balks at the idea of deleting them outright, then that would suggest a re-think of the backup strategy (what would the customer's reaction be if someone actually did this?) The good news is that if the files don't change, TSM's incremental approach will only back them up once (okay, twice if you back up your storage pools, which is recommended). Of course, some of these files are probably junk or temporary files that are no longer needed, in which case it might be worthwhile to comb through those files and clean up the truly unneeded ones. Just my own thoughts on the subject. :-) Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" wrote on 2005-05-20 10:30:47: > Hi All, > > I received a weird request from potential customer. Because we will > charge him per space occupied on our server, he wants to backup only > files less than a year old. He doesn't want to go into each folder and > try to find files that meet the criteria. I know that Arcserve has that > filter option. > > I don't think that we can do it with TSM, but before give him an answer > I thought I would check opinion of The List. > > Thanks in advance, > > > Joe Crnjanski > Infinity Network Solutions Inc. > Phone: 416-235-0931 x26 > Fax: 416-235-0265 > Web: www.infinitynetwork.com >
Re: weird request
On May 20, 2005, at 1:30 PM, Joe Crnjanski wrote: Hi All, I received a weird request from potential customer. Because we will charge him per space occupied on our server, he wants to backup only files less than a year old. He doesn't want to go into each folder and try to find files that meet the criteria. I know that Arcserve has that filter option. I don't think that we can do it with TSM, but before give him an answer I thought I would check opinion of The List. In Unix you could readily do for the home directory this via: find ~ -mtime -365 -print > /tmp/files_list dsmc i -FILEList=/tmp/files_list (Resulting names containing spaces would require quoting; but that could be readily added via an appropriate command pipe-inserted between the 'find' and the redirect.) Something similar could be done in other environments. Another option for the user is the have the TSM client compress the data being sent to the TSM server. Yet another approach, even much simpler from the standpoint of the backup, is for the user to move his older, less relevant data into an oldies folder and Exclude that from backup. It's a common practice to move old data into a "back room" folder anyway. You could make it a site standard that user folders with a special oldies name would not be backed up, which would take care of things for this and similarly cheap users. The TSM client Expire command can be used to more quickly remove old stuff from server storage. Richard Sims
Re: q backup for SQL-BACKTRACK
Have you tried 'dsmc -virtualnode= . . .'? >>> [EMAIL PROTECTED] 05/20/05 11:02 AM >>> We have two clients on NT boxes with oracle databses. (One TSM install). One is the flat file backup, the 2nd with its own dsm.opt file is for SQl-BACKTRACK. We cannot query the backups on SQL-BACTRACK since the dsmc invokes with the flat file client dsm.opt ( and hence can't do a set access for SQL-BACKTRACK. Is there a way of invoking the dsmc for the SQL-BACTRACK client?
Re: Expiration / deletion of inactive files do not appear to be working for SQL-BACKTRACK
Then, since TSM see them all as still active, I'd guess that Backtrack is not expiring the files. David >>> [EMAIL PROTECTED] 05/20/05 11:05 AM >>> Yes, SQL-BACKTRACK is responsible for updating the status of the uniquely name file. >>> [EMAIL PROTECTED] 05/20/2005 10:43:53 AM >>> In TSM for Databases, each backup file has a unique name and rman is responsible for "deleting" them, thus triggering the TSM expiration cycle. Does Backtrack work the same way? >>> [EMAIL PROTECTED] 05/19/05 2:34 PM >>> Hi: We've just discovered q peculiar problem with expiration involing the SQL-BACKTRACK product and SYBASE and ORACLE databases. They do not appear to be expiring. The managment class rules are: DOMAIN_NAME CLASS_NAME VEREXISTS VERDELETED RETEXTRA RETONLY DESTINATION SPAIX DBBKUP1 60 0 30 0 AIXDISKBACK And a "query backup /BACKTRACK:obackups.physical/*/* -inactive" returns a HUGE list of files that are inactive. They should all have been deleted with the RETONLY set to 0. Am I missing something? A DB called SQL-BACKTRACK support and the responce was SQL-BACKTRACK marked them inactive; at that point TSM is not correctly removing them per the definitions. Flat files in other management groups are behaving correctly. API 5,242,880 B 10/15/03 02:54:53DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-10-2003.02:55:41-21544 API 5,242,880 B 11/15/03 02:59:13DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-11-2003.02:59:04-43356 API 5,242,880 B 12/15/02 02:55:59DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-12-2002.02:55:42-31662 API 5,242,880 B 12/15/03 02:50:43DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.15-12-2003.02:50:28-19182 API 5,242,880 B 01/16/03 03:03:22DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-01-2003.03:03:16-32618 API 5,242,880 B 01/16/04 02:57:23DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-01-2004.02:57:00-28874 API 5,242,880 B 02/16/03 02:48:22DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-02-2003.02:48:26-21274 API 5,242,880 B 02/16/04 02:48:41DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-02-2004.02:48:10-39458 API 5,242,880 B 03/16/03 02:50:47DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-03-2003.02:50:59-32472 API 5,242,880 B 03/16/04 02:54:33DBBKUP1 A /BACKTRACK:obackups.phy sical/BRSSBKUP/controlfiles-0.16-03-2004.02:54:33-33320 API 5,242,880 B 04/16/03 03:04:45DBBKUP1 A /BACKTRACK:obackups.phy >>> [EMAIL PROTECTED] 05/10/2005 9:27:12 AM >>> Mario, We've been using St. Bernard OFM 9 in conjuction with TSM 5.2.2 (client vers. of course) to backup both our GroupWise 6, and now GroupWise 6.5 servers in the last year without problems. We've also done successful restores of the GroupWise servers. >>> [EMAIL PROTECTED] 05/09/05 3:41 PM >>> Hi list, I need to perform an online backup of a Novell Groupwise environment using TSM ... does anybody knows how can I accomplish this ? Thanks. Mario Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html
Re: Poor LanFree performance / mixed LAN xfer??
Any clues in the dsmerror.log? >>> [EMAIL PROTECTED] 05/20/05 11:41 AM >>> Hello *SM'ers, Has anyone observed the following; We are experienceing performance problems with LanFree backups. The issue goes away with a retsart of the storage agent, but at some point in the future comes back, requiring another restart of the stoarge agent etc.. Now, when the backups are going OK, the following steps are observed, take note of what happens to the ByteCount (IE: the small cumulative indicator in the square brackets at the command line, '[12.3 G]') ; Backup started First directory entry sent Backup pauses, while byte count increments Backup generates 'unsuccesful' line, and then 'waiting for mount of offline media' ByteCount PAUSES When tape is mounted and wound, BYTECOUNT increases Very Fast. (+100 - 200MB / 'tick' ) Then end stats show simlar to; Total number of objects inspected:3 Total number of objects backed up:3 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted: 0 Total number of objects expired: 0 Total number of objects failed: 0 Total number of bytes transferred: 4.70 GB LanFree data bytes:4.70 GB Data transfer time: 153.13 sec Network data transfer rate:32,229.74 KB/sec Aggregate data transfer rate: 28,567.48 KB/sec Objects compressed by:0% Elapsed processing time: 00:02:52 ..NOTE, ALL data has gone LanFree Now, when the backups are performing slowly, the following occurrs; Backup started First directory entry sent Backup pauses, while byte count increments Backup generates 'unsuccesful' line, and then 'waiting for mount of offline media' ByteCount CONTINUES TO INCREMENT SLOWLY (+15-20 MB / 'tick') When tape is mounted and wound, BYTECOUNT INCREMENTS SLOWLY (+15 - 20MB / 'tick') At the end of backup, we see this; Total number of objects inspected:6 Total number of objects backed up:2 Total number of objects updated: 0 Total number of objects rebound: 0 Total number of objects deleted: 0 Total number of objects expired: 0 Total number of objects failed: 0 Total number of bytes transferred: 4.18 GB LanFree data bytes:2.37 GB Data transfer time: 42.01 sec Network data transfer rate:104,402.77 KB/sec Aggregate data transfer rate: 15,331.31 KB/sec Objects compressed by:0% Elapsed processing time: 00:04:46 Does this indicate, that in this instance some data went LanFree while some went LAN?? .. and what significance is the fact that the BYTECOUNT increases slowly while waiting for a mediamount, but it doesn't when the backup performs well? Puzzled; Matthew. Computer says 'No'.. ___ Disclaimer Notice __ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
Path from NAS to existing Library/Drives
We've attached a new NAS to an existing TSM system, with a 3584 and 6 3592s. Following the steps in Chapter 6 of the Admin Guide, everything went smoothly until step 6, Defining Tape Drives and Paths. Since the drives already exist in TSM it looks like all I should have to do is define the path from NAS to drive: def path nasbox tsmdrive srct=datamover destt=drive devi=name-supplied-by hardware-guy. This produced ANR1763E, i.e., Command Failed - see previous error messages. But there are none of those. I tried variations of case for the device name with the same result. However, when I went to the WebAdmin and tried, leaving off the device name and using the AutoDetect button, I got a success message - for all six drives. But q path f=d shows nothing in the device name. So, in my confusion, I ask, did I miss something when I used the CLI? or is there something amiss in the Admin Guide? are the paths really there and usable? Fred Johanson ITSM Administrator University of Chicago 773-702-8464
Re: Tape Stuck in Remote Status, but no longer used by library sharer; what to do?
Andy, et al. I have no solution, but found your email thread as I'm looking to solve exactly the same problem. It's a tough nut to crack! We have 6 tapes in a shared 3584 w/ exactly that problematic status: The Library Mgr TSM's VolHistory shows tape as PRIVATE,REMOTE owned by other TSM, but the other TSM's VolHist has long since finished with the tapes: two were obsolete DBB backups (probably cancelled/aborted) the other four show UNKNOWN in the devclass field (dunno why) I believe these tapes are stuck in a crack in the Share Library reality and are essentially lost unless someone knows now to remove the "useless and inappropriate" REMOTE records from the Library Mgr's VolHistory. If that can be accomplished, then we can UPDate LIBVolume STATUS=SCRatch to fix the problem. I've tried CHECKOut LIBVolume... at the Library Mgr TSM, but that didn't help. The Library Sharer TSM can not do the CHECKOut LIBVolume because the library is unknown. I think the tapes have fallen into a crack in TSM's reality. Anybody else have a better grip on this? If not, I'll open a PMR. -- [EMAIL PROTECTED] (203.432.6693) Andrew Carlson wrote: On Fri, 20 May 2005 09:27:39 -0500, Ochs, Duane <[EMAIL PROTECTED]> wrote: You can do a delete volume ## discard=yes. This will delete all references to data on that volume from the TSM database. I had the volume checked in. The volume now shows up in q libv: tsm: TSMLIBM>q libv 3584lib 110544 Library Name Volume Name Status Owner Last Use Home Device Element Type --- -- -- - --- -- 3584LIB 110544 Private TSMJ 1,0953592 But, since the volume does not show up in TSMJ (actually it was a database backup tape), I cannot delete it. Any ideas? -- Andy Carlson - Senior Technical Specialist BJC Healtcare --- Gamecube:$150,PSO:$50,Broadband Adapter: $35, Hunters License: $8.95/month, The feeling of seeing the red box with the item you want in it:Priceless.
