473,473 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Help Product Information - Information Integrator for SyBase to UDB Migration

Need product information on IBM's Integration Integrator (I.I) for
conversion of SyBase calls to UDB calls. Production allows for
conversion of modules one-by-one and then when all modules are
converted the database (SyBase) can be converted and I.I removed.

Last I heard the product was in beta.

Any information would be appreciated...

Nov 12 '05 #1
3 1397
See

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

But the description of your requirements is a bit vague. What do you
need II to do? It will not provide migration capabilities for Sybase
calls into DB2 calls. It WILL provide transparency that allows an
application to "address" a Sybase database as if it was a DB2 database.
This product has been generally available since 2004 and it's
predecessor (with much of the same core technology) has been available
since 1995, I believe.

Larry Edelstein

aw***@yahoo.com wrote:
Need product information on IBM's Integration Integrator (I.I) for
conversion of SyBase calls to UDB calls. Production allows for
conversion of modules one-by-one and then when all modules are
converted the database (SyBase) can be converted and I.I removed.

Last I heard the product was in beta.

Any information would be appreciated...

Nov 12 '05 #2
Thanks for your quick response. Sorry for being so vague, but in
brief, we have two dozen applications calling Stored Procedures to
access a SyBase database. Converting each one of the applications and
Stored Procedures will take our departments months. To avoid freezing
of new enhancements during this extended time we are looking for a
solution that will support a mixed environment during the migration
period.

What we want is a product that will provide transparency for the
applications that have already migrated (i.e. "address" a Sybase
database as if it was a DB2 database) allowing us time to complete the
modifications to the application and stored procedures while keeping
the SyBase database until the last application is converted.


P.S. - Not sure I understand the link you provided. It reference
IBM's WebSphere product. We are looking for a DB2 UDB solution. Can
you please clarify my lack of understanding.

Thanks

Nov 12 '05 #3
1. The II product will provide the capability to address a Sybase db as
if it were a DB2 database, however, I'm not sure if it will surface
Sybase stored procs (I know it can surfact Sybase T-SQL, but not sure
about within a stored proc). You'll need to confirm this.

2. The II product has been rebranded as Websphere II. This is because it
really does perform middleware functionality and IBM's middleware is
really covered under the Websphere brand.

Larry Edelstein

aw***@yahoo.com wrote:
Thanks for your quick response. Sorry for being so vague, but in
brief, we have two dozen applications calling Stored Procedures to
access a SyBase database. Converting each one of the applications and
Stored Procedures will take our departments months. To avoid freezing
of new enhancements during this extended time we are looking for a
solution that will support a mixed environment during the migration
period.

What we want is a product that will provide transparency for the
applications that have already migrated (i.e. "address" a Sybase
database as if it was a DB2 database) allowing us time to complete the
modifications to the application and stored procedures while keeping
the SyBase database until the last application is converted.


P.S. - Not sure I understand the link you provided. It reference
IBM's WebSphere product. We are looking for a DB2 UDB solution. Can
you please clarify my lack of understanding.

Thanks

Nov 12 '05 #4

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

Similar topics

2
by: Martijn Rutte | last post by:
Hi, On one side, I have a Sybase 12.5 32 bits Server running on AIX 5.1 (maintenance level 3). On the other, I've got W2000 5.00.2195 (SP2) with SQL Server Standard Edition, Product Version...
8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
5
by: tomL | last post by:
hello all! has anyone tried connecting Info integrator to Informix 9.x? if so, here are my questions....how much of the server's resources does it use? does it matter if using Info integrator...
7
by: AnandG | last post by:
Hi, Could someone please advise on what is the equivalent of the following sybase trigger code to UDB. if @@test > 1 begin return end
2
by: Raquel | last post by:
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...
2
by: aww91 | last post by:
Company is planning a Sybase to UDB migration that is projected to take 1 year. During that long period of time any Code Freeze put into place would impact our users (we normally release code...
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?
7
by: No Spam | last post by:
----snip #define POSITIVE_INTEGRATOR_SATURATION 0x03000000L // #define NEGATIVE_INTEGRATOR_SATURATION 0xFD000000L // long integrator; integrator=0;
2
by: pankaj_wolfhunter | last post by:
Greetings, Sybase authentication is managed by the database manager whereas DB2 relies on OS userid and password. when we migrate from sybase, there are certain applications that are using...
0
Oralloy
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,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
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...
0
tracyyun
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...
0
agi2029
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,...
1
isladogs
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...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.