Results 1 to 5 of 5

Thread: backup

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: backup

    Hi All,

    I am working in db2.can you give me the command for online and off line backup in db2.Andalso what is the command for restore the database command.Please give me the example is easy to understand.

    Regards,
    K.Manikandan

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    I think that IBM documentation is always a good start:
    http://publib.boulder.ibm.com/infoce...c/c0005945.htm

  3. #3
    Join Date
    Oct 2008
    Posts
    70

    backup

    please,send me the commands

  4. #4
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2

  5. #5
    Join Date
    Apr 2008
    Posts
    39
    For either backup or restore, offline is the default option

    BACKUP: basic command is as follows
    ----------
    backup database <database name> to <target dir> (offline backup)
    For Online backup:
    backup database <database name> online <target dir>
    Note: For enabling online backups, archival logging must be enabled. i.e do
    update dbm cfg using logarchmeth1 TSM

    RESTORE: basic command
    -----------
    RESTORE database <database name> FROM <source_dir>

    source_dir: Is the directory where your backup image is located. If there are more than one backup images in this source directory, use timestamp of when the backup is taken as follows

    RESTORE database <database name> FROM <source_dir> taken at <timestamp>

    Online RESTORE command is as follows:
    RESTORE database <database name> online FROM <source_dir> taken at <timestamp>


    Thanks,
    Madhavi

Posting Permissions

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