View previous topic :: View next topic
|
Author |
Message |
Venkateswari
New User
Joined: 16 Jan 2008 Posts: 2 Location: chennai
|
|
|
|
1. difference between the below two statements in a JCL:
UNLDSIZE='SPACE=(TRK,(25,25),RLSE)',
UNLDSIZE='SPACE=(CYL,(500,500),RLSE)'
2. if number of records that my table can contain is 7000000 and Number of Cylinders(approximately required is 7313.285, how can i get the Primary Allocation(CYLS) and Secondary Allocation (CYLS) figures so that i can put these figures in the above statement. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
why not allocate in records and let the system do the math ?? |
|
Back to top |
|
|
Venkateswari
New User
Joined: 16 Jan 2008 Posts: 2 Location: chennai
|
|
|
|
ya tat option is also there but we need in this format. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
obvious question .. Why?
obvious ( any derogatory adjective ) reply ... that' s the requriement
the only way is to
1 determine the number of records
2 determine / use the record lenght
3 find out the device characteristics
- track size / tracks per cylinders / cylinders per volume
4 adjust for best blksize ( no reason to use SDB uh? )
4acarry on the math
4b adjust for multivolume dataset if the input is very large
5 build dynamically the new parameters
5 build dynamically the job stream
6 submit the job
rewrite points 3 and 4 in case some different devices are added to Your system configuration
quite a complicate solution for a stupid requirement |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
I have posted various times on this forum the calculations for space requirements, if you search you will find. |
|
Back to top |
|
|
|