IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Trapping SQL calls in DB2


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 3156
Location: Tucson AZ

PostPosted: Thu Jan 11, 2007 2:13 am
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
No new posts JAVA equivalent for IMS DL/I calls IMS DB/DC 2
No new posts Sending system service calls by AIBTDLI. IMS DB/DC 1
No new posts Scan for Calls to DB2 IBM Tools 10
No new posts Static and Dynamic Calls with DB2 Pro... DB2 6
Search our Forums:

Back to Top