Re: Question from a non-TSM person
Hi Fred! It probably is. Breaking the mirror is an immediate action which is database-wise somewhat comparable with a kill -9 of the TSM server. I have had to do this in the past and TSM came up fine afterward. Of course you will have to make sure that no clients are connected to the server and no housekeeping processes are running during and after this split-off. And of course, this is NOT supported! Why do you want to do it like this? You don't have time to FTP the database to the new host or to do a backup/restore of the database?!?! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: fred johanson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 23:24 To: ADSM-L@VM.MARIST.EDU Subject: Question from a non-TSM person I was asked if it was possible to move TSM from machine to machine by mirroring the DB and log, breaking the mirror, moving the mirrored portions to a new machine, adding the old mirror volumes to dsmserv.dsk, and bringing up the new machine as if nothing happened? Fred Johanson ITSM Administrator University of Chicago 773-702-8464 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: TSM 5.3 CDs
Hi Shukrie! If you have an Passport Advantage contract, you can login at: https://www-112.ibm.com/software/howtobuy/passportadvantage/paocustomer/Enti tlement There is no other place to download the base code. Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Hashim, Shukrie BSP-ISM/116 [mailto:[EMAIL PROTECTED] Sent: Friday, February 11, 2005 01:18 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.3 CDs can someone direct me to the URL for the 5.3 cds download ? please this would be my first time downloading from site ... and I don't know where to start. ... -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Ochs, Duane Sent: 09 February 2005 01:30 To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.3 CDs Free -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joe Crnjanski Sent: Tuesday, February 08, 2005 11:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.3 CDs Is it free or they charge you for this Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ochs, Duane Sent: Tuesday, February 08, 2005 11:46 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.3 CDs I am guessing yes. Also, our entitlement on the PA site only allowed us to order 1 set of cds even though we have 3 server instances in different geographical locations. Duane Ochs Enterprise Computing Quad/Graphics Inc. Sussex, Wisconsin 414-566-2375 -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joe Crnjanski Sent: Tuesday, February 08, 2005 10:35 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.3 CDs We didn't have to order them before. They just arrived after couple of weeks IBM published them to PA site. Do we have to order them now Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Ochs, Duane Sent: Tuesday, February 08, 2005 11:31 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: TSM 5.3 CDs You can order them from Passport advantage as well. I went through the same thing yesterday and instead of being able to order from the PA service center, they instructed me to use the PA website. Duane -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joe Crnjanski Sent: Tuesday, February 08, 2005 10:10 AM To: ADSM-L@VM.MARIST.EDU Subject: TSM 5.3 CDs Hello, Did you guys start receiving TSM 5.3 CDs. I would like your input before I start long and painful journey of looking for name and number of person to call. And, yes I know that I can download it from passport advantage site. Regards, Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Thando Ndaba Sent: Tuesday, February 08, 2005 8:16 AM To: ADSM-L@VM.MARIST.EDU Subject: Hi TSMers I am planning to do a restore for oracle rman backup sets taken from 30th of January. Is there a way in wich I can see all the media that was used for that particilar node on that day? My activety log retention is set to only two days. Kind Regards Thando Ndaba SA Post Office TSM Administrator [EMAIL PROTECTED] ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Re: Question from a non-TSM person
Hi, Be carefull with path. Because one of the machines can have numeration of drives different than the new one... Than you need to update the paths with correct values. Also - If you for mirroring you understand - TSM DB Mirros - than - this is not a good idea - Than you need to replace definitions for DB and LOG in TSM server... To do this is better to use HW mirror!!! Best Regards, Svetoslav Loon, E.J. van - SPLXM [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 11.02.2005 10:28 Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: Question from a non-TSM person Hi Fred! It probably is. Breaking the mirror is an immediate action which is database-wise somewhat comparable with a kill -9 of the TSM server. I have had to do this in the past and TSM came up fine afterward. Of course you will have to make sure that no clients are connected to the server and no housekeeping processes are running during and after this split-off. And of course, this is NOT supported! Why do you want to do it like this? You don't have time to FTP the database to the new host or to do a backup/restore of the database?!?! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: fred johanson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 10, 2005 23:24 To: ADSM-L@VM.MARIST.EDU Subject: Question from a non-TSM person I was asked if it was possible to move TSM from machine to machine by mirroring the DB and log, breaking the mirror, moving the mirrored portions to a new machine, adding the old mirror volumes to dsmserv.dsk, and bringing up the new machine as if nothing happened? Fred Johanson ITSM Administrator University of Chicago 773-702-8464 ** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. **
Nested select
Hi all, I have problem with select command, maybe SB had solve similar problem sometimes. What I need to do: select from occupancy table where I want to have on ONE row : 1st column - nodename 2nd column - sum logical_mb accross stgpools like T% (primary pools) for this node 3rd column - sum logical_mb accross stgpools like C% (copy pools) for this node I think this is example for application of nested select commands and I know, that TSM DB selects are reduced set of SQL92 and SQL93 standard. I was not able to collect appropriate command, so I want to ask anybody, if is it ever possible in TSM to do that. Any idea will be appreciated. Regards Tomas Hrouda Storage Specialist HTD s.r.o. Praha CZECH REPUBLIC [EMAIL PROTECTED]
Re: Question from a non-TSM person
Fred, You could have a problem if your database and recovery logs are on more than one physical disk, because when you break the disk mirrors you could not guarantee that the data on all the mirrored disks was consistent. However, if you halt the TSM server and wait until it comes down then you know there is no more IO happening, Then if you break the mirrors, all the files should be consistent. That would be a much faster operation than a restore from backup. However as Eric said, this would not be supported. If you are physically moving the mirror volumes to a new server, does that mean you are leaving the old ones behind? Could you end up with two TSM servers with the same name and IP address on your Network? That would be a challenge. Jim Armstrong Storage Architect Standard Life (0044) 131 245 3062 fred johanson [EMAIL PROTECTED] To: ADSM-L@VM.MARIST.EDU EDU cc: Sent by: bcc: ADSM: Dist Subject:Question from a non-TSM person Stor Manager [EMAIL PROTECTED] ST.EDU 10/02/2005 22:23 Please respond to ADSM: Dist Stor Manager I was asked if it was possible to move TSM from machine to machine by mirroring the DB and log, breaking the mirror, moving the mirrored portions to a new machine, adding the old mirror volumes to dsmserv.dsk, and bringing up the new machine as if nothing happened? Fred Johanson ITSM Administrator University of Chicago 773-702-8464 For more information on Standard Life, visit our website http://www.standardlife.co.uk/ The Standard Life Assurance Company, Standard Life House, 30 Lothian Road, Edinburgh EH1 2DH, is registered in Scotland (No. SZ4) and is authorised and regulated by the Financial Services Authority. Tel: 0131 225 2552 - calls may be recorded or monitored. This confidential e-mail is for the addressee only. If received in error, do not retain/copy/disclose it without our consent and please return it to us. We virus scan and monitor all e-mails but are not responsible for any damage caused by a virus or alteration by a third party after it is sent.
Re: Nested select
Tomas,
The following select statement will give you exactly what you want.
select node_name as NODENAME,sum(case when substr(stgpool_name,1,1) in ('T')
then logical_mb else 0 end) as PRIMARY_OCC,sum(case when
substr(stgpool_name,1,1) in ('C') then logical_mb else 0 end) as COPY_OCC from
occupancy group by node_name
Regards, Samiran Das
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Tom
Hrouda
Sent: Friday, February 11, 2005 5:19 AM
To: ADSM-L@VM.MARIST.EDU
Subject: Nested select
Hi all,
I have problem with select command, maybe SB had solve similar problem
sometimes. What I need to do: select from occupancy table where I want to have
on ONE row : 1st column - nodename 2nd column - sum logical_mb accross stgpools
like T% (primary pools) for this node 3rd column - sum logical_mb accross
stgpools like C% (copy pools) for this node
I think this is example for application of nested select commands and I know,
that TSM DB selects are reduced set of SQL92 and SQL93 standard. I was not able
to collect appropriate command, so I want to ask anybody, if is it ever
possible in TSM to do that.
Any idea will be appreciated.
Regards
Tomas Hrouda
Storage Specialist
HTD s.r.o. Praha
CZECH REPUBLIC
[EMAIL PROTECTED]
If you are not an intended recipient of this e-mail, please notify the sender,
delete it and do not read, act upon, print, disclose, copy, retain or
redistribute it. Click here for important additional terms relating to this
e-mail. http://www.ml.com/email_terms/
Re: TSM 5.3 Administration Center
Orville, Alas the PDF's are gone. What's left is a bloody CD, which you can either run or install and then you get all the documentation on web-pages. Be aware, there is a tomcat webserver included which seems to die on me every now and then on my PC and there is no easy way to restart it (I've installed the CD). Richard. Orville Lantto [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 10-02-2005 19:28 Please respond to ADSM: Dist Stor Manager To: ADSM-L@VM.MARIST.EDU cc: Subject:Re: TSM 5.3 Administration Center Has anyone found any written documentation on the ISC. The little bit I have found so far points back to DeveloperWorks. I cannot sell this to a knowledgeable customer without REAL production documentation with the REAL product team behind it. DeveloperWorks does many fine things, but, having been in research for 15 years, I do not think my customers should be dependant on people so far removed from the trenches. Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) IBM Premier Business Partner 121 Cheshire Lane, Suite 700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Paul Fielding [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 02/10/2005 12:36 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: TSM 5.3 Administration Center I think a number of people have summed up the issues here well, no need for me to harp on them. The one exception I would make is in regards to creating an 'intuitive interface'. So far, IMHO, the interface is far from intuitive. While I can see the theoretical logic behind burying the Schedules section underneath Policy Domains, it took myself (with 7 years of TSM implementation and usage experience) and my current client several minutes to find it. There are some places where clicking on an icon brings up the properties window for the item, others where you must instead use the pull-down menu to get properties, meanwhile clicking on the icon initiates another wizard of some kind. Many of the windows that are designed to explain what's happening are needlessly cluttered and wordy. If you're going to explain everything, give us a prominent help button beside the options instead - It's a pain in the butt to skim over whole paragraphs of text to try to find the two options you're looking for, which have incidentally been named differently than the traditional name for the option, further making it difficult to find. Then there are the functional decisions that have been made regarding 'hiding' configurations from the user. For example, if the ISC has anything to say about it, Policy Sets are a thing of the past. I have yet to find a reasonable way to view all policy sets, add a policy set or remove one. Yet it is assumed that the server has a STANDARD policy set that automatically gets validated and activated when updating an mgmt class or copy group, with no opportunity for you to see the validation and *not* activate. *However*, when you add or remove mgmt classes (as opposed to updating the copy groups within them), the policy set is NOT validated nor activated. Yet, the ISC returns a successful prompt, claiming that your work here is done, when in fact the mgmtclass/copy groups you've just added/removed are not in the Active policy set.There is a drop down menu on the Policy Domain (why is it at the domain level?) for Activating the Policy Set. Not just any policy set, but THE policy set, which must be named STANDARD otherwise it breaks. For newbies, there's no indication of why one would want to do this, given that policy sets are mentioned nowhere else. And it validates and Activates in one shot, without showing you the output of the validation so you can see something is wrong.Frankly, this is multiple bits of buggy behavior. Make a choice - either make it work correctly so the end-user doesn't need to know that policy sets exist, or give us the chance to work with our policy sets. One of the single biggest features I liked about the old Web Interface is gone - the command line at the bottom. For those of us who find some benefits to using the GUI, and some benefits to using the CLI, this was a great tool - the GUI was at our side, but the CLI was always *right* *there* when we wanted it, and the output was cleanly put into the browser window in a way we could scroll along easily. The CLI in the ISC is in an annoying place to get to, you can't easily keep it at your fingertips, and the
exclude vs. exclude.backup
With the advent of the 5.3 Windows Client, the install defaults to includeing a number of system excludes for the server. This is fine and all, but one of the things it does is separates them by exclude.backup and exclude.archive, repeating the same filespec for each. My belief has always been that exclude would exclude both backups and archives, which would negate the need to exclude the same filespec with both exclude.backup and exclude.archive. Am I missing something? regards, Paul - This mail sent through IMP: http://horde.org/imp/
Re: exclude vs. exclude.backup
Ok, I just tested, and indeed the exclude statement by itself does not exclude archives, forcing an exclude.archive will exclude them. I'm surprised - I've made a poor assumption over the years. I wonder if anyone else has been caught by that one? regards, Paul Quoting [EMAIL PROTECTED]: With the advent of the 5.3 Windows Client, the install defaults to includeing a number of system excludes for the server. This is fine and all, but one of the things it does is separates them by exclude.backup and exclude.archive, repeating the same filespec for each. My belief has always been that exclude would exclude both backups and archives, which would negate the need to exclude the same filespec with both exclude.backup and exclude.archive. Am I missing something? regards, Paul - This mail sent through IMP: http://horde.org/imp/ -- [EMAIL PROTECTED] http://www.fielding.ca - This mail sent through IMP: http://horde.org/imp/
Re: Upgrade of hardware and software (5.1.1 - 5.3)
Customers upgrading to TSM 5.3 will benefit from the informative IBM site Technote 1193325. And there is an equally helpful 5.3 FAQ Technote, 1193418. Richard Sims
Re: exclude vs. exclude.backup
On Feb 11, 2005, at 7:27 AM, Paul Fielding wrote: ...My belief has always been that exclude would exclude both backups and archives, which would negate the need to exclude the same filespec with both exclude.backup and exclude.archive. ... While an unqualified Exclude should intuitively exclude a file system object from all TSM operations, the product unfortunately departs from obviousness here, requiring the .archive qualifier to exclude from archiving as well, as has been consistently explained in the client manuals. Products sometimes have warts like this due to the way they evolve from initial design objectives, as in Backup being the initial role of the primordial product. Richard Sims
Select Statement question
Hello All! I have this finally working, but I was wondering if there is a way to shorten the width of the columns so that they can all fit on one line? And also, the customer has requested that the successful column be changed to completed, missed or failed. I didn't think this was possible unless I join 2 tables and then produce the same output. Is this a correct assumption? Thanks! ANS8000I Server command: 'select entity as node_name, date(start_time) as date, cast(activity as varchar(10)) as activity, time(start_time) as start, time(end_time) as end, cast(bytes/1024/1024 as decimal(6,0)) as megabytes, cast(affected as decimal(7,0)) as files, successful from summary where start_time=current_timestamp - 1 day and (entity like 'HM%' or entity like 'PAB%' or entity like 'VMS%' or entity like 'GEOHMKLG%' ) and activity='BACKUP' order by successful, node_name' NODE_NAMEDATE ACTIVITY START END MEGABYTES FILES SUCCESSFUL -- -- -- - - -- HMCH1021 2005-02-09 BACKUP 19:12:14 19:22:03 572 2266YES HMCH1028 2005-02-09 BACKUP 19:08:53 19:13:37 381 2063YES HMCH1147 2005-02-09 BACKUP 19:12:13 19:42:06 384 2157YES HMCH1150 2005-02-09 BACKUP 19:10:29 19:17:45 70 329YES HMCH1160 2005-02-09 BACKUP 19:12:18 19:15:14 281 1987YES HMCH1161 2005-02-09 BACKUP 19:09:25 19:13:47 187 221YES Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED]
Re: Select Statement question
On Feb 11, 2005, at 9:19 AM, Joni Moyer wrote: I have this finally working, but I was wondering if there is a way to shorten the width of the columns so that they can all fit on one line?... Joni - The following SQL function is most commonly used to limit the width of a column: CHARSQL function to return a string of optionally limited length, left-aligned. Syntax: CHAR(Expression[,Len]) Your users should also be aware that Xwindows managers and most Web browsers allow changing the size of displayed text, so that wider stuff can fit in a window. Richard Sims
Re: exclude vs. exclude.backup
object from all TSM operations, the product unfortunately departs from obviousness here, requiring the .archive qualifier to exclude from archiving as well, as has been consistently explained in the client manuals. While the manuals do state that Exclude will exclude files from backup, and independently the manuals do state that Exclude.archive will exclude files from archive, it does not make it clear that Exclude by itself will *not* exclude files from archive, and the fact that the Exclude.backup function exists, to my mind, implys that Exclude (by itself) would not limit itself to backups, or in other words it would successfully exclude archives. For quite some times I've made an assumption based on this which turned out to be a poor assumption. This was only clarified by the new 5.3 install which separates exclude.backups from exclude.archives in it's default option file creation. I agree whole heartedly that this is probably a side effect of 'evolving features'. Kind of like Policy Domains, where the single biggest use of Policy Domains these days is to separate Agent data from regular backup data, as opposed to what a Domain was originally designed for... regards, Paul Quoting Richard Sims [EMAIL PROTECTED]: On Feb 11, 2005, at 7:27 AM, Paul Fielding wrote: ...My belief has always been that exclude would exclude both backups and archives, which would negate the need to exclude the same filespec with both exclude.backup and exclude.archive. ... While an unqualified Exclude should intuitively exclude a file system object from all TSM operations, the product unfortunately departs from obviousness here, requiring the .archive qualifier to exclude from archiving as well, as has been consistently explained in the client manuals. Products sometimes have warts like this due to the way they evolve from initial design objectives, as in Backup being the initial role of the primordial product. Richard Sims -- [EMAIL PROTECTED] http://www.fielding.ca - This mail sent through IMP: http://horde.org/imp/
My SQL
Hello, Simple question; Can we backup MySQL database with TDP for MS SQL Regards, Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com
Re: My SQL
On Friday 11 February 2005 16:44, Joe Crnjanski wrote: Hello, Simple question; Can we backup MySQL database with TDP for MS SQL No. Stef
Re: My SQL
ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/11/2005 10:44:25 AM: Hello, Simple question; Can we backup MySQL database with TDP for MS SQL Regards, Joe Crnjanski Joe, No. Del
Offsite reclamation question? [ LONG ]
Hi, all: I've got a question I've been wondering about, relating to how foresightful TSM is in its' offsite reclamation. I'll spin an example: TSM server 'SRV1' has three nodes NODE1 NODE2 NODE3 It's got stgpools PRIMARY : collocated . Volumes named Pxxx COPY: non-collocated . Volumes named Cxxx OFFSITE : non-collocated . Volumes named Oxxx Daily incrementals happen on all nodes. Tapes go offsite every day. OK, given that scenario, we know that the vast majority of offsite tapes have a thin slice of data from all of NODE1, NODE2, and NODE3. --- Known scenario --- So when an offsite volume O213 passes the reclamation threshold, the server begins building a new offsite volume O501. It mounts PRIMAY volume P001 (with node1's data on it) and makes an additional copy of those files from NODE1 that appear on O213, and are still interesting to the server. Then it mounts PRIMARY volume P002, does the same for NODE2, Then it mounts PRIMARY volume P003, does the same for NODE3. Now, new offsite volume O501 is ready to leave on the next truck. --- Unknown scenario --- Now, what if O214, O215, and O216 all pass the reclamation threshold? We know the server's going to start building O502. Say it picks O214 to begin with. When P001 is mounted, will the reclamation copy files from -all- the reclaimable offsite volumes, only from O214, or what? I can see pseudocode something like: - Pick an offsite volume to work on - From that offsite volume, pick a first onsite volume to mount - From that onsite volume, determine all files wanted for offsite reclamation. Copy them. This would be expensive in query time, but the alternative is a big-O N * M of tape mounts, which makes me shudder. But it would certainly be simpler to code.
3494 tape library on AIX
We are setting up a DR machine. While we have TSM coming up after a DB restore, we still need to test connecting the 3494 tape library on the DR machine. Looking through the software inventory on the production machine, these seem to be the only related software packages for the tape libbrary and cartridge drivers. We have network connections to the library, no scsi connections. Is any other software required for the tape library? Atape.driver 9.0.7.0C FIBM AIX Enhanced Tape and Medium Changer Device Driver atldd.driver 5.5.1.0C FIBM Automated Tape Library Device Driver Larry Clark
My SQL
Another simple question, HOW we can backup My SQL database. I have a customer with around 5GB MySQL database. Backup is over the internet, so dump file backup is out of question. Regards, Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Friday, February 11, 2005 11:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: My SQL ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/11/2005 10:44:25 AM: Hello, Simple question; Can we backup MySQL database with TDP for MS SQL Regards, Joe Crnjanski Joe, No. Del
Re: My SQL
On Fri, 11 Feb 2005, Joe Crnjanski might have said: Another simple question, HOW we can backup My SQL database. I have a customer with around 5GB MySQL database. Backup is over the internet, so dump file backup is out of question. Regards, Joe Crnjanski Infinity Network Solutions Inc. Phone: 416-235-0931 x26 Fax: 416-235-0265 Web: www.infinitynetwork.com -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Del Hoobler Sent: Friday, February 11, 2005 11:15 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: My SQL ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/11/2005 10:44:25 AM: Hello, Simple question; Can we backup MySQL database with TDP for MS SQL Regards, Joe Crnjanski Joe, No. Del I currently use the 'dump to a file and then backup the file' method. Is it possible to dump the file locally, gzip it, then send it through the net?
Re: 3494 tape library on AIX
Those are the 2 filesets you need. The other thing you may have to do is configure the library manager so that it will accept the TCP/IP connections from your DR host. It's been a while since I've done it, but it's in the menu under LAN host connections or something like that. Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Friday, February 11, 2005 9:37 AM To: ADSM-L@VM.MARIST.EDU Subject: 3494 tape library on AIX We are setting up a DR machine. While we have TSM coming up after a DB restore, we still need to test connecting the 3494 tape library on the DR machine. Looking through the software inventory on the production machine, these seem to be the only related software packages for the tape libbrary and cartridge drivers. We have network connections to the library, no scsi connections. Is any other software required for the tape library? Atape.driver 9.0.7.0C FIBM AIX Enhanced Tape and Medium Changer Device Driver atldd.driver 5.5.1.0C FIBM Automated Tape Library Device Driver Larry Clark
Re: 3494 tape library on AIX
We are just going to reconfig the DR TSM server to inheret the name /IP address of the production server for DR test purposes. [EMAIL PROTECTED] 02/11/2005 11:55:20 AM Those are the 2 filesets you need. The other thing you may have to do is configure the library manager so that it will accept the TCP/IP connections from your DR host. It's been a while since I've done it, but it's in the menu under LAN host connections or something like that. Ben -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Clark Sent: Friday, February 11, 2005 9:37 AM To: ADSM-L@VM.MARIST.EDU Subject: 3494 tape library on AIX We are setting up a DR machine. While we have TSM coming up after a DB restore, we still need to test connecting the 3494 tape library on the DR machine. Looking through the software inventory on the production machine, these seem to be the only related software packages for the tape libbrary and cartridge drivers. We have network connections to the library, no scsi connections. Is any other software required for the tape library? Atape.driver 9.0.7.0C FIBM AIX Enhanced Tape and Medium Changer Device Driver atldd.driver 5.5.1.0C FIBM Automated Tape Library Device Driver Larry Clark
Re: My SQL
On Feb 11, 2005, at 11:51 AM, Joe Crnjanski wrote: Another simple question, HOW we can backup My SQL database. I have a customer with around 5GB MySQL database. Backup is over the internet, so dump file backup is out of question. A not-so-simple answer...which is: Hmmm... MySQL has an API, and TSM has an API, so an enterprising customer programmer could... I'm kind of surprised to not heard of someone producing a Customer Data Protection client for MySQL, given the potential. There might be one out there. Richard Sims
Re: My SQL
On Friday 11 February 2005 17:51, Joe Crnjanski wrote:
Another simple question,
HOW we can backup My SQL database.
I have a customer with around 5GB MySQL database. Backup is over the
internet, so dump file backup is out of question.
I don't know from where I got the original script, but this is working nice
for me:
#!/usr/bin/perl
# mysql-backup v1.0 (c) 26.5.2003 by Andreas Ley (u) 27.5.2003
# MySQL Online TSM Backup
$mycnf = /root/mysqladmin.cnf;
$dsmc = /usr/bin/dsmc ;
use DBI;
use Getopt::Std;
sub usage {
my $image = $0;
$image =~ s!.*/!!;
print STDERR Usage: $image [-v] [database [...]]\n;
print STDERR or:$image [-v] -a\n;
print STDERR -v Verbose mode\n;
print STDERR -a Lock all databases during backup\n;
print STDERR Default is to lock databases one by one\n;
exit(1);
}
getopts('aDhxv');
usage if ($opt_h);
@opts = (-verbose) if ($opt_v);
open (MYCNF,$mycnf) || die Can't read $mycnf: $!\n;
while (MYCNF) {
chomp;
$user = $' if (/^\s*user\s*=\s*/);
$password = $' if (/^\s*password\s*=\s*/);
}
close (MYCNF);
print STDERR Connect to database...\n if ($opt_v);
$dbh = DBI-connect(dbi:mysql:, $user, $password,
{ RaiseError = 1, PrintError = 0, AutoCommit = 1 });
($dummy,$datadir) = $dbh-selectrow_array(show variables like 'datadir');
sub dsmc {
unless ($opt_v) {
open(OLDOUT,STDOUT);
open(STDOUT,/dev/null);
}
#print @_\n ;
#map(s!/+$!!,@_);
system($dsmc,incremental,-subdir=yes,@opts,@_);
unless ($opt_v) {
open(STDOUT,OLDOUT);
}
}
if ($opt_a) {
print STDERR Lock all tables...\n if ($opt_v);
$dbh-do(flush tables with read lock);
dsmc($datadir//);
} else {
if ($#ARGV = 0) {
$databases = [EMAIL PROTECTED];
} else {
print STDERR Read databases...\n if ($opt_v);
$databases = $dbh-selectcol_arrayref(show databases);
}
for $database (@$databases) {
print STDERR Lock tables in $database...\n if ($opt_v);
$tables = $dbh-selectcol_arrayref(show tables from
$database);
$temp = join(,, @$tables);
if ( @$tables ) {
$dbh-do(lock tables .join(,,map($database.$_
read,@$tables)));
dsmc($datadir.$database.'/');
}
print STDERR Export tables in $database...\n if ($opt_v);
$output = $dbh-selectcol_arrayref(mysqldump
--tab=/backup/mysql --opt db_name);
}
}
$dbh-disconnect;
/root/mysqladmin.cnf:
user=mysql-user
password=password
Stef
Re: 3494 tape library on AIX
Make sure you have /etc/ibmatl.conf customized on your DR machine. [EMAIL PROTECTED] 02/11/05 11:36 AM We are setting up a DR machine. While we have TSM coming up after a DB restore, we still need to test connecting the 3494 tape library on the DR machine. Looking through the software inventory on the production machine, these seem to be the only related software packages for the tape libbrary and cartridge drivers. We have network connections to the library, no scsi connections. Is any other software required for the tape library? Atape.driver 9.0.7.0C FIBM AIX Enhanced Tape and Medium Changer Device Driver atldd.driver 5.5.1.0C FIBM Automated Tape Library Device Driver Larry Clark
Re: Offsite reclamation question? [ LONG ]
Hello, I have a follow up question. I see that you have 3 storage pools. Can you tell me what COPY storage is used for? is this one used like similar to Primary or are you making copy of Primary? Primary --- Copy Offsite (goes to offsite) or Primary -- copy (goes offsite) ---Offsite (goes offsite) Sung Y. Lee Sung Y. Lee ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/11/2005 11:34:46 AM: Hi, all: I've got a question I've been wondering about, relating to how foresightful TSM is in its' offsite reclamation. I'll spin an example: TSM server 'SRV1' has three nodes NODE1 NODE2 NODE3 It's got stgpools PRIMARY : collocated . Volumes named Pxxx COPY : non-collocated . Volumes named Cxxx OFFSITE : non-collocated . Volumes named Oxxx Daily incrementals happen on all nodes. Tapes go offsite every day. OK, given that scenario, we know that the vast majority of offsite tapes have a thin slice of data from all of NODE1, NODE2, and NODE3. --- Known scenario --- So when an offsite volume O213 passes the reclamation threshold, the server begins building a new offsite volume O501. It mounts PRIMAY volume P001 (with node1's data on it) and makes an additional copy of those files from NODE1 that appear on O213, and are still interesting to the server. Then it mounts PRIMARY volume P002, does the same for NODE2, Then it mounts PRIMARY volume P003, does the same for NODE3. Now, new offsite volume O501 is ready to leave on the next truck. --- Unknown scenario --- Now, what if O214, O215, and O216 all pass the reclamation threshold? We know the server's going to start building O502. Say it picks O214 to begin with. When P001 is mounted, will the reclamation copy files from -all- the reclaimable offsite volumes, only from O214, or what? I can see pseudocode something like: - Pick an offsite volume to work on - From that offsite volume, pick a first onsite volume to mount - From that onsite volume, determine all files wanted for offsite reclamation. Copy them. This would be expensive in query time, but the alternative is a big-O N * M of tape mounts, which makes me shudder. But it would certainly be simpler to code.
Re: Offsite reclamation question? [ LONG ]
== On Fri, 11 Feb 2005 14:55:28 -0500, Sung Y Lee [EMAIL PROTECTED] said: Hello, I have a follow up question. I see that you have 3 storage pools. Can you tell me what COPY storage is used for? is this one used like similar to Primary or are you making copy of Primary? Primary --- Copy Offsite (goes to offsite) or I keep a copy onsite, in case of media failure. - Allen S. Rout
Re: Offsite reclamation question? [ LONG ]
Hi, Overall... Normally a site will have one or more primary storage pools. These may be colocated to improve the efficiency of restores, depending on the site and its resources. These primary storage pools are copied to one or more copypools. The copypools are normally not colocated to save on storage resources. The copypools are checked out and sent offsite, and their status updated as offsite after the data is added to volumes each day. Then as the expiration process expires the data of the copypool volumes that are offsite, they are returned to the site and checked in and become scratch volumes. [EMAIL PROTECTED] 02/11/2005 2:55:28 PM Hello, I have a follow up question. I see that you have 3 storage pools. Can you tell me what COPY storage is used for? is this one used like similar to Primary or are you making copy of Primary? Primary --- Copy Offsite (goes to offsite) or Primary -- copy (goes offsite) ---Offsite (goes offsite) Sung Y. Lee Sung Y. Lee ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/11/2005 11:34:46 AM: Hi, all: I've got a question I've been wondering about, relating to how foresightful TSM is in its' offsite reclamation. I'll spin an example: TSM server 'SRV1' has three nodes NODE1 NODE2 NODE3 It's got stgpools PRIMARY : collocated . Volumes named Pxxx COPY : non-collocated . Volumes named Cxxx OFFSITE : non-collocated . Volumes named Oxxx Daily incrementals happen on all nodes. Tapes go offsite every day. OK, given that scenario, we know that the vast majority of offsite tapes have a thin slice of data from all of NODE1, NODE2, and NODE3. --- Known scenario --- So when an offsite volume O213 passes the reclamation threshold, the server begins building a new offsite volume O501. It mounts PRIMAY volume P001 (with node1's data on it) and makes an additional copy of those files from NODE1 that appear on O213, and are still interesting to the server. Then it mounts PRIMARY volume P002, does the same for NODE2, Then it mounts PRIMARY volume P003, does the same for NODE3. Now, new offsite volume O501 is ready to leave on the next truck. --- Unknown scenario --- Now, what if O214, O215, and O216 all pass the reclamation threshold? We know the server's going to start building O502. Say it picks O214 to begin with. When P001 is mounted, will the reclamation copy files from -all- the reclaimable offsite volumes, only from O214, or what? I can see pseudocode something like: - Pick an offsite volume to work on - From that offsite volume, pick a first onsite volume to mount - From that onsite volume, determine all files wanted for offsite reclamation. Copy them. This would be expensive in query time, but the alternative is a big-O N * M of tape mounts, which makes me shudder. But it would certainly be simpler to code.
Re: Offsite reclamation question? [ LONG ]
== On Fri, 11 Feb 2005 15:02:07 -0500, David E Ehresman [EMAIL PROTECTED] said: Reclaim is built to require the fewest number possible of primary tapes. So when a reclaim threshold is set for a copy pool, TSM determines all eligible tapes, picks a primary pool tape to mount, takes all eligible files off it, then proceed to the next primary tape. So, you think the answer is 'yes', and in my scenario for instance, if I have a dozen offsite tapes ready for reclamation, once the first primary mount is complete I would expect to see that -all- of their pct_utilized have gone down by some small aliquot. Nice. - Allen S. Rout
I have a db and disk pool volume question.
I have an opportunity to redesign the disk pool and db layout of our TSM Server , and I was wondering if my fellow TSMers can help me with it. First things first our environment is as follows, TSM Version: 5.1.7 soon to be 5.2.? on Win2k, the Disk the DB will be stored on will be a RAID 5 Disk on a EMC CX700 array. My main question is can TSM read/write multiple streams to a single Disk or DB vol? The reason why I ask this is that that would help me decide the size/number of the volumes to the number of disks I am using in the RAID array. For example, if TSM can only read/write a single stream to a disk pool volume, I would create a group of disk pool volumes on a 170 gig RAID 5 array, containing 9 disks plus 1 for parity, with 9 disk pool volumes of about 18.8 gigs. The reason I would do this is to optimize the I/O across all the spindles. Any help or advice would be appreciated. Thank You, Matt Martinez Systems Administrator IDEXX Laboratories, Inc. Phone:207-856-0656 Fax:207-856-8320 [EMAIL PROTECTED]
Re: Offsite reclamation question? [ LONG ]
I thought about this question. The answer is maybe in my opinion. how do you know P001 contains all the data what 0214, 0215, and 0216 need? Unless there is a way to compare the data inside these tapes. When P001 is mounted it will reclaim some data or maybe all tapes.. Another question I have is, during reclamation if P001 is not available, does it grab the tape from COPY pool? Sung Y. Lee ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU wrote on 02/11/2005 03:24:18 PM: == On Fri, 11 Feb 2005 15:02:07 -0500, David E Ehresman [EMAIL PROTECTED] said: Reclaim is built to require the fewest number possible of primary tapes. So when a reclaim threshold is set for a copy pool, TSM determines all eligible tapes, picks a primary pool tape to mount, takes all eligible files off it, then proceed to the next primary tape. So, you think the answer is 'yes', and in my scenario for instance, if I have a dozen offsite tapes ready for reclamation, once the first primary mount is complete I would expect to see that -all- of their pct_utilized havegone down by some small aliquot. Nice. - Allen S. Rout
AW: AW: TSM 5.3 and ISC install - successful on W2K Server under VMWare
Hallo Joerg! Your tip/hint was absolutely right. I followed your instructions -- and all went OK Thanks a lot for your help Michael Malitz e-mail: [EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joerg Pohlmann Gesendet: Samstag, 05. Februar 2005 21:48 An: ADSM-L@VM.MARIST.EDU Betreff: Re: AW: TSM 5.3 and ISC install Michael, make sure that the amount of memory the virtual machine sees (as RAM) is 1GB. Also, I found that on some installs, the process wants to go to SUN's java site and download/install bits and pieces of java, but this varies with what's installed on your W2K machine. It just means that you will need to let the install process access the internet. Joerg Pohlmann 604-535-0452 Michael Malitz [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 2005-02-05 11:17 Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject AW: TSM 5.3 and ISC install Hi all, I?m also struggling with the new ISC and can not get over 66 %!!. I'm using Windows XP Host with VMWare and installed W2K Advanced Server SP4. My assigned physical memory to that W2K machine is 700 MB . During install a maximum of around 520 MB is used by ISCinstall processes. I increased the virtual Memory min 500 max 2000 MB and have 2,3 GB free disk space When I reach 66 % I get an error: Help is very much appreciated ? thanks and rgds Mikel Contents of ISCRuntimeInstallProgress.properties + #Sat Feb 05 22:33:17 CET 2005 ISC_FAILURE_MESSAGE=CheckDeployPageFail status=FAILED timestamp=Sat Feb 05 22\:33\:17 CET 2005 +++ end of log Contents of - the last entries of ISCRuntimeInstall.log (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.RemovePasswordsAction, msg2, Password replacement complete (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.RemovePasswordsAction, msg2, RemovePasswordsAction exit. (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.FailAndExitAction, wrn, CheckDeployPageFail (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.FailAndExitAction, wrn, (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.FailAndExitAction, msg2, status=FAILED,timestamp=Sat Feb 05 22:33:17 CET 2005,progress=(unchanged) +++ end of log Thanks again Michael Malitz e-mail: [EMAIL PROTECTED] -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Steve Harris Gesendet: Montag, 31. Jänner 2005 03:04 An: ADSM-L@VM.MARIST.EDU Betreff: Re: TSM 5.3 and ISC install Hi all For what its worth, I installed all the ISC stuff without incident on a newly installed (just TSM and MSSQL) generic brand win20003 server with 2GB of memory. The only issue that I had was that to begin with I was attempting to install from a remotely mounted file specified as UNC ie \\remoteservername\drive\etc When I mapped the drive and tried again everything went swimmingly. Now learning to use it is another matter, but the install part wasn't too bad for me. Regards Steve. Steve Harris TSM Admin Queensland Health, Brisbane Australia. [EMAIL PROTECTED] 29/01/2005 1:24:48 Well, I decided to try it again, trying this suggestion. I increased my virtual-storage to 2.2GB (it was at 700MB + 512MB real). Same results. I fired up Window Task Manager and watched the install the whole time. Memory usage never went above 425MB. The install gets to 10% and sits there for around 10-minutes. Then jumps to 15%sits there a while and then BOOM - Install Failed - Uninstall Failed. Oh well.time to call for support ! David Wellington [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU 01/28/2005 03:11 AM Please respond to ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU To ADSM-L@VM.MARIST.EDU cc Subject Re: TSM 5.3 and ISC install - won't Hi, I've just spent 3 weeks or so trying to install ISC on a virtual machine and have experience many problems. The install would fail at the 15% mark everytime. Each time the install failed I looked in the logs that it told me too, and like you, it was full of rubbish. At no stage was there ever an error message that told me what the problem was. In the end, after trying many different things, including upgrading Java, I increased the memory allocation to the virtual machine and it installed up to 66% complete before failing. I then increased the memory again, and after yet another 4 hours, the install finally completed. In the end, I had some 2Gb of memory allocated to the virtual machine. Hopefully, this information
Re: AW: AW: TSM 5.3 and ISC install - successful on W2K Server under VMWare
Was it the memory or having access to SUN's website that helped? Michael Malitz [EMAIL PROTECTED] wrote:Hallo Joerg! Your tip/hint was absolutely right. I followed your instructions -- and all went OK Thanks a lot for your help Michael Malitz e-mail: [EMAIL PROTECTED] -Urspr|ngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joerg Pohlmann Gesendet: Samstag, 05. Februar 2005 21:48 An: ADSM-L@VM.MARIST.EDU Betreff: Re: AW: TSM 5.3 and ISC install Michael, make sure that the amount of memory the virtual machine sees (as RAM) is 1GB. Also, I found that on some installs, the process wants to go to SUN's java site and download/install bits and pieces of java, but this varies with what's installed on your W2K machine. It just means that you will need to let the install process access the internet. Joerg Pohlmann 604-535-0452 Michael Malitz Sent by: ADSM: Dist Stor Manager 2005-02-05 11:17 Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject AW: TSM 5.3 and ISC install Hi all, I?m also struggling with the new ISC and can not get over 66 %!!. I'm using Windows XP Host with VMWare and installed W2K Advanced Server SP4. My assigned physical memory to that W2K machine is 700 MB . During install a maximum of around 520 MB is used by ISCinstall processes. I increased the virtual Memory min 500 max 2000 MB and have 2,3 GB free disk space When I reach 66 % I get an error: Help is very much appreciated ? thanks and rgds Mikel Contents of ISCRuntimeInstallProgress.properties + #Sat Feb 05 22:33:17 CET 2005 ISC_FAILURE_MESSAGE=CheckDeployPageFail status=FAILED timestamp=Sat Feb 05 22\:33\:17 CET 2005 +++ end of log Contents of - the last entries of ISCRuntimeInstall.log (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.RemovePasswordsAction, msg2, Password replacement complete (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.RemovePasswordsAction, msg2, RemovePasswordsAction exit. (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.FailAndExitAction, wrn, CheckDeployPageFail (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.FailAndExitAction, wrn, (Feb 5, 2005 10:33:17 PM), Setup.product.install, com.ibm.pvc.we.care.ismp.FailAndExitAction, msg2, status=FAILED,timestamp=Sat Feb 05 22:33:17 CET 2005,progress=(unchanged) +++ end of log Thanks again Michael Malitz e-mail: [EMAIL PROTECTED] -Urspr|ngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Steve Harris Gesendet: Montag, 31. Jdnner 2005 03:04 An: ADSM-L@VM.MARIST.EDU Betreff: Re: TSM 5.3 and ISC install Hi all For what its worth, I installed all the ISC stuff without incident on a newly installed (just TSM and MSSQL) generic brand win20003 server with 2GB of memory. The only issue that I had was that to begin with I was attempting to install from a remotely mounted file specified as UNC ie \\remoteservername\drive\etc When I mapped the drive and tried again everything went swimmingly. Now learning to use it is another matter, but the install part wasn't too bad for me. Regards Steve. Steve Harris TSM Admin Queensland Health, Brisbane Australia. [EMAIL PROTECTED] 29/01/2005 1:24:48 Well, I decided to try it again, trying this suggestion. I increased my virtual-storage to 2.2GB (it was at 700MB + 512MB real). Same results. I fired up Window Task Manager and watched the install the whole time. Memory usage never went above 425MB. The install gets to 10% and sits there for around 10-minutes. Then jumps to 15%sits there a while and then BOOM - Install Failed - Uninstall Failed. Oh well.time to call for support ! David Wellington Sent by: ADSM: Dist Stor Manager 01/28/2005 03:11 AM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject Re: TSM 5.3 and ISC install - won't Hi, I've just spent 3 weeks or so trying to install ISC on a virtual machine and have experience many problems. The install would fail at the 15% mark everytime. Each time the install failed I looked in the logs that it told me too, and like you, it was full of rubbish. At no stage was there ever an error message that told me what the problem was. In the end, after trying many different things, including upgrading Java, I increased the memory allocation to the virtual machine and it installed up to 66% complete before failing. I then increased the memory again, and after yet another 4 hours, the install finally completed. In the end, I had some 2Gb of memory allocated to the virtual machine. Hopefully, this information maybe of some help. Regards. David Wellington
Re: Number of HBA's
I did not realize that was where you were going. I agree, looking at some of the disk solutions/options that are out there one could reduce costs even more by implementing more disk and less tape. Orville Lantto [EMAIL PROTECTED] wrote: I question why so many tape drives, tape drives are expensive. Perhaps those backups should be going to disk storage pools on $ 500 disk drives instead of buying more $15,000 tape drives. We make good money selling those tape drives, but adding tape drives is the more expensive way to accomplish the goal. I acknowledge that there are circumstances where a backup must go direct to tape, but in today's climate of inexpensive disk, perhaps less often than in the past. Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) IBM Premier Business Partner 121 Cheshire Lane, Suite 700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. TSM_User Sent by: ADSM: Dist Stor Manager 02/09/2005 09:12 PM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject Re: Number of HBA's but why design to do that? For the very practical reason that money doesn't grow on trees. If someone were to purchase and IBM 3584 with 12 LTO3 drives would we suggest that they use 12 HBA's or 6 dual port HBA's? In most cases I think not. There is a number of drives per HBA which should be met but it is more site and situation specific than a rule. You should be aware of how fast the drives can stream but you should also know how fast you need them to go. You should not under size your solution but you should also not oversize it either. Your point about database backup performance being dependent on disk speed. This is yet another reason not to determine how many drives per HBA you use simply based on the speed of the drive. Orville Lantto wrote: The point was that two HBAs for tape only provides bandwidth for two tape drives with compressible data, not four. Many people seem to under appreciate the bandwidth requirements of a properly designed tape system. For database data, it is usually the disk that is to slow to achieve optimum backup speeds. Yes, you can run the tape drive at a slower speed, but why design to do that? Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) IBM Premier Business Partner 121 Cheshire Lane, Suite 700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Loon, E.J. van - SPLXM Sent by: ADSM: Dist Stor Manager 02/09/2005 02:13 AM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject Re: Number of HBA's Hi Orville! I don't think this is really necessary since LTO2. LTO1 performance does suffer when you can't keep the drive streaming, but LTO2 and 3 adjust their tape speed if they detect that the amount of incoming data is too low. So there should not be any back-hitching here... Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Orville Lantto [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 21:33 To: ADSM-L@VM.MARIST.EDU Subject: Re: Number of HBA's Don't forget drive compression when making throughput calculations! 80 MB/sec * 4 (compression of text data) =320 MB/second as the maximum available bandwidth per LTO-3 drive. Good Luck keeping ONE of these beasts streaming with high compression! Orville L. Lantto Datatrend Technologies, Inc. (http://www.datatrend.com) IBM Premier Business Partner 121 Cheshire Lane, Suite 700 Minnetonka, MN 55305 Email: [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Ben Bullock Sent by: ADSM: Dist Stor Manager 02/08/2005 02:10 PM Please respond to ADSM: Dist Stor Manager To ADSM-L@VM.MARIST.EDU cc Subject Re: Number of HBA's The documents say you are supposed to NOT have SAN and tape devices running on the same HBAs. I would expect you would use 2 HBAs to connect to the SAN and 2 to connect to
