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
 

 

Trapping SQL calls in DB2

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

New User


Joined: 09 Jul 2004
Posts: 12

PostPosted: Thu Jan 11, 2007 12:53 am    Post subject: Trapping SQL calls in DB2
Reply with quote

Is it possible to Trap the Database calls done from the programs i.e either 'Select' or 'Insert' or 'Update'????? icon_confused.gif

Eg: Consider statement
"Select Field1, Field2
from Table 1 "
When the above query is run from the program, what all internal system programs/routines does this query trigger before fetching the 'Field1' & 'Field2' data from the DB2 table 'Table1'.

Pls answer my above query, If my query is not clear pls do leave a reply & I will try to explain more.

Thanks,
Raj.
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Thu Jan 11, 2007 2:13 am    Post subject:
Reply with quote

Hi Raj,

Not being a "real" DBA, I can only guess....Would a trigger give you access to what you want?

Bill
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Thu Jan 11, 2007 3:02 am    Post subject: Re: Trapping SQL calls in DB2
Reply with quote

Raj,

When I first read your post, the same answer as William suggested came to mind, but Triggers only fire for ?Insert?, ?Update?, and ?Delete?. And this will only capture the row that got modified.

Re-reading your post, I?m not sure you?re asking to capture rows that have been accessed.
Could you please clarify your question for us?

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

New User


Joined: 09 Jul 2004
Posts: 12

PostPosted: Thu Jan 11, 2007 3:07 am    Post subject: Re: Trapping SQL calls in DB2
Reply with quote

Hi Bill,
Yes, with the type of Triggered system level program/s would enable me to capture the data which is either Updating/Reading/Deleting to Table-I to another Table-II i.e rerouting the calls of Table-I to Table-II

Pls let me know if not clear..

Thanks,
Raj.
Back to top
View user's profile Send private message
Santoshdorge

New User


Joined: 27 Jun 2006
Posts: 48
Location: Pune

PostPosted: Thu Jan 11, 2007 12:37 pm    Post subject:
Reply with quote

Hi
Do you know about Omegamon - DB2 - Classic.I think this would help you.

Please correct me if I am wrong


Thanks,
Santosh
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 Sending system service calls by AIBTDLI. lind sh IMS DB/DC 1 Wed Mar 16, 2016 6:51 pm
No new posts Scan for Calls to DB2 kctechpro2 IBM Tools 10 Fri Sep 04, 2015 11:31 pm
No new posts Static and Dynamic Calls with DB2 Pro... RahulChaudhari DB2 6 Sun Nov 30, 2014 1:37 am
No new posts IMS Calls Vs DB2 Calls shiitiizz All Other Mainframe Topics 5 Fri Jun 06, 2014 12:20 pm
No new posts IMS calls to database. dilip_bangalore IMS DB/DC 3 Mon Sep 23, 2013 1:17 pm


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