8.2. Databases: Logical and Physical Storage of Your Data

This section discusses how DB2 logically and physically creates databases.

8.2.1. Creating a Database

As mentioned in Chapter 2, DB2 at a Glance: The Big Picture, you used the CREATE DATABASE command to create a database. The basic syntax of the command is

						CREATE DATABASE
						database name
						ON
						drive/path

The database name:

  • Can be a maximum of eight characters long

  • Cannot contain all numbers

  • Cannot start with a number

  • Cannot contain spaces

  • Cannot already have been used within the same DB2 instance

DB2 creates the database on the drive or path specified by the DFTDBPATH Database Manager Configuration parameter. On Windows this will be a drive, and on Linux and UNIX this will be the path to a file ...

Get Understanding DB2®: Learning Visually with Examples 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.

Start your free trial