| View previous topic :: View next topic |
| Author |
Message |
vino_dh
Beginner
Joined: 03 Aug 2006
Posts: 4
Topics: 1
|
 Posted: Thu Aug 03, 2006 1:37 pm Post subject: How to calculate avg recordsize manualy |
 |
|
Hi,
can anyone tell me how to calculate the avg recordsize in vsam cluster manually.
keys(5,2)
max recordsize is 55
what will be the avg recordsize - in case fo variable recordsize.
Thanx |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Thu Aug 03, 2006 2:20 pm Post subject: |
|
|
vino_dh,
Avg Recordsize? It depends on your data. Since your key is 5 bytes long , you have minimum length of 6( 2 offset) and max length of 55. So if you need the average then you need to calculate the total length of all records and divide it by the number of records.
Hope this helps...
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
vino_dh
Beginner
Joined: 03 Aug 2006
Posts: 4
Topics: 1
|
| Posted: Fri Aug 04, 2006 1:11 am Post subject: |
|
|
Hi,
are you sure about your answer. after creating cluster we will pass the data. before creating cluster we wont know how many records we are going to enter.
can u clear my doubt.
Thanx |
|
| Back to top |
|
|
shekar123
Advanced
Joined: 22 Jul 2005
Posts: 528
Topics: 90
Location: Bangalore India
|
| Posted: Fri Aug 04, 2006 5:26 am Post subject: |
|
|
vino_dh,
Look at Kolusu's Profile and he is the moderator of this site.If you look at to his replies i hope you will not ask 
| Quote: |
are you sure about your answer.
|
_________________
Shekar
Grow Technically |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Fri Aug 04, 2006 5:33 am Post subject: |
|
|
| Quote: |
are you sure about your answer. after creating cluster we will pass the data. before creating cluster we wont know how many records we are going to enter.
|
vinu_dh,
If you read my answer carefully once again you will see what I meant. The AVG record size depends on your data.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
vino_dh
Beginner
Joined: 03 Aug 2006
Posts: 4
Topics: 1
|
| Posted: Fri Aug 04, 2006 12:21 pm Post subject: |
|
|
Hi,
I know kolusu is a genius. But what I felt is since he is concentrating on complicated coding he never get a chance to concentrate on this kind of minor doubt. Thanx for your immediate reply.
Thanx |
|
| Back to top |
|
|
Bill Dennis
Advanced
Joined: 03 Dec 2002
Posts: 579
Topics: 1
Location: Iowa, USA
|
| Posted: Fri Aug 04, 2006 1:44 pm Post subject: |
|
|
vino,
Are you referring to the AVGREC parameter used in allocating files?
_________________
Regards,
Bill Dennis
Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity. |
|
| Back to top |
|
|
vino_dh
Beginner
Joined: 03 Aug 2006
Posts: 4
Topics: 1
|
| Posted: Sat Aug 05, 2006 6:51 am Post subject: |
|
|
Hi Dennis,
Yes. |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12375
Topics: 75
Location: San Jose
|
| Posted: Sat Aug 05, 2006 4:05 pm Post subject: |
|
|
| Bill Dennis wrote: | vino,
Are you referring to the AVGREC parameter used in allocating files?
|
| vino_dh wrote: | Hi Dennis,
Yes. |
hmm your first Post refers to VSAM cluster definition and I assumed that your question was related to the RECORDSIZE(average maximum) parameter
Now you say it is the JCL AVGREC parameter?
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
Bill Dennis
Advanced
Joined: 03 Dec 2002
Posts: 579
Topics: 1
Location: Iowa, USA
|
| Posted: Mon Aug 07, 2006 8:44 am Post subject: |
|
|
AVGREC is used to estimate SPACE requirements and is not directly related to logical records in the file. Perhaps you can tell us what you will do with the average record size once you know what it is?
_________________
Regards,
Bill Dennis
Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
