View previous topic :: View next topic |
Author |
Message |
Cogito-Ergo-Sum Advanced
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
|
Posted: Sat Dec 28, 2002 1:27 am Post subject: |
|
|
Kolusu,
Actually, I must apologise for asking a stupid question. A second later I posted my previous post, I realised the answer. Unforutnately, I could not edit my post then. (Otherwise, I would have missed my last bus to home!)
Thanks anyway, Kolusu! _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes. |
|
Back to top |
|
 |
rasprasads Beginner
Joined: 10 Dec 2002 Posts: 59 Topics: 20 Location: Chennai
|
Posted: Fri Jan 10, 2003 1:58 am Post subject: |
|
|
I had a job to allocate a Sequential dataset with following code:
Code: |
//SORTIN DD DSN=Input,
// DISP=SHR
//SORTOUT DD DSN=OUTPUTDSN,
// DISP=(NEW,CATLG,DELETE),
// SPACE=(CYL,(750,300),RLSE),
// DCB=(RECFM=FB,LRECL=605,BLKSIZE=0)
//SYSIN DD *
sort fields=copy
//*
|
I am just copying the input file to the output.There are as many as 4,500,000 records in the input.
The BLKSIZE of output DS was 32670.There were around 1000 cylinders allocated.
Why was the blocksize not a efficient value (as only one block can be given in a track here).Also how has it allocated the number of cylinders ?
Please help... _________________ Rasprasad S |
|
Back to top |
|
 |
Cogito-Ergo-Sum Advanced
Joined: 15 Dec 2002 Posts: 637 Topics: 43 Location: Bengaluru, INDIA
|
Posted: Fri Jan 10, 2003 2:21 am Post subject: |
|
|
Rasprasads,
I do not get this.
Quote: | // DCB=(RECFM=FB,LRECL=605,BLKSIZE=0) |
and you claim
Quote: | The BLKSIZE of output DS was 32670 |
I replicated your SORT step. The O/P dataset did get allocated with DCB=27830 which is optimum for device type 3390. _________________ ALL opinions are welcome.
Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes. |
|
Back to top |
|
 |
Premkumar Moderator

Joined: 28 Nov 2002 Posts: 77 Topics: 7 Location: Chennai, India
|
Posted: Fri Jan 10, 2003 3:26 am Post subject: |
|
|
<deleted>
Last edited by Premkumar on Fri Jan 10, 2003 3:44 am; edited 3 times in total |
|
Back to top |
|
 |
rasprasads Beginner
Joined: 10 Dec 2002 Posts: 59 Topics: 20 Location: Chennai
|
Posted: Fri Jan 10, 2003 3:28 am Post subject: |
|
|
Corgito,
I could not allocate the dataset in a single volume as there were large no. of records.I allocated a multi volume dataset.Would that be a reason for this?
(The dataset is in disk not in tape...)
If so could you throw some light on multi volume datasets allocation space? _________________ Rasprasad S |
|
Back to top |
|
 |
Premkumar Moderator

Joined: 28 Nov 2002 Posts: 77 Topics: 7 Location: Chennai, India
|
Posted: Fri Jan 10, 2003 3:45 am Post subject: |
|
|
rasprasads,
Are you sure that your output file is created in DASD and not in Tape?
An utility we have says 32670 is the efficient block size for a FB605 file in tape. |
|
Back to top |
|
 |
rasprasads Beginner
Joined: 10 Dec 2002 Posts: 59 Topics: 20 Location: Chennai
|
Posted: Fri Jan 10, 2003 3:52 am Post subject: |
|
|
Premkumar,
As i said earlier the datset is in disk and not in tape.But it has been allocated as a multi volume dataset... _________________ Rasprasad S |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12382 Topics: 75 Location: San Jose
|
Posted: Fri Jan 10, 2003 6:28 am Post subject: |
|
|
rasprasad,
I guess your shop does not have SDB parm turned on. So even though you have coded blksize 0 it will not calculate the optimum block size.
I am also guessing that your input file is on tape and it's blocksize is 32760.
To copy and get the system determined blocksize use the following sysin card.
Code: |
OPTION SDB=ON
SORT FIELDS=COPY
|
Hope this helps...
cheers
kolusu |
|
Back to top |
|
 |
rasprasads Beginner
Joined: 10 Dec 2002 Posts: 59 Topics: 20 Location: Chennai
|
Posted: Fri Jan 10, 2003 6:53 am Post subject: |
|
|
Kolusu,
Could you please look into this :
SYSIN :
OPTION SDB=ON
*
SORT FIELDS=COPY
OPTION STATEMENT : SYNTAX ERROR
I have coded the SYSIN as follows:
//SYSIN DD *
OPTION SDB=ON
SORT FIELDS=COPY
I am not aware of what SDB is!Can you please explain this... _________________ Rasprasad S |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12382 Topics: 75 Location: San Jose
|
Posted: Fri Jan 10, 2003 7:08 am Post subject: |
|
|
Rasprasad,
If you have DFSORT at your shop then specify
Code: |
//DFSPARM DD *
OPTION SDB=YES
//SYSIN DD *
SORT FIELDS=COPY
/*
|
If you have syncsort at your shop then specify
Code: |
//$ORTPARM DD *
SDB=ON
//SYSIN DD *
SORT FIELDS=COPY
/*
|
Check this link for SDB
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICECA109/3.12?DT=20020722140254
The above explains all the option parms. find SDB in the link.
Hope this helps...
cheers
kolusu |
|
Back to top |
|
 |
rasprasads Beginner
Joined: 10 Dec 2002 Posts: 59 Topics: 20 Location: Chennai
|
Posted: Fri Jan 10, 2003 8:34 am Post subject: |
|
|
Kolusu,
Thanks for your solution.It gave the result.
But when i executed the same job once again with a different i/p file and mentioning a DATACLAS parameter for the Output dataset, i got the following message and The Dataset was allocated a blocksize of 32670 and gave the message:
$ORTPARM : SDB=ON
SYSIN :
SORT FIELDS=COPY
ALTERNATE PARM USED
BSAM WAS USED FOR SORTIN
BSAM WAS USED FOR SORTOUT
I hope the reason may be due to BSAM. Is it correct?
Also for 4.5 million records the no of cylinders allocated were around 997.
How is this arrived at? _________________ Rasprasad S |
|
Back to top |
|
 |
hebbs Beginner
Joined: 14 Aug 2004 Posts: 1 Topics: 0
|
Posted: Sat Aug 14, 2004 12:29 pm Post subject: Optimum BLKSIZE |
|
|
Does this calculation apply to VB files as well? _________________ Hebbs |
|
Back to top |
|
 |
Mervyn Moderator

Joined: 02 Dec 2002 Posts: 415 Topics: 6 Location: Hove, England
|
Posted: Sat Aug 14, 2004 3:45 pm Post subject: |
|
|
No. Generally, use half-track blocking for disk files, and 32760 for tape files.
System Determined Blocksize, as defined above, is easier still. _________________ The day you stop learning the dinosaur becomes extinct |
|
Back to top |
|
 |
Nagaraj.krish Beginner
Joined: 12 Apr 2006 Posts: 1 Topics: 0
|
Posted: Wed Apr 12, 2006 9:32 am Post subject: Relating Track and Block size |
|
|
Suppose the Block size = 27500
Rec length = 500
Then No of records in a block - 55.
What will be the no of records in a Track.
In previous discussion, i infer it will be 110 records in a track.
But later it is said that there can be more than 2 records /block/ track.
How to arrive the correct number atleast appx.... |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12382 Topics: 75 Location: San Jose
|
Posted: Wed Apr 12, 2006 9:40 am Post subject: |
|
|
Nagaraj.krish,
You will have 110 records in a track. The contradiction about the no: of records is for a different blocksize.
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
 |
|
|