View previous topic :: View next topic
|
Author |
Message |
rajinfy123
New User
Joined: 09 Jul 2004 Posts: 12
|
|
|
|
Is it possible to Trap the Database calls done from the programs i.e either 'Select' or 'Insert' or 'Update'?????
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
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 |
|
|
rajinfy123
New User
Joined: 09 Jul 2004 Posts: 12
|
|
|
|
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 |
|
|
Santoshdorge
New User
Joined: 27 Jun 2006 Posts: 48 Location: Pune
|
|
|
|
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 |
|
|
|