Hmm, that tunig one db is much like tuning another is not really surprising, right. Want to know why, it's all more: memory, spindles and last cpu, it's all about separating recovery log and database (and indices). This does not mean the tsm db is anything like db2, it most likely isn't since the tsm db is not a relational database...
On maandag, juli 15, 2002, at 12:01 , Zlatko Krastev wrote: > The key is "will be". So be patient. > Alternative is list archives - performance considerations were many > times > discussed. > Third option might be DB2 docs. Basic DB2 performance tuning looks just > like TSM DB tuning but is having more switches and levers ,-) On the end > internal TSM DB is just the DB2 code at version 1 or 2 with some > functionality stripped out. Single DB instance, unknown number of > tablespaces (with no individual control), single bufferpool for tables > and > indexes, etc. > The only curious thing (for me) is that DB2 does have a tablespace limit > of 64 GB if 4kB pagesize is used. And even if TSM uses separate > tablespaces for BACKUPS, CONTENTS and AS.Segments tables it is unknown > what can happen if any table reaches this limit (and is this a limit for > TSM). On the list I've seen client, driver, TDP developers, support > people > but not yet server developer (or I missed him/her) to reveal the mistery > :) > So if you need a book right now just ask a DB2 admin for some hints or > visit DB2 docs site and read few chapters there. > > Zlatko Krastev > IT Consultant > > > > > Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > cc: > > Subject: TSM 5.1 Performance Tuning Guide - Where? > > The README.SRV file for AIX Server 5.1.1.1 update says that, "The IBM > Tivoli Storage Manager V5.1 Performance Tuning Guide will be available > on the home page. Point your web browser to this address: > http://www.tivoli.com/support/storage_mgr/tivolimain.html " > > I can't find it. > > Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] > =================== The command line is your friend. =================== > --- Met vriendelijke groeten, Remco Post SARA - Stichting Academisch Rekencentrum Amsterdam http://www.sara.nl High Performance Computing Tel. +31 20 592 8008 Fax. +31 20 668 3167 "I really didn't foresee the Internet. But then, neither did the computer industry. Not that that tells us very much of course - the computer industry didn't even foresee that the century was going to end." -- Douglas Adams