Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Question Unanswered: containers in backup image

    hi all,
    m using db2 v8 ESE on windows.
    plz. let me know if containers are also backed-up when we execute a backup utility commmand, as m getting the following error at the time of restoring the databases from the backup image(i am restoring bcoz one of my containers have been mistakently deleted)

    SQL1271W Database "xxxx" is recovered but one or more table spaces are
    off-line on node(s) "0".

    how to overcome this error....

  2. #2
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    If you read up on SQL1271W, you will find that this is not an error but rather a warning - as the trailing 'W' indicates.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  3. #3
    Join Date
    Jul 2008
    Posts
    131
    ya i know thats a warning, but what can i see is, containers are not restored properly as i am not able to access any databases within that tablespace. plz. try working this if anyone can:
    1.create a tablespace
    2. create any database in this tablespace
    3. take a backup copy of this database using backup command
    4. now intensionally delete the tablespace you created and then restore the backup database.
    5. now see if you can access the database which you created in this tablespace

    if it works for anyone, do let me know

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Have you tried to follow the User Response in the long message description?
    Repair or restore the table spaces if necessary and run roll-forward
    recovery. If the same message occurs, try running table space level
    roll-forward recovery offline.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  5. #5
    Join Date
    Jul 2008
    Posts
    131
    i have restored the complete database backup image file and had then rollforwarded the database itself instead of rollforwarding only the tablespaces, but still the problem continues to occur...

  6. #6
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I repeat myself: have you tried to follow exactly the User Response in the message? If not, why not and why did you start this question here? If you did try it, we can work from there.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  7. #7
    Join Date
    Jul 2008
    Posts
    131
    finally i have done with the restoration successully.
    i tried working exactly the way user response asked to but that din't solved my problem.
    when i delete the complete tablespace itself (whose one of the container has got corrupted)before the restoration of the same tablespace, then only the restoration works....but if i try restoring the database without deleting the tablespace, the error continues to occur....

Posting Permissions

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