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" <ADSM-L AT VM.MARIST DOT EDU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
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 rogerd AT uic DOT edu
=================== The command line is your friend. ===================
---
Met vriendelijke groeten,
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
|
