IBM VERSION 9 manual Verifying your new database, Prerequisites, Procedure, Related concepts

Models: VERSION 9

1 109
Download 109 pages 12.57 Kb
Page 40
Image 40

vcreates a new database on the disk or directory of your choice

vassigns disk space for your data

vconfigures the new database for optimal performance

vturns on automatic maintenance

vconfigures notification by e-mail or pager if the database needs attention

The Create Database with Automatic Maintenance wizard can be started from First Steps or directly from within the Control Center.

Prerequisites:

vIf you wish to start the wizard from First Steps, you must also have the First Steps component installed. First Steps is part of the Getting started component grouping in the DB2 Setup wizard. It is installed as part of a Typical installation or may be selected when performing a Custom installation.

vYou must have SYSADM or SYSCTRL authority to perform this task.

vFor Linux, you must have Xwindow software capable of rendering a graphical user interface for First Steps and the Control Center to run on your machine. Ensure that you have properly exported your display. For example, export DISPLAY=9.26.163.144:0.

vOn Linux, ensure that you are logged on as the instance owner, db2inst1 by default. An instance is a logical database manager environment where you catalog databases and set configuration parameters.

Procedure:

1.Log on to the system with the user account that you want to use to create the database.

2.Start the Create Database with Automatic Maintenance in the one of the following ways:

vFrom First Steps: Click Create Your Own Database.

vFrom the Control Center: Click the All Databases folder. Click Create New Database in the All Databases pane.

3.Follow the steps of the wizard. You will have to provide some details and preferences about your new database, including such things as its name and the contacts who can be notified under various conditions.

If you created your own database from First Steps, you will now want to start the Control Center to begin exploring and working with your database. To do this, click Work With Databases in First Steps.

Related concepts:

v“Database basics” on page 31

Related tasks:

v“Verifying your new database” on page 32

Verifying your new database

Once you have launched the Control Center, you can verify that your database was created by finding it in the Object Tree that fills the left side of the Control Center window.

32Getting started with DB2 installation and administration

Page 40
Image 40
IBM VERSION 9 manual Verifying your new database, Prerequisites, Procedure, Related concepts, Related tasks