backup hangs db2

Harold Pritchett

backup hangs db2
I am running db2 UDB v8.1 FP 12 on RedHat Enterprise Linux 3.

Everything has been running fine for months. The server hadn't
been re-booted since early October. This morning, the server
was hung, with db2 in a strange state. I was unable to stop
the server, getting an SQL1072C Cannot restart deb2 "Inconsistant
state" error.

I had to re-boot the server to get db2 back up.

I then trid to run my backup script, and the server hung again
exactly the same way. I ended up re-booting the server again
to bet it back.

The guts of the backup script looks like this:

DATE=$(/bin/date +%Y%m%d)
DOW=$(/bin/date +%A)
HNS=$(/bin/hostname -s)
logfile2=$DATE".log"

if [ $DOW = Sunday ]; then
backupset="weekly"
backuppath="/db2home/backup2"
logfile="/db2home/backup2/"$DATE".log"
/bin/su - db2inst1 -c "db2stop force"
/bin/su - db2inst1 -c "db2start"
/bin/su - db2inst1 -c "db2 -tvf /db2home/bin/animals.weekly -l $logfile -r $logfile"
/bin/su - db2inst1 -c "db2 -tvf /db2home/bin/toolsdb.weekly -l $logfile -r $logfile"
else
backupset="daily"
backuppath="/db2home/backup1"
logfile="/db2home/backup1/"$DATE".log"
/bin/su - db2inst1 -c "db2stop force"
/bin/su - db2inst1 -c "db2start"
/bin/su - db2inst1 -c "db2 -tvf /db2home/bin/animals.daily -l $logfile -r $logfile"
/bin/su - db2inst1 -c "db2 -tvf /db2home/bin/toolsdb.daily -l $logfile -r $logfile"
fi

The files below have been re-formatted for readability...

The output from the cron job contains:

Backup.db started at Sat Dec 30 03:30:01 EST 2006
SQL1064N DB2STOP processing was successful.
SQL1063N DB2START processing was successful.
ATTACH TO db2inst1

Instance Attachment Information

Instance server = DB2/LINUX 8.2.5
Authorization ID = DB2INST1
Local instance alias = DB2INST1


BACKUP DATABASE ANIMALS USER db2inst1 using TO '/db2home/backup1'
WITH 1 BUFFERS BUFFER 0 PARALLELISM 1 WITHOUT PROMPTING
/usr/local/bin/backup.db: line 30: 22950 Killed /bin/su - db2inst1
-c "db2 -tvf /db2home/bin/animals.daily -l $logfile -r $logfile"
ATTACH TO db2inst1
/usr/local/bin/backup.db: line 30: 32455 Killed /bin/su - db2inst1
-c "db2 -tvf /db2home/bin/toolsdb.daily -l $logfile -r $logfile"
/db2home/backup1/ANIMALS.0.db2inst1.NODE0000.CATN0000.20061229033223.001.bz2.bz2:
No such file or directory
Backup.db ended at Sat Dec 30 08:00:43 EST 2006

A normal output looks like this:

Backup.db started at Sat Dec 30 03:30:01 EST 2006
SQL1064N DB2STOP processing was successful.
SQL1063N DB2START processing was successful.
ATTACH TO db2inst1

Instance Attachment Information

Instance server = DB2/LINUX 8.2.5
Authorization ID = DB2INST1
Local instance alias = DB2INST1


BACKUP DATABASE ANIMALS USER db2inst1 using TO '/db2home/backup1'
WITH 1 BUFFERS BUFFER 0 PARALLELISM 1 WITHOUT PROMPTING

Backup successful. The timestamp for this backup image is : 20061230033110


DETACH
DB20000I The DETACH command completed successfully.

TERMINATE
DB20000I The TERMINATE command completed successfully.

ATTACH TO db2inst1

Instance Attachment Information

Instance server = DB2/LINUX 8.2.5
Authorization ID = DB2INST1
Local instance alias = DB2INST1


BACKUP DATABASE toolsdb USER db2inst1 using TO '/db2home/backup1'
WITH 1 BUFFERS BUFFER 0 PARALLELISM 1 WITHOUT PROMPTING

Backup successful. The timestamp for this backup image is : 20061230033803


DETACH
DB20000I The DETACH command completed successfully.

TERMINATE
DB20000I The TERMINATE command completed successfully.

Does anyone have any ideas why my backup just started to fail? What can I do
to get this back?

Thanks

Harold
--
Harold Pritchett
[login to unmask email] +1.706.546.0692
pgp public key: http://www.arches.uga.edu/~harold/pgpkey.html

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm