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

SOC7 when using DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
raviputran

New User


Joined: 05 Jul 2007
Posts: 13
Location: bangalore

PostPosted: Mon Mar 08, 2010 9:19 pm
Reply with quote

Hi,

I am trying to sort a temporary dataset using DFSORT. I am continiously getting SOC7 abend with the following message

ICE185A 0 S0C7 ABEND ISSUED BY DFSORT, ANOTHER PROGRAM OR EXIT DURING (PHASE S 3)

I tried to trace using offset but it's misleading. Data is fine.

What could be the blocker in this case.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8696
Location: Dubuque, Iowa, USA

PostPosted: Mon Mar 08, 2010 9:44 pm
Reply with quote

Quote:
I tried to trace using offset but it's misleading. Data is fine.

What could be the blocker in this case.
The data, by definition, is not "fine". A S0C7 abend means that you have specified a field to be numeric and the field does not contain numeric data. That is the only meaning for this abend -- and if you tell the system the data is numeric and it is not numeric, then the data cannot be "fine".

Since you did not post anything for us to help you, presumably you can go back and find the invalid data and fix it. Starting with the attitude that the data is "fine", however, is pretty much a guarantee that you will not be able to resolve this issue.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Mon Mar 08, 2010 10:02 pm
Reply with quote

Hello,

If the data is "fine", then you have not named the correct positions in the sort control statements.

If the data is variable, you must add 4 for the rdw. . .
Back to top
View user's profile Send private message
vinowiz

New User


Joined: 01 Feb 2010
Posts: 1
Location: chennai

PostPosted: Tue Mar 09, 2010 11:38 am
Reply with quote

SOC 7 occurs due to Data exception. when u r trying to move non numeric value to numeric variable.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Mar 09, 2010 11:43 am
Reply with quote

Hello vinowiz and welcome to the forum,

Please note that this particular 0c7 happens in a SORT process, not some program.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Tue Mar 09, 2010 11:50 am
Reply with quote

vinowiz wrote:
SOC 7 occurs due to Data exception. when u r trying to move non numeric value to numeric variable.
Moves usually are PACK/UNPK and will not exception....
This is probably a sort order PD compare or a SUM problem.....
Back to top
View user's profile Send private message
Escapa

Senior Member


Joined: 16 Feb 2007
Posts: 1399
Location: IL, USA

PostPosted: Tue Mar 09, 2010 12:09 pm
Reply with quote

raviputran wrote:
Hi,

I am trying to sort a temporary dataset using DFSORT. I am continiously getting SOC7 abend with the following message

ICE185A 0 S0C7 ABEND ISSUED BY DFSORT, ANOTHER PROGRAM OR EXIT DURING (PHASE S 3)

I tried to trace using offset but it's misleading. Data is fine.

What could be the blocker in this case.

If you could post the sortcard then possible field in which data is bad and causing abend could be told.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Tue Mar 09, 2010 11:45 pm
Reply with quote

Quote:
Data is fine.


If you got an S0C7, then either some data has invalid values or or the location you gave for some data is wrong.

Note that you can use the VERIFY operator of DFSORT's ICETOOL to identify bad ZD or PD values. See:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA40/6.18?DT=20090527161936
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Tue Jun 15, 2010 11:16 pm
Reply with quote

I'm jumping in here because I have a similar problem, and while yes I understand what a Soc7 means, it does in deed seem that the data is fine.
I am converting legacy data for a client, so far I've successfully done about 60 files using DFSORT. I am stuck on 2 files that have a problem. The sort runs, processess in one case 60,000 records then gets a soc7. I delete record 60,001, then 60,002, etc but always get a soc 7 here after 60,000 records. I try copying record number 1 ( which processed successfully) and placing it after record 60,000, but same thing. 1st time, the record is processed, second time, at record 60,001 , the same data gets a soc 7. Now I tried preallocating a file. ( It is not getting a B37, there is plenty of space) and I am getting a soc7 after record 62400, The data has not changed , no one uses it. So record 60,001 produced a soc7 before , now I go all the way to record 62400 and record 62401 gets a soc7 . Always in the same place, even if I delete input records. Makes no sense to me. Is there any other possible explanination besides bad data - file size? block size?
thanks
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jun 15, 2010 11:23 pm
Reply with quote

Hello,

Are the problem files possibly variable rather than fixed?
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Tue Jun 15, 2010 11:25 pm
Reply with quote

a PS to the posting I did a few minutes ago, the block size definitely impacts the number of records processed. I ran my job 4 times in the past half hour, each time with a different block size. Same input data, but the soc7 occurs at different places, anywhere from 60000 records to 62480. I've yet to make it through the entire file and I did not have this problem with other DFSORT jobs that I wrote
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Tue Jun 15, 2010 11:26 pm
Reply with quote

the files are all flat
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Tue Jun 15, 2010 11:39 pm
Reply with quote

by setting the block size = the length of one record I am now processing 99% of the records before getting the Soc7
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Tue Jun 15, 2010 11:45 pm
Reply with quote

Hello,

Quote:
the files are all flat
Flat files can be variable or fixed.

Try splitting the file in half and running again. . .
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Tue Jun 15, 2010 11:46 pm
Reply with quote

sorry, meant the files are fixed length
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Tue Jun 15, 2010 11:52 pm
Reply with quote

yep, that works, by changing the block size and splitting the file I can process the entire file, thanks
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Jun 16, 2010 12:29 am
Reply with quote

About time to open a ticket with IBM support,
there is no reason to fiddle with the block size to avoid an abend
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Wed Jun 16, 2010 12:46 am
Reply with quote

IBM support? this client has no IBM support
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Jun 16, 2010 12:59 am
Reply with quote

then they will have to live with ... changing the block size and splitting the file icon_cool.gif
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Wed Jun 16, 2010 1:07 am
Reply with quote

client is the government. need I say more icon_smile.gif
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Wed Jun 16, 2010 1:28 am
Reply with quote

steves wrote:
IBM support? this client has no IBM support
If the client has no support, then why are you using Dfsort?
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Wed Jun 16, 2010 1:30 am
Reply with quote

they are getting rid of their mainframe, I'm just trying to find the easiest way to archive a ton of old data they have; DFsort is easier than writing cobol programs to reformat the data
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Jun 16, 2010 1:37 am
Reply with quote

isn' t it a bit unethical to seek help on how to get rid of the mainframe
on forums devoted to mainframes icon_rolleyes.gif

I sincerely hope that all Your client bytes lose their parity icon_biggrin.gif icon_biggrin.gif
Back to top
View user's profile Send private message
steves

New User


Joined: 26 Feb 2007
Posts: 30
Location: chicago

PostPosted: Wed Jun 16, 2010 1:40 am
Reply with quote

i'm a mainframe developer. this client is getting rid of their mainframe. I'll still be around and the knowledge I gain will still be here
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Wed Jun 16, 2010 1:48 am
Reply with quote

Hello,

Quote:
yep, that works, by changing the block size and splitting the file I can process the entire file, thanks
Well, it had been my hope that this would help diagnose the problem rather than be the solution. . .

Just curious, but what media are the problem files stored on?

To do the experiments you ran, did you re-block the input multiple ways?

How long has it been since the system software was upgraded?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL Goto page 1, 2  Next

 


Similar Topics
Topic Forum Replies
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
No new posts DFsort help with SUM() DFSORT/ICETOOL 12
No new posts DFSORT - VB file RDW getting overridden DFSORT/ICETOOL 3
Search our Forums:

Back to Top