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

0C1 Error while executing a Db2 statement


IBM Mainframe Forums -> DB2
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
GauravKudesiya
Warnings : 1

New User


Joined: 11 Oct 2008
Posts: 74
Location: Chicago, IL

PostPosted: Wed Apr 07, 2010 12:49 am
Reply with quote

After seeing this very old post: 0C1 Error while executing First Db2 statement in pgm i am facing same issue..
I recompiled and linked my code.
but when first EXEC SQL came, it fails with same error.

EXEC SQL is converted into the below code, and it fails while CALL 'DSNHLI'

PERFORM SQL-INITIAL UNTIL SQL-INIT-DONE
CALL 'DSNHLI' USING SQL-PLIST3


and The error i am facing is

The operating system has generated the following message:
CEE3201S The system detected an operation exception (System Completion
Code=0C1).
The current location is DSO0700B ::> DSO0700B :> 1299.1.


I am using IBM DEBUGGER for debugging.

Regards,
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: Wed Apr 07, 2010 1:00 am
Reply with quote

Hello,

Did you use the system standard compile process?

What does the output of the linkedit and bind show?
Back to top
View user's profile Send private message
GauravKudesiya
Warnings : 1

New User


Joined: 11 Oct 2008
Posts: 74
Location: Chicago, IL

PostPosted: Wed Apr 07, 2010 1:41 am
Reply with quote

I use compile option of the DCCS.
Return code of Link is 00 and Bind is 04.

Hope it gives come clues

Regds,
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: Wed Apr 07, 2010 1:57 am
Reply with quote

Hello,

DCCS. . .? Not something i know. . .

Look at the output of the link for "unresolved".

Does this run successfully without the debugger in use? If yes, you need to work with your support people to make sure the debugger is being used correctly.
Back to top
View user's profile Send private message
GauravKudesiya
Warnings : 1

New User


Joined: 11 Oct 2008
Posts: 74
Location: Chicago, IL

PostPosted: Wed Apr 07, 2010 2:06 am
Reply with quote

HI,
First of all Its not working even without Debugger.
Secondly, i found many UNRESOLVED in sysprint of Link.

Its
z/OS V1 R9 BINDER 15:06:52 TUESDAY APRIL 6, 2010
BATCH EMULATOR JOB(T0084GKD) STEP(DCCSLNK ) PGM= IEWL PROCEDURE(LINK )
IEW2278I B352 INVOCATION PARAMETERS - LIST,LET,XREF,DCBS,

IEW2322I 1220 1 INCLUDE SYSLIB(DFSLI000)
IEW2322I 1220 2 NAME DSO0700B(R)


When i find "UNRESOLVED"
I found :

28CC CEEBETBL 4 V-CON | CEEBXITA UNRESOLVED(W) |


And similar lines many times.. icon_sad.gif

I cant figure out the cause.

Regards,
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: Wed Apr 07, 2010 2:09 am
Reply with quote

Hello,

Suggest you compare the jcl used to compile/link/bind something that does work with this module that has problems.

It sounds like one or more libraries are missing from the job. Probably something best resolved with the support people.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10888
Location: italy

PostPosted: Wed Apr 07, 2010 2:09 am
Reply with quote

why not ask Your support about the proper compile and link process ??
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Thu Apr 08, 2010 5:41 pm
Reply with quote

If you invoke you module using the IKJEFT01 module (TSO environment), you should include DSNELI in your link instead of DFSLI000...

There has been several posts in this issue later than the one quoted above.
Back to top
View user's profile Send private message
suhail2322

New User


Joined: 27 Mar 2009
Posts: 3
Location: Chennai

PostPosted: Wed Nov 06, 2019 6:19 pm
Reply with quote

did you found any solution, i am facing same problem
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts IEW2315E 1369 Link error All Other Mainframe Topics 3
No new posts Executing DB2 SQL store procedure via... DB2 0
No new posts Help on IMS -API URL migrating from P... IMS DB/DC 1
No new posts JES datasets IO Error ABENDS & Debugging 3
No new posts Error to invoke MPP program through B... IMS DB/DC 3
Search our Forums:

Back to Top