Database segmentation in IDMS

Products

• IDMS
• IDMS - Database

Issue/Introduction

Today's IDMS databases continue to grow. Among the reasons for this growth may be the addition of new application functionality, business consolidations, or the inability to archive historical data from legacy databases. Regardless of the reason for their growth, this expansion creates concerns in two areas; space and time. The concern with space is typically not related to the number of physical devices needed to contain the data but with the number of IDMS pages that are available in which a given database can reside. Larger databases also mean that the time required by applications to perform routine processing also increases. This can be especially meaningful when considering batch processes or routine maintenance operations.

Environment

Release: All supported releases.

Resolution

This article presents an overview of two types of database segmentation generally referred to as vertical and horizontal segmentation. Although each segmentation implementation is unique by database, the general concepts of these two methods of segmentation provide the basis from which all segmentation strategies are derived.

Download the document attached below.