Re: database backup problem trigger
ok now that I can read the act log without my pc crashing I copied the last things it recorded and the first thing after a reboot. one of the more interesting things is that device type DBB disappeared. I had to recreate it, also the ANR's you see are many would any one have any idea on what may have happened? thanks Paul 04/01/02 14:15:39 ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage pool TAPEPOOL: Node W53260A, Type Backup, File space \\w53260a\c$, File name \PROGRAM FILES\WEBSVR\HTMLASCR\ HTMLA.INF. 04/01/02 14:15:39 ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage pool TAPEPOOL: Node W53260A, Type Backup, File space \\w53260a\c$, File name \PROGRAM FILES\WEBSVR\HTMLASCR\ HTMLA2.INF. 04/01/02 14:15:39 ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage pool TAPEPOOL: Node W53260A, Type Backup, File space \\w53260a\c$, File name \PROGRAM FILES\WEBSVR\HTMLASCR\ LOG.HTR. 04/01/02 14:15:39 ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage pool TAPEPOOL: Node W53260A, Type Backup, File space \\w53260a\c$, File name \PROGRAM FILES\WEBSVR\HTMLASCR\ LOGU.HTR. 04/01/02 14:15:39 ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage pool TAPEPOOL: Node W53260A, Type Backup, File space \\w53260a\c$, File name \PROGRAM FILES\WEBSVR\HTMLASCR\ MSG.HTR. 04/01/02 14:15:39 ANR1173E Space reclamation for offsite volume(s) cannot copy file in storage pool TAPEPOOL: Node W53260A, Type Backup, File space \\w53260a\c$, File name \PROGRAM FILES\WEBSVR\HTMLASCR\ MSGU.HTR. 04/02/02 11:26:08 ANR7860W Insufficient Space Available for file L8674677.- LOG. 04/02/02 11:26:08 ANR4429W Unable to Define Recovery Log Volume L8674677.LOG. 04/02/02 11:26:08 ANR4415I Data Base and Recovery Log Space Expansion Completed. > -Original Message- > From: Alex Paschal [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 4:09 PM > To: [EMAIL PROTECTED] > Subject: Re: database backup problem trigger > > Well, I have seen situations where a full recovery log causes that, and > I've > seen situations where I audited a bad volume and all the damaged files > were > dumped into the activity log so fast that it stopped logging anything to > the > activity log. I haven't had it happen recently, since I learned to audit > with quiet=yes, as a matter of fact, but I have started using the dsmulog > utility to keep my actlog for months, so if that happens again, I can just > go to the dsmulog files to see what was going on and what might have > caused > it. > > I also have cron'd processes that log in every 10 and 30 minutes to check > various stuff and alog them to circular log files, so it's pretty easy to > see how problem situations, such as those involving the recovery log, > evolve. > > Alex Paschal > Storage Administrator > Freightliner, LLC > (503) 745-6850 phone/vmail > > > -Original Message- > From: Coviello, Paul [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 11:50 AM > To: [EMAIL PROTECTED] > Subject: Re: database backup problem trigger > > > yes that is right, it was looking for DBB when I did the query it > wasn't there! the manual /scheduled one is using the tapepool or devclass > offsite. I recreated a DBB devclass and the DB trigger worked. of course > that doesn't explain where it went! > > thanks any idea on the other ? > > > Paul > > > -Original Message- > > From: Alex Paschal [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 02, 2002 2:45 PM > > To: [EMAIL PROTECTED] > > Subject: Re: database backup problem trigger > > > > I assume you're talking about dbbackups instead of restores. > > > > If you do a "query dbbackuptrigger" what DEVclass and INCRDEVclass is it > > set > > to use? If you do a "query devclass" do those devclasses exist? What > > devclass is your manual dbbackup using? > > > > Alex Paschal > > Storage Administrator > > Freightliner, LLC > > (503) 745-6850 phone/vmail > > > > -Original Message- > > From: Coviello, Paul [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 02, 2002 11:29 AM > > To: [EMAIL PROTECTED] > > Subject: database backup problem trigger > > > > > > HI we had a failure of our TSM server running AIX 4.3.3 and TSM 4.1.3 > > > > one of the errors we are getting is the following: > > > > ANR4570E Database backup/restore terminated - device class DBB not > defined > > > > this is not happening if we do the scheduled one manually. this is only > > happening with the database backup trigger. > > > > > > the other problem is we can't query the act log from 11:30 this am to 24 > > hours ago? nothing in between! > > > > any ideas > > > > > > thanks > > Paul
Re: database backup problem trigger
Well, I have seen situations where a full recovery log causes that, and I've seen situations where I audited a bad volume and all the damaged files were dumped into the activity log so fast that it stopped logging anything to the activity log. I haven't had it happen recently, since I learned to audit with quiet=yes, as a matter of fact, but I have started using the dsmulog utility to keep my actlog for months, so if that happens again, I can just go to the dsmulog files to see what was going on and what might have caused it. I also have cron'd processes that log in every 10 and 30 minutes to check various stuff and alog them to circular log files, so it's pretty easy to see how problem situations, such as those involving the recovery log, evolve. Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Coviello, Paul [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 11:50 AM To: [EMAIL PROTECTED] Subject: Re: database backup problem trigger yes that is right, it was looking for DBB when I did the query it wasn't there! the manual /scheduled one is using the tapepool or devclass offsite. I recreated a DBB devclass and the DB trigger worked. of course that doesn't explain where it went! thanks any idea on the other ? Paul > -Original Message- > From: Alex Paschal [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 2:45 PM > To: [EMAIL PROTECTED] > Subject: Re: database backup problem trigger > > I assume you're talking about dbbackups instead of restores. > > If you do a "query dbbackuptrigger" what DEVclass and INCRDEVclass is it > set > to use? If you do a "query devclass" do those devclasses exist? What > devclass is your manual dbbackup using? > > Alex Paschal > Storage Administrator > Freightliner, LLC > (503) 745-6850 phone/vmail > > -Original Message- > From: Coviello, Paul [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 11:29 AM > To: [EMAIL PROTECTED] > Subject: database backup problem trigger > > > HI we had a failure of our TSM server running AIX 4.3.3 and TSM 4.1.3 > > one of the errors we are getting is the following: > > ANR4570E Database backup/restore terminated - device class DBB not defined > > this is not happening if we do the scheduled one manually. this is only > happening with the database backup trigger. > > > the other problem is we can't query the act log from 11:30 this am to 24 > hours ago? nothing in between! > > any ideas > > > thanks > Paul
Re: database backup problem trigger
yes that is right, it was looking for DBB when I did the query it wasn't there! the manual /scheduled one is using the tapepool or devclass offsite. I recreated a DBB devclass and the DB trigger worked. of course that doesn't explain where it went! thanks any idea on the other ? Paul > -Original Message- > From: Alex Paschal [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 2:45 PM > To: [EMAIL PROTECTED] > Subject: Re: database backup problem trigger > > I assume you're talking about dbbackups instead of restores. > > If you do a "query dbbackuptrigger" what DEVclass and INCRDEVclass is it > set > to use? If you do a "query devclass" do those devclasses exist? What > devclass is your manual dbbackup using? > > Alex Paschal > Storage Administrator > Freightliner, LLC > (503) 745-6850 phone/vmail > > -Original Message- > From: Coviello, Paul [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 11:29 AM > To: [EMAIL PROTECTED] > Subject: database backup problem trigger > > > HI we had a failure of our TSM server running AIX 4.3.3 and TSM 4.1.3 > > one of the errors we are getting is the following: > > ANR4570E Database backup/restore terminated - device class DBB not defined > > this is not happening if we do the scheduled one manually. this is only > happening with the database backup trigger. > > > the other problem is we can't query the act log from 11:30 this am to 24 > hours ago? nothing in between! > > any ideas > > > thanks > Paul
Re: database backup problem trigger
I assume you're talking about dbbackups instead of restores. If you do a "query dbbackuptrigger" what DEVclass and INCRDEVclass is it set to use? If you do a "query devclass" do those devclasses exist? What devclass is your manual dbbackup using? Alex Paschal Storage Administrator Freightliner, LLC (503) 745-6850 phone/vmail -Original Message- From: Coviello, Paul [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 11:29 AM To: [EMAIL PROTECTED] Subject: database backup problem trigger HI we had a failure of our TSM server running AIX 4.3.3 and TSM 4.1.3 one of the errors we are getting is the following: ANR4570E Database backup/restore terminated - device class DBB not defined this is not happening if we do the scheduled one manually. this is only happening with the database backup trigger. the other problem is we can't query the act log from 11:30 this am to 24 hours ago? nothing in between! any ideas thanks Paul
database backup problem trigger
HI we had a failure of our TSM server running AIX 4.3.3 and TSM 4.1.3 one of the errors we are getting is the following: ANR4570E Database backup/restore terminated - device class DBB not defined this is not happening if we do the scheduled one manually. this is only happening with the database backup trigger. the other problem is we can't query the act log from 11:30 this am to 24 hours ago? nothing in between! any ideas thanks Paul
