Creating database objects - IBM DB2 9.7 for Linux, UNIX, and Windows

Use the Control Center to create database objects such as databases, tables, views, indexes, and triggers.

Before you begin

To create databases in the Control Center, you need either SYSADM or SYSCTRL authority. For information on the authorities needed to create other database objects, such as tables and table spaces, see the authorities and privileges information for creating the specific object.

Procedure

To create a new database object:

Open the Control Center:
- On Windows operating systems, click Start > Programs > IBM DB2 > General Administration Tools > Control Center.
- On Linux operating systems, click Main Menu and, select IBM DB2 > Control Center.
Expand the object tree to display a folder for the type of object that you want to create.
Right-click the folder. A pop-up menu of all of the available actions for the object opens.
Click the Create or Create from Import menu item, if it is available. A window or notebook opens to guide you through the process for creating the object.