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

How to get the stored procedure information?


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
srilata83

New User


Joined: 02 Apr 2009
Posts: 16
Location: chennai

PostPosted: Tue Nov 10, 2009 2:38 pm
Reply with quote

Hi All,

I don't know much about stored procedure.I am being asked to increase the ASUTIME LIMIT parameter .I know that to alter the parameter. i have to get the stored procedure and from there only i can alter the parameter.But the requesting team doesnt know where to get stored procedure name.Do anybody help?Or is there any other way to increase this Limit?The job is a db2 unload utility.Hw can i alter this limit and how to get the stored proc name?

Please help.....

Thanks in advance.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1281
Location: Belgium

PostPosted: Tue Nov 10, 2009 3:35 pm
Reply with quote

ASUTIME limit is default maintained in table RLFUSER.DSNRLST01

read up on DB2 Governor :
publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db29.doc.perf/db2z_setsystemresourcelimit.htm
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 Capturing Job Execution Information All Other Mainframe Topics 3
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Extract all the TWS scheduler informa... IBM Tools 1
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts Table Information - DB2 DB2 1
Search our Forums:

Back to Top