Error SQL0818N occurs when performing rollforward of a tablespace

Technote (FAQ)


Question

Why is error "SQL0818N: A timestamp conflict occurred" received when rolling forward a tablespace?

Cause

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.

Answer

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 terminate
db2 connect to <dbname>
db2 bind <path>/@db2ubind.lst blocking all grant public action add
db2 terminate

Related information

Binding utilities to the database

Rate this page:

(0 users)Average rating

Add comments

Document information


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:

2006-12-21

Translate my page

Machine Translation

Content navigation