Wanda, I will check out ALLOWREORGTABLE NO. Thanks, that could be very important.
As for the second issue, can anybody tell me why the automatic database log isn't running, even when the filesystem for the archives is filling up? What triggers it, and how do I control it? I guess I can just write a script to monitor it and perform the "backup db" when the filesystem gets close to full, but since this is supposed to be an automatic feature, it seem like something is wrong here. Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721 -------- Original Message -------- Subject: Re: [ADSM-L] TSM 6.1 automatic database backups From: "Prather, Wanda" <wprat...@icfi.com> Date: Thu, May 13, 2010 7:42 pm To: ADSM-L@VM.MARIST.EDU John, Make sure you have in the dsmserv.opt file: ALLOWREORGTABLE NO There is a bug in 6.1 that lets the automatic DB table reorgs go nuts with the log. 1) On one instance, each day a full TSM DB backup gets done, but within about 16-18 hours, the archive filesystem is filling up. The archive filesystem is 50GB, which is of course much bigger than it was under 5.5. We have only migrated a fraction of the TSM clients over to this instance, so I shudder to think how much archive space is going to be require when all the TSM clients are in place. Can anybody give me any tips on reducing the amount of log data that gets created so it doesn't fill up so fast? 2) I used "set drrecovery dbb_full" to point this to a FILE type devclass where we want the DB backups to go. According to the manual, this should cause the database to get automatically get backed up. But the manual is totally obscure about how full it is going to get before it kicks off the backup. It describes the vague criteria, but doesn't seem to give the admin any controls. We have seen it 98% full, and gave up and performed the 'backup db' manually. Can anybody give me more details than the manuals have about how this works and how to control it? Best Regards, John D. Schneider The Computer Coaching Community, LLC Office: (314) 635-5424 / Toll Free: (866) 796-9226 Cell: (314) 750-8721