By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a

"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

P: n/a
"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

P: n/a
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.