IBM Mainframe Forum

Dear all,

My application has below SORT utility in JCL and basically SORT is used here to copy large data from large VSAM file to a flat file as a backup purpose

//S010 EXEC PGM=SORT
//SORTIN DD DSN=Large vsam file,DISP=SHR,
// AMP=(AMORG,'BUFND=20')
//SORTOUT DD DSN=flat file,
// DISP=(NEW,CATLG,DELETE),
// UNIT=CART,LABEL=EXPDT=99000,VOL=(,,,99),
// DCB=PRD.T.LRECL150
//*
//SYSIN DD DSN
SORT FIELDS=COPY

Above process is nearly taking more time to run and please suggest me if any improvements can be done or else any utility that can replace above.

Thankyou very much,
Prasadg

IDCAMS REPRO - it was invented for working with VSAM files
ADRDSSU - it was invented for taking backups

Why do people have trouble providing necessary details? For example, we back up 2 VSAM files totaling 37,000 cylinders (11 mod 3 disk packs or about 30 gigabytes) in 43 minutes using ADRDSSU -- going to tape. That gives you size and time values for comparison purposes -- details that are needed by responders!

How big is a "large" VSAM file to you? How much time is the SORT step taking?

Hello Robert,

I will check jobs and will let you know information.

Thanks for your response.

Also, are the output tapes real or virtual? What media type? 3490, 3590, 3592?

Dear Robert,

The VSAM file has around 3240860 records and its consuming time of nearly one minute.

Please let me know if any advice.

Thankyou.

Hello,

Why do you believe 1 minute is too much?

Dear Dick,

The job runs nearly for 2 minutes in some cases, based on size of file and I want to know if there is any suggestion that can improve my performance if my input VSAM file crosses 100 millions.

Hope you understand my issue.

Thankyou very much,

2 MINUTES! For 3 MILLION records? I would start thinking about other methods if it approaches 30-45 minutes. You will be retired by then!

Please tell me you are kidding us about being worried about performance. If you are backing up 100 million records, one hour elapsed time is not by any means unusual or out of line. If you want to reduce this time, you will have to work with your site support group to schedule the job to run when the system workload is at a minimum; nothing else will help you.