we do not have a dba and need some help
our db crashed and when it came back up one of the tablespaces was in roll forward pending,
when trying to roll forward we get a
SQL0818N A timestamp conflict occurred error,
db2dart /atsc gives us a Error: Tablespace file /container mismatch

to make things worst the backups were accidentally deleted

anybody have any suggestions

thanks

Hide, I feel storm coming

Take a look at:
IBM - Error SQL0818N occurs when performing rollforward of a table space

many thanks!
this was helpful, we no longer have the invalid timestamp error,
but now

SQL1272N Table space level roll-forward recovery for database
"DEVDB" has stopped before completion on node(s) "0".

any hints on how to troubleshoot I/O errors?

thanks again

You need to check db2diag.log for errors

it appears the container for the tablespace can not be accessed


ADM6023I The table space "USERSPACE2" (ID "3") is in state 0x"80". The table
space cannot be accessed. Refer to the documentation for SQLCODE -290.


Error checking container 0 (C:\DB2\NODE0000\SQL00002\SQLT0003.0) for tbsp 3. Rc = 860F000A

this is just our development enviroment, our old dba had created some daily db2look /db2move exports
can we use them to recover the database?

thx

You can use DDL / data to recreate the objects in this tablespace.

what are the steps to do that?
do i just run the ddl_gen.sql


sorry, i'm the network engineer and have minimal experience with db2

First, check what's wrong with C:\DB2\NODE0000\SQL00002\SQLT0003.0 (does it exist?) and if you can recover this db using a backup image from some other db2 environment (prod/test).

You need to read about db2move, db2look, tablespaces, etc... in the manual. db2move exports all tables (in all tablespaces) by default. Exported data will be in IXF format (contains definition - DDL - for most objects). You can find some examples in the manual or on the web. Here is the link to v9.5 Info Center:
IBM DB2 9.5 Information Center for Linux, UNIX, and Windows