Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Trigger after commit

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Haresh

New User


Joined: 04 Jan 2009
Posts: 18
Location: Germany

PostPosted: Thu Mar 03, 2011 9:59 pm    Post subject: DB2 Trigger after commit
Reply with quote

Hi

please let me know is there some way to make the DB2 trigger to work only after the DB2 commit.

We have a DB2 table which will be inserted/updated/deleted by many applications. We need to capture these changes and replicate in another system in near time basis.

The main problem is all these insert/delete/update within a transaction are inter related and should be replicated as single request.

Thank You
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Mar 03, 2011 10:07 pm    Post subject:
Reply with quote

Hello,

At the top of the page is a link to "IBM Manuals". Look at the SQL Reference for your release of DB2.

This is not a proper use for a TRIGGER . . .
Back to top
View user's profile Send private message
Haresh

New User


Joined: 04 Jan 2009
Posts: 18
Location: Germany

PostPosted: Thu Mar 03, 2011 11:02 pm    Post subject:
Reply with quote

Hi

i already went through the manual, but i just want to know whether any of you guys cracked a similar scenario.

Anyway now i am looking into the option of 'DB2 Probagator' for my requirement.

thank you for the reply
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Fri Mar 04, 2011 1:10 am    Post subject:
Reply with quote

Hi Haresh,

In my place we use two kinds of tools for replication tool,

CA-Log Analyzer - Which will be executed after the batch process, it gets all the changes happened to table during that day and generates SQL STATEMENTS which is FTP'd and executed at multiple MS-SQL SERVER's.

We are starting to use Attunity Product for real-time replication, capturing changes from mainframe and ship it to SQL SERVER. This product even captures VSAM changes.

Thanks,
Sushanth
Back to top
View user's profile Send private message
Haresh

New User


Joined: 04 Jan 2009
Posts: 18
Location: Germany

PostPosted: Fri Mar 04, 2011 7:01 pm    Post subject:
Reply with quote

Hi Sushanth,

thank you for the details,
will have a look on both the things and check whether it will fit in our system.

Haresh
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm
No new posts How to track incoming input files tha... shreya19 JCL & VSAM 6 Thu Feb 25, 2016 6:15 pm
No new posts Issue in trigger vickey_dw DB2 3 Wed Feb 10, 2016 5:41 pm
No new posts Trigger a mainframe job by mail Praveen Thenraj IBM Tools 8 Wed Jan 13, 2016 12:05 pm
No new posts Setting up a new trigger krisprems DB2 4 Thu Dec 24, 2015 10:33 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us