View previous topic :: View next topic
|
Author |
Message |
shakti
New User
Joined: 20 Jan 2004 Posts: 42
|
|
|
|
Hello,
I am running a easytrive jcl which reads input file and pass it where clause of a sql statement. In executing the above jcl, i am getting the following error.
CSV003I REQUESTED MODULE DQSPSCV NOT FOUND
CSV028I ABEND806-04 JOBNAME=NBDT1JSV STEPNAME=JS20
IEA995I SYMPTOM DUMP OUTPUT
SYSTEM COMPLETION CODE=806 REASON CODE=00000004
Can anybody help me out to resolve this?
Thanks
Shakti |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Shakti,
Quote: |
REQUESTED MODULE DQSPSCV NOT FOUND |
DQSPSCV , this module is not found in the load libraries. or give the STEPLIB for that step JS20.
Correct me if I am wrong. |
|
Back to top |
|
|
shakti
New User
Joined: 20 Jan 2004 Posts: 42
|
|
|
|
Hi,
My sysprint doesn't show any sql portion my jcl....
dont know what could be the cause of this issue? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
go to the IBM LookAt Site
www-03.ibm.com/servers/eserver/zseries/zos/bkserv/lookat/
and enter your 806-04, and READ the error description (which you will find is very similar to what Gnanas wrote.
the reason you don't have any sysprint of your sql, is because that part of the job never executed. because of the 806.............. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Shakti,
Did you try any of the above suggestions ?
A name such as 'DQSPSCV' suggests as if it's a users' program, if so you need to provide the load library for this program in the step (in DD name STEPLIB) when you execute this program, else JOB'll try to find in the load module in the system libraries & if will not find such a load-module there (this is the case with you ..I think) will cause 806 abend. |
|
Back to top |
|
|
shakti
New User
Joined: 20 Jan 2004 Posts: 42
|
|
|
|
Can you please let me the system load libraries since i am not abl e to locate those?
thanks
sakthi |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Shakti,
You ask this to System Admin Team. Normally, they will be SYS1.*, SYS2.*, etc.
Correct me if I am wrong. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Hi,
Before trying this
Quote: |
You ask this to System Admin Team. Normally, they will be SYS1.*, SYS2.*, etc. |
let us know whether 'DQSPSCV' is writteen by you? (I can not be more straight forward than this...) |
|
Back to top |
|
|
shakti
New User
Joined: 20 Jan 2004 Posts: 42
|
|
|
|
Anuj D. wrote: |
Hi,
Before trying this
Quote: |
You ask this to System Admin Team. Normally, they will be SYS1.*, SYS2.*, etc. |
let us know whether 'DQSPSCV' is writteen by you? (I can not be more straight forward than this...) |
Hi Anuj,
It is not written by me...Its a system defined module
Thanks
Shakti |
|
Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Hi,
Few days back, I was also getting S806-04 error while I was executing a COBOL program.
All our team uses Changeman to compile a program but as I was not much aware of it, I was trying to compile thru compile JCL and tried to execute the run JCL but I was getting the above error.
From Quick Reference (QW), I could find one of the reason is Autherization. I compiled the same program thru Changeman and used Changeman Loadlib, Executed run JCL successfully.
Might be authority problem in ur case also.
Following is the QW information for S806-04.
Quote: |
04 The system could not find the module, whose entry point is the
value of the EP or EPLOC operand, in the indicated library
(private library, job library, or link library). This situation
can occur when LSEARCH=YES is specified on the macro and the
limited library search fails to locate the module. For an alias
name, ensure that the entry point attributes match that of the
load module which was previously loaded (that is, authorization,
RMODE, entry point displacement).
|
Please correct me if I am wrong.
KSK |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10886 Location: italy
|
|
|
|
lots of traffic without solving... ANYTHING
abend 806 ... load module not found
a reread of the manual is all You can get here
WHY ??
Because we do not know anything about Your environment,
the load module not found "DQS...." does not start with one of
the id' s commonly used in a vanilla/bare-bones Mvs environment
for example if the module started with
DSN... it would be DB2related
DSQ.. QMF ( if I remember correctly )
IKJ... TSO
ISP... ISPF
ISF... SDSF
IST... VTAM
and so on and so on
So... PLEASEE PLEASEE speak with Your system support people |
|
Back to top |
|
|
ksk
Active User
Joined: 08 Jun 2006 Posts: 355 Location: New York
|
|
|
|
Hi e.s,
Thanks for the response. Again I am posting just to know whether my guess was correct or not.
I have posted here because, I have not used any defined programs as mentioned above. I used some programs like COMPARE, FIRST (purely user defined programs) etc.
When I compiled thru COmpile JCL and used user defined Load library, got S806-04 error but the same programs with same names were compiled thru Changeman and used Changeman load library, run JCL executed successfully.
KSK |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6248 Location: Mumbai, India
|
|
|
|
Quote: |
So... PLEASEE PLEASEE speak with Your system support people |
Or ask some Senior from your shop or search this Program in 3.14 in the 'baseline' PROCLIB, might be you would get some more information. (just a guess..) |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19243 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
It is not written by me...Its a system defined module |
I suspect that it is not part of the IBM O/S system. I suspect it may be part of some purchased software. Many sites have separate libraries for purchased software (often by vendor).
Regardless of where the module originated, the library that contains it is not part of the standard link list. You will need to include a STEPLIB or JOBLIB DD to name the library in your job.
Might it be that the module name is mis-spelled or was this generated internally? |
|
Back to top |
|
|
|