Keep an entire database area in the buffer permanently

Products

• IDMS
• IDMS - Database

Issue/Introduction

Often times if a database area is relatively small and heavily accessed, it may be desirable to keep every page of the area permanently buffered in storage.

This document describes a common technique for doing so.

Environment

Release: All supported releases.

Resolution

Define a database buffer with the same number of pages and page size as the area. Define each file constituting the area to point to that buffer. Make sure that no other files in the CV use that buffer.

In this way, over the life time of the CV, every page in the area will eventually get loaded to the buffer and no other normal database access can force them out of the buffer.

Additional Information

BUFFER Statements
DMCL Statement