Create a new DB2 database

Become Instance Owner

During the install of IBM DB2 LUW, if you accepted the defaults, the Instance Owner's userid is "db2inst1". If you changed that, use that userid instead.

To create new databases, you have to become the Instance Owner and get into the DB2 system.

Run:

su - db2inst1

Enter the password.

This will make you "db2inst1" and display a very bare prompt

Run:

ksh

to get a more useable environment.

Run:

db2

This gets you "into the DB2 system".

Create a new database and call it MURACH.

Because there are tables used in Murach books that have the same names as the Sample DB, create the MURACH DB.

Follow the instructions above to "get into the db2 system", then:

At the db2> prompt, Run

CREATE DATABASE MURACH

You might wait a very long time but it should come back with "successfully created database"

Create a new database and call it BOOKS.

Create the BOOKS DB.

Follow the instructions above to "get into the db2 system", then:

At the db2> prompt, Run

CREATE DATABASE BOOKS

You might wait a very long time but it should come back with "successfully created database"