I hope you can be convinced TSM DB is pure relational and not flat files
with few SQL queries on top of them:
Internal addressing of all data archived/backed up is through OBJECT_ID.
All links between the object (B/A client file, TDP backup/logs, Content
Manager documents, etc.), the object's name and physical placement on
volumes is through relations.
SELECT queries are not some kind of add-on but integral part of TSM
server with very wide subset of DB2 features (field types, SQL functions,
etc.). If in doubt about any TSM SQL function look at its description in
DB2 manuals.
Have a look at nice post made by Roger Deschner on thread "tsm internal
design?" 6 weeks ago. His definition for WDSF/ADSM/TSM is very nice and
hits the bullseye. Thank you, Roger.

Lets say TSM DB is not DB2 but a cousin of it. Actually they are derived
from the same code. Also TSM DB physical layout is using same LVM code AIX
is using for filesystems and raw devices (but this is another story).
If you are interested in the history of the product (and try to dig down
IBM Announcement Letters archives) you can find TSM originate from
mainframe world:
1. '80s - IBM Data Facility Storage Management Subsystem (DFSMS for
System/370; still current and developed as DFSMS for S390/zSeries; very
good product but mainframe guys can comment it better than me)
2. '91 - IBM Workstation Data Save Facility/VM (VM server to backup PCs
running DOS)
3. '93 - IBM Data Facility Distributed Storage Manager (v1.0, from there
come all dsm* names)
4. '93 - in version 1.1 renamed to IBM ADSTAR Distributed Storage Manager
(ADSM)
5. 1994-2002 - You probably know the rest.

Same story for the DB2 - IBM had relational database (with SQL queries)
for System/370; later ported to RS/6000, S/390, AS/400 (integrated in the
OS/400); got new name in '90s as DB2; later become DB2 UDB. Same
research&concepts evolved from the old mainframes.


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:        Re: TSM 5.1 Performance Tuning Guide - Where?

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