Unfortunately the classical answer "it depends" applies.
Based on processor power, memory size, number and type of disks, tuning
for performance (spreading access, no adapter bottlenecks) and of course
SLA requirements the limit can be reached at different point. Several
people on this list reported DBs over 150 GB.
DB reorg might be necessary but not too often. And you might have to
decide will it be one lengthy scheduled downtime or few shorter ones (if
server is split).
I do not have proof but personally am sure TSM DB and DB2 are derived from
same basic code. And this leads to a wish - DB2 is introducing on-line
reorg, hope someday TSM DB will have it.
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 DB Questions
We have several TSM 4.2 servers running on both z/OS and AIX and have
concerns about the TSM DB size as it impacts our ability to run
maintenance
operations like DB Audits, Reorgs, and SQL Queries also seem to take much
longer than they should on some systems.
I am curious what DB Sizes others have found manageable. The only answer
we
have been able to get from our Tivoli contacts is that we should not
exceed
50GB. This seems much too large given that a DB Rerog on a 50GB database
requires us to schedule a 36 hour outage (unload, format, reload process
on
z/OS).
1) How do other TSM shops size their TSM DB's?
I have heard both that the TSM DB is based on DB2, and that is in no way
related to DB2 from various Tivoli support people. I have seen some
discussion here and on ADSM.org about DB tuning practices with the
assumption that this is a variation of DB2. One of our admins recently
attended a TSM 4.1 class and in his textbook there is a comment "All
though
the TSM database is not a relational database....an interface makes it
appear as one".
(TSM 4.1 Enhancements, Tuning, and Troubleshooting, section 10-3)
2) Does anyone here know definitively if the TSM DB is or isn't a DB2
variant?
Thank You,
Al Bratlie
Lead Systems Engineer
Enterprise Storage Group
Thomson Legal and Regulatory Group Technical Services
"All views and opinions expressed are those of the author and have not
been
approved or reviewed by TLRTS"
|
