BPSFI - Object Search First in Buffer Pool

Search Sequence 1 is used (search buffer pool first for all libraries, then the system file(s)).

Natural looks for the object in the following sequence until it is found:

1. in the buffer pool, first in the current library, then in one steplib after another, then in the two SYSTEM libraries;

2. in the system file(s), first in the current library, then in one steplib after another, then in the two SYSTEM libraries.

For performance reasons, it is recommended that you set BPSFI=ON in production environments.

Caution:
If you set BPFSI=ON, make sure that object names are unique across all libraries that are involved in the search. If objects with the same name exist in different libraries being searched, unpredictable results may occur.

Search Sequence 2 is used (alternating search in buffer pool and system file(s) for each library).

Natural looks for the object in the following sequence until it is found:

1. in the current library, first in the buffer pool, then in the system file(s);

2. in one steplib after another, first in the buffer pool, then in the system file(s) for each steplib;

3. in the two SYSTEM libraries, first in the buffer pool, then in the system file(s) for each library.