Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Syncsort optimization - VSAM copy to Tape

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Syncsort optimization - VSAM copy to Tape
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: 1703
Location: Australia

PostPosted: Sat May 17, 2008 3:39 am    Post subject:
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

Site Director


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

PostPosted: Sat May 17, 2008 3:42 am    Post subject:
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    Post subject: Reply to: VSAM file into Tape
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

Site Director


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

PostPosted: Sat May 17, 2008 6:41 am    Post subject:
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: 2150
Location: At my coffee table

PostPosted: Sat May 17, 2008 7:08 am    Post subject: Re: Syncsort optimization - VSAM copy to Tape
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Compare and COPY using DFSORT pshongal DFSORT/ICETOOL 3 Fri Nov 17, 2017 9:49 am
No new posts Copy selected columns from 2 input fi... Poha Eater DFSORT/ICETOOL 3 Thu Nov 02, 2017 3:43 pm
No new posts Copy 4 byte of data from the last rec... arunsoods DFSORT/ICETOOL 9 Fri Oct 06, 2017 12:15 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us