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.
4  1988 
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.
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.
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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Diogo Alves - Software Developer |
last post by:
Greetings
I would like to knowhow can I put a sliding panel...
I've done this:
if (panel1.Width < 300)
{
while (panel1.Width < 300)
{
panel1.Width = panel1.Width + 40;
|
by: linkswanted |
last post by:
World Moving & Storage Moving Companies and Movers
We would like to take this opportunity to introduce "World Moving &
Storage" to You. "World Moving & Storage" is well established, Fully...
|
by: linkswanted |
last post by:
Moving Companies California http://www.movingcompanies.co.il
california movers, los angeles movers, moving in california, moving to
CA, Moving company los angeles, moving to los angeles.
|
by: linkswanted |
last post by:
Free Moving Estimate, Local Movers, Long Distance Moving, Packing
Supplies, Storage Rental, Home Moving, Apartment Moving, Office
Moving, Commercial Moving, Moving Companies in your area....
|
by: linkswanted |
last post by:
http://www.movingcompanies.co.il/supplies/boxes.html
http://www.movingcompanies.co.il/residental/
http://www.movingcompanies.co.il/commercial/corporate-moves.html...
|
by: linkswanted |
last post by:
We are your trusted source. World Moving & Storage is bonded and
licensed by the U.S. Department of Transportation and is one of the
largest residential moving and corporate relocation company in...
|
by: linkswanted |
last post by:
We are your trusted source. World Moving & Storage is bonded and
licensed by the U.S. Department of Transportation and is one of the
largest residential moving and corporate relocation company in...
|
by: SuzK |
last post by:
I am trying to calculate in VBA in Access 2002 a moving average and update a table with the calculations. Fields in my WeeklyData table are
Week Ending (date)
ItemNbr (double)
Sales Dollars...
|
by: mcjason |
last post by:
I saw something interesting about a grid pair puzzle problem that
it looks like a machine when you find each that work out the way it
does and say with all the others that work out the way they...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
| |
