473,324 Members | 2,166 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

SYBASE to DB2 ....

Hello Esteemed Listers,

Have also cross posted this to the Mainframe DB2 community.

We have been asked to look into the feasibility and the method of
migrating a SYBASE application to DB2. It is also being debated
whether the application
should be converted to UDB for LUW or DB2 for OS/390. We are looking
at IBM's MTK (Migration toolkit) for conversion. Had some specific
questions regarding
this:

1. Does this toolkit support migration to DB2 for OS/390 (V7.1) or
does it only support migration to UDB for LUW. If IBM MTK does not
support migration to DB2 for OS/390, is there any alternate tool
available which can do the same.

2. Is there anyone who has actually performed SYBASE to DB2 for OS/390
conversion and would they be so kind to share their experiences;
especially vis a vis the amount of manual effort required for
converting the database objects (the SYBASE database being converted
has triggers and stored procedures coded in Transact-SQL, I believe,
which could be a problem
area). Any ballpark estimates on the actual effort required. In SYBASE
database here, there are around 150 Stored procedures and around 120
triggers.

3. Is it 'easier' (in terms of effort required) to migrate to DB2 for
OS/390 or to UDB for LUW. In either cases, what are the pros of one
over the other.

Any other experience which could be useful to us in this regard.

Thank you so much.
Raquel.
Nov 12 '05 #1
2 4397
Raquel,

The DB2 migrations page is at
http://www.software.ibm.com/data/db2/migration .

There are ways of getting in touch with the Migration Team and asking
questions off that page. For example, at

http://www-306.ibm.com/software/data/db2/migration/mtk/

are newsgroups where you can post questions. In addition, at

http://www-306.ibm.com/software/data...dbmigteam.html

are contacts for the migration teams.

Larry Edelstein

Raquel wrote:
Hello Esteemed Listers,

Have also cross posted this to the Mainframe DB2 community.

We have been asked to look into the feasibility and the method of
migrating a SYBASE application to DB2. It is also being debated
whether the application
should be converted to UDB for LUW or DB2 for OS/390. We are looking
at IBM's MTK (Migration toolkit) for conversion. Had some specific
questions regarding
this:

1. Does this toolkit support migration to DB2 for OS/390 (V7.1) or
does it only support migration to UDB for LUW. If IBM MTK does not
support migration to DB2 for OS/390, is there any alternate tool
available which can do the same.

2. Is there anyone who has actually performed SYBASE to DB2 for OS/390
conversion and would they be so kind to share their experiences;
especially vis a vis the amount of manual effort required for
converting the database objects (the SYBASE database being converted
has triggers and stored procedures coded in Transact-SQL, I believe,
which could be a problem
area). Any ballpark estimates on the actual effort required. In SYBASE
database here, there are around 150 Stored procedures and around 120
triggers.

3. Is it 'easier' (in terms of effort required) to migrate to DB2 for
OS/390 or to UDB for LUW. In either cases, what are the pros of one
over the other.

Any other experience which could be useful to us in this regard.

Thank you so much.
Raquel.


Nov 12 '05 #2
Raquel wrote:
1. Does this toolkit support migration to DB2 for OS/390 (V7.1) or
does it only support migration to UDB for LUW. If IBM MTK does not
support migration to DB2 for OS/390, is there any alternate tool
available which can do the same. I think teh statement is that MTK is helpful for Sybase-> DB2 OS/390
conversion. But this target is not typical. You will likely face more
hands-on rework.
2. Is there anyone who has actually performed SYBASE to DB2 for OS/390
conversion and would they be so kind to share their experiences;
especially vis a vis the amount of manual effort required for
converting the database objects (the SYBASE database being converted
has triggers and stored procedures coded in Transact-SQL, I believe,
which could be a problem
area). Any ballpark estimates on the actual effort required. In SYBASE
database here, there are around 150 Stored procedures and around 120
triggers. 150 Procedures is (next to) nothing. The triggers are another matter.
How big are those triggers? Do they do error-handling?
DB2 Stinger supports CALL in Trigger...
Sybase triggers are all statement level and no before triggers are
available (unless that has changed without me knowing it).
It pays to convert such triggers into the appropriate form when moving
to DB2 (for each row/for each statement, before/after).
But that requires manual work. MTK will be of limited help there.
Interestingly DB2 zOS provides a trigger support that is closer to
Sybase's model.
So I'd give DB2 zOS the edge on that one.
3. Is it 'easier' (in terms of effort required) to migrate to DB2 for
OS/390 or to UDB for LUW. In either cases, what are the pros of one
over the other.

DB2 for LUW is the preferred target w.r.t. tooling provided.
Also I believe it is the most common target.
One reason against zOS ia that teh Sybase folks likely come with
Windows/unix skills. Keeping the hardware stable takes one variable out
of the equation. Of course if your company has zOS-skills then the
reverse can be true (drawing on your DB2 zOS skill-set)

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Josh Close | last post by:
I'm getting these errors almost every time I use sybase. I'm using it with mssql. I build it like so: python setup.py build_ext -D WANT_THREADS -D HAVE_FREETDS -U WANT_BULKCOPY python setup.py...
0
by: Dave Cole | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. NOTES: This...
0
by: Dave Cole | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. NOTES: This...
0
by: Dave Cole | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. NOTES: The...
2
by: eight02645999 | last post by:
hi i am writing a CGI to process some database transactions using the Sybase module. so in my CGI script, i have: .... import Sybase import cgitb; cgitb.enable(display=1 ,...
1
by: db2sysc | last post by:
All, We have listed out the INBUILT Function differences between Sybase and DB2. Kindly provide your feedback or corrections and for CHANGES - DO WE NEED TO CODE our own UDFs?
1
by: xinhuanet.com | last post by:
can you tell me how to connect to sybase database with vb.net? please give me one example.thank you!
3
by: Alex Murphy | last post by:
As title, Thanks
0
by: =?ISO-8859-1?Q?S=E9bastien_Sabl=E9?= | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. The module is...
0
by: =?ISO-8859-1?Q?S=E9bastien_Sabl=E9?= | last post by:
WHAT IS IT: The Sybase module provides a Python interface to the Sybase relational database system. It supports all of the Python Database API, version 2.0 with extensions. The module is...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.