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 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 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
//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
No comments:
Post a Comment