Certainly the architectural limit is a boundary you don't want to get very close to.
But besides that, there are issues of database performance as the DB grows and grows. We have TSM servers running four TSM instances on 8-way pSeries AIX servers with redundant FC links to raw logical volumes on EMC Symmetrix or Clariiion disk, with databases ranging from 80-225GB, and their performance is just fine. Expire inventory times are 1-2 hours, Database backup is 1-2 hours max (to LTO4 tape drives). But we also have smaller Windows servers with dual processors and LTO3 tape drives, and with 30-50GB databases the Expire Inventory and Database backups are also 1-2 hours. If we let those Windows TSM databases grow to 225GB they would not perform nearly so well, so we have to watch how big they grow. Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721 -------- Original Message -------- Subject: Re: [ADSM-L] TSM DB Size From: Richard Mochnaczewski <richard.mochnaczew...@standardlife.ca> Date: Tue, November 10, 2009 10:51 am To: ADSM-L@VM.MARIST.EDU We had a health check done by IBM when we were at TSM 5.3 and were told they don't recommend a DB size higher than 120Gb for performance and restore purposes. Rich -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Kelly Lipp Sent: Tuesday, November 10, 2009 11:48 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM DB Size The architectural limit is 500GB. Practically, one should be a good bit smaller. It really boils down to how long do you want a restore of the backed up DB to take? Figure about 150% of the backup time for a restore. Can you live with that? Kelly Lipp Chief Technical Officer www.storserver.com 719-266-8777 x7105 STORServer solves your data backup challenges. Once and for all. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Huebschman, George J. Sent: Tuesday, November 10, 2009 9:42 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] TSM DB Size We have DB's over 190 Gb in 5.5, on AIX servers: TSM_Server CAP_GB MAX_EXT_GB PCT_UTIL MAX_UTIL ----------- ------- ---------- -------- -------- AIXPRODXYZ 191.95 0.00 89.4 89.4 AIXPRODDMZ 219.76 4.17 90.3 91.1 -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Richard Mochnaczewski Sent: Tuesday, November 10, 2009 11:35 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] TSM DB Size Hi *, Does anyone know what the maximum size database is for TSM 5.4 and TSM 5.5 ? We were told by IBM when we were at TSM 5.3 that 120Gb was the limit and was wondering what the limit is for 5.4 and 5.5. Currently running TSM 5.4.3.0 on AIX 5.3 TL 9. Rich IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason therefore recommends that you do not send any confidential or sensitive information to us via electronic mail, including social security numbers, account numbers, or personal identification numbers. Delivery, and or timely delivery of Internet mail is not guaranteed. Legg Mason therefore recommends that you do not send time sensitive or action-oriented messages to us via electronic mail. This message is intended for the addressee only and may contain privileged or confidential information. Unless you are the intended recipient, you may not use, copy or disclose to anyone any information contained in this message. If you have received this message in error, please notify the author by replying to this message and then kindly delete the message. Thank you.
