Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
Good start, but that is not all of the requested info. . .
At least 2 sets of sysout are missing - the jes msg log and the informational output from the sort execution.
If the input requires 17 physical volumes, you might ask if higher-volume media is available for these very large files. Are these tapes mounted by a silo or are they manually loaded? I syspect much of the elapsed time is due to waiting on tape mounts.
One thing you "could" do to reduce elapsed time, if permitted by your shop, is to "ping-pong" tape drives for the input file. By doing so, you would essentially eliminate any time lost in mounting/demounting physical tapes ( except for the first volume ). To "ping-pong" tape drives, just code UNIT=(TAPE,2) on the input file DD statement ( assuming that 'TAPE' is the unit designation for tape in your shop - if not, just substitute whatever is your shop's standard ).
At least 2 sets of sysout are missing - the jes msg log and the informational output from the sort execution..
Are you asking for the complete JESMSG log. Kindly let me know if you need any specific details from JESMSG log, I can find it and provide you.
Quote:
Are these tapes mounted by a silo or are they manually loaded?
the step where the file is created, we have UNIT=SILO. Could you please explain what is meant by SILO? I thought it is a tape name.
To my astonishment, my second job with SORT FIELDS=(1,9,CH,A) and SUM FIELDS statement has completed within 1hrs 20 mins. where as the SORT FIELDS=COPY has taken almost 2 hours. I am still not able to understand why a copy is taking more time than the sorting?
I have used DYNALLOC=32 and IO parameter in this JCL. After summing up, the number of records in the output file is 29.
Let me know if you need any other details. The same input file is used for different extraction purposes. In this particular case, it is extracting only 985 records and it is summed up to give a total of 29 records.
In other jobs, more than 10,000 records are extracted and no SUM statement is needed and the file is needed to be sorted order.
Also, if someone can tell me know how to understand the above SYSLOG, it will be more helpful.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
UNIT=SILO is specific to your system - it could just as well be UNIT=BARN. These names are determined by the system configuration.
On the other hand, a silo is a hardware device that contains many cart volumes. These are inventoried within the hardware and are automatically mounted on a tape drive when needed. The computer operators do not manually mount these volumes.
Even 10,000 is a very small number of records and would process in just a few seconds - unless it took longer to pass 17 volumes looking for the 10,000 records.
You need to work with your local support people to gain a better understanding of where the time goes in this job. From what you've posted, almost all of the time is spent reading the 17 volumes or waitiing for them to be mounted for processing.
And tape datasets should not be specified with disp=shr. . . A tape volume cannot be shared. . .
Thanks Dick Scherrer. I will check with my local support team.
Sorry, i have a very basic question on dataset sharing.
dick scherrer wrote:
Hello,
And tape datasets should not be specified with disp=shr. . . A tape volume cannot be shared. . .
I have a question here. Although, i have mentioned as DISP=SHR for one of my test job (DASD file), dataset cannot be used simultaneously by two jobs. It shows contention. So, ideally what is the difference b/w DISP=OLD & DISP=SHR for the input file.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
Hello,
At the top of the page is a link to "IBM Manals". The second "set" includes JCL information. In the Language Reference for your environment, read about the DISP parameter.
The flashlight/tubelight near the top left is the manual Search facility.
If you find something in the manual that is not clear, post what you found and your doubt about it. Someone will be able to clarify.
Onn systems where i have some amount of control, shr is only used for datasets that would properly have multipleconcurrent users/processes (like a vsam file or a pds).