467,923 Members | 1,766 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,923 developers. It's quick & easy.

DB2 Backup

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
  • viewed: 1346
Share:
4 Replies
Raj
Everything would me moved... is the target on the same OS as the source?

Apr 11 '06 #2
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
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
"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

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew E | last post: by
3 posts views Thread by Thiko | last post: by
2 posts views Thread by nt | last post: by
6 posts views Thread by Eric Herber | last post: by
1 post views Thread by alex | last post: by
4 posts views Thread by uthuras | last post: by
6 posts views Thread by k04jg02 | last post: by
10 posts views Thread by Konstantin Andreev | last post: by
2 posts views Thread by clilush | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.