MVSFORUMS.com

Vinodch · Posted: Mon Jun 18, 2007 11:01 am Post subject: Lessen of CPU TIME Using IDCAMS.

Jobs copying one KSDF to another KSDF using IDCAMS consumes large CPU time for copying and building the AIX; is there any means the file definition / usage of any parameter lessen the consumption of the CPU time; please let know.
_________________
Thanks,
Vinod.

expat · Posted: Wed Jun 20, 2007 3:38 am Post subject:

Do not build the AIX during the copy.

Copy the KSDS, then build the AIX - It is much faster
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

Vinodch · Posted: Wed Jun 20, 2007 10:28 am Post subject:

Hi

The copying of KSDF is done separatetly and the building of AIX is done separatetly.
_________________
Thanks,
Vinod.

warp5 · Posted: Thu Jun 21, 2007 12:31 am Post subject:

Why not use ADRDSSU?

expat · Posted: Thu Jun 21, 2007 2:03 am Post subject:

So which is taking the most time, the KSDS load or the build AIX ?
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

Vinodch · Posted: Tue Jun 26, 2007 10:55 am Post subject:

Both are taking long time; Copying around 10 millions records takes 2 hours to copy & build the AIX.
_________________
Thanks,
Vinod.

dbzTHEdinosauer · Posted: Tue Jun 26, 2007 11:09 am Post subject:

Vinodch,

it took you a week to respond to expat's question. least you could have done is give him an answer. in addition to wall clock, what was the actual cpu time - for each?

also, what are the record sizes? how big is your ksds primary key. How big is the AIX?
_________________
Dick Brenholtz
American living in Varel, Germany

expat · Posted: Tue Jun 26, 2007 11:52 am Post subject:

And how do you do it ............

Do you define the AIX and PATH at the same time as the base cluster
_________________
If it's true that we are here to help others,
then what exactly are the others here for ?

Vinodch · Posted: Mon Jul 02, 2007 9:27 am Post subject:

Sorry for the late reply.

The base cluster will be defined first - copy all the records - once the copy is done - create the AIX and build the same.

The file has around 10 millions of records. The CPU time for copy base cluster is around 16.77 and 31.21 is for building the AIX.

-
_________________
Thanks,
Vinod.