Chapter 10. Creating Table Spaces

The type of data in your database, the size of your database, and your performance needs are some of the considerations that you must take into account when deciding on how your data should be stored. DB2 provides table spaces and buffer pools to give you flexibility in defining how your data is stored.

Today you learn how to create and tune these storage objects for your environment. You will use the Create Table Space Wizard to create table spaces in your database that can be used to store your data. You will also learn how you can separate different types of data to improve performance.

Today you learn the following:

  • How to create table spaces

  • How to manage your data across multiple table spaces

  • How to use the Create ...

Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second 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.