How much data in primary to pool since last backup?
Chaps, Easy question... We run a backup of our tape pool every day to our copy tape pool which we then send offsite. Can we tell how much data in the primary pool is to be backed up?...This way, we can see how much longer the backup stgpool will take.. Kind Regards, Roy Lake TBG European IT Tel: 0208 526 8883 E-Mail: [EMAIL PROTECTED] ** IMPORTANT INFORMATION ** This message is intended only for the use of the person(s) ("the Intended Recipient") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. The views in this message or it's attachments are that of the sender. If you are not the Intended Recipient please contact the sender and dispose of this email as soon as possible. If in doubt contact the Tibbett Britten European IT Helpdesk on 0870 607 6777 (UK) or +0044 870 607 6777 (Non UK).
informix slow level 0 backups ...
Hi *SM'ers ! I'm facing kind of strange behaviour of our Informix clients : everyday 5 AM informix servers are doing a level 0 (complete) backup of their Db, that goes directly to tape (LTO drives, in a 3584 library, connected on an IBM SAN data gateway 3108 G07 model) through a fiber channel network, and the problem is that the transfert rate varies randomly from an approx 7000 kbps to a 35 !!! kbps. Problem does'nt seem to come from the network, because the same machine at the same time is able to send its logical logs at a normal transfer rate, but on ssa disks this time. Did anybody face the same kind of problem, or does anybody have an idea to test or improve performance ? Thanks a lot for any precious advice ! Arnaud
Re: Longlasting tape-reclamation run
It would be nice if there was some documentation to explain the practical differences in the behaviour of (1) Reclaim (tape pool to itself) (2) Move Data (tape pool to itself) (3) Move Data (tape pool to disk pool) followed by Migrate (disk pool to tape pool) Geoff - Send email to the documentation folks, listed in the front of the manuals. If you haven't done it before, you will be very impressed at how responsive they are to good suggestions from the customer base. (Makes for full employment in the documentation department! :-) Richard Sims, BU
Servers freeze with Linux-Client on Kernel 2.4
Hi *SM'ers! We tried to Backup a Linux-Client with SuSE 7.1 , Kernel 2.4.x and TSM-CLient Version 4.1.1 (cause 4.1.2 doesn't Support national Characters). In both causes, per Scheduler or Command Line, the Server freezes without any Messages anywhere. Only a Hard Reset brings him up again. Does anyone have any other experiences. TO TIVOLI (developer technical support ?): Is the Problem known? Is support planned for Kernel 2.4.x (including REISERFS)an when? I feel confident that this will be important for a lot of TSM-Customers. For us it is. -- With regards / Mit freundlichen Gren ''~`` ( o o ) +--.oooO--(_)--Oooo.--+ | | | Leopold Hameder | | Heinrich Bauer Verlag | | Hamburg | |.oooO| |( ) Oooo.| +-\ (( )+ \_)) / (_/
Re: Servers freeze with Linux-Client on Kernel 2.4
We tried to Backup a Linux-Client with SuSE 7.1 , Kernel 2.4.x and TSM-CLient Version 4.1.1 (cause 4.1.2 doesn't Support national Characters). In both causes, per Scheduler or Command Line, the Server freezes without any Messages anywhere. I recall postings from about a year ago (see www.adsm.org), relating to server problems in conjunction with artifacts of the Linux system as conveyed by the client. You didn't specify the level of server you are sending to, but it may be the case that the server level is old and needs upgrading. In any case, if a server freezes due to anything coming from a client, it's defective and needs fixing: servers need to be robust, and be able to protect themselves from anything coming in from the network, be it legitimate traffic or malicious attack stuff. Richard Sims, BU
Re: Compression / No Compression ???
All this is why (if you do charge back) you simply charge the client by what the "auditocc" shows... Then if "THEY" take their processor time to compress their data they get a little bit of a charge break but if "THEY" don't take the time to compress their data, they end up paying more ! Or should I word that as You end up making a bigger profit ;-) Sure charge them for 20 or 40 GB of stored data, then compress it down to just 10 GB (or 1 3590 tape) What I've seen over time is that clients will use the money saved by using compression to buy more CPU's for their processors thus making backups run faster at night (by performing compression quicker) AND makes for a better running system during the day when they have their clients on their box ! but yet again, it all boils down to It depends ;-) Dwight -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 2:13 PM To: [EMAIL PROTECTED] Subject: Re: Compression / No Compression ??? I agree with Richard and Dwight. It depends. We have client compression on, I did a bit of testing, and sending client-compressed data on through the tape drive compression generally doesn't hurt us, but doesn't help much, either. In some simple tests I ran, we got at most an additional 10% compression on 3490 tape drives. The problem with TSM and figuring out what compression is doing, is that TSM only tells you what the CLIENT reports sending to it. It doesn't KNOW what the hardware compression is doing. You can't necessarily rely on the CAPACITY figures it reports for each volume. Assume, for the sake of simplicity, that the compression ratio is 2:1 for either client software compression, or your tape hardware compression. And assume your "native", or raw physical tape cartridge capacity is 20 GB. - On a client that has 40 GB of data to send, if compression is ON at the client, it will compress the data down to 20 GB, report 20 GB sent to the server, and the server will report to YOU that it sent 20 GB to the tape, and you will have 1 full tape. That tape volume will show "est capacity" at 20 GB. - On a client that has 40 GB of data to send, if compression is OFF at the client, it will report 40 GB sent to the server, and the server will tell you that it sent 40 GB to the tape, and you will still have exactly 1 full tape, since the hardware will compress the 40 GB down to 20 GB. That tape volume will show "est capacity" at 40 GB. If you have a mixture of clients compressing/ not compressing, you can't look at the "capacity" figures for your tape volumes and tell a darn thing. All you can do is make some controlled tests where you work with a specific client to send a specific set of data, and see how much data you can send to a tape before it fills up. Then you can assume you will get the same compression ratios on clients with similar data. -Original Message- From: Richard L. Rhodes [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 9:24 AM To: [EMAIL PROTECTED] Subject: Re: Compression / No Compression ??? Oracle db's are highly compressable. We run our Oracle backups through the unix compress utility. I've seen tablespace files on a newly created instance (no data loaded yet) compress from 1gb down to 10mb. A normal tablespace file full of data will tipically compress about 3-to-1. In general, data can only be compressed once. If you compress via sftw, like the unix compress utility or TSM's client then the drive hdwr compressions won't add anything. In this case you would basically get the native capacity of the tape drive onto a tape. We use 3590E drives with tapes that have 40gb native capacity. Our tapes that hold oracle backups generally end up with right around 40gb. Client side compression accomplishes the same thing. When hdwr compression is turned on, the tape drive tries to compress the datastream it receives from the tsm server. When not using client compression and not backing up already compressed files, the tape drive will attempt to compress the datastream. On the tapes with this kind of backups we get anywhere from 50gb up to 120gb. 120gb on a 40gb tape is a 3:1 compression ratio. An ORacle db will compress around 3 to 1. Client side compression takes cpu cycles and in general will result in a much slower backup but uses much less network bandwidth. Hdwr compression in the tape drive is very fast, much faster than client side compression (usually). The big argument is usually whether you should run your tape drive in compressed mode even if you send already compressed data to it (client side compression or just backing up .Z or .zip files). If you compress a datastream that is already compressed, the datastream will actually get bigger. Go ahead, run a unix compress on an existing .Z file. My answer is to always leave it ON. Modern compression chips used in tape drives can detect when data received by the drive is
Informix Onbar bug ?
Hi all, We are experiencing problems backing up our informix databases (version 724UC5X8). It seems (according to a trace that I've done) that the onbar process is not properly estimating the size of the db chunk that it wants to back up. What seems to be happening is that rootdbs gets backed up first (with the correct size estimate), then when the onbar process continues with the db0 chunk, it simply uses the same size estimate as the rootdbs.What is sometimes happening is that the size estimate directs the backup to the disk pool, but since the estimate is faulty, there is not enough room in the disk pool. I could send these backups directly to a tape pool, but we have many(20-30) small (1-3G) databases, and would prefer to fix the problem. Has anyone else ran into this problem ?I've noticed that someone was using SQL Backtrack for Informix backups. Is this why ? (Or simply the ability to parallelize the backups). Running TSM server 4.1.0 and client 4.1.2 Thanks, Glenn Glenn MacIntosh Manager of Technical Services Sobeys Inc. 123 Foord St. Stellarton, Nova Scotia (902) 752-8371 Ext. 4017
Re: Compression / No Compression ??? .. another view!
Just to Jump on the bandwagon... I backup with compression to a disk stgpool with later migration to tape... It whizzes away quite merrily and compression is saving network time and hard disk space on the server (thus allowing more clients to have almost instant file restores...) It works for me!! Tony Morgan Fortis Bank UK London -Original Message- From: Cook, Dwight E [mailto:[EMAIL PROTECTED]] Sent: 09 March 2001 12:57 To: [EMAIL PROTECTED] Subject: Re: Compression / No Compression ??? All this is why (if you do charge back) you simply charge the client by what the "auditocc" shows... Then if "THEY" take their processor time to compress their data they get a little bit of a charge break but if "THEY" don't take the time to compress their data, they end up paying more ! Or should I word that as You end up making a bigger profit ;-) Sure charge them for 20 or 40 GB of stored data, then compress it down to just 10 GB (or 1 3590 tape) What I've seen over time is that clients will use the money saved by using compression to buy more CPU's for their processors thus making backups run faster at night (by performing compression quicker) AND makes for a better running system during the day when they have their clients on their box ! but yet again, it all boils down to It depends ;-) Dwight -Original Message- From: Prather, Wanda [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 2:13 PM To: [EMAIL PROTECTED] Subject: Re: Compression / No Compression ??? I agree with Richard and Dwight. It depends. We have client compression on, I did a bit of testing, and sending client-compressed data on through the tape drive compression generally doesn't hurt us, but doesn't help much, either. In some simple tests I ran, we got at most an additional 10% compression on 3490 tape drives. The problem with TSM and figuring out what compression is doing, is that TSM only tells you what the CLIENT reports sending to it. It doesn't KNOW what the hardware compression is doing. You can't necessarily rely on the CAPACITY figures it reports for each volume. Assume, for the sake of simplicity, that the compression ratio is 2:1 for either client software compression, or your tape hardware compression. And assume your "native", or raw physical tape cartridge capacity is 20 GB. - On a client that has 40 GB of data to send, if compression is ON at the client, it will compress the data down to 20 GB, report 20 GB sent to the server, and the server will report to YOU that it sent 20 GB to the tape, and you will have 1 full tape. That tape volume will show "est capacity" at 20 GB. - On a client that has 40 GB of data to send, if compression is OFF at the client, it will report 40 GB sent to the server, and the server will tell you that it sent 40 GB to the tape, and you will still have exactly 1 full tape, since the hardware will compress the 40 GB down to 20 GB. That tape volume will show "est capacity" at 40 GB. If you have a mixture of clients compressing/ not compressing, you can't look at the "capacity" figures for your tape volumes and tell a darn thing. All you can do is make some controlled tests where you work with a specific client to send a specific set of data, and see how much data you can send to a tape before it fills up. Then you can assume you will get the same compression ratios on clients with similar data. -Original Message- From: Richard L. Rhodes [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 08, 2001 9:24 AM To: [EMAIL PROTECTED] Subject: Re: Compression / No Compression ??? Oracle db's are highly compressable. We run our Oracle backups through the unix compress utility. I've seen tablespace files on a newly created instance (no data loaded yet) compress from 1gb down to 10mb. A normal tablespace file full of data will tipically compress about 3-to-1. In general, data can only be compressed once. If you compress via sftw, like the unix compress utility or TSM's client then the drive hdwr compressions won't add anything. In this case you would basically get the native capacity of the tape drive onto a tape. We use 3590E drives with tapes that have 40gb native capacity. Our tapes that hold oracle backups generally end up with right around 40gb. Client side compression accomplishes the same thing. When hdwr compression is turned on, the tape drive tries to compress the datastream it receives from the tsm server. When not using client compression and not backing up already compressed files, the tape drive will attempt to compress the datastream. On the tapes with this kind of backups we get anywhere from 50gb up to 120gb. 120gb on a 40gb tape is a 3:1 compression ratio. An ORacle db will compress around 3 to 1. Client side compression takes cpu cycles and in general will result in a much slower backup but uses much less network bandwidth. Hdwr compression in the tape drive is very fast, much faster than client side
AS/400 Backup
Hi gurus. Our TSM server is an AIX 4.3. We have some AS/400 machines and we want back up them with our TSM server. Is it possible? Is there any As/400 client software for accomplish that backup ? Perhaps BRMS? Thanks in advance. Kindest regards Raul Giraldo Suarez. Bancolombia.
Re: Compression / No Compression ??? .. another view!
I had 32 Notes (No agent, just the standard Client) servers backing up over Token Ring. They all started the backups at the same time, and flooded the network (I didn't design it, and they wouldn't let me change things). Backups ran for over 6 hours. I turned on client compression (These were Pentium 100 boxes, 128 or 256MB RAM, running OS/2 Warp 3.0), and the backup window went down to 2 hours. Since the clients were always waiting for the token, they could compress "in the background" and save on the network transfer time. Along with the other testimonials, I guess this proves "It depends." Nick Cassimatis [EMAIL PROTECTED]
Re: AS/400 Backup
BRMS is the client for the AS400. I have used it to back up 3 AS400s. I wasn't thrilled with it. You still have to use BRMS for your scheduling, retention periods, object selections, and etc. All you do is point BRMS to use TSM as the tape device. You still have to deal with the control groups and policies in BRMS. TSM does nothing but writes the data to tape. Stephen Firmes, Storage Management Specialist Articulent Inc. 45 South Street, Hopkinton, MA 01748 P: 508-497-2500/F: 508-497-3464 Please visit our web site at www.articulent.com -Original Message- From: Raul Giraldo Suarez [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:16 AM To: [EMAIL PROTECTED] Subject: AS/400 Backup Hi gurus. Our TSM server is an AIX 4.3. We have some AS/400 machines and we want back up them with our TSM server. Is it possible? Is there any As/400 client software for accomplish that backup ? Perhaps BRMS? Thanks in advance. Kindest regards Raul Giraldo Suarez. Bancolombia.
Re: Not Server but CLIENT freeze with TSM-Client on Kernel 2.4
Sorry, I confused the terms. Not the TSM-Server freezes but the "Server" on which the client runs. My TSM-Server (Version 4.1.2) works fine. Richard Sims wrote: We tried to Backup a Linux-Client with SuSE 7.1 , Kernel 2.4.x and TSM-CLient Version 4.1.1 (cause 4.1.2 doesn't Support national Characters). In both cases, per Scheduler or Command Line, the Server freezes without any Messages anywhere. I recall postings from about a year ago (see www.adsm.org), relating to server problems in conjunction with artifacts of the Linux system as conveyed by the client. You didn't specify the level of server you are sending to, but it may be the case that the server level is old and needs upgrading. In any case, if a server freezes due to anything coming from a client, it's defective and needs fixing: servers need to be robust, and be able to protect themselves from anything coming in from the network, be it legitimate traffic or malicious attack stuff. Richard Sims, BU -- With regards / Mit freundlichen Gren ''~`` ( o o ) +--.oooO--(_)--Oooo.--+ | | | Leopold Hameder | | c.a.r.u.s. Information Technology AG | | | |.oooO| |( ) Oooo.| +-\ (( )+ \_)) / (_/
Possible Bill-Back methods
Hello all, I currently in the process of creating a bill-back matrix for my off-site clients. I am curious to see if there are "industry standards" for a formula that I can use. Below are some of the questions in particular. 1. Do you charge per GB of total storage? If so, what is a good price to charge? 2. Do you charge for Network use / transfer time. 3. I am also planning on putting in a support fee for restores and misc. work. Any discussion on this would be greatly appreciated. Best Regards, Blaine [EMAIL PROTECTED]
DLT Library and drives
Hello everybody !! I have a DLT Library Compaq with to tapes and I need if this is soported by TSM v.3.7 The TSM reconize the library as HP C5173 - 7000 and the tapes as Quantum DLT 7000 CPQ. All the machines, are instelled in a NT4 What element number I can assign, because I start the device configuracion, I dont have this model. Thank you very much. Christian Astuni IBM Gobal Services [EMAIL PROTECTED] Tel. # 4898-4621 - Cel. # 15 4494-2315 Hipolito Yrigoyen 2149 - Martnez (1640) Bs. As. - Argentina
Compression/No Compression...the story continues findings.....
Hi Chappies, After having fiddled with the compression settings over the last few days, here are my findings:- But seriously folks, after testing all of the various options, here are my findings:- NO Compression:- Setting this option, shaved 25 minutes off of the total backup time for our main Oracle database, but bizarrely had NO effect on others, and we used the same amount of tapes when doing the storage pool backups. DRIVE Compression Using this option, cut 28 minutes off of the total backup time for our main Oracle database, 23 minutes off of another DB, and 29 minutes off of another, and we used 1 less tape when doing the storage pool backups (this is arguable though, as the number of tapes we use can go up or down 1 or 2, depending on drive errors, etc). Under the original circumstances where CLIENT compression was used, this obviously took more time, as it was compressing the data BEFORE sending it to the server. As I said earlier this week though, there IS a negative side to all of this, in that the storage pool backups (copies of our main storage pools that get sent offsite for DR purposes) now take 4 hours, where typically it used to take 2 hours. Interestingly enough, migration from DISK storage pool to tape storage pool is NOT affected. So, as you can see, it's a question of what is preferred - quicker COLD backup times balanced against crippling storage pool backup times. One thing you can rely on though - DONT rely on the "Estimated Capacity" figure of a tape in TSM - it actually means very little Thanks to everyone for their input!!! Kind Regards, Roy Lake TBG European IT Tel: 0208 526 8883 E-Mail: [EMAIL PROTECTED] ** IMPORTANT INFORMATION ** This message is intended only for the use of the person(s) ("the Intended Recipient") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. The views in this message or it's attachments are that of the sender. If you are not the Intended Recipient please contact the sender and dispose of this email as soon as possible. If in doubt contact the Tibbett Britten European IT Helpdesk on 0870 607 6777 (UK) or +0044 870 607 6777 (Non UK).
Re: How much data in primary to pool since last backup?
You could run a backup stg command prior to running your normal backup stg and that would give you the total amount of data that needs to be copied from one storage pool to another. The command would be: ba stg tapepool copypool preview=yes maxpr=1 wait=no (or wait=yes) This would give you one process that would tell you the total amount of data that needs to be backed up from one to another and then you could watch you real ba stg process to see how much data they have accually moved. The preview does not require tape mounts so it is preaty fast. I use it on occassion to see how much data was written directly to tape (since I have backups that go to disk and to tape) -Original Message- From: Roy Lake [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 1:34 AM To: [EMAIL PROTECTED] Subject: How much data in primary to pool since last backup? Chaps, Easy question... We run a backup of our tape pool every day to our copy tape pool which we then send offsite. Can we tell how much data in the primary pool is to be backed up?...This way, we can see how much longer the backup stgpool will take.. Kind Regards, Roy Lake TBG European IT Tel: 0208 526 8883 E-Mail: [EMAIL PROTECTED] ** IMPORTANT INFORMATION ** This message is intended only for the use of the person(s) ("the Intended Recipient") to whom it is addressed. It may contain information which is privileged and confidential within the meaning of applicable law. Accordingly any dissemination, distribution, copying or other use of this message or any of its content by any person other than the Intended Recipient may constitute a breach of civil or criminal law and is strictly prohibited. The views in this message or it's attachments are that of the sender. If you are not the Intended Recipient please contact the sender and dispose of this email as soon as possible. If in doubt contact the Tibbett Britten European IT Helpdesk on 0870 607 6777 (UK) or +0044 870 607 6777 (Non UK).
incl.excl.list
I do not want to backup a filesystem named /export/home/infra_old and edited the incl.excl.list to look like this: exclude.dir /tmp exclude.dir /cdrom exclude.dir /export/home/infra_old But when the backup schedule runs, it is still backing up this filesystems. I also stop the sched and re-started it after editing the incl.excl.list. Why is it still backing up export/home/infra_old? Regards, Long _ Get your FREE download of MSN Explorer at http://explorer.msn.com
Re: MVS : 'IEC510D' reply 'U' or 'F' msg during backup storagepool
Someone is moving the write protect tab on the cartridge to write protect, by doing this you will be asked to verify if you really want to write on this tape. Just move the write protect tab to read/write on the cartridge and you should be fine. Paul Van de Vijver Paul.Van.De.Vijver@HONTo: [EMAIL PROTECTED] DA-EU.COM cc: Sent by: "ADSM: Dist Subject: MVS : 'IEC510D' reply 'U' or 'F' msg Stor Manager" during backup storagepool [EMAIL PROTECTED] 03/09/2001 09:27 AM Please respond to "ADSM: Dist Stor Manager" Hi all, During Backup Storagepool (from STK robot towards Magstar robot) and also during space reclamation we often get next message : IEC510D F 0944,H06190,ADSM,ADSM,ADSM.BFS *41 IEC510D REPLY 'U'-USE OR 'F'-UNLOAD Explanation: F indicates that the tape volume indicated on the device is file-protected. That is, a program may be attempting to write on the volume but its file-protection ring is not inserted or the tab is set to prevent a write, so it can only be read. This msg is issued on INPUT vols and means that vol is write-protected (although it isn't !!!) and that it should be writable (although it is only input ???) This is very ennoying for the operators, because they have to respond each time to the msg Has anybody experienced the same problem and what can I do to solve it ? We are still running ADSM Server 3.1.2.40 (upgrade to TSM planned in the near future) Thanks for any help, Paul Van de Vijver TS Group, IS Dept Honda Europe Belgium
Library capacity
Hello all, My current setup, H50, 3494LIB, 4 3590's, 7133 D40, is beginning to come to a point where I need more capacity, or so I feel. I would like for the company to order the next section of library, 2 3494's, memory for the computer, DASD and a few other bits now, but I found out yesterday it won't happen till Q4. Now I believe I may have a problem with this but without a way for me to estimate how much the system will grow in relation to what I have available I can't very well push them to order sooner. With all the knowledge I have at my disposal, and I don't mean my own, that's where you all come in, I'm looking for some commands within AIX or TSM to get the information I need. Is there a way to find out how many slots the 3494 has, total, used and available? Sure I could start counting...no, forget that idea Commands for this would help greatly. Now with that figured out I'm looking to see if there is a way to figure out how many tapes are used each day, for onsite and offsite, as opposed to how many tapes are reclaimed/returned. If I could run this each day for a month and maybe backdate it if possible, I might come up with an idea when we would hit the wall. Taking into account the library is shared with MVS, which has 2 drives of it's own, I would have to factor in their info if I could get it. I have Exchange and another group who want access now, which would put an additional load on what I already have. So keeping in mind those could get implemented before I get more space, I could very well run out even quicker than expected. My own feeling is, even without the additional computers, I'll run out of space before Q4. Thanks for the help, Geoff Gill NT Systems Support Engineer SAIC Computer Systems Group E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
Re: Library capacity
Issue the following from your H50. mtlib -l/dev/lmcp0 -qL Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Gill, Geoffrey L. [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 10:24 AM To: [EMAIL PROTECTED] Subject: Library capacity Hello all, My current setup, H50, 3494LIB, 4 3590's, 7133 D40, is beginning to come to a point where I need more capacity, or so I feel. I would like for the company to order the next section of library, 2 3494's, memory for the computer, DASD and a few other bits now, but I found out yesterday it won't happen till Q4. Now I believe I may have a problem with this but without a way for me to estimate how much the system will grow in relation to what I have available I can't very well push them to order sooner. With all the knowledge I have at my disposal, and I don't mean my own, that's where you all come in, I'm looking for some commands within AIX or TSM to get the information I need. Is there a way to find out how many slots the 3494 has, total, used and available? Sure I could start counting...no, forget that idea Commands for this would help greatly. Now with that figured out I'm looking to see if there is a way to figure out how many tapes are used each day, for onsite and offsite, as opposed to how many tapes are reclaimed/returned. If I could run this each day for a month and maybe backdate it if possible, I might come up with an idea when we would hit the wall. Taking into account the library is shared with MVS, which has 2 drives of it's own, I would have to factor in their info if I could get it. I have Exchange and another group who want access now, which would put an additional load on what I already have. So keeping in mind those could get implemented before I get more space, I could very well run out even quicker than expected. My own feeling is, even without the additional computers, I'll run out of space before Q4. Thanks for the help, Geoff Gill NT Systems Support Engineer SAIC Computer Systems Group E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
Re: Informix Onbar bug ?
We have been sucessfully using the ONTAPE version of SQL BackTrack for Informix V 2.1. According to the local historians, we bought this bought SQL B for I in order to do table backups. Unfortunately the Informix server has to be down to do this so we never used that feature. The other negative is that there is no facility to expire the backups... they just keep growing until you get in and delete them fileset by fileset. Anyway, along comes 3.0. This version uses ONBAR and CAN do table by table backups on the fly. It is also supposed to be capable of expiring stuff but I can't get that feature to work. It is also totally incompatible with the backups done with 2.1 so if you have the need to do a restore, you will have to keep the 2.1 version on your client and link up to it if an older backup (made under 2.1) needs to be restored... I am begging my boss to get us a copy of TDP for Informix for eval... One other note... not many folks are using SQL BackTrack for Informix and BMC is NOT repeat NOT able to support it well and the documentation is HORRIBLE... Our INFORMIX level is 731UC2. We run it with DataMart, PeopleSoft and Lawson applications. George Lesho Storage / System Admin AFC Enterprieses Glenn MacIntosh [EMAIL PROTECTED] on 03/09/2001 07:00:30 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Informix Onbar bug ? Hi all, We are experiencing problems backing up our informix databases (version 724UC5X8). It seems (according to a trace that I've done) that the onbar process is not properly estimating the size of the db chunk that it wants to back up. What seems to be happening is that rootdbs gets backed up first (with the correct size estimate), then when the onbar process continues with the db0 chunk, it simply uses the same size estimate as the rootdbs.What is sometimes happening is that the size estimate directs the backup to the disk pool, but since the estimate is faulty, there is not enough room in the disk pool. I could send these backups directly to a tape pool, but we have many(20-30) small (1-3G) databases, and would prefer to fix the problem. Has anyone else ran into this problem ?I've noticed that someone was using SQL Backtrack for Informix backups. Is this why ? (Or simply the ability to parallelize the backups). Running TSM server 4.1.0 and client 4.1.2 Thanks, Glenn Glenn MacIntosh Manager of Technical Services Sobeys Inc. 123 Foord St. Stellarton, Nova Scotia (902) 752-8371 Ext. 4017
Re: incl.excl.list
Do you have any include statements? List the entire include/exclude statement. Also, do you have and Client Option Files Active that might override the inc/exc list? Long Nguyen adsm_lm@HOTMTo: [EMAIL PROTECTED] AIL.COM cc: Sent by: Subject: incl.excl.list "ADSM: Dist Stor Manager" [EMAIL PROTECTED] RIST.EDU 03/09/2001 11:11 AM Please respond to "ADSM: Dist Stor Manager" I do not want to backup a filesystem named /export/home/infra_old and edited the incl.excl.list to look like this: exclude.dir /tmp exclude.dir /cdrom exclude.dir /export/home/infra_old But when the backup schedule runs, it is still backing up this filesystems. I also stop the sched and re-started it after editing the incl.excl.list. Why is it still backing up export/home/infra_old? Regards, Long _ Get your FREE download of MSN Explorer at http://explorer.msn.com
Re: SQL Backtrack Restore
It's been our experience that you need a valid control file to do such a move. We such a move every week via a script that crossmounts a control file from machine to machine. At 08:06 AM 3/9/2001 -0800, you wrote: Can backups that were created via SQLBACKTRACK be restored to a different client using the TSM fromnode feature? If yes, what would the 'set access' command be on the source client? Jim Taylor Senior Associate, Technical Services Enlogix * E-mail: [EMAIL PROTECTED] * Office: (416) 496-5264 ext. 286 * Cell: (416)458-6802 * Fax: (416) 496-5245
Re: SQL Backtrack Restore
Jim, I use SQL BackTrack for Informix to restore backups made on one node to another using the virtualnodename parameter set to the source machine's name and placed into the target machine's dsm.opt file. Since you didn't specify which SQL BackTrack product you are using and I don't know if all of them work the same way, I can't give you any more info. If you are using the SQL BackTrack for Informix product, let me know and I will describe the steps to backing up on one machine and restoring to another... Lot of small details to get a sucsessful restore... George Lesho Storage/System Admin AFC Enterprises Jim Taylor [EMAIL PROTECTED] on 03/09/2001 10:06:06 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: SQL Backtrack Restore Can backups that were created via SQLBACKTRACK be restored to a different client using the TSM fromnode feature? If yes, what would the 'set access' command be on the source client? Jim Taylor Senior Associate, Technical Services Enlogix * E-mail: [EMAIL PROTECTED] * Office: (416) 496-5264 ext. 286 * Cell: (416)458-6802 * Fax: (416) 496-5245
Re: AS/400 Backup
You can use BRMS from IBM or RobotSave from Help Systems. You need the AS/400 API installed on the AS/400. We had two as/400 backing up to TSM both working but one was very slow (640 with 100mb card). The 830 w/gb ethernet is as fast as any other client that I have (11.3GB is 30 minutes). Not sure if this is the processor or the ethernet card since the 640 does not have a gig card. I think this just shows that if you through the hardware at it it will work but if you don't it is very slow. You must configure everything on the AS/400 side and you just register the node in TSM. -Original Message- From: Steve Firmes [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 6:27 AM To: [EMAIL PROTECTED] Subject: Re: AS/400 Backup BRMS is the client for the AS400. I have used it to back up 3 AS400s. I wasn't thrilled with it. You still have to use BRMS for your scheduling, retention periods, object selections, and etc. All you do is point BRMS to use TSM as the tape device. You still have to deal with the control groups and policies in BRMS. TSM does nothing but writes the data to tape. Stephen Firmes, Storage Management Specialist Articulent Inc. 45 South Street, Hopkinton, MA 01748 P: 508-497-2500/F: 508-497-3464 Please visit our web site at www.articulent.com -Original Message- From: Raul Giraldo Suarez [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:16 AM To: [EMAIL PROTECTED] Subject: AS/400 Backup Hi gurus. Our TSM server is an AIX 4.3. We have some AS/400 machines and we want back up them with our TSM server. Is it possible? Is there any As/400 client software for accomplish that backup ? Perhaps BRMS? Thanks in advance. Kindest regards Raul Giraldo Suarez. Bancolombia.
Re: Management Class Question
Jeff, I think what will happen if you zap the management classes within a policy domain, data that was backed up or archived under the zapped managment classes will be expired per the rules for the policy domain default management class first for backups and archives. If you do not have a default management class, then it would go by the policy domain grace period. George Lesho Storage/System Admin AFC Enterprises Jeff Rankin [EMAIL PROTECTED] on 03/08/2001 09:43:15 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Management Class Question We are looking at doing a massive reorganization of our naming standards within our TSM servers. During this reorganization, some management class we have will go away and new ones will be created. Others will just be renamed. I know that in order to bind data to a specific management class I can just use the include statement for the clients and that will start backing up or archive files to the new management class assignments, but my question is what happens to the old data that is already backed up to the TSM server? Will it be rebound to the new management classes or will it fall into the grace period retention of the policy domains? If the policy domain is what controls the data retention in this case, would it just be safer to leave all of the existing management classes in place and just start backing up with the new management classes and let the old data expire off? We are running TSM 4.1.2. Any help would be greatly appreciated. -- Jeff Rankin Associate Technical Analyst, Excel Corporation Phone: 316-291-2903 Fax: 316-266-4415 Email: [EMAIL PROTECTED]
SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- TSM TDP for Oracle
People, I am wondering if anyone has any experience with this stuff. I am really interested in both Oracle and SQL Server! 1) Does SQL-Backtrack backup directly into TSM without having to use/buy the TSM TDP for Oracle/SQL Server ? 2) Can you do a HOT backup of the Oracle/SQL Server database ? 3) Is it slick ... does it work well ? Thank you, Larry
Re: Runaway dsmserv
Not sure why you would see runaway dsmserv processes on your clients... dsmserv process is a server process... if you are pegging a CPU, any process may be the culprit... memory leaks will cause this sort of behaviour. Suggest you do a ps and grep for "defunct" when the CPU utilization starts to soar... George Lesho Storage/System Admin AFC Enterprises Jeff J Coskey [EMAIL PROTECTED] on 03/08/2001 08:28:29 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: Runaway dsmserv Rick, I too have seen this occuring at many of my clients. What I can surmise is that you get runaway sessions appearing with a ? when you do a 'q sess'. If you can cancel these, then you will see that the dsmserv process CPU utilization drops back down dramatically. I have played around a little with idletimeout but I'm not sure if this is the correct solution. Can someone from Tivoli provide feedback on this one? I've seen the CPU shoot up to 100% even on SP nodes and 4-way S7A machines with lots of memory. It will cause the machine to start thrashing. There should be a cleaner, more automated solution instead of having to reboot the server or manually canceling the runaway sessions. Thanks, Jeff Coskey IBM Global Services Server and Storage Solutions 3109 W. Dr. Martin L. King Jr. Blvd, Tampa, FL 33607 Phone: (813) 801-3868 T/L: 427-3868 Cell: (813) 495-6923 Pager: (800) 759- pin: 1201907 Email: [EMAIL PROTECTED] "Richard L. Rhodes" [EMAIL PROTECTED]@VM.MARIST.EDU on 03/08/2001 04:10:04 AM Please respond to [EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Runaway dsmserv Were having a strange problem. Over a period of several weeks we saw the cpu utilization of dsmserv rise to the point it was running our AIX server at 100% utilization. It was running at 100% utilization even whan nothing was happening on the server - no backups, migration, reclamation, etc. We called support - they suggested we reboot our server, which was our idea also. After the reboot, everything seemed back to normal. Now, a week after the reboot, dsmserv is running a constant 50% of our server, reguardless of what's happening. We're going to cycle dsmserv this afternoon after batch processing. Then, call support, again. Is anyone else seeing this kind of behavior? Rick
TAPE DEFINITION LOST
TSM spit out a tape this morning with it's DRM offsite tapes. I can not find where it is defined to our server by doing a q libv or a q vol. When I try to check it in or redefine it to the server it says that it is already defined or that it contains export data. What does this mean? How do I get this tape back?
Re: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- T SM TDP for Oracle
We are currently using SQL Backtrack on our production database and TDP for SAP R/3 on development systems migrating to TDP on all. In answer to your questions 1) Yes SQL Backtrack goes directly into TSM 2) Yes you can do a hot backup. We do a 1 T database hot every night 3) Hate it. We have problems with just about everything with it. Setting it up is an issue. Upgrading versions has caused us problems. Getting support has caused us major problems because there is a tendency to not fully look into the problem and just immediately blame it on TSM. If there is a tape error it does not retry very well and the entire backup fails. We have had problems with SQL Backtrack doing it's own expiration. The licensing scheme is done on the size of your database. I suppose that is ok if your database doesn't grow much but ours does so you have to get a license at 250, 500, 750, 1200 which of course costs significantly more. For us financially TDP is the better solution. The installation is easier and support has been better. We have also had fewer problems with it. Then again we are also using TDP for SAP R/3 so I am not sure if TDP for Oracle is better or worse. That's my .02 Becky Davidson Data Manager/AIX Administrator EDS/Earthgrains voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED] -Original Message- From: Larry Girardi [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 11:30 AM To: [EMAIL PROTECTED] Subject: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- TSM TDP for Oracle People, I am wondering if anyone has any experience with this stuff. I am really interested in both Oracle and SQL Server! 1) Does SQL-Backtrack backup directly into TSM without having to use/buy the TSM TDP for Oracle/SQL Server ? 2) Can you do a HOT backup of the Oracle/SQL Server database ? 3) Is it slick ... does it work well ? Thank you, Larry
Re: TAPE DEFINITION LOST
q volhist type=export will show if it is an export tape. type=all will show all, but that list can be long so pipe it to a file and search for that volser to find out what kind of tape it is. Kelly J. Lipp Storage Solutions Specialists, Inc. PO Box 51313 Colorado Springs CO 80949-1313 (719) 531-5926 Fax: (240) 539-7175 Email: [EMAIL PROTECTED] or [EMAIL PROTECTED] www.storsol.com www.storserver.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Hicks Sent: Friday, March 09, 2001 10:35 AM To: [EMAIL PROTECTED] Subject: TAPE DEFINITION LOST TSM spit out a tape this morning with it's DRM offsite tapes. I can not find where it is defined to our server by doing a q libv or a q vol. When I try to check it in or redefine it to the server it says that it is already defined or that it contains export data. What does this mean? How do I get this tape back?
Novell 3.12 question with TSM
We have upgraded our TSM server from 3.1.2.20 to version 4.1.0 Since I have done this, I have the following error on all the 3.12 command screens: TCPIP- 4.0-235: Number of connections in syn-received state on port 1501 has exceeded the maximum (16) allowed by the application. Could be due to a possible syn attack. TCPIP is trying to compensate by deleting all half-open connections. Although it does not appear to be causing me any problems in the backups, the network guys don't like the error. I can't find any documentation on requirements for any certain Novell pieces. I have not upgraded the Novell client yet it is still at 3.1.06 [EMAIL PROTECTED]
passwd problem
Has anyone seen this when setting up a new udb client. TSM version 3.1. Any help would be greatly appreciated. dsmc q sess Node Name: XX-UDB ANS0110E LogMsg: Unable to open error log file 'dsmerror.log' for output. LogMsg: The file access permissions do not allow the specified action. ANS1503E Valid password not available for server 'TSM1-UDB'. The ADSM administrator for your system must run ADSM and enter the password to store it locally. dsmc
Re: Possible Bill-Back methods
We bill out for a few clients that we backup for another internal division. Real high level: Total amount of capacity / total$ for the hardware (including maint charges) + total$ for the software + total$ for the media + labor$ + $$ amount of square footage we consume in the datacenter for the hardware to sit there = our rate charged per GB stored per month to each client that wants the service. Curt Magura Lockheed Martin EIS Gaithersburg, Md. 301-240-6305 -Original Message- From: Blaine Gilbreath [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 9:45 AM To: [EMAIL PROTECTED] Subject: Possible Bill-Back methods Hello all, I currently in the process of creating a bill-back matrix for my off-site clients. I am curious to see if there are "industry standards" for a formula that I can use. Below are some of the questions in particular. 1. Do you charge per GB of total storage? If so, what is a good price to charge? 2. Do you charge for Network use / transfer time. 3. I am also planning on putting in a support fee for restores and misc. work. Any discussion on this would be greatly appreciated. Best Regards, Blaine [EMAIL PROTECTED]
Re: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- T SM TDP for Oracle
Becky, Thank you! That is what I needed (the straight poop!). Does anyone have a differing opinion or additional experience? Thanks again, Larry "Davidson, Becky" [EMAIL PROTECTED] on 03/09/2001 12:36:57 PM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Larry Girardi/IS/Travelers) Subject: Re: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- T SM TDP for Oracle We are currently using SQL Backtrack on our production database and TDP for SAP R/3 on development systems migrating to TDP on all. In answer to your questions 1) Yes SQL Backtrack goes directly into TSM 2) Yes you can do a hot backup. We do a 1 T database hot every night 3) Hate it. We have problems with just about everything with it. Setting it up is an issue. Upgrading versions has caused us problems. Getting support has caused us major problems because there is a tendency to not fully look into the problem and just immediately blame it on TSM. If there is a tape error it does not retry very well and the entire backup fails. We have had problems with SQL Backtrack doing it's own expiration. The licensing scheme is done on the size of your database. I suppose that is ok if your database doesn't grow much but ours does so you have to get a license at 250, 500, 750, 1200 which of course costs significantly more. For us financially TDP is the better solution. The installation is easier and support has been better. We have also had fewer problems with it. Then again we are also using TDP for SAP R/3 so I am not sure if TDP for Oracle is better or worse. That's my .02 Becky Davidson Data Manager/AIX Administrator EDS/Earthgrains voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED] -Original Message- From: Larry Girardi [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 11:30 AM To: [EMAIL PROTECTED] Subject: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- TSM TDP for Oracle People, I am wondering if anyone has any experience with this stuff. I am really interested in both Oracle and SQL Server! 1) Does SQL-Backtrack backup directly into TSM without having to use/buy the TSM TDP for Oracle/SQL Server ? 2) Can you do a HOT backup of the Oracle/SQL Server database ? 3) Is it slick ... does it work well ? Thank you, Larry
Re: Runaway dsmserv
I've been plagued by these too, but only with web browser connections. Tivoli has played ignorant about it for the past year so now I just use the command line interface. John Mills -Original Message- From: George Lesho [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Runaway dsmserv Not sure why you would see runaway dsmserv processes on your clients... dsmserv process is a server process... if you are pegging a CPU, any process may be the culprit... memory leaks will cause this sort of behaviour. Suggest you do a ps and grep for "defunct" when the CPU utilization starts to soar... George Lesho Storage/System Admin AFC Enterprises Jeff J Coskey [EMAIL PROTECTED] on 03/08/2001 08:28:29 AM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: Runaway dsmserv Rick, I too have seen this occuring at many of my clients. What I can surmise is that you get runaway sessions appearing with a ? when you do a 'q sess'. If you can cancel these, then you will see that the dsmserv process CPU utilization drops back down dramatically. I have played around a little with idletimeout but I'm not sure if this is the correct solution. Can someone from Tivoli provide feedback on this one? I've seen the CPU shoot up to 100% even on SP nodes and 4-way S7A machines with lots of memory. It will cause the machine to start thrashing. There should be a cleaner, more automated solution instead of having to reboot the server or manually canceling the runaway sessions. Thanks, Jeff Coskey IBM Global Services Server and Storage Solutions 3109 W. Dr. Martin L. King Jr. Blvd, Tampa, FL 33607 Phone: (813) 801-3868 T/L: 427-3868 Cell: (813) 495-6923 Pager: (800) 759- pin: 1201907 Email: [EMAIL PROTECTED] "Richard L. Rhodes" [EMAIL PROTECTED]@VM.MARIST.EDU on 03/08/2001 04:10:04 AM Please respond to [EMAIL PROTECTED] Sent by: "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Runaway dsmserv Were having a strange problem. Over a period of several weeks we saw the cpu utilization of dsmserv rise to the point it was running our AIX server at 100% utilization. It was running at 100% utilization even whan nothing was happening on the server - no backups, migration, reclamation, etc. We called support - they suggested we reboot our server, which was our idea also. After the reboot, everything seemed back to normal. Now, a week after the reboot, dsmserv is running a constant 50% of our server, reguardless of what's happening. We're going to cycle dsmserv this afternoon after batch processing. Then, call support, again. Is anyone else seeing this kind of behavior? Rick
Archive of file lists
Presently, we have scripts that break our DB into x groups of files. A dsmc arch command is issued against each file in the group one at a time. We are therefore using x streams of dsmc arch commands to archive the db. This seems like a lot of overhead, spawning a separate dsmc session per file. QUESTION: Is there a way to pass a file list to the dsmc arch command in place of the file spec? I know that I can issue the file names separated by commas, however I run into a problem with the length of the command. Any help would be appreciated. Jim Taylor Senior Associate, Technical Services Enlogix * E-mail: [EMAIL PROTECTED] * Office: (416) 496-5264 ext. 286 * Cell: (416)458-6802 * Fax: (416) 496-5245
Re: Archive of file lists
QUESTION: Is there a way to pass a file list to the dsmc arch command in place of the file spec? Jim - No. Parameter handling is just basic programming, and yet the command line clients remain incredibly primitive in this regard, to the great frustration of the customer base. I'm dismayed that the people directing development have left the command line clients as lame as they are. It's embarassing to the product. Richard Sims, BU
cache migrated files
I'm hoping I did this correctly but need to ask. I have a disk pool that I want some data to remain on for the sake of it being readily available without mounting multiple tapes. This is just directory information if anyone is curious. I defined the pool, and set cache migrated files=yes. I do need to make sure this data is put in the offsite pool as well, and to a tape pool that remains in the library for backup purposes. The disk pool is set to migrate, but with set cache files=yes, I'm assuming it will remain on disk as well as be copied to onsite and offsite pools...I did define that too...properly I hope I was sure the percent used yesterday was 0.7 but at the moment I see it's 0.5 after the migration finished. Not sure why this happened yet but maybe someone could shed some light. Is there a way I can compare what is on the tape to what's on the disk pool? Is my assumption correct or will it make me the other part of *ass*umption? Geoff Gill NT Systems Support Engineer SAIC Computer Systems Group E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
archive
Good Day everyone! I'm running TSM 3.7.4 on the server ( AIX 4.3.3-06) and 3.7.2 on the client (AIX 4.3.3-06). I'm looking for a way to archive files that are already "inactive" on TSM. I'm trying to avoid restoring the data to disk and then archiving back to TSM. Any help would be greatly appreciated! Thanks, Laura Galvin IMPORTANT: The security of electronic mail sent through the Internet is not guaranteed. Legg Mason therefore recommends that you do not send confidential information to us via electronic mail, including social security numbers, account numbers, and personal identification numbers. Delivery, and timely delivery, of electronic mail is also not guaranteed. Legg Mason therefore recommends that you do not send time-sensitive or action-oriented messages to us via electronic mail, including authorization to "buy" or "sell" a security or instructions to conduct any other financial transaction. Such requests, orders or instructions will not be processed until Legg Mason can confirm your instructions or obtain appropriate written documentation where necessary.
Re: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- T SM TDP for Oracle
We use SQL BackTrack for Informix and my experience is idential with Becky's... sent her comments to my co-workers and they got a good chuckle... The first time I called BMC for support, the person who was working the problem claimed they had never heard of this product too many acquisitions too fast and too few users (calls to their help people) add up to dismal support. Their documentation for V 3.0 was mostly incorrect as well... Still haven't finished upgrading from 2.1 to 3.0 because I can't get expiration to work George Lesho Storage/System Admin AFC Enterprises Larry Girardi [EMAIL PROTECTED] on 03/09/2001 01:10:12 PM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: George Lesho/Partners/AFC) Fax to: Subject: Re: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- T SM TDP for Oracle Becky, Thank you! That is what I needed (the straight poop!). Does anyone have a differing opinion or additional experience? Thanks again, Larry "Davidson, Becky" [EMAIL PROTECTED] on 03/09/2001 12:36:57 PM Please respond to "ADSM: Dist Stor Manager" [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc:(bcc: Larry Girardi/IS/Travelers) Subject: Re: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- T SM TDP for Oracle We are currently using SQL Backtrack on our production database and TDP for SAP R/3 on development systems migrating to TDP on all. In answer to your questions 1) Yes SQL Backtrack goes directly into TSM 2) Yes you can do a hot backup. We do a 1 T database hot every night 3) Hate it. We have problems with just about everything with it. Setting it up is an issue. Upgrading versions has caused us problems. Getting support has caused us major problems because there is a tendency to not fully look into the problem and just immediately blame it on TSM. If there is a tape error it does not retry very well and the entire backup fails. We have had problems with SQL Backtrack doing it's own expiration. The licensing scheme is done on the size of your database. I suppose that is ok if your database doesn't grow much but ours does so you have to get a license at 250, 500, 750, 1200 which of course costs significantly more. For us financially TDP is the better solution. The installation is easier and support has been better. We have also had fewer problems with it. Then again we are also using TDP for SAP R/3 so I am not sure if TDP for Oracle is better or worse. That's my .02 Becky Davidson Data Manager/AIX Administrator EDS/Earthgrains voice: 314-259-7589 fax: 314-877-8589 email: [EMAIL PROTECTED] -Original Message- From: Larry Girardi [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 11:30 AM To: [EMAIL PROTECTED] Subject: SQL-Backtrack OBSI Module (via TSM API) for Oracle -versus- TSM TDP for Oracle People, I am wondering if anyone has any experience with this stuff. I am really interested in both Oracle and SQL Server! 1) Does SQL-Backtrack backup directly into TSM without having to use/buy the TSM TDP for Oracle/SQL Server ? 2) Can you do a HOT backup of the Oracle/SQL Server database ? 3) Is it slick ... does it work well ? Thank you, Larry
SQL BackTrack For Informix V 3.0
IS ANYBODY USING THIS PRODUCT? Have you been able to make "expiration" work... Not having much luck and would appreciate some assistance. TSM server 3.7.3.6 on AIX 4.3.2 and Client 3.7.2 on AIX 4.3.3. Informix 731UC2. The BMC Product, as mentioned in the subject line is V 3.0 and the obsi module is obsi-adsm 2.4.10. Any hints on how to make expiration work would be welcome... BMC has proved less than helpful. George Lesho Storage/System Admin AFC Enterprises
HELP! TSM accounting record question....
Hello, We are running the latest TSM server on AIX... I am trying to determine my clients that are conducting "non-scheduled backups". In other words, client that may belong to a schedule but are backing up their data outside of the schedule window According to the TSM manual field 25 is the "Client session type. A value of 1 or 4 indicates a general client session. A value of 5 indicates a client session that is running a schedule" BUT I am seeing all my scheduled clients that are being backed up during the schedule time, as having a code of 2 and 3 in field 25 why? I thought that if the client is being backed up as the result of belonging to a schedule, that they would have a "5" in field 25 Please email me at [EMAIL PROTECTED] Keith Kwiatek
Re: cache migrated files
It sounds like you did everything correct. 1. you make the disk pool, allow file caching 2. then you 'backup' the data to you offsite pool, and 3. 'migrate' the data to your primary (tape) pool Miles fyi: Storage Pool Name: DISKDATA Storage Pool Type: Primary Device Class Name: DISK Estimated Capacity (MB): 47 700.0 Pct Util: 94.9 Pct Migr: 0.3 Pct Logical: 100.0 High Mig Pct: 90 Low Mig Pct: 10 Migration Delay: 0 Migration Continue: Yes Migration Processes: 4 Next Storage Pool: BACKUP Reclaim Storage Pool: Maximum Size Threshold: 16 000 M Access: Read/Write Description: Migration STG from DISK to BACKUP Overflow Location: Cache Migrated Files?: Yes Collocate?: Reclamation Threshold: Maximum Scratch Volumes Allowed: Delay Period for Volume Reuse: Migration in Progress?: No Amount Migrated (MB): 25 944.54 Elapsed Migration Time (seconds): 3 024 Reclamation in Progress?: Volume Being Migrated/Reclaimed: Last Update by (administrator): PURDYM Last Update Date/Time: 03/09/01 01:00:15 [EMAIL PROTECTED] 09-Mar-01 2:32:52 PM I'm hoping I did this correctly but need to ask. I have a disk pool that I want some data to remain on for the sake of it being readily available without mounting multiple tapes. This is just directory information if anyone is curious. I defined the pool, and set cache migrated files=yes. I do need to make sure this data is put in the offsite pool as well, and to a tape pool that remains in the library for backup purposes. The disk pool is set to migrate, but with set cache files=yes, I'm assuming it will remain on disk as well as be copied to onsite and offsite pools...I did define that too...properly I hope I was sure the percent used yesterday was 0.7 but at the moment I see it's 0.5 after the migration finished. Not sure why this happened yet but maybe someone could shed some light. Is there a way I can compare what is on the tape to what's on the disk pool? Is my assumption correct or will it make me the other part of *ass*umption? Geoff Gill NT Systems Support Engineer SAIC Computer Systems Group E-Mail: [EMAIL PROTECTED] Phone: (858) 826-4062 Pager: (888) 997-9614
Re: label libvol how change overwrite=n to yes
Depends on how you labeled and checked in tapes. Be careful with overwrite=yes, you can overwrite tapes with data on them -yes! I prefer using overwrite=yes when checking from bulk i/o, with: search=bulk option. Do a q vol on the tapes you labeled and see if anything shows up. Do a q libvol and see if they are in list. If they are not used for data by now, then the way I handle this is to checkout the tapes and then do: label libvol lib_name search=bulk labelsource=barcode checkin=scratch overwrite=yes This will relabel tapes. I have had a few that got mislabeled (label on tape didn't match barcode - this solved it. Also had a few tapes that got read/write errors at very beginning of tape, solved that too. Depends on what type of library you have too as to how to label, if you don't have bulk I/O station. David B. Longo System Administrator Health First, Inc. 3300 Fiske Blvd. Rockledge, FL 32955-4305 PH 321.434.5536 Pager 321.634.8230 Fax:321.434.5525 [EMAIL PROTECTED] [EMAIL PROTECTED] 03/09/01 06:41PM After issuing a label libvol command to a series of tapes, I discovered I forgot to use the overwrite=yes option, which was necessary in this case. The default is overwrite=no. I tried the label libvol command again, with overwrite=yes, but the log says that 0 tapes were labelled. Does anybody know how I can change this setting to overwrite=y? These tapes will be unusable unless this overwrite option is changed to yes. I am unable to find any procedure in the TSM Admin Guide on how to do this. Thanks, in advance. Peter Glass Distributed Storage Management (DSM) Wells Fargo Services Company * 612-667-0086 * 866-249-8568 * [EMAIL PROTECTED] "MMS health-first.org" made the following annotations on 03/09/01 22:42:01 -- This message is for the named person's use only. It may contain confidential, proprietary, or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it, and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Health First reserves the right to monitor all e-mail communications through its networks. Any views or opinions expressed in this message are solely those of the individual sender, except (1) where the message states such views or opinions are on behalf of a particular entity; and (2) the sender is authorized by the entity to give such views or opinions. Ý==