DB2 (Express C Edition) Installation and Using a Database

basesprocketΔιαχείριση Δεδομένων

31 Οκτ 2013 (πριν από 3 χρόνια και 5 μήνες)

164 εμφανίσεις

5.1

DB2 (Express C Edition)


Installation and Using a Database

Unit objectives

After completing this unit, you should understand:


Steps to install DB2
-
Express C database.


Use the Control Center to manage systems, DB2 instances,
databases, database objects, and more.


Identify how the Configuration Assistant lets you maintain a
list of databases to which your applications can connect,
manage, and administer.

Introduction to DB2
Express
-
C


DB2 Express
-
C data server software ("DB2 Express
-
C") is a
member of the IBM DB2 family of powerful data server
software for managing both relational and XML data.


DB2 Express
-
C is a free, no
-
limits, and easy to use edition of
DB2.


The ‘C’ in DB2 Express
-
C stands for the Community. A
community of DB2 Express
-
C users that bands together to
assist each other, both online and offline.


You can download DB2 express edition from the following
website:


http://www
-
01.ibm.com/software/data/db2/express/download.html

Installation Prerequisites


DB2 Express
-
C is available on Linux®, Sun Solaris (x64), and
Microsoft Windows® 2003, XP, and Vista. It is also available as
a beta on Mac OS X. The processor architectures available are
32
-
bit, 64
-
bit and PowerPC (Linux).


For the latest information on DB2 Express
-
C hardware
requirements, review the DB2 Express
-
C web page at
http://www.ibm.com/software/data/db2/express/about.html


To install DB2 on Windows, you must have an operating
system user with sufficient authority.


For
Windows, the user account must belong to the
Administrators group on the machine
where you will perform the
installation.


Alternatively, on Windows 2008, Windows Vista, or higher, a non
-
administrator can perform an installation, but will be prompted for
administrative credentials by the DB2 Setup wizard.

Installation requirements for DB2


Before you install a DB2® database product on Windows
operating systems, ensure that the system you choose meets
the necessary operating system, hardware, and software
requirements.

Windows workstation platforms

Operating System

Prerequisites

Hardware

Windows XP Professional (32

bit and 64

bit)

Windows Vista Business (32

bit and 64

bit)

Windows Vista Enterprise (32

bit and 64

bit)

Windows Vista Ultimate (32

bit and 64

bit)

Windows 7 Professional (32
-
bit and 64
-
bit)

Windows 7 Enterprise (32
-
bit and 64
-
bit)

Windows 7 Ultimate (32
-
bit and 64
-
bit)

Windows XP Service Pack 2 or
later

IBM® Data Server Provider for
.NET client applications and CLR
server
-
side procedures require
.NET 2.0 framework runtime.

64
-
bit IBM data server provider for
.NET applications are supported.

All Windows Vista service packs
are supported.

All Intel and AMD processors capable of running the
supported Windows operating systems (32

bit and
64

bit based systems)

Installation wizard


Although there are several methods to install DB2 Express
-
C,
the easiest method is to use the GUI
-
based DB2 Installation
wizard.


After downloading and uncompressing the DB2 Express
-
C
image, you can launch the wizard as follows:


Execute the
setup.exe file located in the EXP/image/directory


DB2 Express
-
C is straightforward to install by following the
instructions in the DB2 installation wizard.


In most cases, the default settings are sufficient, so all you
need to do is accept the license, click the
Next

button until the
“Finish”
button is active, and then click the
Finish

button
.


After a few minutes, your installation is complete and DB2 will
be up and running.

Steps for installation DB2


After run setup.exe, the DB2 Setup Launchpad will display
.
Click on
Install a
Product

and then choose
Install New
to install a new copy of DB2 Express
-
C on
your system



After accepting the license, it is usually sufficient to choose the

Typical”
installation


In the next step, Choosing “
Install IBM DB2 Express Edition on
this computer”


Then, s
elect directory to install DB2


When you arrive at the following panel,

you will need to type in a user ID
which will be used to setup and run the instance and other services.


The default user ID name is
db2admin,
enter password for db2admin


Then, click next after the following window appeared



Finally,
the installation wizard displays a summary of what will be installed,
and the different configuration values provided in the previous steps. When
you click the

Finish”
button, the installation begins, and the program files
will be laid down on your system.


After click “install” button, it will display the following windows


After finished installation, click next button




When the installation completes, the following window appears
,
informing
you of the results of the installation wizard process, as well as any further
steps that are required to complete your installation. Click
“Finish”
button.


After you click
“Finish”
in the installation results window will display as
following.















Note:
If you install DB2 Express
-
C it will automatically created a sample database


Validating your installation


After installing DB2, you can run three commands from the
DB2 Command Window to verify that your installation is in
good shape:


db2level:
This command displays information about the DB2 product
installed, fix pack level, and other details.


db2licm
-
l:
This command lists all the licensing information specific to
your installed DB2 products


db2val:
This is a new command available in DB2 9.7. It validates your
installation by verifying the core functionality of your DB2 copy. It
makes sure your instances are consistent, and that database creation
and database connections work


The following window provides an example of the output of these three
commands.

DB2 command editor


To run DB2 command editor click, <Start>/<All Program>/<IBM
DB2>/<DB2COPY1>/<General Administrator>/<Control Centre>















Then, click ‘Advanced’


Control Center

Object

Tree

Pane

Contents

Pane

Object

Detail

Pane


After that
Control Center
window will display.

Command Editor: to type SQL command

SQL Assist

Exercise


In this exercise, you will install DB2 Express
-
C and create the
SAMPLE database


Objective


Before you can begin exploring all the features and tools that come
with DB2 Express
-
C, you must first install it on your system.


In this exercise, you will perform a basic installation of DB2 Express
-
C
on Windows.


Refer file Ex0
-
Installation DB2