Chapter 11. Data Storage Management

• PROCESSOR, MEMORY, DISK CONSIDERATIONS

• DB2 STORAGE MODEL

• TABLE SPACE DESIGN

• IMPLEMENTATION EXAMPLES

• MAINTENANCE

Being able to efficiently store and quickly retrieve large amounts of data is one of the main functions of any relational database management system. The physical placement of the data can directly affect the query performance. It is the responsibility of the database administrator to understand the concepts of data placement and to create an appropriate physical database design.

Processor, Memory, and Disk Resources

Before looking at specific DB2 objects, you should consider the hardware that will be used to implement your DB2 system. Besides the minimum amount of processor, disk, and memory ...

Get DB2® 9 for Linux®, UNIX®, and Windows®: DBA Guide, Reference, and Exam Prep, Sixth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.