View previous topic :: View next topic
|
Author |
Message |
hernikiten
New User
Joined: 08 Apr 2005 Posts: 23 Location: india
|
|
|
|
Hi,
I have a file of record length 40 and 3,00,000 records.
I am trying to deduplicate it by --> SELECT FROM(IN) TO(TMP1A) ON(1,9,CH) FIRST statement.
TMP1A has a SPACE=(TRK,(100,20)RLSE)
Its giving an SB37.
Please advice all alternatives to fix it.
Thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Allocate more space - you have not allocated enough to handle your volume. If you change trk to cyl, you should have enough space. |
|
Back to top |
|
|
cpuhawg
Active User
Joined: 14 Jun 2006 Posts: 331 Location: Jacksonville, FL
|
|
|
|
Not sure if you meant 3,000,000 or 300,000.
40 byte records. Fixed blocked - half track blocking.
You can store about 698 per track.
3000000/698 = 4298 tracks = 287 cylinders
300000/698 = 430 tracks = 29 cylinders |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Yup,
That's why i suggested going to cyl |
|
Back to top |
|
|
hernikiten
New User
Joined: 08 Apr 2005 Posts: 23 Location: india
|
|
|
|
Thanks for the reply - I have amended the JCL and its scheduled for tonight's run. Will get back to you if problem still persists. |
|
Back to top |
|
|
|