DB2 Backup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nesa - 11 Apr 2006 14:12 GMT

I have a question related to backup and restore procedures; When
backing up and then restoring a DB2 database on another machine, does
the process copy all of user defined store procedures and functions
over to the target machine?
I would assume everything would be copied to the target machine
including data, metadata, as well as other database objects including
stored procedures and functions, however I have seen a post in this
group that suggests otherwise. I am fairly new to DB2 and would
appreciate your help.
Thanks
Nesa

Reply to this Message

Raj - 11 Apr 2006 14:23 GMT

Everything would me moved... is the target on the same OS as the source?

Reply to this Message

Liu Liu - 11 Apr 2006 15:00 GMT

For SQL stored procedures and UDFs, everything would work fine in the
new machine. For external ones, it's more complicated. Backup doesn't
really copy any of the external libraries (at least as of v8 GA), so
you will have to copy them by yourselves. If you installed jar files
for Java routines, they will still be available for you since the
content is stored in the catalog.

Reply to this Message

Nesa - 11 Apr 2006 15:14 GMT

Target and source machines are identical (that is OS and hw
architecture), and have DB2 that is of same version and patch level.
What I am basically concerned about is whether the backup/restore to
the target will create a functionally identical copy of the source DB.
It seems from your replies that the answer is yes.
Thanks!

Reply to this Message

Mark A - 11 Apr 2006 19:09 GMT

> Target and source machines are identical (that is OS and hw
> architecture), and have DB2 that is of same version and patch level.
> What I am basically concerned about is whether the backup/restore to
> the target will create a functionally identical copy of the source DB.
> It seems from your replies that the answer is yes.
> Thanks!

Yes, if you have only SQL SP's and UDF's. If you have some user-written C or
java SP's or UDF's (other than those supplied by DB2) then you will need to
copy some other files related to such routines over to the other machine.

Reply to this Message