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 ...

Get Beginning DB2: From Novice to Professional 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.