Chapter 18. Database Creation and Configuration

You've used several wizards to create databases in a matter of minutes. Now you'll dive to the lowest level to see exactly how to accomplish database creation (and related configuration and management tasks) using SQL. By using data definition language (DDL) commands, I'll show you that databases can be created in a flash by leveraging intuitive DB2 defaults. I'll also show you how to leverage all the flexibility DB2 has to offer when creating and managing databases.

To appreciate and understand the options as I present them, a quick tour of the fundamental building blocks of DB2 databases is in order. Let's take a quick look at the anatomy of a DB2 database, from the lowest level on disk to the highest conceptual point where users create objects and manipulate data.