IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syncsort optimization - VSAM copy to Tape


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Banabas Rout

New User


Joined: 17 May 2008
Posts: 4
Location: Tampa

PostPosted: Sat May 17, 2008 2:41 am
Reply with quote

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.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Sat May 17, 2008 3:39 am
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 17, 2008 3:42 am
Reply with quote

Hello,

Please post the complete informational sysout output from the sort/copy step.
Back to top
View user's profile Send private message
Banabas Rout

New User


Joined: 17 May 2008
Posts: 4
Location: Tampa

PostPosted: Sat May 17, 2008 6:22 am
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Sat May 17, 2008 6:41 am
Reply with quote

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.
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Sat May 17, 2008 7:08 am
Reply with quote

Banabas Rout wrote:
//STEP010 EXEC PGM=SORT,PARM='VSCORE=512K'
Where did 'VSCORE' come from?
I'd let sort allocate all the buffers it wants......
Maybe adding extra buffers to the input....
It is just a copy, no work will be done, other than channel I/O. Sort (either) should be fairly good at sucking up data and spitting it back out (given the memory).....
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Access to non cataloged VSAM file JCL & VSAM 18
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts VB to VB copy - Full length reached SYNCSORT 8
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Deleting a Tape file JCL & VSAM 14
Search our Forums:

Back to Top