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
 

 

Help with SOC4 on DSNHLI/DSNELI

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Kiran K Menon

New User


Joined: 25 May 2011
Posts: 7
Location: India

PostPosted: Sun Apr 24, 2016 10:16 pm    Post subject: Help with SOC4 on DSNHLI/DSNELI
Reply with quote

Hello All,
Do you guys happen to encounter SOC4 exception on Cobol DB2 program on the DSNHLI/DSNELI call ?

In my case, we had an implementation to a higher test environment which involved changes to few db2 tables and identified program changes. As a customory practise with our client, they tend to rebind all DBRMs (irrespective of whether a change has happened on the modules involved). Unforunately, once the rebind had happened, some of the existing modules started failing with a SOC4 on DSNHLI call.
Batch programs failing with SOC4 and some onlines showing an abend code of AD2R

The message from the batch job is as below (with the offset address pointing to an INSERT query)
eg :
RUN PROG (abcdefg) PLAN (abcdefg)
IKJ56641I DSN ENDED DUE TO ERROR+
IKJ56641I SYSTEM ABEND CODE 0C4 REASON CODE 00000038

We have tried to recompile the abended module in a lower environment and promote it back to the higher environment followed by a rebind again but it wasn't helping either. Please note that the same module works fine in a lower environment and we are not aware of any DB2 version difference between the 2 regions. Also, note that there are other DBRM that got rebinded (without changes) holding good. And everything was working fine until this changes has gone in.

The abendaid was showing the below message
COMMAND ===> SCROLL ===> CSR

A storage reference exception occurred during execution of program DSNELI.
The expected completion code is S0C4.

Analysis of Error

The next sequential instruction to be executed in program DSNELI was at
displacement 000001DE.

The execution was a SELECT ID INTO :ID
FROM FINAL TABLE (INSERT INTO DB.TABLENAME(FIELD1,FIELD2, ID) VALUES('FIELD1','FIELD2',Current timestamp) kind of SQL

Any help in the right direction is highly appreciated

Thanks
Back to top
View user's profile Send private message

Kiran K Menon

New User


Joined: 25 May 2011
Posts: 7
Location: India

PostPosted: Sun Apr 24, 2016 10:56 pm    Post subject:
Reply with quote

Just wanted to add that the table on which the INSERT / SELECT is happening is not modified as part of the changes
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Mon Apr 25, 2016 3:08 am    Post subject:
Reply with quote

It looks to me a table space issue for the batch programs and for online AD2R yoU will have see the dump , start here.
at first what did you site support advised you on these abends? Did you even approach them ? Such issues only them can resolved as they know your system but we don't.
Back to top
View user's profile Send private message
Kiran K Menon

New User


Joined: 25 May 2011
Posts: 7
Location: India

PostPosted: Mon Apr 25, 2016 10:42 am    Post subject:
Reply with quote

Hello Rohit,
The support group (including the DBAs) were unavailable during the time to comment on it. I have tried to look through the SYSTABLESPACESTATS and SYSTABLEPART with my limited knowledge but didn't notice anything suspicious.

The AD2R abend is happening for a similiar SELECT / INSERT combination explained above.

I guess the DBAs would be back in office today to take a look at it.

Thanks.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Mon Apr 25, 2016 11:13 am    Post subject:
Reply with quote

Thats good. please share us back with your fix so that others can also be benefited.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1715
Location: UK

PostPosted: Mon Apr 25, 2016 7:51 pm    Post subject:
Reply with quote

"The abendaid was showing the below message
COMMAND ===> SCROLL ===> CSR"

Please review your posts before submitting (or immediately after) and fix stuff like this. You should know by now when, and how, to use the code tags.
Back to top
View user's profile Send private message
Kiran K Menon

New User


Joined: 25 May 2011
Posts: 7
Location: India

PostPosted: Tue Apr 26, 2016 12:31 pm    Post subject:
Reply with quote

Update : No solution on this so far from DBAs either

On a separate note, we are unable to run the above query even using IKJEFT01 (as a stand alone query) in the higher enviornment but is working perfectly fine in the lower regions. When the INSERT was run seperately there were no issues but the moment we use SELECT FROM FINAL TABLE with an INSERT it goes for a toss.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Tue Apr 26, 2016 10:18 pm    Post subject:
Reply with quote

You will have to share us the error message and the sqlcodes and also the DB2 version on which you made your tries.
what do you mean by higher and lower environments? DBA's should be able to help you.
Back to top
View user's profile Send private message
Kiran K Menon

New User


Joined: 25 May 2011
Posts: 7
Location: India

PostPosted: Wed Apr 27, 2016 3:12 pm    Post subject:
Reply with quote

fyi,
Finally got a resolution to the issue. As part of testing the IBM Accelerator product the DBAs had recently changed a subsysem parameter called ACCELMODEL from NO to YES. Once this parameter was changed back to NO, we rebinded all the packages again at it worked fine.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1610
Location: NY,USA

PostPosted: Wed Apr 27, 2016 7:19 pm    Post subject:
Reply with quote

Thanks for letting us know.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7913
Location: Bellevue, IA

PostPosted: Wed Apr 27, 2016 7:50 pm    Post subject:
Reply with quote

This is a perfect example of why your FIRST point of contact should be your site support group, not a forum (this or any). Nobody on this forum works for your site and hence we would have no way of knowing that your site support group had changed site parameters; if you had contacted them first, perhaps they would have realized that their change was impacting users sooner.
Back to top
View user's profile Send private message
Kiran K Menon

New User


Joined: 25 May 2011
Posts: 7
Location: India

PostPosted: Wed Apr 27, 2016 8:34 pm    Post subject:
Reply with quote

Robert, i wasn't waiting for an update from the forum before reaching out to the support group. I have mentioned that in my third post 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 soc4 on internal table in cobol abdulrafi COBOL Programming 13 Fri May 06, 2016 3:39 pm
No new posts soc 4 with dsnhli while debugging cic... manigadu IBM Tools 1 Sat Nov 22, 2014 1:05 pm
No new posts SOC4 X'4' abend in PLI-IMS program Kunal Surpurkar IMS DB/DC 3 Tue Jan 07, 2014 3:48 pm
No new posts SOC4 abend on field display Pavankumar.m COBOL Programming 5 Thu Nov 21, 2013 7:01 pm
No new posts SOC4 Abend while migrating from COBOL... satyagrahi144 ABENDS & Debugging 3 Mon Oct 07, 2013 12:31 pm


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