HI
I need to create a file which takes 3 volser 's to fit the data in.But i need only 2000 records in each vol ser.
I now that if the i/p records are more then the o/p file will take more than one volser to hold the data.Each volser will hold more than 10k records .
But now i want each vol ser to take only 2k records ...
So Do we have any option to set volser to take these many no. of records from i/p n then take another volser for the next set of 2k records?
Can we set the no. of records a VOLSER can hold
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: Can we set the no. of records a VOLSER can hold
Hello and welcome to the forum,
If you are willing to create 3 different datasets on 3 separate volumes, you can do this easily using your sort product.
Define the control statements to copy 2000 records to the first 2 output files and the remainder to the 3rd output file.
If you are willing to create 3 different datasets on 3 separate volumes, you can do this easily using your sort product.
Define the control statements to copy 2000 records to the first 2 output files and the remainder to the 3rd output file.
Hope this helps,
d.sch.
d.sch.
Re: Can we set the no. of records a VOLSER can hold
I think i cannot use SORT b/c my JCL uses some other program to create the o/p file from the given 3 i/p files.
And I want the i/p name to be the same.
And I want the i/p name to be the same.
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: Can we set the no. of records a VOLSER can hold
Hello,
You have to use the file name that is already associated with the input file(s).And I want the i/p name to be the same.
Sure you can. . . Run the existing process as-is. Then split the output file into 3 using the sort. . .I think i cannot use SORT b/c my JCL uses some other program to create the o/p file from the given 3 i/p files.
Hope this helps,
d.sch.
d.sch.
-
- Posts: 278
- Joined: Thu May 15, 2008 9:45 pm
- Skillset: MVS
MQ
ISPF - Referer: sister site
Re: Can we set the no. of records a VOLSER can hold
If writing to disk, size the primary allocation for 2000 records with 0 secondary and UNIT=(xxxxx,3) in the JCL.
If writing to tape, you can use Assembler to invoke DCB exits and force EOV after 2000 records.
The whole thing sounds ridiculous, though.
If writing to tape, you can use Assembler to invoke DCB exits and force EOV after 2000 records.
The whole thing sounds ridiculous, though.
Regards,
Bill Dennis
Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
Bill Dennis
Disclaimer: My comments on this forum are my own and do not represent the opinions or suggestions of any other person or business entity.
Re: Can we set the no. of records a VOLSER can hold
Hi dick
I have tried with SORT ..n created 3 VOLSER with same o/p file name.
But here we want the VOLSER shud have dependency ..like the second VOLSER shud have the dependency with 1st n so on.
If we split using SORT there wil not b any dependency rt? each volser will b seperate.
The O/p tape shud have 3 VOLSER n those 3 shud have dependency like wen we mount on system it shu show like
1st volser seq.no(=1)--------1 st VOLSER
1st volser seq.no(=2)--------2 nd VOLSER
1st volser seq.no(=3)--------3rd VOLSER
This is how it shud show.
This can be achieved only wen we create a file with 3 VOLSER...I have created like dat but wat we want is each VOLSER shud contain only abt 2k records to ease testing.
Hi Bill
The solution you have given may work.bt I dnt have aces to all those things.
Thank u
I have tried with SORT ..n created 3 VOLSER with same o/p file name.
But here we want the VOLSER shud have dependency ..like the second VOLSER shud have the dependency with 1st n so on.
If we split using SORT there wil not b any dependency rt? each volser will b seperate.
The O/p tape shud have 3 VOLSER n those 3 shud have dependency like wen we mount on system it shu show like
1st volser seq.no(=1)--------1 st VOLSER
1st volser seq.no(=2)--------2 nd VOLSER
1st volser seq.no(=3)--------3rd VOLSER
This is how it shud show.
This can be achieved only wen we create a file with 3 VOLSER...I have created like dat but wat we want is each VOLSER shud contain only abt 2k records to ease testing.
Hi Bill
The solution you have given may work.bt I dnt have aces to all those things.
Thank u
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: Can we set the no. of records a VOLSER can hold
Hello,
Without doing something that is highly customized (like using the assembler that Bill mentioned), you won't create vol1, vol2, vol3 of the same dataset with 2000 records . . .
What you can do is create 3 dataset names on 3 separate volumes and put 2000 records on the first 2 and the remainder on the 3rd volume.
If you explain why this is even being considered, someone may have an alternative suggestion.
Without doing something that is highly customized (like using the assembler that Bill mentioned), you won't create vol1, vol2, vol3 of the same dataset with 2000 records . . .
What you can do is create 3 dataset names on 3 separate volumes and put 2000 records on the first 2 and the remainder on the 3rd volume.
If you explain why this is even being considered, someone may have an alternative suggestion.
Hope this helps,
d.sch.
d.sch.
Re: Can we set the no. of records a VOLSER can hold
B/c we have been asked for testing accordingly.
But now i have created tapes with 3VOLSER bt not with 2k records in it n explained ,They have approved
But pls tel me how many records a VOLSER can hold n also the no.of records a file can hold on SYSDA.
But now i have created tapes with 3VOLSER bt not with 2k records in it n explained ,They have approved
But pls tel me how many records a VOLSER can hold n also the no.of records a file can hold on SYSDA.
-
- Global moderator
- Posts: 3720
- Joined: Sat Dec 19, 2009 8:32 pm
- Skillset: Systems programming, SAS, COBOL, CICS, JCL, SMS, VSAM, etc.
- Referer: other forum
- Location: Dubuque, Iowa, USA
Re: Can we set the no. of records a VOLSER can hold
But pls tel me how many records a VOLSER can hold n also the no.of records a file can hold on SYSDA.
Things that are needed to be known to answer this question:
1. What kind of VOLSER -- tape or disk?
2. If tape, what kind of tape -- 3490? 3590E? 3590J? Something else? is it compressed or not?
3. If disk, is is 3390 mod 3? mod 9? "mod 27"? "mod 54"? If not 3390, what is the device geometry?
4. Are the records fixed or variable length? How many bytes per record? How many records per block?
5. What are you calling "SYSDA"? Is this a physical device or VIO? If a physical device, see question number 3?
For example, unblocked fixed length 80-byte records on a 3390 allows 78 records per track which is 1170 records per cylinder and 3,901,950 on a mod 3 device (3335 cylinders). Blocked at 27920 bytes per block, you get 698 records per track, 10470 per cylinder and 34,917,450 records on a mod 3.
- dick scherrer
- Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
Re: Can we set the no. of records a VOLSER can hold
Hello,
Suggest you work to convince whoever wants this kind of info that this is not time well spent. . .
A better "thing" to calculate is for a given amount of data, how much media will it require (blocked optimally).
Suggest you work to convince whoever wants this kind of info that this is not time well spent. . .
A better "thing" to calculate is for a given amount of data, how much media will it require (blocked optimally).
Hope this helps,
d.sch.
d.sch.
-
- Similar Topics
- Replies
- Views
- Last post
-
- 6
- 2387
-
by sergeyken
View the latest post
Thu Dec 09, 2021 8:10 pm
-
-
Commit issued without hold and without close cursor statemen
by ravi11081992 » Sat Jan 22, 2022 2:42 pm » in DB2 - 2
- 2253
-
by engh
View the latest post
Tue Sep 20, 2022 6:07 pm
-
-
-
Insert records from File1 between records of File2
by Daouchiche » Wed Nov 10, 2021 6:37 am » in DFSORT/ICETOOL/ICEGENER - 6
- 2344
-
by sergeyken
View the latest post
Thu Nov 11, 2021 12:43 am
-
-
- 3
- 3721
-
by naveenkumar sudha
View the latest post
Mon May 09, 2022 10:15 pm
-
-
SORT the records based on the second word
by seethahexa » Wed Aug 19, 2020 1:30 pm » in DFSORT/ICETOOL/ICEGENER - 1
- 1416
-
by sergeyken
View the latest post
Wed Aug 19, 2020 6:08 pm
-