How to keep entire database area in the buffer permanently

book

Article ID: 140063

calendar_today

Updated On:

Products

CA IDMS CA 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 releases.

Component : CA IDMS

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