ADSM-L

Deadlock while starting ON-Bar backup

2001-12-16 12:02:02
Subject: Deadlock while starting ON-Bar backup
From: "Ganu Sachin, IBM" <Sachin.Ganu AT KWA2.SIEMENS.CO DOT IN>
Date: Sat, 15 Dec 2001 10:33:09 +0530
Hi,

Sometimes I face problem while starting automated backup of Informix using
Tivoli Storage Manager. I have AIX 4.3.3 with TSM 3.7.0 and TDP for Informix
version 1.0 and Informix is 7.24 UC3. The backup is scheduled at 00:05:00 in
TSM. Any idea why it is happening?
I also backup Informix control files followed by ON-Bar backup in the same
script which is scheduled thro' TSM.

There are no errors reported in Informix logfile. Any idea what could be the
reason ? How do I avoid this situation ? Attached is ON-Bar logfile for your
reference. The error is marked as bold red.

 2001-12-15 00:04:46 27528  28692 Begin backup logical log 88114.
 2001-12-15 00:04:46 27528  28692 Successfully connected to Storage Manager.
 2001-12-15 00:04:48 27528  28692 Completed backup logical log 88114.
 2001-12-15 00:04:55 27534  28696 onbar -l
 2001-12-15 00:04:55 27534  28696 Begin backup logical log 88115.
 2001-12-15 00:04:55 27534  28696 Successfully connected to Storage Manager.
 2001-12-15 00:04:57 27534  28696 Completed backup logical log 88115.
 2001-12-15 00:05:03 27542  28702 onbar -l
 2001-12-15 00:05:03 27542  28702 Begin backup logical log 88116.
 2001-12-15 00:05:03 27542  28702 Successfully connected to Storage Manager.
 2001-12-15 00:05:05 27542  28702 Completed backup logical log 88116.
 2001-12-15 00:05:08 27546  28710 onbar -b -w -L 1
 2001-12-15 00:05:11 28666  27136 onbar -l
 2001-12-15 00:05:11 28666  27136 Begin backup logical log 88117.
 2001-12-15 00:05:11 28666  27136 Successfully connected to Storage Manager.
 2001-12-15 00:05:13 27546  28710 SQL     -245  Could not position within a
file via an index.
 2001-12-15 00:05:13 27546  28710 ISAM     -143 ISAM error: deadlock
detected
 2001-12-15 00:05:13 28666  27136 Completed backup logical log 88117.
 2001-12-15 00:05:20 27142  15816 onbar -l
 2001-12-15 00:05:20 27142  15816 Begin backup logical log 88118.
2001-12-15 00:05:20 27142  15816 Successfully connected to Storage Manager.
 2001-12-15 00:05:22 27142  15816 Completed backup logical log 88118.
 2001-12-15 00:05:28 27148  15826 onbar -l
 2001-12-15 00:05:28 27148  15826 Begin backup logical log 88119.
 2001-12-15 00:05:29 27148  15826 Successfully connected to Storage Manager.
 2001-12-15 00:05:30 27148  15826 Completed backup logical log 88119.
 2001-12-15 00:06:17 14612  28436 onbar -l
 2001-12-15 00:06:17 14612  28436 Begin backup logical log 88120.
 2001-12-15 00:06:17 14612  28436 Successfully connected to Storage Manager.
 2001-12-15 00:06:19 14612  28436 Completed backup logical log 88120.

Thanks & regards

Sachin
<Prev in Thread] Current Thread [Next in Thread>
  • Deadlock while starting ON-Bar backup, Ganu Sachin, IBM <=