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"
