How to figure out why Log got pinned - afterwards
Over the weekend, my Log got pinned and it filled up, severely interrupting a barbecue. (Murphy's Law in action: My pager went off WHILE the steaks were on the grill.) Now that it is all mopped up (and the easily available evidence is thereby destroyed) how can I figure out how this happened? (I know, I should have entered a SHOW LOGPIN command, but I didn't. It didn't occur to me until a search of adsm.org long afterward.) Are there any telltale signs I can search for in the Activity Log? Or in the Accounting file? Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] Research is what I'm doing when I don't know what I'm doing. = -- Wernher von Braun =
Re: How to figure out why Log got pinned - afterwards
Look for an NT box that had a session canceled due to a timeout value being reached... 04/23/2004 23:37:24 ANR0481W Session 834 for node (WinNT) terminated - client did not respond within 7800 seconds. (SESSION: 834) That sucker pinned my log and triggered about 200+ full data base backups because each full db backup didn't free enough log space! ARGH ! Dwight E. Cook Systems Management Integration Professional, Advanced Integrated Storage Management TSM Administration (918) 925-8045 Roger Deschner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: How to figure out why Log got pinned - afterwards Manager [EMAIL PROTECTED] .EDU 04/26/2004 09:48 AM Please respond to ADSM: Dist Stor Manager Over the weekend, my Log got pinned and it filled up, severely interrupting a barbecue. (Murphy's Law in action: My pager went off WHILE the steaks were on the grill.) Now that it is all mopped up (and the easily available evidence is thereby destroyed) how can I figure out how this happened? (I know, I should have entered a SHOW LOGPIN command, but I didn't. It didn't occur to me until a search of adsm.org long afterward.) Are there any telltale signs I can search for in the Activity Log? Or in the Accounting file? Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] Research is what I'm doing when I don't know what I'm doing. = -- Wernher von Braun = inline: graycol.gifinline: ecblank.gifinline: pic26065.gif
Re: How to figure out why Log got pinned - afterwards
Dwight, You might want to look into some of the new additions to Define dbb, such as mininterval and minlogfreepct. They can help to alleviate problems like the one you ran into. They cause TSM to not run another incr db bkp unless a certain amount of time has elapsed and/or a certain percentage of the log will actually be freed up by running the db backup. ..Paul At 01:59 PM 4/26/2004 -0500, Dwight Cook wrote: Look for an NT box that had a session canceled due to a timeout value being reached... 04/23/2004 23:37:24 ANR0481W Session 834 for node (WinNT) terminated - client did not respond within 7800 seconds. (SESSION: 834) That sucker pinned my log and triggered about 200+ full data base backups because each full db backup didn't free enough log space! ARGH ! Dwight E. Cook Systems Management Integration Professional, Advanced Integrated Storage Management TSM Administration (918) 925-8045 Roger Deschner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: ADSM: cc: Dist StorSubject: How to figure out why Log got pinned - afterwards Manager [EMAIL PROTECTED] .EDU 04/26/2004 09:48 AM Please respond to ADSM: Dist Stor Manager Over the weekend, my Log got pinned and it filled up, severely interrupting a barbecue. (Murphy's Law in action: My pager went off WHILE the steaks were on the grill.) Now that it is all mopped up (and the easily available evidence is thereby destroyed) how can I figure out how this happened? (I know, I should have entered a SHOW LOGPIN command, but I didn't. It didn't occur to me until a search of adsm.org long afterward.) Are there any telltale signs I can search for in the Activity Log? Or in the Accounting file? Roger Deschner University of Illinois at Chicago [EMAIL PROTECTED] Research is what I'm doing when I don't know what I'm doing. = -- Wernher von Braun = -- Paul Zarnowski Ph: 607-255-4757 719 Rhodes Hall, Cornell UniversityFx: 607-255-8521 Ithaca, NY 14853-3801 Em: [EMAIL PROTECTED]