Filter
Top Products
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:
v Create a database using the Control Center
v Add a database using the Control Center or Configuration Assistant
v Drop a database from the Control Center
v Backup a database using the Control Center
v Restore a database using the Control Center
v Configure a database using the Control Center
v Connect to a database using the Control Center
v Resolve 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