Syncsort optimization - VSAM copy to Tape

Banabas Rout · New User Joined: 17 May 2008 Posts: 4 Location: Tampa

I am taking backups from a VSAM file into Tape GDG version;

Following is the Step provided;
//STEP010 EXEC PGM=SORT,PARM='VSCORE=512K'
//*
//SORTIN DD DSN=VREIDE.TEST.FILE,DISP=SHR
//SORTOF1 DD DSN=VREIDE.TAPE.FILE(+1),
// DISP=(NEW,CATLG,DELETE),
// UNIT=TAPE,
// VOL=(,,,25),
// LABEL=EXPDT=99000,
// DCB=(SYS1.DSCB,RECFM=FB,LRECL=100,BUFNO=20)
//IAMINFO DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FILES(1)
RECORD TYPE=F
/*

Can anyone provide inputs on how can we Finetune the Copy process with additional parameters? This job takes a fait amount of time and I am researching on parameters that can save some CPU Time.

gcicchet · Senior Member Joined: 28 Jul 2006 Posts: 663

Hi,
how long is a piece of string ?

You need to provide more information than that, like how many records, blocksizes, how many tapes does the job use, CPU time elapsed time.

Gerry

dick scherrer · Posted: Sat May 17, 2008 3:42 am Post subject:

Hello,

Please post the complete informational sysout output from the sort/copy step.

Banabas Rout · New User Joined: 17 May 2008 Posts: 4 Location: Tampa

Please find the details from SYSOUT attached;

Length of records = 8500 bytes

SYNCSORT FOR Z/OS 1.2.2.3R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCS
HSBC z/OS 1.8.0
PRODUCT LICENSED FOR CPU SERIAL NUMBER 3B5CC, MODEL 2094 717 LICE
SYSIN :
SORT FIELDS=COPY 00001
OUTFIL FILES(1) 00002
RECORD TYPE=F
WER276B SYSDIAG= 126184, 1429315, 1429315, 10320795
WER164B 8,900K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 64K BYTES RESERVE REQUESTED, 3,090,600 BYTES USED
WER146B 64K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=F ; LRECL= 8500; CISIZE = 10240
WER110I SORTOF1 : RECFM=FB ; LRECL= 8500; BLKSIZE= 25500
WER410B 5,824K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
WER410B 0 BYTES RESERVE REQUESTED, 11,776 BYTES USED
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER405I SORTOF1 : DATA RECORDS OUT 1668880; TOTAL RECORDS OUT 1668880
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER416B VSAM WAS USED FOR SORTIN
WER416B OUTFIL WAS USED FOR SORTOF1
WER054I RCD IN 1668880, OUT 1668880
WER169I RELEASE 1.2 BATCH 0458 TPF LEVEL 2.3

Other Details:
IAM FILE STATUS-----------= LOADED
CI SIZE-------------------= 10240
KEY OFFSET----------------= 0
TOTAL RECORDS DELETED-----= 581
TOTAL RECORDS INSERTED----= 1187

BLOCK SIZE----------------= 27998
VARIABLE LENGTH OVERFLOW--= YES
NUMBER OF VOLUMES---------= 3
SHARE OPTIONS-------------= 2
HIGH ALLOCATED RBN--------= 292259
DASD RESERVE (CA%)--------= 10
FILE DEFINED TIME---------= 18:52:31
FILE LOADED TIME----------= 19:31:23
FILE UPDATE TIME----------= 17:02:11

IAM FILE FORMAT-----------= ENHANCED
LOGICAL RECORD LENGTH-----= 8500
KEY SIZE------------------= 22
TOTAL RECORDS-------------= 1668880
TOTAL RECORDS UPDATED-----= 87051
IAM FILE CHARACTERISTICS -
BLOCKING FACTOR-----------= 2
TRACKS IN USE-------------= 139231
NUMBER OF EXTENTS---------= 17
DATASET TYPE--------------= KSDS
NUMBER OF IAM DATA BLOCKS-= 278048

dick scherrer · Posted: Sat May 17, 2008 6:41 am Post subject:

Hello,

Please notice that your system uses Syncsort rather than DFSORT (the DFSORT moderator has relocated your post).

Is this run one that you want to make faster or is this some smaller file?

Please post the elapsed time and record count from a few of the runs you want to improve (if you can post the first file in the jes sysout, that may help as well). Also, please mention how many tapes are typically created per backup.

CICS Guy