|
View previous topic :: View next topic
|
| Author |
Message |
VIGNRSH
Warnings : 1
New User
Joined: 18 Mar 2007
Posts: 44
Location: New Jersey,USA
|
|
|
|
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
|
|
