Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
0C1 Error while executing a Db2 statement

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: 0C1 Error while executing a Db2 statement
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

Site Director


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

PostPosted: Wed Apr 07, 2010 1:00 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Wed Apr 07, 2010 1:57 am    Post subject:
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    Post subject:
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

Site Director


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

PostPosted: Wed Apr 07, 2010 2:09 am    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10327
Location: italy

PostPosted: Wed Apr 07, 2010 2:09 am    Post subject: Reply to: 0C1 Error while executing a Db2 statement
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    Post subject:
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
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 6 Thu Sep 07, 2017 6:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us