# Why is Multi-fetch limited to a 4k buffer?

**URL:** <https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems\
**Created:** [May 12, 2017, 1:57am UTC](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554 "2017-05-12T01:57:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [May 12, 2017, 1:57am UTC](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554/1 "2017-05-12T01:57:54Z")

</div>

```auto
DEFINE DATA LOCAL
1 EMP VIEW EMPLOYEES
  2 ADDRESS-LINE (101)
         1 REDEFINE EMP
  2 #LEN (A2020)
END-DEFINE
LIMIT 10
R.
READ MULTI-FETCH ON
     EMP PHYSICAL
END-READ
WRITE *COUNTER (R.) (SG=F AD=L)
END
```

With MULTI-FETCH ON, I can expect to retrieve up to 8 records with each L2 call. My decompressed record length is 2,020, so I expect to retrieve 8 records, based on the assumption that a 32k buffer is available. But I am getting a multi-fetch factor of 2! If I increase the MU occurrences to 102 (DRL=2,040), I get single fetch.

Is Multi-fetch limited to a 4k buffer? On the mainframe it’s 32k. Is it possible to increase it?

Natural 8.3.8 (Innovation release)  
Adabas 6.5.0

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [May 13, 2017, 1:36am UTC](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554/2 "2017-05-13T01:36:25Z")

</div>

what is your MFSET set to?

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [May 13, 2017, 1:45am UTC](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554/3 "2017-05-13T01:45:54Z")

</div>

It’s set to OFF so that I can control it programmatically.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:38pm UTC](https://techcommunity.softwareag.com/t/why-is-multi-fetch-limited-to-a-4k-buffer/194554/4 "2021-04-02T15:38:26Z")

</div>


