Vijay Kumar Vemuri
  • 35, Male
  • Bangalore
  • India
Share on Facebook Share on Facebook Share

Vijay Kumar Vemuri's Friends

  • Anil Mahadev

Vijay Kumar Vemuri's Groups


Vijay Kumar Vemuri's Page

Gifts Received


Vijay Kumar Vemuri has not received any gifts yet

Give Vijay Kumar Vemuri a Gift

Profile Information

Full Name:
Vijay Kumar Vemuri
Job Title:
Associate System Engineer
IBM India
Platforms of Interest:

Comment Wall (3 comments)

You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

At 7:32am on February 17, 2009, RAVI GROVER said…
The query is like this

connect to db name
select procschema,procname,body/text from syscat.procedures with ur|grep -ip 'SP Name'
At 11:14pm on February 16, 2009, RAVI GROVER said…
Hi Vijay,

Greetings!! There is a tool called devloper workbench which must have this kind of functionality of finding the code which is calling that Sp. But if you are sure that the calling program is a function or procedure that what you do is get the definition from the syscat.procedures / functions on column BODY/TEXT. then grep for the SP which is being called.You will get the occuirences and it is one way to find who is calling this sp and auth id you can get it from syscat itself. We can discuss this more on call.

Ravi G(9818800832)
At 2:40pm on February 16, 2009, IDUG: The Worldwide DB2 Community said…
Hi Vijay,

The IDUG DB2-L ListServe is a great place to post questions such as these and receive responses from members of the IDUG DB2 Community. To learn more about the DB2-L Listserv and subscribe, visit


Featured Downloads

Try BLU Acceleration on Cloud

© 2021   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service