Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 10256
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 Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us