How to compare two ps files having millions of records ?

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
nareshv_99
Member
Posts: 25
Joined: Sun Feb 05, 2012 10:59 pm
Location: Bangalore

How to compare two ps files having millions of records ?

Post by nareshv_99 » Sun Feb 05, 2012 11:08 pm

hi,
i have two sequential files having millions of records. how can i compare both the files ?
i tried with x3.13 but it gave space abend. :?

could anyone help me in this ? :? :?

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Mon Feb 06, 2012 10:34 am

Use the batch option of 3.13. When the job abends extract the JCL from the spool, amend the space for the listings dataset - or convert it to use a dataset - and resubmit it.
Regards
Nic

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Mon Feb 06, 2012 10:57 am

when using the batch option,
i believe you have the option to EDIT the JCL before submitting the job.

you can then copy the jcl to your own 'JCL' pds,
so that you will have a working JOB which you can then edit
and modify for any SUPERC, thus negating the need to go thru the 3.xx panels.

something to keep in mind:
if the record length is larger than 133, you will not have the complete record as output.

so, unless you are using the output (of a million record compare)
as input to something else (and the record length is less than 134)
why don't you use the summary output format (giving you totals)
since i don't know what you are going to do with 100's of thousands,
if not millions of output records.....
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

mohan.lal@capgemini.com
Member
Posts: 1
Joined: Mon Feb 06, 2012 11:54 am

Post by mohan.lal@capgemini.com » Mon Feb 06, 2012 12:17 pm

:lol:

nareshv_99
Member
Posts: 25
Joined: Sun Feb 05, 2012 10:59 pm
Location: Bangalore

Post by nareshv_99 » Mon Feb 06, 2012 8:16 pm

i have got the solution..
i used below ICETOOL toolin

i gave two files on INDD like
//INDD DD DSN=file1,DISP=SHR
// DD DSN=file2,DISP=SHR
//OUTDD DD DSN=file,DIPS=(,CATLG,) ..
..
//TOOLIN DD*
COPY FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*

it gave MAX CC=12 as both files are same.. OUTDD dsn is empty..

thnks for you suggestion too.. :)

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Tue Feb 07, 2012 12:07 am

That syntax is NOT valid for the ICETOOL COPY operator. The cc=12 would be the result of the syntax error. It would have nothing to do with whether the files were the same.

For complete details on correct DFSORT/ICETOOL syntax, see:

http://www.ibm.com/support/docview.wss? ... g3T7000080
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

nareshv_99
Member
Posts: 25
Joined: Sun Feb 05, 2012 10:59 pm
Location: Bangalore

Post by nareshv_99 » Tue Feb 07, 2012 8:46 am

I'm not sure of Syntax.. as i posted it from my home.. i forgot the actual syntax.. i'll check it in office and post it again..

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Wed Feb 08, 2012 12:05 am

Ok. The syntax for a job to get RC=12 for an empty data set would be quite different (SELECT? COUNT?) so hopefully you got it right.

In the future, please don't post syntax guesses as it just confuses people.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

nareshv_99
Member
Posts: 25
Joined: Sun Feb 05, 2012 10:59 pm
Location: Bangalore

Post by nareshv_99 » Wed Feb 08, 2012 10:17 pm

nareshv_99 wrote: //TOOLIN DD*
COPY FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*

it gave MAX CC=12 as both files are same.. OUTDD dsn is empty..

thnks for you suggestion too.. :)
it was not COPY.. it is SELECT..
//TOOLIN DD*
SELECT FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*
Frank, sorry for posting wrong syntax..i can't post anything from my office thats why i posted what i remembered..

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Wed Feb 08, 2012 11:10 pm

That syntax is still invalid - it should be:

SELECT FROM(INDD) TO(OUTDD) ON(1,7,PD) ON(8,2,BI) ON(10,1,CH) NODUPS
Frank, sorry for posting wrong syntax..i can't post anything from my office thats why i posted what i remembered.
All of the DFSORT books are available at:

http://www.ibm.com/support/docview.wss? ... g3T7000080

So you could look up the correct syntax even from home.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others