MVSFORUMS.com

sant_1028 · Beginner Joined: 23 Dec 2004 Posts: 8 Topics: 4

We have developed DB2 Stored Procedures in COBOL we are able to successfully bind in WLM Environment but we are not able to see our latest changes(Load Module), we can see our changes next day.

Does we need explicit WLM Refresh for every compile if so what steps to be added to JCL.

Adv Thanks,
Santhosh

kolusu · Posted: Tue Jan 25, 2005 10:01 pm Post subject:

sant_1028,

I guess your SP is defined with "stay resident" option. The stay resident option keeps a copy of the module. Usually most shops have an automated procedure to refresh the WLM address space.

Check this link which explains in detail about Refreshing the stored procedures environment

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/6.2.3.2?SHELF=&DT=20010710165542&CASE=

Also check this link for the WLM environment refresh stored procedure (WLM_REFRESH)

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/APPENDIX1.9.1?DT=20010710165542

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu