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
 

 

Neep help with ISRSUPC

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
swaroopnaga

New User


Joined: 15 Oct 2005
Posts: 8
Location: US

PostPosted: Fri Aug 26, 2011 8:43 pm    Post subject: Neep help with ISRSUPC
Reply with quote

Hi,

I am trying to compare two files of 20 million rows using the batch ISRSUPC, the summary is shown below:

?104345 NUMBER OF LINE MATCHES 10000 TOTAL CHANGES (PAIRED+NONPAIRED
0 REFORMATTED LINES 10000 PAIRED CHANGES (REFM+PAIRED INS
10000 NEW FILE LINE INSERTIONS 0 NON-PAIRED INSERTS
10000 OLD FILE LINE DELETIONS 0 NON-PAIRED DELETES
?114850 NEW FILE LINES PROCESSED
?114850 OLD FILE LINES PROCESSED

Can anyone provide some input as what "?" stands for?
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Aug 26, 2011 8:46 pm    Post subject: Reply to: Neep help with ISRSUPC
Reply with quote

most probably some kind of <number> overflow
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7223

PostPosted: Fri Aug 26, 2011 8:53 pm    Post subject: Reply to: Neep help with ISRSUPC
Reply with quote

How long did it take to run, out of interest?

The length of those number fields, including the ?, would be able to hold 9,999,999 - probably usually enough for a file comparison.

I agree with enrico. When the 10millionth arrived, the program cleverly noted that it couldn't be displayed, so when producing the totals it plopped the ? down to bring your attention to it. Probably somewhere deep in the manual it mentions file limits, and I guess you are lucky that this is the only apparent effect.

I'd not feel lucky. I'd split the files into three equal pieces and do the compare(s) again. I wouldn't want to "trust to luck" that half my file compared when I know "something" is "wrong" with the program for that half of the file.
Back to top
View user's profile Send private message
Escapa

Senior Member


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

PostPosted: Fri Aug 26, 2011 8:55 pm    Post subject:
Reply with quote

Or try with DFSORT compare and check how many new records and how many old records try to match the number with this number..

you will get to know what that ? means...
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Fri Aug 26, 2011 8:57 pm    Post subject: Reply to: Neep help with ISRSUPC
Reply with quote

using isrsupc for <application> dataset comparison is a bit of overshooting

application data is usually sorted on some key, most probably a <SORT> approach might be faster
Back to top
View user's profile Send private message
swaroopnaga

New User


Joined: 15 Oct 2005
Posts: 8
Location: US

PostPosted: Fri Aug 26, 2011 9:00 pm    Post subject: Re: Reply to: Neep help with ISRSUPC
Reply with quote

It took 16 hours for this comparison....
thanks for your inputs..

Naga
Back to top
View user's profile Send private message
Escapa

Senior Member


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

PostPosted: Fri Aug 26, 2011 9:05 pm    Post subject: Re: Reply to: Neep help with ISRSUPC
Reply with quote

swaroopnaga wrote:
It took 16 hours for this comparison....
thanks for your inputs..

Naga

Your job was running for 16 long hours icon_eek.gif icon_eek.gif icon_eek.gif

For doing just comparision?

You are lucky .. Your job is not thrown away by system management team..
Back to top
View user's profile Send private message
swaroopnaga

New User


Joined: 15 Oct 2005
Posts: 8
Location: US

PostPosted: Fri Aug 26, 2011 9:07 pm    Post subject: Re: Reply to: Neep help with ISRSUPC
Reply with quote

Thats the reason I don't want to run again without perfect solution icon_sad.gif
Back to top
View user's profile Send private message
Escapa

Senior Member


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

PostPosted: Fri Aug 26, 2011 9:10 pm    Post subject: Re: Reply to: Neep help with ISRSUPC
Reply with quote

Give your input file layouts....

and Tell us what is the sort product installed at your shop...
Back to top
View user's profile Send private message
swaroopnaga

New User


Joined: 15 Oct 2005
Posts: 8
Location: US

PostPosted: Fri Aug 26, 2011 9:24 pm    Post subject: Re: Reply to: Neep help with ISRSUPC
Reply with quote

the file length is 250.I used SUPERC program.
Back to top
View user's profile Send private message
Escapa

Senior Member


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

PostPosted: Fri Aug 26, 2011 9:27 pm    Post subject: Re: Reply to: Neep help with ISRSUPC
Reply with quote

swaroopnaga wrote:
the file length is 250.I used SUPERC program.

Read my post again and answer what I asked (completely)
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts ISRSUPC SRCHFOR tool - Query while us... soundarr JCL & VSAM 7 Wed Mar 16, 2016 8:55 pm
No new posts Passing parms when calling ISRSUPC(su... jasorn COBOL Programming 3 Mon Nov 16, 2015 12:06 pm
No new posts ISRSUPC -renaming OUTDD output dd sta... PokerGuru JCL & VSAM 11 Tue Jul 01, 2014 10:07 pm
No new posts How to use PARM when calling ISRSUPC ... chaoj CLIST & REXX 5 Mon Jun 09, 2014 3:02 pm
No new posts ISRSUPC - Utility Location Biswajit D JCL & VSAM 3 Fri May 24, 2013 6:59 pm


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