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....

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?

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....

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

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

Adding to that.

your database must be in archive mode.

regards,

mujeeb

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...