Sort need Help

aru_bec · New User Joined: 23 Dec 2005 Posts: 19 Location: Bangalore

Hi all,

One of our production job didn't process the number of records as per the expectation.

It receives data from a system say System1.

then it is fed to a job which sorts the data. Ideally the number of i/p records and o/p records should be the same. The job creates three different files.

The sort card looks like this.

Frank Yaeger · Posted: Tue Mar 07, 2006 10:02 pm

aru_bec · New User Joined: 23 Dec 2005 Posts: 19 Location: Bangalore

Frank,

There are three files...i have just copied two of them.

The sortout data set and the other two contains only 150000 (200000 - 50000) records. SYSLOG also shows that DATAIN - 150000 and DATAOUT - 150000. but the i/p file contains 200000.

Where are the other 50000?

Note that the job run successfully.

Let me know if you need more clarification.

Thanks,
Arvind

Frank Yaeger · Posted: Tue Mar 07, 2006 10:27 pm

aru_bec · New User Joined: 23 Dec 2005 Posts: 19 Location: Bangalore

Frank,

Due to security reasons and complexity (using many procs) i can't paste the JCL.

But syslog looks like this -

SORTOUT : DELETED = 0, REPORT = 0, DATA = 150000
0 SORTOUT : TOTAL IN = 150000, TOTAL OUT = 150000
0 addOUT : DELETED = 0, REPORT = 0, DATA = 150000
0 addOUT : TOTAL IN = 150000, TOTAL OUT = 150000
0 dateOUT : DELETED = 0, REPORT = 0, DATA = 150000
0 dateOUT : TOTAL IN = 150000, TOTAL OUT = 150000

but the i/p data set contains 200000 records.

Hope this helps you identify my problem.

Thanks for your response,
Arvind

Frank Yaeger · Posted: Tue Mar 07, 2006 11:04 pm

I wanted to see your JCL and all of the messages to determine if my guess about what's going on was reasonable. My guess is that you're running into the system restriction described in the second bullet here:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/1.8.3.1?SHELF=&DT=20050222160456&CASE=

If that's not it, then I need to see the input DD statement or statements (if concatenated) and the //SORTOUT DD and //ADDOUT DD statements. I also need to see ALL of the messages with their ICExxxs numbers. If you want to send all of that to me offline (yaeger@us.ibm.com) rather than posting them here, that's fine. Just put "DFSORT" somewhere in your Subject to catch my attention.

aru_bec · New User Joined: 23 Dec 2005 Posts: 19 Location: Bangalore

Thank you Frank,

The remaining 50000 records were there in the i/p file, but the sort prg didn't read those records. I rerun the program and now we are handling the issue in the system3.

The link provided by you was very helpfull.

(http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/1.8.3.1?SHELF=&DT=20050222160456&CASE= )

Thanks & regards,
Arvind

Frank Yaeger · Posted: Thu Mar 09, 2006 9:21 pm

Your references to System 1 and System 3 don't really mean anything to anyone else on this list. Since you said the link I provided was helpful, I assume that the problem was in fact some variation of the system restriction described there and you were able to do something to avoid that system restriction.