View previous topic :: View next topic
|
Author |
Message |
Baskaran Warnings : 1 New User
Joined: 24 Oct 2006 Posts: 32 Location: India
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
Baskaran Warnings : 1 New User
Joined: 24 Oct 2006 Posts: 32 Location: India
|
|
|
|
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 |
|
|
amalraj_ece
New User
Joined: 16 Jul 2006 Posts: 21 Location: delhi
|
|
|
|
Normally the BUFNO specifies how much amount of virtual storage is going to be allocated for that step |
|
Back to top |
|
|
|