If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Ingres to DB2 migration

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-24-04, 07:04
sarovb sarovb is offline
Registered User
 
Join Date: Jul 2003
Posts: 32
Ingres to DB2 migration

We are in the process of migrating INGRES to DB2.
In Ingres db ,there are a lot of Dbevents. How dbevents will be migrated to DB2 database. In DB2,What is equivalent for dbevents? can somebody throw some light on this.
Reply With Quote
  #2 (permalink)  
Old 11-24-04, 08:28
J Petruk J Petruk is offline
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by sarovb
We are in the process of migrating INGRES to DB2.
In Ingres db ,there are a lot of Dbevents. How dbevents will be migrated to DB2 database. In DB2,What is equivalent for dbevents? can somebody throw some light on this.
What is a dbevent? Sounds suspiciously like a db2 trigger... but I'm just going on the name.
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #3 (permalink)  
Old 11-24-04, 11:22
sarovb sarovb is offline
Registered User
 
Join Date: Jul 2003
Posts: 32
dbevents

In Ingres, dbevents ...send messages through different sessions.(communication)
Like dbms_pipe in oracle.
Reply With Quote
  #4 (permalink)  
Old 11-24-04, 11:35
J Petruk J Petruk is offline
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Quote:
Originally Posted by sarovb
In Ingres, dbevents ...send messages through different sessions.(communication)
Like dbms_pipe in oracle.
There aren't any built-in mechanisms in DB2 that do anything like that, sounds a bit more like MQSeries than DB2. There are built-in hooks to MQSeries that could help, though.

Other may have some ideas.
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #5 (permalink)  
Old 11-24-04, 11:49
J Petruk J Petruk is offline
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
I was digging around an found this (good old internet!)

http://www-106.ibm.com/developerwork...mukherjee.html

It might help, I think it was written to duplicate the Oracle dbms_pipe function but if it's the same it might apply.
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On