Joined: 18 Mar 2007 Posts: 44 Location: New Jersey,USA
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,
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 .
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??
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
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.