IBM Support

Error SQL0818N occurs when performing rollforward of a tablespace

Question & Answer


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

[{"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Business Unit":{"code":"BU001","label":"Analytics Private Cloud"},"Component":"Recovery - Rollforward","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.7;9.5;9.1;8.2","Edition":""}]

Document Information

Modified date:
16 June 2018