We have a 75GB DB at 90% capacity. It takes a while to do a full backup to a 3590 class tape device.
We have enough nodes dumping data at the box that the log can fill in the time it takes the db backup to complete. We have our incremental trigger set at 40%, so incrementals have (so far, knock on wood) been completing OK, provided no other problems occur, such as the problems with lock contention in the 4.2.2.x series. -----Original Message----- From: Mark Stapleton [mailto:[EMAIL PROTECTED]] Sent: Friday, June 14, 2002 9:57 AM To: [EMAIL PROTECTED] Subject: Re: DB backups From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Jolliff, Dale > Is anyone doing db backups to disk using devclass type FILE? Yes. > I know, it's not necessarily a good thing, but right now we have a db that > is large enough that the log can fill before a full db backup can run. You can run an incremental backup to FILE, which won't take up that much room. Actually, the size of the database has nothing to do with the use of the log. The log is filled with TSM transactions that are waiting to be committed to the database. Your best choices for solutions are 1) Increase the size of your log (if possible) 2) Run more than one backup of your database each day (incremental or full) 3) Change your logmode to normal (if it's currently in rollforward mode) -- Mark Stapleton ([EMAIL PROTECTED]) Certified TSM consultant Certified AIX system engineer MSCE
