Understanding DB2®: Learning Visually with Examples

8.6. Case Study

Let's start by creating a database named mydb on your Windows server's C: drive as follows:

					CREATE DATABASE mydb ON c:
				

Your server was configured with four physical hard drives that are dedicated to your database, so you want to create a new table space that will use these drives. Since DMS table spaces are more flexible, you have decided to use DMS file containers for the table space. Once you have formatted the four drives using the operating system tools and given them the labels G, H, I, and J drives, you are ready to create the table space.

First you need to connect to the database:

					CONNECT TO mydb
				

You can then create the table space:

					CREATE TABLESPACE myts MANAGED BY DATABASE USING
					(FILE 'g:\ts1' 50000,
					FILE 'h:\ts1' ...