Gurus (sorry about the long message - most of it is DB2diag.log info):
Running DB2 9.1 fp2 on Windows 2003 server.
We are running Confluence (an enterprise wiki) on this box. This is the
only application that is running on this box and that is using this
database. We are still testing this application, so there are only about
10 people using it at the moment and it really isn't being hit hard. I
was receiving the following health monitor message a few times a day...
ADM10502W Health indicator "Database Backup Required"
("db.db_backup_req") is in state "Automated backup failed" on "database"
"DB2.WIKI_CFL".
The following was logged in the db2diag.log at that time...
2007-11-26-05.26.52.484000-360 I6729967H375 LEVEL: Event
PID : 3192 TID : 4252 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.071126112656
FUNCTION: DB2 UDB, Health Monitor, hmonBkpBackupDBOnline, probe:500
START : Automatic job "Backup database online" has started on database
WIKI_CFL, alias WIKI
2007-11-26-05.26.52.530000-360 E6730344H397 LEVEL: Info
PID : 3048 TID : 2496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WIKI_CFL
APPHDL : 0-769 APPID: *LOCAL.DB2.071126112657
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubSetupJobControl, probe:1391
MESSAGE : Starting an online db backup.
2007-11-26-05.26.54.296000-360 I6730743H426 LEVEL: Warning
PID : 3048 TID : 5412 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile,
probe:3180
MESSAGE : Successfully archived log file S0036205.LOG to
C:\DB2Logs\Wiki\Archive\DB2\WIKI_CFL\NODE0000\C0000000\ from
C:\DB2Logs\Wiki\Active\.
2007-11-26-05.27.05.031000-360 E6731171H372 LEVEL: Info
PID : 3048 TID : 2496 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : WIKI_CFL
APPHDL : 0-769 APPID: *LOCAL.DB2.071126112657
AUTHID : DB2ADMIN
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:833
MESSAGE : Backup complete.
2007-11-26-05.27.05.031000-360 I6731545H575 LEVEL: Event
PID : 3192 TID : 4252 PROC : db2fmp.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, Health Monitor, hmonBkpBackupDBOnline, probe:540
MESSAGE : SQL1224N The database manager is not able to accept new
requests,
has terminated all requests in progress, or has terminated your
particular request due to a problem with your request.
STOP : Automatic job "Backup database online" has completed with errors
on database WIKI_CFL, alias WIKI
2007-11-26-05.27.05.093000-360 I6732122H342 LEVEL: Info
PID : 3048 TID : 2400 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390
DATA #1 : <preformatted>
ExtNum 36206 state 1 baselsn 0000003A64FA0000 nextlsn 0000003A64FA000C
Yesterday, I did a manual on-line backup and it completed without any
errors. Any idea why the automatic backup was failing?
Also, I noticed that a new log file is added to the archive directory
every minute. The log files are only 12kb in size. Again, there aren't a
lot of people using this, and it is creating logs when no one is on. Is
there a way to see what is in a log file (preferably useful information)?
I have copied information from the DB2diag.log file that seems to show up
every minute when the log file is created. I have a database on another
server that is used by multiple people 24/7. The log file settings are
the same, however, a new archive log is only created once or twice a day.
2007-11-26-09.58.00.065000-360 I6988885H344 LEVEL: Info
PID : 3048 TID : 980 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpghck, probe:1390
DATA #1 : <preformatted>
ExtNum 36434 state 101 baselsn 0000003A9DFA0000 nextlsn 0000003A9DFA009A
2007-11-26-09.58.00.065000-360 I6989231H426 LEVEL: Warning
PID : 3048 TID : 5860 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile,
probe:3180
MESSAGE : Successfully archived log file S0036434.LOG to
C:\DB2Logs\Wiki\Archive\DB2\WIKI_CFL\NODE0000\C0000000\ from
C:\DB2Logs\Wiki\Active\.
2007-11-26-09.58.01.331000-360 E6989659H347 LEVEL: Info
PID : 3048 TID : 4580 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInitDelOldLog,
probe:1440
DATA #1 : <preformatted>
Cleaning up logs from RenameArchNum 36434 to delLimit 36435.
Any information would be helpful.
Thanks,
Dan Luchinski
Database Administrator
ASPCA Knowledge Management Center
University of Illinois Allied Agency
Phone: 217.337.9777 Fax: 217.337.0599 Web: www.aspca.org
DB2 & UDB email list listserv db2-l LazyDBA home page