Geschrieben von Bernd Heilig on Juli 08, 2003 um 15:47:

Als Antwort auf DB2 crash geschrieben von Smilc on Juli 08, 2003 um 14:44:

Hi smilc,

do you really do a DB2 offline Backup ??

I found this in UDB Technical Support Database :

http://www-1.ibm.com/support/docview.wss?rs=0&q=%2bDIA3811C&uid=swg21005750&loc=en_US&cs=utf-8&cc=US&lang=en

Abstract
Customer sees DIA3811C at "predictable" time in the 'db2diag.log'. This often results on the instance crashing or being marked as "damaged".

Content
Often when one sees an entry in the 'DBsysc.exe' with a "DIA3811C A locked file was encountered" and "ZRC=FFFFF60E" occurring at a "predictable" time, for example just past midnight. Most often the case is a file system backup while the database is active.

File system backups are not a supported recovery mechanism for DB2 UDB databases.

However, recovery of DB2 databases from file system backups are often successful, provided that the database was offline when the file system backup was taken.

regards Bernd

• Re: DB2 crash Sven 11:04 05.12.2003 (0)
• Re: DB2 crash smilc 10:27 10.7.2003 (0)

Schreibe eine Antwort