IBM 000-8697 Manual Do Utilizador
Installation and Initial Configuration
1-45
OnLine Disk Space Allocation
illustrates four guidelines for planning the physical layout of your
OnLine data. Each guideline is described in detail in the text that follows.
Figure 1-2
Guidelines for planning your disk layout
Consider mirroring
Locate a primary chunk and its mirror chunk on different disks.
primary
mirror
high-use table
Locate high-use tables on their own device at the center of the disk
or spread them across multiple devices.
or spread them across multiple devices.
Isolate high-use tables
Consider rapidly growing tables
table 1 extents
table 2 extents
table 3 extents
table 2 extents
table 3 extents
Avoid dbspace fragmentation caused by improperly sized extents.
Plan for the final location of the physical and logical logs
Separate the logs and locate them on disks not shared by active tables.
logical log
physical log
disk platter