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

Moving DB from DB2/Oz to DB2 UDB on soloris

P: n/a
Hello,
I have a requirement. We are planning to move a single DB2 database
from our mainframe environment which is running on Oz (DB2/Oz) to
another DB2 UDB instance running on Sun soloris. Can this be possible?
If so can any one give me a hint. Thanks in advance for the help.

Thanks.

Sep 19 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Sep 19, 2:08 pm, nanchil <sujin.prabha...@gmail.comwrote:
Hello,
I have a requirement. We are planning to move a single DB2 database
from our mainframe environment which is running on Oz (DB2/Oz) to
another DB2 UDB instance running on Sun soloris. Can this be possible?
If so can any one give me a hint. Thanks in advance for the help.

Thanks.
Sorry it is from DB2/Os390 to Db2 UDB in solaris.

Sep 19 '07 #2

P: n/a
Any one Please...
On Sep 19, 2:54 pm, nanchil <sujin.prabha...@gmail.comwrote:
On Sep 19, 2:08 pm, nanchil <sujin.prabha...@gmail.comwrote:
Hello,
I have a requirement. We are planning to move a single DB2 database
from our mainframe environment which is running on Oz (DB2/Oz) to
another DB2 UDB instance running on Sun soloris. Can this be possible?
If so can any one give me a hint. Thanks in advance for the help.
Thanks.

Sorry it is from DB2/Os390 to Db2 UDB in solaris.

Sep 21 '07 #3

P: n/a
nanchil wrote:
Any one Please...
On Sep 19, 2:54 pm, nanchil <sujin.prabha...@gmail.comwrote:
>On Sep 19, 2:08 pm, nanchil <sujin.prabha...@gmail.comwrote:
>>Hello,
I have a requirement. We are planning to move a single DB2 database
from our mainframe environment which is running on Oz (DB2/Oz) to
another DB2 UDB instance running on Sun soloris. Can this be possible?
If so can any one give me a hint. Thanks in advance for the help.
Thanks.
Sorry it is from DB2/Os390 to Db2 UDB in solaris.
You can do a db2look against DB2 zOS, and re-apply on DB2 for LUW via
the command line.
Then pull over the data in whichever means you wish.
Could be federated INSERT's, unload and reload or using the cross-loader
(LOAD FROM CURSOR).
You cannot backup/restore.

You may need to do some minor massaging of CREATE FUNCTION/PROCEDURE
statements since DB2 for zOS has some options Db2 for LUW doesn't have
(or need).

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Sep 21 '07 #4

P: n/a
On Sep 21, 6:33 pm, Serge Rielau <srie...@ca.ibm.comwrote:
nanchil wrote:
Any one Please...
On Sep 19, 2:54 pm, nanchil <sujin.prabha...@gmail.comwrote:
On Sep 19, 2:08 pm, nanchil <sujin.prabha...@gmail.comwrote:
>Hello,
I have a requirement. We are planning to move a single DB2 database
from our mainframe environment which is running on Oz (DB2/Oz) to
another DB2 UDB instance running on Sun soloris. Can this be possible?
If so can any one give me a hint. Thanks in advance for the help.
Thanks.
Sorry it is from DB2/Os390 to Db2 UDB in solaris.

You can do a db2look against DB2 zOS, and re-apply on DB2 for LUW via
the command line.
Then pull over the data in whichever means you wish.
Could be federated INSERT's, unload and reload or using the cross-loader
(LOAD FROM CURSOR).
You cannot backup/restore.

You may need to do some minor massaging of CREATE FUNCTION/PROCEDURE
statements since DB2 for zOS has some options Db2 for LUW doesn't have
(or need).

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Thanks. your help is appreciated.

Sep 24 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.