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
 

 

Sort need Help

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
aru_bec

New User


Joined: 23 Dec 2005
Posts: 19
Location: Bangalore

PostPosted: Tue Mar 07, 2006 9:48 pm    Post subject: Sort need Help
Reply with quote

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.

Code:

  INREC FIELDS=(1,10,          - 0010 Name
                         11,50,           -0060 address
                         61,08)          - 0068 date
  SORT FIELDS=(01,10,CH,A) 
  OUTFIL FNAMES=SORTOUT, OUTREC=(1,10)
  OUTFIL FNAMES=ADDOUT, OUTREC=(1,60)


The input file contains 200000 records. The o/p also should contain 200000 rcords. Previous runs also depicted the same.

This time the job didnot process 50000 records. The job didn't fail and gave any error message and o/p is transferred to System3(unix) where we are facing problems.

I think there is a problem in data quality in the i/p file (50000 records). Is my assumption correct?

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

Frank Yaeger

DFSORT Moderator


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

PostPosted: Tue Mar 07, 2006 10:02 pm    Post subject:
Reply with quote

Quote:
The job creates three different files.


I see two OUTFIL statements, so the job would create two different files. Each should have all of the input records, but SORTOUT would have the first 10 bytes of each record and ADDOUT would have the first 60 bytes of each record.

Are you saying that only 50000 of the 200000 input records were written to the output data sets? Or are you saying something else? Please clarify.

Please show your JCL and the //SYSOUT messages.
Back to top
View user's profile Send private message
aru_bec

New User


Joined: 23 Dec 2005
Posts: 19
Location: Bangalore

PostPosted: Tue Mar 07, 2006 10:23 pm    Post subject: Re: Sort need Help
Reply with quote

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
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Tue Mar 07, 2006 10:27 pm    Post subject:
Reply with quote

Quote:
Let me know if you need more clarification.


I already did when I said
Quote:
Please show your JCL and the //SYSOUT messages.


I can't tell you anything more without seeing your JCL and the messages you received.
Back to top
View user's profile Send private message
aru_bec

New User


Joined: 23 Dec 2005
Posts: 19
Location: Bangalore

PostPosted: Tue Mar 07, 2006 10:39 pm    Post subject: Re: Sort need Help
Reply with quote

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
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Tue Mar 07, 2006 11:04 pm    Post subject:
Reply with quote

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:

http://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.
Back to top
View user's profile Send private message
aru_bec

New User


Joined: 23 Dec 2005
Posts: 19
Location: Bangalore

PostPosted: Thu Mar 09, 2006 7:17 am    Post subject: Re: Sort need Help
Reply with quote

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
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


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

PostPosted: Thu Mar 09, 2006 9:21 pm    Post subject:
Reply with quote

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.
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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