Re: Sudden logical log overuse??

Rob Mascaro (rob@DIALix.oz.au) wrote: : Hi, : Can someone point me in the right direction to look for logical log : space filling up too fast. We have 5 10mb logs which have been more than : adequate in the past for a database chunk size in total of 300mb of : which half is used. Suddenly we are running out of logs, I have a hunch : that some users are doing continual long searches causing the logs to fill : up. Usually, searches won't fill up logs. The culprits tend to be updates, inserts, and deletes. Look for users copying large tables with: insert into tableA (select * from tableB) types of statements. Be suspicious of people doing loads into tables, no matter whate the type. If you can catch the problem in the act, look at the tables in use with a tbstat -t. That'll help you see what tables are likely prospects. Look for tables with lots of rows and lots of reads and writes. You didn't specify what you mean by "running out of logs". The above would cause your logs to fill very rapidly. If you're seeing a case where old logs just kind of hang around and don't go away after being backed up to tape, you have a long transaction problem. Use a series of tbstat -u commands and look for "T" or "B" in the flag field, indicating transactions. One particular sneaky source of long transactions is a user doing a job inside of a begin work loop. Until that person commits (maybe the job's waiting for input and he's at lunch) the logfiles cannot be released. If others are doing lots of loggable stuff in the meantime, the logs fill up and because of your guy with the late lunch, they don't go away. : How can I determine what the problem is?? If the above doesn't work, try using the tblog utility to look at the logfiles and see what kind of transactions they're recording. If possible look at a log other than the current one. If you do a tblog on the active log, you'll freeze up the system. : Thanks, : Rob. : -- : \\ = ,_|\\ : < []_[]= | Rob Mascaro email: Rob@Dialix.oz.au / \\ : /\\/(_)\\|/|\\ Systems Administrator phone: +61 9 4251804 <* | : Racing and Gaming Perth, Western Australia \\/--\\/ Good luck, Joe -- =========================================================================== jlumbley@netcom.com Joe Lumbley Database Administrator (214) 941-3417 The Tigon Corporation (214) 733-8671 (work) Dallas, Texas ===========================================================================