Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question Unanswered: Backup / Restore

    Hi All - AIX 5.2 DB2 8.1.4

    Two questions I haven't been able to resolve through documentation.

    1. I backing up on TSM, I can use the db2adutl query to see my backup
    images - but is there any way to see if they are complete?
    (my connection had closed when I returned)

    2. Can I do a partial restore, i.e. of a Tablespace, from a full backup image?


    Comment appreciated.

    Cheers
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    1) Yes ... You can use the db2ckbkp (Check Backup) command

    2) Yes, if your database is enabled for rollforward

    HTH

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

  3. #3
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Talking

    Thank You Sathyaram

    Speedily helpful as always!

    Cheers
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  4. #4
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question Bonus questions

    ..hmmm

    Isn't the db2ckbkp exactly the same as the verify option
    in db2adutl? - it sure looks to have the same functionality.

    Also, is the a way to see the size of the backup image
    on TSM, through the shell?

    Thanks
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  5. #5
    Join Date
    Apr 2004
    Posts
    48
    Quote Originally Posted by sathyaram_s
    1) Yes ... You can use the db2ckbkp (Check Backup) command

    2) Yes, if your database is enabled for rollforward

    HTH

    sathyaram

    what does HTH means ??

  6. #6
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220
    Hope This Helps - I think
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

Posting Permissions

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