BACKUP & RUNSTATS running simultaneously

[satish mullapudi]

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

[peter]

On Jun 18, 3:51*pm, satish mullapudi <[e-mail]>
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.