View previous topic :: View next topic
|
Author |
Message |
balubhat
New User
Joined: 04 Oct 2005 Posts: 19 Location: Singapore
|
|
|
|
Hi
Does any of the SYSIBM table provide the total number of UPDATE/DELETE/INSERT/SELECT in a program?
Basically, without going into the program, is it possible to know how many UPDATE sql query are there a given program? And on which table also...
Pls let me know if any of you knows about it.
I tried to find in SYSIBM.SYSPAKSTMT but it doesn't give that.
Thanks! |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
No |
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
This is an UNTESTED Query for you to start with.
I am sure you can tailor it to fit your needs:
Code: |
SELECT GRANTEE,
TTNAME,
DELETEAUTH,
INSERTAUTH,
SELECTAUTH,
UPDATEAUTH,
FROM SYSIBM.SYSTABAUTH
WHERE GRANTEE = MY-PROGRAM
AND (DELETEAUTH = 'Y'
OR INSERTAUTH = 'Y'
OR SELECTAUTH = 'Y'
OR UPDATEAUTH = 'Y')
|
|
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
you could also do a SuperC Search
on your DBRM library,
search keys would be INSERT, DELETE, SELECT, UPDATE
then you could sort the results either by program or table. |
|
Back to top |
|
|
|