MVSFORUMS.com

abracadabra · Posted: Fri Jun 08, 2007 8:56 am Post subject: Sort

Hi,

I was recently asked by someone how an existing sort step can be further improved. The input file has 10 million recs and the output file has to have all the 10 millions recs.

Also need to know if someone can direct me to appropriate docs on estimation techniques and different testing strategies. Was not sure where to put thi question.
_________________
Cheers!

kolusu · Posted: Fri Jun 08, 2007 9:10 am Post subject:

abracadabra,

Just great. This is exactly what I need today. Evil or Very Mad

You are a member on this board for close to 4 years and yet you cannot follow the rules.

1. Use meaningful topics (don't use the Forum name for the topic). Use a descriptive Title to explain your problem. Post detailed information on what you're trying to accomplish. Do not make people guess what you mean. This will give you a much better chance of getting a good answer to your question.

2. How can suggest improvements without knowing what you are trying to do? You did not show the sort cards.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

abracadabra · Posted: Fri Jun 08, 2007 9:23 am Post subject:

Sorry about that Kolusu. Sometimes therea re restrictions at work with internet policies and people moving around and one tries to get things written as quickly as one can. However, it is my fault and I will ensure that such a thing is not repeated.

This was more like an interview question. 10 million reords in input. All records need to be copied over. Present program is SORT. It takes 8 hours for the step to run. How can you improve the sort step?
_________________
Cheers!

amargulies · Beginner Joined: 10 Jan 2007 Posts: 123 Topics: 0

abracadabra,

We still need to see your sort control cards. Also, which sort utility are you using? If you don't know, then please post the sysout.
_________________
Alissa Margulies
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com

Phantom · Posted: Fri Jun 08, 2007 9:28 am Post subject:

abracadabra,

Still...I do not see much difference between your first post and second one...

We are not concerned about time...rather we are more concerned about the environment your sort is running on.

1. What sort product do you have ?
2. What is the version ?
3. What version of OS you are running against.
4. What command is used in the sort card
5. Where is the input file stored (DASD / Tape) ?
6. What are the DCB parameters of the input and output file.
7. Are you using Sort work files ?
8. If so, are they defined Dynamic / Static ?
and so on....and so forth

Thanks,
Phantom

Bill Dennis · Posted: Fri Jun 08, 2007 1:02 pm Post subject: