DB2 Backup

Nesa

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

Apr 11 '06 #1

Raj

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

Apr 11 '06 #2

Liu Liu

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.

Apr 11 '06 #3

Nesa

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!

Apr 11 '06 #4

Mark A

"Nesa" <mi*******@yahoo.com> wrote in message
news:11*********************@v46g2000cwv.googlegro ups.com...

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.

Apr 11 '06 #5