MSDB record storage

MSDB records contain no pointers except the forward chain pointer (FCP) connecting free segment records in the terminal-related dynamic database.

This topic contains Diagnosis, Modification, and Tuning information.

The following figure shows a high-level view of how MSDBs are arranged in priority sequence.

Figure 1. Sequence of the four MSDB organizations
MSDBs are stored in the following order: terminal-related fixed, non-terminal-related without terminal keys, terminal-related dynamic, non-terminal-related without terminal keys.