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
 

 

SOC4 abend in DB2 Insert

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
Appu

New User


Joined: 26 Apr 2010
Posts: 74
Location: India

PostPosted: Wed Dec 08, 2010 10:21 pm    Post subject: SOC4 abend in DB2 Insert
Reply with quote

Hi,

In my PLI DB2 program , I am trying to insert a row in to a DB2 table and it is giving me SOC4 abend on the insert statement. But the same row is getting inserted whn i try it through SPUFI.

The abend is as follows :

IBM0534S ONCODE=8094 PROTECTION EXCEPTION
INFORMATION FOR THREAD 8000000000000000

TRACEBACK:
DSA ENTRY E OFFSET STATEMENT LOAD MOD PROGRAM UNIT
1 CEEHDSP +000041E2 CEEPLPKA CEEHDSP

Can anyone help ? Thanks.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Dec 08, 2010 10:23 pm    Post subject: Reply to: SOC4 abend in DB2 Insert
Reply with quote

does the abend occur at the FIRST invocation of a DB2 service ?

if yes check the linkage editor for unresolved VCONS and AMODE/RMODE settings
Back to top
View user's profile Send private message
Appu

New User


Joined: 26 Apr 2010
Posts: 74
Location: India

PostPosted: Wed Dec 08, 2010 10:30 pm    Post subject:
Reply with quote

Hi ,

The insert is the 2nd statement . The previous SQL statement like Include SQLCA worked fine returning sqlcode 0.


Link step went fine . I could see AMODE and RMODE are NOT SPECIFIED.
No VCONS are unresolved. Only thebelow ones are unresolved.
IBMQOFNT
IBMQOFPT
DSNHLI
IBMQEFSH
IBMPOFCX
IBMPINPL
CEESG011
CEEBETBL
CEEROOTA
CEEOPIPI
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10256
Location: italy

PostPosted: Wed Dec 08, 2010 10:58 pm    Post subject: Reply to: SOC4 abend in DB2 Insert
Reply with quote

Quote:
Link step went fine
please define fine
what is the return code from the linkage editor ?

anyway do You, your support realize that DSNHLI is the interface stub for DB2
and that it is not supposed to be uresolved!

work with Your support to setup a proper ( compile/link) procedure
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Dec 09, 2010 1:05 pm    Post subject:
Reply with quote

Quote:
The previous SQL statement like Include SQLCA worked fine returning sqlcode 0


How do you know that there was an sqlcode of 0 returned for the INCLUDE SQLCA statement?
Back to top
View user's profile Send private message
Kjeld

Active User


Joined: 15 Dec 2009
Posts: 365
Location: Denmark

PostPosted: Thu Dec 30, 2010 6:32 am    Post subject:
Reply with quote

Sorry for posting late, but this thread ended appearently unresolved.

Appu wrote:
Hi ,

The insert is the 2nd statement . The previous SQL statement like Include SQLCA worked fine returning sqlcode 0.


Link step went fine . I could see AMODE and RMODE are NOT SPECIFIED.
No VCONS are unresolved. Only thebelow ones are unresolved.
IBMQOFNT
IBMQOFPT
DSNHLI
IBMQEFSH
IBMPOFCX
IBMPINPL
CEESG011
CEEBETBL
CEEROOTA
CEEOPIPI

The INCLUDE SQLCA statement does not execute any code at runtime, so I assume that the INSERT statement is after all the first DB2 call when you execute your program.

I think your problem is calling the wrong DB2 connect module. The entry point DSNHLI is contained in multiple connect modules that are used for different runtime environments. For TSO batch interface (IKJEFTxx), you should load or link module DSNELI.

For further info on this, reference your current DB2 Application Programming Guide manual.
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm
No new posts IMS BMP program causes 878 system abend Artemk IMS DB/DC 7 Tue Nov 22, 2016 8:26 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm
No new posts hot to get details when "EXEC CI... Andi1982 CICS 11 Tue Sep 20, 2016 5:01 pm
No new posts Insert Lines in JCL with Rexx after a... Willy Jensen CLIST & REXX 3 Tue Aug 30, 2016 4:18 pm


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