Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2010
    Posts
    6

    Unanswered: tablespace in roll forward pending

    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

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Hide, I feel storm coming
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by akira28 View Post
    when trying to roll forward we get a
    SQL0818N A timestamp conflict occurred error,
    Take a look at:
    IBM - Error SQL0818N occurs when performing rollforward of a table space

  4. #4
    Join Date
    Sep 2010
    Posts
    6
    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

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You need to check db2diag.log for errors

  6. #6
    Join Date
    Sep 2010
    Posts
    6
    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

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    You can use DDL / data to recreate the objects in this tablespace.

  8. #8
    Join Date
    Sep 2010
    Posts
    6
    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

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •