473,226 Members | 1,625 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,226 software developers and data experts.

Sybase to UDB

We have a client who wants to convert their Sybase application (with
Stored Procedures, Triggers etc.) to UDB on AIX. Has someone on the
list attempted this? Could they share their experiences (especially
bad experiences) including application and data porting, best third
party tools that could help, specific competencies of personnel
involved etc.

TIA
Raquel.
Nov 12 '05 #1
7 3452
"Raquel" <ra****************@yahoo.com> wrote in message
news:9a**************************@posting.google.c om...
We have a client who wants to convert their Sybase application (with
Stored Procedures, Triggers etc.) to UDB on AIX. Has someone on the
list attempted this? Could they share their experiences (especially
bad experiences) including application and data porting, best third
party tools that could help, specific competencies of personnel
involved etc.

TIA
Raquel.


Check the IBM web site to see if they have porting guides.
Nov 12 '05 #2
http://www.software.ibm.com/data/db2/migration

Larry Edelstein

Raquel wrote:
We have a client who wants to convert their Sybase application (with
Stored Procedures, Triggers etc.) to UDB on AIX. Has someone on the
list attempted this? Could they share their experiences (especially
bad experiences) including application and data porting, best third
party tools that could help, specific competencies of personnel
involved etc.

TIA
Raquel.


Nov 12 '05 #3
Raquel,

First the disclaimer: I'm deep blue

There is a fair bit of experience around with the Migration Toolkit
which you can download from the website Larry pointed you to.

In my experience the biggest problem lies in the expectations.
The standard request is to migrate the app as is, doing minimal changes
to the SQL and procedural logic.
And of course the reason for the migration is that it is supposed to be
faster and scale better on DB2 than on Sybase.

These two requirements do not work together!

If the requirement to DB2 is to emulate Sybase you will see
_significant_ performance degradation because that's what emulation
means. It means trying to be something one is not. And DB2 is not Sybase.

The moment it is acknowledged that the app can be separated into areas
that are performance critical and those that are not, you can rely on
the MTK to migrate the non-critical part and do a reasonably well job.
So all you need to do is deal with the hic-ups.

For the performance critical part you start with the MTK, get yourself
some good DB2 people and redesign the pieces that are not up to snuff.
The reason is that Sybase T-SQL is quite fast (tuned for over a decade),
but the SQL is quite simple, so procedures tend to read a lot like
Visual Basic.
DB2 does not yet have the same level of tuning in SQL PL, but possibly
the best SQL Compiler (did I say I'm biased?).
So you will find yourself replacing procedural logic with SQL to get
onto DB2's strong side. And for that you need someone who thinks in DB2
and not Sybase T-SQL.

Beyond the MTK you need the Development Center (for debugging) which is
shipped with DB2.
I (not IBM) hope to push out an SQL Procedure Tracing facility for
Stinger and an SQL Procedure Profiler for Stinger. They will show up on
developerWorks for DB2. Both will help tune and debug migrated procedures.

You want to start of with Stinger anyway because of the SQL Procedure
enhancements.

Cheers
Serge

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

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c8**********@hanover.torolab.ibm.com...
Raquel,
[snip]
I (not IBM) hope to push out an SQL Procedure Tracing facility for
Stinger and an SQL Procedure Profiler for Stinger. They will show up on
developerWorks for DB2. Both will help tune and debug migrated procedures.

You want to start of with Stinger anyway because of the SQL Procedure
enhancements.

What is "Stinger"?

Rhino
Nov 12 '05 #5
As is the trend these days, "Stinger" is the code name for the next DB2
release. When it is actually announced it will be given a numerical
designation (unfortunately 7 of 9 is already taken :->).

--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory
"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:pP*********************@news20.bellglobal.com ...

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c8**********@hanover.torolab.ibm.com...
Raquel,

[snip]
I (not IBM) hope to push out an SQL Procedure Tracing facility for
Stinger and an SQL Procedure Profiler for Stinger. They will show up on
developerWorks for DB2. Both will help tune and debug migrated procedures.
You want to start of with Stinger anyway because of the SQL Procedure
enhancements.

What is "Stinger"?

Rhino

Nov 12 '05 #6
"Rhino" <rh****@NOSPAM.sympatico.ca> wrote in message
news:pP*********************@news20.bellglobal.com ...

"Serge Rielau" <sr*****@ca.eye-be-em.com> wrote in message
news:c8**********@hanover.torolab.ibm.com...
Raquel,

[snip]
I (not IBM) hope to push out an SQL Procedure Tracing facility for
Stinger and an SQL Procedure Profiler for Stinger. They will show up on
developerWorks for DB2. Both will help tune and debug migrated procedures.
You want to start of with Stinger anyway because of the SQL Procedure
enhancements.

What is "Stinger"?

Rhino

Next release of DB2 which will be either 8.2 or 9.1 (TBD).
Nov 12 '05 #7
Thank you very much Serge and all the others who replied. Truely
appreciate your inputes.

Regards,
Raquel.
Nov 12 '05 #8

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: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...

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.