ChannelDB2

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

Vijay Kumar Vemuri's Friends

  • RAVI GROVER
  • Anil Mahadev

Vijay Kumar Vemuri's Groups

 

Vijay Kumar Vemuri's Page

Gifts Received

Gift

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
Company:
IBM India
Platforms of Interest:
Other

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…
HI
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 http://www.idug.org/listserv.html.

Regards,
IDUG
 
 
 

Featured Downloads

Try BLU Acceleration on Cloud

© 2019   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service