How many records is ON?

, , , ,
1

On a mainframe you specify

MULTI-FETCH number

For Open Systems you specify

MULTI-FETCH ON

To determine the number of records returned by Open Systems, I ran the following

DEFINE DATA LOCAL
1 EMP    VIEW EMPLOYEES
  2 PERSONNEL-ID
  2 NAME
END-DEFINE
*
READ (80) MULTI-FETCH ON EMP BY PERSONNEL-ID
  DISPLAY *COUNTER
          PERSONNEL-ID
          NAME
END-READ
END

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?

2

Usually and mainly for historical reasons the multi-fetch factor for local Adabas access is 8 and for access via Net-Work is 32.