Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
BUFNO and number of records in sequential files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
Baskaran
Warnings : 1

New User


Joined: 24 Oct 2006
Posts: 32
Location: India

PostPosted: Tue Oct 24, 2006 3:34 pm    Post subject: BUFNO and number of records in sequential files
Reply with quote

IS there any relation for parameter BUFNO in jcl and number of record read from a sequential file in a job?

for performance point of view is there any standards to be followed for coding BUFNO in realtion with sequention file content(number of records)
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Tue Oct 24, 2006 6:53 pm    Post subject:
Reply with quote

Quote:
IS there any relation for parameter BUFNO in jcl and number of record read from a sequential file in a job?


No. The number of records read by a STEP (since BUFNO is a DD parameter; DD parms are part of a STEP, not a JOB) depends upon what the STEP does. The BUFNO parm indicates - number of blocks read during a physical I/O.

Quote:
for performance point of view is there any standards to be followed for coding BUFNO in realtion with sequention file content(number of records)


Standards are set by sites. Have no idea what your site standards are. Since buffers are usually allocated below the 16M line, and sites have standards concerning how much lower memory can be allocated to a JOB, you need to learn about your site standards.

Now, if your question is: 'are there things that need to be taken into consideration when determining the BUFNO value with respect to performance' - yes. A buffer contains a block. If you allocate enough buffers to load the complete file in memory, the physical I/O performed with the first read will load everything; subsequent reads will effectively be repositioning of record pointers in memory.

You also need to take into consideration, what else occurs during this STEP.

your question is so general that it will only elicit general answers.
Back to top
View user's profile Send private message
Baskaran
Warnings : 1

New User


Joined: 24 Oct 2006
Posts: 32
Location: India

PostPosted: Wed Oct 25, 2006 11:21 am    Post subject: BUFNO and number of records in sequential files
Reply with quote

Thanks Dick Brenholtz

We a job which does unlod records from Db2 table into a GDG and then performs a SORT and then load it in to a different table.during unloding, records are filtered by a SQL statment.


My question how we should do performance tuning for this senario.
Back to top
View user's profile Send private message
amalraj_ece

New User


Joined: 16 Jul 2006
Posts: 21
Location: delhi

PostPosted: Mon Oct 30, 2006 7:16 pm    Post subject: Re: BUFNO and number of records in sequential files
Reply with quote

Normally the BUFNO specifies how much amount of virtual storage is going to be allocated for that step
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 4 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Compare VSAM files using DFSORT pshongal DFSORT/ICETOOL 5 Thu Nov 23, 2017 10:24 am
No new posts Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us