I agree- we have tried to run unload/load DB and audit DB to either conserve space or cleanup the database and found in both cases that the time required (we have 100 GB databases) was not worth the effort. R.Sims comments on this make sense too, since DB space is random, however we still face 1.3 hours for DBS backup daily--
It would certainly be nice to shrink the overall daily timeframes down with an advanced DB backup function above and beyond the full+incremental variants that we use today- wouldn't it be cool to have multi-session DB backups that allow you to backup/restore the DB to/from multiple volumes at once like DB2 or UDBEEE.....
Also- a DB merge utility would be brilliant- where someday in the future if you loose one TSM server(failure,scheduled maintenance, disasters), the other TSM server instance could still access it's data stores (like a big parallel database setup where any instance can get to any data...).
Ok- 'time to pass the crack pipe....
John
From: Zlatko Krastev/ACIT <[EMAIL PROTECTED]> Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: Re: Auditdb timing - FYI Date: Thu, 12 Jun 2003 11:25:38 +0300
rhetorical answer to a rhetorical question: I am under impression that TSM DB and DB2 are some sort of cousins - derived from same SQL/370 design or code. Thus the answer to your question might be "when TSM DB is going to catch up with recent improvements on DB2/Informix front". I still remember (and can find in my archives) the Roger's post on the thread "rollforward vs. normal mode" nearly a year ago. TDP for TSM is not so silly as it sounds. But if an add-on product is developed allowing multi-stream TSM DB backups/restores and better access to DB contents for queries, it might be sold separately as DRM was in v4.2 and before (regardless the name). Wake up IBM/Tivoli Marketing, developers and support are good but you have to be inventive too. And better not by changing licensing schema on each version or changing prices every quarter.
Zlatko Krastev IT Consultant
Fred Johanson <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 06.06.2003 22:08 Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED] cc: Subject: Re: Auditdb timing - FYI
...
My real question, rhetorical of course, is when is TIVOLI going to supply us with a tool kit for identifying and working thru DB problems? Why do I have to write some code to identify an object in the DB? Why are there no functions available to do this?
Wouldn't it be nice if V5R3 or V6R1, whichever comes first, were devoted to the care and feeding of the TSM DB.
My $.02 anyway.
...
_________________________________________________________________ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail
