Error SQL0818N occurs when performing rollforward of a tablespace
Why is error "SQL0818N: A timestamp conflict occurred" received when rolling forward a tablespace?
This can occur after an unexpected failure with DB2. For example, if an I/O error occurs during crash recovery, the table space will be left in rollforward pending state after the crash recovery. Once the underlying I/O error is corrected, the rollforward of the table space may fail with an SQL0818N error.
The explanation associated with the SQL0818N error message says "the timestamp generated by the precompiler at precompile time is not the same as the timestamp stored with the package at bind time". In this case, the package associated with the ROLLFORWARD command is problematic.
The solution associated with the SQL0818N error is to bind the application again, using the bind file for the program that matches the object module. In this case, the appropriate BIND commands are as follows:
db2 connect to <dbname>
db2 bind <path>/@db2ubind.lst blocking all grant public action add
More support for:
DB2 for Linux, UNIX and Windows
Recovery - Rollforward
Software version: 8.2, 9.1, 9.5, 9.7
Operating system(s): AIX, HP-UX, Linux, Solaris, Windows
Reference #: 1228205
Modified date: 21 December 2006
Translate this page: