Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Stored Proc call fails in SPAS with IEW4005I

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
VIGNRSH
Warnings : 1

New User


Joined: 18 Mar 2007
Posts: 44
Location: New Jersey,USA

PostPosted: Wed Nov 12, 2008 10:23 am    Post subject: Stored Proc call fails in SPAS with IEW4005I
Reply with quote

Hi ,
I am currently using the DB2 v7 due to which we are executing the Stored Procs in SPAS . When execuing the Stored Procs , iam getting the following error,

Code:

CSV031I LIBRARY ACCESS FAILED FOR MODULE NPSP    , RETURN CODE 24, REASON CODE 2
IEW4008I FETCH FAILED FOR MODULE GYSPROC1 FROM DDNAME STEPLIB  BECAUSE OF AN ERR
IEW4005I FETCH FOR MODULE GYSPROC1 FROM DDNAME STEPLIB  FAILED BECAUSE IEWFETCH


It REads TTR conversion error from Manuals..


Please Help on how to avoid this Error , because , the last time i faced this issue i have re started the entire sytem , and it was resolved temporarily .

Note:
1.Whenever Stored Procs are changed i do stop and restart them .
2.My Stored Proc Load Library is PDS and not PDSE as, i found in some forums that LoadModules of SPs should ideally reside in PDSe .
If the above is correct , can anyone explain why it should reside in PDSes??

Thank YOu
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 12, 2008 10:31 am    Post subject:
Reply with quote

Hello,

Suggest you convert your PDS datasets to PDSE. When a member is replaced in the standard pds, the "old" address is being remembered in the system and when an attempt to invoke the module is made, there are problems.

You can once again you can restart the system, which will resolve the new modules locaton in the pds. PDSE datasets are internally managed in a different manner than PDS datasets. One example is that you do not need to compress PDSE datasets.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Nov 12, 2008 10:56 am    Post subject:
Reply with quote

Hi,
Quote:
i have re started the entire sytem
What does this mean ? Please assist.

We are talking about DB2 Store PROCs here , right ?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Nov 12, 2008 11:19 am    Post subject:
Reply with quote

Hi Anuj,

Quote:
What does this mean ? Please assist.
To bring the environment down and bring it back up. This will refesh everything internally clearing the problem.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts LIBDEF not working in called proc packerm CLIST & REXX 0 Fri Sep 15, 2017 7:22 pm
No new posts REXX to view the PGM or PROC jackzhang75 CLIST & REXX 11 Tue Jun 20, 2017 1:20 am
No new posts Fileaid 2 commands instream work. In ... descann Compuware & Other Tools 2 Tue May 16, 2017 3:31 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts Need help in triggering a PL1 module ... Varungv99 IMS DB/DC 0 Fri Apr 07, 2017 10:01 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us