Creating a Database in db2 Express at 18:45

Creating a Database

In subsequent chapters, you will build an application against a database called L8NITE.

From the Control Center, right-click the All Databases folder and select Create > With Automatic Maintenance

Step 1: Specify the database name and location

Complete the following fields:

• 
  
  Database name: L8NITE
• 
  
  Default drive: C: (select a drive that has sufficient disk space)
• 
  
  Alias: This will default to L8NITE if left blank.
• 
  
  Comment: This is optional and can be left blank.

Click Next to continue.

Step 2: Configure the Maintenance Window

The second step asks whether you can specify a period of time when DB2 can do some offline maintenance activities. Assuming that your database will not be used 24/7 we recommend you select Yes and click Next. If you don't want to specify a maintenance window, DB2 will still be able to do some online maintenance activities.

Step 3: Specify automatic offline maintenance timing

The third step of the wizard (Timing) is available if you answered Yes to step 2. Set aside two or more hours a week when DB2 can perform automated tasks to ensure the health of your database.

Click Next to continue.

Step 4: Configure notification

DB2 can automatically send you an e-mail (or send a message to a pager) if a problem or unhealthy condition is detected. If you wish to configure this, click the Add Contact button. Setting up notification can be skipped if you do not want to receive messages from DB2.

Step 5: Configure memory

DB2 automatically detects how much physical memory is available on your system (Figure 2.17). All you are required to provide is the percentage of memory DB2 can use for tuning itself.