SYNCSORT | SYNCSORT JOINKEYS | INREC OUTREC | OMIT INCLUDE | SORT Report.

SYNCSORT Mainframe
SYNCSORT

What is SYNCSORT?


SYNCSORT (MFX) is a  comprehensive and high-performance product. It's designed to use the advanced facilities of the z/OS operating system and IBM Z® mainframes. It's used for various daily data operations such as SORT/MERGE/JOIN/COPY.

SYNCSORT Performance.


SyncSort for z/OS is now renamed to MFX for z/OS. Yet, there is no change in operations, syntax.  As per studies, sort-relate data processing consumes almost 25% of the CPU time.  

MFX uses the cutting edge optimized technique to exploit z\OS  system architecture. It uses the combination of advanced sorting algorithms and data access methods to reduce the sort execution elapsed time. Refer below the figure for more details. 



SYNCSORT

SYNCSORT Performance

MFX's (SYNCSORT) Basic Functions. 


  • Sorting   - re-arranging file records in a specific sequence.
  • Merging  - combining data from different data set's into a single data set. 
  • Copying  - taking a backup of data set with or without any sorting process. 
  • Joinkeys  - are used to merge, select or reformat data from multiple data sets using joins keys. SYNCSORT support Inner join, left outer join, right outer join, and full outer join.
  • Reporting - SYNCSORT utility is of the best utility to generate instant customized reports.


SYNCSORT
SYNCSORT Operation Example.

SYNCSORT Procedure Sample JCL. 

In below mention JCL you need to supply SORTIN, SORTOUT, and SYSIN DD statements as per your requirement.

//RCT01XA JOB (99999),'RC012TX',CLASS=X
//STEP01  EXEC PGM=SYNCSORT
//SORTIN  DD ...input data-set...
//SORTOUT DD ...output data-set...
//SYSIN   DD *
... sort control statements as per requirment...

SYNCSORT Basic Sample JCL.

//RC01TX2  JOB (99999),'RC012TX',CLASS=X
//STEP022  EXEC PGM=SORT,PARM='options'
//SORTLIB  DD 
DISP=SHR,DSN=SYS1.SORTLIB
//SYSOUT   DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SORTWK01 DD UNIT=SYSDA,SPACE=(CYL,(50,30))
//SORTWK02 DD UNIT=SYSDA,SPACE=(CYL,(50,30))
//SORTWK03 DD UNIT=SYSDA,SPACE=(CYL,(50,30))
//SORTIN   DD DSN=RC01.EMPPAY.INPFL,DISP=OLD
//SORTOUT  DD ... specify output data-set ...
//SYSIN DD *
... SYNCSORT control statements as per requirments

SYNCSORT (MFX) Control Statements Syntax and Example.


No comments:

Post a Comment

New In-feed ads