Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Posts
    85

    Unanswered: Restore Database ... Tablespace

    I just want to confirm that assume that one did a full database backup, one still can issue a RESTORE DATABASE ... TABLESPACE from the db backup image and one isn't necessarily required to have separate tablespace backup images.
    Ruby

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Your assumption is correct ...

    But remember, there are other things (like creation of a table in a tablespace) that could impact the minumum point to which the tablespace can be rolled forward .. Look at the 'Minimum recovery time ' in 'list tablespaces show detail' output ...

    HTH

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    You must also have LOGRETAIN set on when you do the backup. This is probably obvious to most people.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  4. #4
    Join Date
    Sep 2003
    Posts
    85
    Sathyaram,
    You wrote that:
    "Look at the 'Minimum recovery time ' in 'list tablespaces show detail' output ... " . We're running UDB ESE FP7a and there's no such output as minimum recovery time.
    Ruby

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Do you have LOGRETAIN on (set to RECOVERY) for that database?
    Last edited by Marcus_A; 02-09-05 at 18:27.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Sep 2003
    Posts
    85
    Marcus,
    LOGRETAIN=RECOVERY is set.

  7. #7
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    According to the DB2 version 8.2 Command Reference, when using the "list tablespaces show detail" command, the Minimum recovery time is displayed (but only if not zero).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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