Results 1 to 2 of 2

Thread: backup issues

  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Question backup issues

    hi ...

    what is the difference between(exately)hotback up and cold backup?

    Can u give procedure for those two things........?


    Bestregards
    shiva

  2. #2
    Join Date
    Oct 2009
    Posts
    5
    Quote Originally Posted by shivareddyk View Post
    hi ...

    what is the difference between(exately)hotback up and cold backup?

    Can u give procedure for those two things........?


    Bestregards
    shiva
    I would assume that a 'hot' backup would be a backup that you would perform online: db2 backup db <db_name> online <other db options>

    And a 'cold' backup would be one that you perform offline: db2 backup db <db_name>

    Now keep in mind, that in order to perform a 'cold' backup, you need to make sure no one is connected to the db, that it is in a quiesce state, and you'll need to deactivate the db as well.

    So:

    db2 connect to <db_name>
    db2 quiesce db immediate force connections
    db2 connect reset
    db2 deactivate db <db_name>
    db2 backup db <db_name>
    ..
    <finished>
    ..
    db2 activate db <db_name>
    db2 connect to <db_name>
    db2 unqueisce db
    db2 connect reset

Posting Permissions

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