Creating and configuring DB2 non-partitioned databases

We will discuss here how to create a single-partitioned database, which is sufficient for most database applications and is the most common configuration for small- to medium-sized databases.

If you plan on having a Business Intelligence (BI) database, you should be planning for a partitioned database. You can estimate one processor core for every 300 GB of data. We will cover this topic in Chapter 3, DB2 Multi-partitioned Databases—Administration and Configuration.

Getting ready

Gather as much technical information as you can about the hardware or virtual machine(s) you have at your disposal, for this database. Identify in which instance you will create your database, and ensure you will have enough memory and disk space for what you need.

Identify the location where you will create the table spaces (filesystems for Unix platforms, disk drives on Windows servers) and how much available space you will have. Make sure the instance owner has...