We are having what appear to be contention issues when running db2 backups.
DB2 is version 8.1.1 running on AIX5.1
The scripted backups fail. The scripts issues a list applications, receives a clear signal and tries to start the backup which then fails with
SQL1035N The database is currently in use.
The diaglog shows repeated occurrences of
DIA0001E An internal error occurred. Report the following error code :
"ZRC=0xFFFFFBF5".
and
ADM1510W A file sharing violation has occurred while accessing log file
"S0008397.LOG". Another process may be using this file. DB2 will try to
delete it later.
The active log directory is
/db2log/scioltpp/scdoltpp/NODE0000
The archive log directory is
/db2backup/SCDOLTPP
The database image copy directory is
/db2bck
Mincommit is set to 1.
Seems to be a contention issue. Any thoughts on what we could look at would be appreciated.
Thanks
Gerry
datapro01@yahoo.com