IBM VERSION 9 Basic administration, Creating your own database Database basics, Related concepts

Chapter 5. Basic administration

Now that you have installed your DB2 product and verified its successful installation, you are ready to create your own database. The following sections will guide you through the steps of creating a new database that will take advantage of DB2 automatic maintenance features.

Creating your own database

Database basics

A relational database presents data as a collection of tables. A table consists of a defined set of columns and any number of rows. The data in each table is logically related, and relationships can be defined between tables. Data can be viewed and manipulated based on mathematical principles and operations called relations (such as, INSERT, SELECT, and UPDATE).

A database is self-describing in that it contains, in addition to data, a description of its own structure. It includes a set of system catalog tables, which describe the logical and physical structure of the data; a configuration file, which contains the parameter values associated with the database; and a recovery log, which records ongoing transactions and transactions that can be archived.

Databases can be local or remote. A local database is physically located on the workstation in use, while a database on another machine is considered remote.

You can:

vCreate a database using the Control Center

vAdd a database using the Control Center or Configuration Assistant

vDrop a database from the Control Center

vBackup a database using the Control Center

vRestore a database using the Control Center

vConfigure a database using the Control Center

vConnect to a database using the Control Center

vResolve database health alerts with the Health Center

Related concepts:

v“Getting started with the Configuration Assistant” on page 54

v“Getting started with the Control Center” on page 42

v“Getting started with the Health Center” on page 49

Related tasks:

v“Verifying your new database” on page 32

Creating your own database using the Create Database with the Automatic Maintenance wizard

The Create Database with Automatic Maintenance wizard is the quickest way to set up your own database. Based on basic information that you provide, the wizard:

© Copyright IBM Corp. 1993, 2006 31