IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need help in resolving S806 abend


IBM Mainframe Forums -> CA Products
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
shakti

New User


Joined: 20 Jan 2004
Posts: 42

PostPosted: Thu Dec 13, 2007 1:50 pm
Reply with quote

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
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Thu Dec 13, 2007 1:54 pm
Reply with quote

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
View user's profile Send private message
shakti

New User


Joined: 20 Jan 2004
Posts: 42

PostPosted: Thu Dec 13, 2007 2:49 pm
Reply with quote

Hi,

My sysprint doesn't show any sql portion my jcl....

dont know what could be the cause of this issue?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Dec 13, 2007 2:55 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Thu Dec 13, 2007 4:02 pm
Reply with quote

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
View user's profile Send private message
shakti

New User


Joined: 20 Jan 2004
Posts: 42

PostPosted: Thu Dec 13, 2007 6:59 pm
Reply with quote

Can you please let me the system load libraries since i am not abl e to locate those?

thanks
sakthi
Back to top
View user's profile Send private message
Gnanas N

Active Member


Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India

PostPosted: Thu Dec 13, 2007 8:11 pm
Reply with quote

Shakti,

You ask this to System Admin Team. Normally, they will be SYS1.*, SYS2.*, etc.

Correct me if I am wrong.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Fri Dec 14, 2007 11:47 am
Reply with quote

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
View user's profile Send private message
shakti

New User


Joined: 20 Jan 2004
Posts: 42

PostPosted: Fri Dec 14, 2007 2:26 pm
Reply with quote

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
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Fri Dec 14, 2007 2:49 pm
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Fri Dec 14, 2007 2:55 pm
Reply with quote

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
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 355
Location: New York

PostPosted: Fri Dec 14, 2007 3:32 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


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

PostPosted: Fri Dec 14, 2007 3:37 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Fri Dec 14, 2007 9:38 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CA Products

 


Similar Topics
Topic Forum Replies
No new posts Call an hlasm from REXX in batch and ... CLIST & REXX 4
No new posts What is the most complex abend you've... Mainframe Interview Questions 8
No new posts ISAM and abend S03B JCL & VSAM 10
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
No new posts WER999A - UNSUCCESSFUL SORT 8ED U Ab... SYNCSORT 5
Search our Forums:

Back to Top