Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 6967
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 Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts To find out size allocated to a seque... ashek15 JCL & VSAM 15 Thu Apr 27, 2017 9:42 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us