Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2005
    Posts
    40

    Unanswered: How to get schema level backup?

    All,

    Iam working on DB2 8.2.2 for solaris 5.9. Is there any way to get the backup of a particular schema, if i have more than one schema. Replies will be appreciated.

    Thanks in advance....

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    I don't think so. You can export all tables in a schema. Even if you could get a schema backup, how were you planning to use it?
    mota

  3. #3
    Join Date
    Dec 2001
    Posts
    80
    Since DB2 support tablespace level backup, you can put different schema into separate tablespace.

  4. #4
    Join Date
    Jan 2005
    Posts
    40
    Quote Originally Posted by matthewlau
    Since DB2 support tablespace level backup, you can put different schema into separate tablespace.

    Thanks for replies...

    Yes we have different tablespaces for different schema's. May i know how can we get the seperate backup for them....

  5. #5
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Suppose you wannt to take backup of tablespace TS_BIG_DAT.

    db2 "BACKUP DATABASE SAMPLE TABLESPACE ( TS_BIG_DAT) TO /home/backup/latest"

    Thanks,
    Jayanta
    Xansa India Ltd

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    If you are new to DB2 and not comfortable with DB2 backup/restores, I would not suggest using BACKUP TABLESPACE ..

    There are many restrictions on resotring a tablespace ... the ones that I can think of right now are :
    1) You cannot restore the tablespace backup toi another database
    2) You cannot use this backup to recover a dropped table

    How about db2move ?

    Cheers
    sathyaram

  7. #7
    Join Date
    Mar 2004
    Posts
    448
    Adding to that.

    your database must be in archive mode.

    regards,

    mujeeb

  8. #8
    Join Date
    Jan 2005
    Posts
    40
    Thanks for all replies...

    Our database is in archive mode and we have altogether 10 tablespaces in different filesystems and iam confortable with all the backups and restores.
    Just wanted to know something about schema level backups...

    Quote Originally Posted by bmujeeb
    Adding to that.

    your database must be in archive mode.

    regards,

    mujeeb

Posting Permissions

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