On a mainframe you specify
For Open Systems you specify
To determine the number of records returned by Open Systems, I ran the following
DEFINE DATA LOCAL
1 EMP VIEW EMPLOYEES
READ (80) MULTI-FETCH ON EMP BY PERSONNEL-ID
Via Database Workbench, I see that 10 L3s were executed, so the Multi-fetch factor is 8.
Then I ran similar programs on other machines, with the following results:
Windows XP 32-bit 8 records
Windows Server 2003 64-bit 32 records
SuSE Linux ES 10 64-bit 8 records
This was not an apples-to-apples comparison, because I do not have the EMPLOYEES file loaded on all three machines, but I used very small views (record buffers) in each test.
Can a developer affect the multi-fetch factor in any way (e.g. view size or NATPARMs), or is it an internal constant, dependent soley upon the operating system used?