467,118 Members | 964 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

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

DB2 8.1, Copy Stored Proc's from one db to another...how?

I have a db on one machine, and another on a second machine. I have written
some stored procedures that I want to copy to the second machine.

As I understand it, there is a possibility to connect the Development
Center to more than one db but, no matter how I try, I cant set up this
connection. One time I even managed to move the db on the second machine,
while I was trying to make a connection (from machine one...), and after
that it was impossible to access anything...

Is there anybody out there that has a perfectly simple example on how to
do this? With explanations what to fill in, in all fields, during the
process...

Or, if someone has a better way of getting the SP's over to the second
db...

Btw, I run in WinXp environment...

Many thanx in advance!
Nov 12 '05 #1
  • viewed: 2748
Share:
3 Replies

"Willis" <me**********@hotmail.com> wrote in message
news:be******************************@localhost.ta lkaboutdatabases.com...
I have a db on one machine, and another on a second machine. I have written some stored procedures that I want to copy to the second machine.

As I understand it, there is a possibility to connect the Development
Center to more than one db but, no matter how I try, I cant set up this
connection. One time I even managed to move the db on the second machine,
while I was trying to make a connection (from machine one...), and after
that it was impossible to access anything...

Is there anybody out there that has a perfectly simple example on how to
do this? With explanations what to fill in, in all fields, during the
process...

Or, if someone has a better way of getting the SP's over to the second
db...

Btw, I run in WinXp environment...

Many thanx in advance!

Have you had a look at
http://www-106.ibm.com/developerwork...tml#scenario8?

This article doesn't address stored procedures but it might help you get
your connections working....

Rhino
Nov 12 '05 #2
"Willis" <me**********@hotmail.com> wrote in message news:<be******************************@localhost.t alkaboutdatabases.com>...
I have a db on one machine, and another on a second machine. I have written
some stored procedures that I want to copy to the second machine.

As I understand it, there is a possibility to connect the Development
Center to more than one db but, no matter how I try, I cant set up this
connection. One time I even managed to move the db on the second machine,
while I was trying to make a connection (from machine one...), and after
that it was impossible to access anything...

Is there anybody out there that has a perfectly simple example on how to
do this? With explanations what to fill in, in all fields, during the
process...

Or, if someone has a better way of getting the SP's over to the second
db...

Btw, I run in WinXp environment...

Many thanx in advance!


The simplest way to do is to copy from Development Center.
Nov 12 '05 #3
Willis wrote:
I have a db on one machine, and another on a second machine. I have written
some stored procedures that I want to copy to the second machine.

As I understand it, there is a possibility to connect the Development
Center to more than one db but, no matter how I try, I cant set up this
connection. One time I even managed to move the db on the second machine,
while I was trying to make a connection (from machine one...), and after
that it was impossible to access anything...

Is there anybody out there that has a perfectly simple example on how to
do this? With explanations what to fill in, in all fields, during the
process...

Or, if someone has a better way of getting the SP's over to the second
db...

Btw, I run in WinXp environment...

Many thanx in advance!

Bearing in mind that it's a good idea to be at the same release level
and on the same OS for both DBs, you can use get routine and put routine
from the command-line. I had a lot of trouble getting the development
center to work, mainly because I had different user ids on the two
systems. So now I do it like:

on server where SP is compiled -
db2 get routine into 'myroutine.sar' from specific routine
routines.myroutine; -- you don't have to use specific

on server where you want to put SP -
db2 put routine from 'myroutine.sar' owner user; -- to account for
new user name for the owner

--
Rob Wilson
ro********@ameritech.net.invalid (remove the .invalid)
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

45 posts views Thread by John | last post: by
3 posts views Thread by mandible | last post: by
reply views Thread by mirandacascade@yahoo.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.