BACKUP & RUNSTATS running simultaneously
in [DB2]
|
Prev: Is it possible to "enable" auto-rollback functionality while dead-lock occurred on DB2/400?
Next: Catalog Service - User interrupt detected
From: satish mullapudi on 18 Jun 2008 01:51 Hi Am using DB2 UDB ESE on AIX platform. I used to take a full/ incremental online backup regularly. This process used to go on since years. But recently, whenever am trying to take the same, am receiving the 911 error msg. I have understood that the 911 errors are due to the locks held by RUNSTATS appln. on the tables. But since years , both the BACKUP & RUNSTATS have been running simultaneously without any errors. Any idea on why the error has been coming nowadays only ! Any help is welcomed..... Thanks in advance, Satish
From: peter on 28 Jun 2008 03:00
On Jun 18, 3:51 pm, satish mullapudi <satishmullapud...(a)gmail.com> wrote: > Hi > Am using DB2 UDB ESE on AIX platform. I used to take a full/ > incremental online backup regularly. This process used to go on since > years. But recently, whenever am trying to take the same, am receiving > the 911 error msg. I have understood that the 911 errors are due to > the locks held by RUNSTATS appln. on the tables. But since years , > both the BACKUP & RUNSTATS have been running simultaneously without > any errors. > Any idea on why the error has been coming nowadays only ! > > Any help is welcomed..... > > Thanks in advance, > Satish Hi We have had this problem and if you read the manual it is actually acknowledged as an issue. At the end of the online backup it does an update which contents with the runstats. Killing/completion of the runstats allows the backup to complete. Can't remember where in the manual but it is there in some dark corner. We have groaned to IBM about the problem but it is "working as designed". You just need to re-arrange your schedule to minimise the potential of the issue. |