Hi,
I'm a developer for a software application vendor, and our application
makes use of a customer-maintained Oracle 8i/9i database. We've had a
customer request to support DB2 database, and I'm looking into the
feasibility of migration. Our application runs on NT Server and, the
DB2 database would be in some cases on a separate AIX machine, in
other cases on an AS/400.
There are two problems we are running into, both relating to our use
of Oracle Supplied Packages:
First, we make use of the DBMS_PIPE Oracle Supplied Package to
communicate from a trigger back to our application via named pipes. Is
there a way to do this in DB2?
Second, we want that communication to be transactionally controlled.
Of course, even in Oracle, communicating out of the trigger back to
the application happens immediately, not on the COMMIT. The way we
handle this in Oracle is by making use of the DBMS_TRANSACTIO N Oracle
Supplied Package. This allows us to retrieve a unique identifier for
the current transaction in the trigger, send it to the application via
DBMS_PIPE, and later check that transaction id against the data
dictionary table V$TRANSACTION to determine the state of the
transaction. The application then is able to apply the update only
after a COMMIT. So in DB2 how would I find a unique identifier for the
current transaction, and then how would I find out the state of a
transaction later from a different session?
Thanks in advance,
Abram Friesen 4 3974
"Abram Friesen" <ab***@oax.co m> wrote in message
news:e4******** *************** ***@posting.goo gle.com... Hi,
I'm a developer for a software application vendor, and our application makes use of a customer-maintained Oracle 8i/9i database. We've had a customer request to support DB2 database, and I'm looking into the feasibility of migration. Our application runs on NT Server and, the DB2 database would be in some cases on a separate AIX machine, in other cases on an AS/400.
There are two problems we are running into, both relating to our use of Oracle Supplied Packages:
First, we make use of the DBMS_PIPE Oracle Supplied Package to communicate from a trigger back to our application via named pipes. Is there a way to do this in DB2?
Second, we want that communication to be transactionally controlled. Of course, even in Oracle, communicating out of the trigger back to the application happens immediately, not on the COMMIT. The way we handle this in Oracle is by making use of the DBMS_TRANSACTIO N Oracle Supplied Package. This allows us to retrieve a unique identifier for the current transaction in the trigger, send it to the application via DBMS_PIPE, and later check that transaction id against the data dictionary table V$TRANSACTION to determine the state of the transaction. The application then is able to apply the update only after a COMMIT. So in DB2 how would I find a unique identifier for the current transaction, and then how would I find out the state of a transaction later from a different session?
I can't address your specific questions directly but I seem to recall that
there used to be migration tools and/or guides for DB2's competitors at the
IBM website. For instance, if a customer was switching from Oracle to DB2,
these tools or guides would help them do so. Perhaps they might contain
discussions that would answer your questions? I never used or read any of
these things but I remember seeing mention of them on this newsgroup a few
years back.
I don't know where the migration tools/guides were and the website has been
recently reorganized so any URL mentioned in an old newsgroup post might be
dead anyway. All I can suggest is that you look around the DB2 portion of
the IBM website and see what you can find. A search on "migration" or
"migration Oracle DB2" might find them for you, if they are still there and
up-to-date.
Rhino http://www-306.ibm.com/software/data/db2/migration/
Larry Edelstein
Rhino wrote: "Abram Friesen" <ab***@oax.co m> wrote in message news:e4******** *************** ***@posting.goo gle.com...
Hi,
I'm a developer for a software application vendor, and our application makes use of a customer-maintained Oracle 8i/9i database. We've had a customer request to support DB2 database, and I'm looking into the feasibility of migration. Our application runs on NT Server and, the DB2 database would be in some cases on a separate AIX machine, in other cases on an AS/400.
There are two problems we are running into, both relating to our use of Oracle Supplied Packages:
First, we make use of the DBMS_PIPE Oracle Supplied Package to communicate from a trigger back to our application via named pipes. Is there a way to do this in DB2?
Second, we want that communication to be transactionally controlled. Of course, even in Oracle, communicating out of the trigger back to the application happens immediately, not on the COMMIT. The way we handle this in Oracle is by making use of the DBMS_TRANSACTIO N Oracle Supplied Package. This allows us to retrieve a unique identifier for the current transaction in the trigger, send it to the application via DBMS_PIPE, and later check that transaction id against the data dictionary table V$TRANSACTION to determine the state of the transaction . The application then is able to apply the update only after a COMMIT. So in DB2 how would I find a unique identifier for the current transaction, and then how would I find out the state of a transaction later from a different session?
I can't address your specific questions directly but I seem to recall that there used to be migration tools and/or guides for DB2's competitors at the IBM website. For instance, if a customer was switching from Oracle to DB2, these tools or guides would help them do so. Perhaps they might contain discussions that would answer your questions? I never used or read any of these things but I remember seeing mention of them on this newsgroup a few years back.
I don't know where the migration tools/guides were and the website has been recently reorganized so any URL mentioned in an old newsgroup post might be dead anyway. All I can suggest is that you look around the DB2 portion of the IBM website and see what you can find. A search on "migration" or "migration Oracle DB2" might find them for you, if they are still there and up-to-date.
Rhino
Thanks Larry and Rhino for the direction.
In case anyone's interested, I found an implementation of DBMS_PIPE
package for DB2 here: http://www-106.ibm.com/developerwork...mukherjee.html
The link for the download of pipe.zip was broken, but I managed to
download it with: http://www-106.ibm.com/developerwork...erjee/pipe.zip
Thanks again.
Abram Friesen
Larry <La***@nospam.n et> wrote in message news:<0o******* *************** @news4.srv.hcvl ny.cv.net>... http://www-306.ibm.com/software/data/db2/migration/
Larry Edelstein
Rhino wrote: "Abram Friesen" <ab***@oax.co m> wrote in message news:e4******** *************** ***@posting.goo gle.com...
Hi,
I'm a developer for a software application vendor, and our application makes use of a customer-maintained Oracle 8i/9i database. We've had a customer request to support DB2 database, and I'm looking into the feasibility of migration. Our application runs on NT Server and, the DB2 database would be in some cases on a separate AIX machine, in other cases on an AS/400.
There are two problems we are running into, both relating to our use of Oracle Supplied Packages:
First, we make use of the DBMS_PIPE Oracle Supplied Package to communicate from a trigger back to our application via named pipes. Is there a way to do this in DB2?
Second, we want that communication to be transactionally controlled. Of course, even in Oracle, communicating out of the trigger back to the application happens immediately, not on the COMMIT. The way we handle this in Oracle is by making use of the DBMS_TRANSACTIO N Oracle Supplied Package. This allows us to retrieve a unique identifier for the current transaction in the trigger, send it to the application via DBMS_PIPE, and later check that transaction id against the data dictionary table V$TRANSACTION to determine the state of the transaction . The application then is able to apply the update only after a COMMIT. So in DB2 how would I find a unique identifier for the current transaction, and then how would I find out the state of a transaction later from a different session?
I can't address your specific questions directly but I seem to recall that there used to be migration tools and/or guides for DB2's competitors at the IBM website. For instance, if a customer was switching from Oracle to DB2, these tools or guides would help them do so. Perhaps they might contain discussions that would answer your questions? I never used or read any of these things but I remember seeing mention of them on this newsgroup a few years back.
I don't know where the migration tools/guides were and the website has been recently reorganized so any URL mentioned in an old newsgroup post might be dead anyway. All I can suggest is that you look around the DB2 portion of the IBM website and see what you can find. A search on "migration" or "migration Oracle DB2" might find them for you, if they are still there and up-to-date.
Rhino
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: susmita_ganguly |
last post by:
Hi
I am trying to upgrade from oracle 8i to oracle 9i on the same server
..I don't know much abt migration .
Can anyone help me out.
Thanks.
Susmita
|
by: ss_dash |
last post by:
Hi all,
I am using the Oracle Workbench for migrating my DB currently on Sql
Server 2000 to Oracle 9i. During the migration the following happens
SELECT @tBaseTable = tBaseTable, @tDBColumnName = tDBColumnName
|
by: prunoki |
last post by:
Hello,
I am an SQL server newbie. Our company has a massive application
written in PL/SQL. I need to port parts of it to SQL Server.
- Which SQL server version should I choose, to have a reasonable chance
of porting?
- Could you recommend any best practices, tools? I use Toad for SQL
development on Oracle, I am looking for something similar for SQL
|
by: Tavish Muldoon |
last post by:
At a high level - what would be involved in switching from Oracle to DB2?
Pretty vague, I know - but anyone have experience with this kind of migration?
Pointers? Things to look for?
Tmuld
|
by: Phil S |
last post by:
I used the Migration Workbench for Oracle 9.2 Client to migrate the
tables in an Access 2K back-end database to Oracle. (The Migration
Workbench is intended to automate the process of migrating tables from
Access to Oracle.) Following the migration, when I try to link the
Oracle table to the Access front-end using Oracle ODBC Driver, I have
to either select one or more fields in the Oracle table as key fields
or not have any key fields. ...
| |
by: Ashish Patankar |
last post by:
I want to migrate my Oracle 10g database to Db2. I want some
documentation for the comparision between these to databases. I also
want to know which features of Oracle 10g are supported by Db2 and
which are not supported.
|
by: manindra |
last post by:
Recently we migrated our product from MS-SQL 2000 to Oracle 9i. We see lot of performance degradation due to migration. Some times complex queries are hitting 10 fold slower than SQL Server.
Reasons could be,
1.The Oracle Server with respect to configuration may have issues.
2.The SQL server optimized queries are not suitable for Oracle(The normal cases, such as datatypes, syntax etc are already taken care).
Any help on this is...
|
by: Girish |
last post by:
Hi all,
We are doing an exercise of migrating an application (developed in
Informix 4gl) from Informix to Oracle database.
Before doing actual migration, we would like to know some of the key
advantages of Oracle over Informix. If there are any examples of any
company getting benefits because of this kind of migration, please
reply me such kind of case studies.
Please reply to my email id.
|
by: --CELKO-- |
last post by:
I need to convert a bunch of DB2 triggers to Oracle. Is there any
kind of tools for this?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |