DB2 Personal Edition (Linux) installation _DB2

Source: Internet
Author: User
Tags db2 db2 installation create database
The DB2 tutorial you are looking at is: DB2 Personal Edition (Linux) installation. DB2 Personal Edition (Linux) installation

Cowboy (zizhao_chen@yahoo.com)
The FE of Swust
2003-10-23

Key words:
DB2 Linux Installation

Summary:
This paper briefly introduces the installation process of DB2 PE on Linux system.

Directory:
DB2 PE Introduction
or installation files
Preparing the installation Environment
Complete the installation
Test
Conclusion
Resources

DB2 PE Introduction

DB2 Personal Edition (DB2 PE) is a single-user RDBMS that runs on low-priced commercial hardware (commodity hardware) desktops. DB2 PE is available for Windows 98, Windows ME, Windows NT (SP6 or later), Windows 2000 (recommended SP2), Windows XP, and Linux. When Microsoft publishes Windows 2003 servers, DB2 PE will support them. DB2 PE owns all the features of the DB2 Workgroup Server Edition, with one exception: The remote client cannot connect to the database running the DB2 version. (However, workstations with control center can connect to these databases to perform remote administration.) Because "this DB2 is still DB2", applications developed for DB2 PE will be able to run on any other version of DB2. You can use DB2 PE to develop DB2 applications before they are used in a production environment.
DB2 PE is useful regardless of whether the PC is connected to the network, or it is useful in both cases for users who need a strong data store, or for users who need to provide database storage tools and are able to connect to a remote DB2 server. DB2 PE also comes with the DB2 Warehouse Center (DB2 Warehouse Center), so users can experiment with business intelligence modeling functions such as extraction, conversion, and loading (see Data Warehouse?). )。 DB2 PE is extensible and can support all DB2 extender:xml (now bundled to DB2 installation), Spatial, and Net Search. (For more information, see DB2 Extender.) )
Users who occasionally connect may want to use the DB2 built-in replication feature and the DB2 control Server (DB2) to establish a synchronization environment in which employees can stay in contact with the enterprise. Of course, this is only suitable for users with laptops and certain workstations, such as those running retail terminal (POINT-OF-SALE,POS) applications.


Ready to install
Here, we are installing DB2 PE (Personal Edition), which can be obtained from the IBM site. The download address is:. Download the file in the tar format.
In my case, my installation file has been placed down on an FTP in the LAN. My installation environment is a newly installed Redhat 7.2, using the default component of the way the server is installed.
Copy the installation files to the Local:
[Root@no18 root]# wget Ftp://192.168.0.1/software/DB/DB2_V81_PE_LNX_32_NLV.tar
Extract:
[Root@no18 root]# tar xvf db2_v81_pe_lnx_32_nlv.tar
The files that are unpacked are placed in the PE folder in the current directory.
To begin the installation:
[Root@no18 root]# Pe/db2_install
Over the array, the installation can be completed. By this time, the main work we have installed is done.


Complete the installation
What we need to do now is to work on the initialization of the database. This includes installing the authorization file and creating an instance and running it.
First, we install the authorization file.
If the authorization file is not installed, it is an evaluation version and expires in 90 days. The authorization file is already available in the installation package. We install it with the following command:
[Root@no18 root]#/opt/ibm/db2/v8.1/adm/db2licm-a/root/pe/db2/license/db2pe.lic
Next, we need to create a user.
[Root@no18 root]# Useradd db2ins1
[Root@no18 root]# passwd db2ins1
To start creating an instance:
[Root@no18 root]#/opt/ibm/db2/v8.1/instance/db2icrt-u db2ins1 db2ins1
In this way, we create an instance of db2ins1.
Start the instance:
[Root@no18 root]# su db2ins1
[Db2ins1@no18 db2ins1]$ Db2start
SQL1063N Db2start processing was successful.

Test

As a test, we run a simple sql: Create a database of SQL.
[Root@no18 root]# su db2ins1
[Root@no18 root]# CD
[Db2ins1@no18 db2ins1]$ DB2 CREATE DATABASE MyDB
db20000i the CREATE DATABASE command completed successfully.
That's OK, our database was created successfully.

Conclusion

DB2 has won many users with its ease of use and powerful and strong support. In this article, we have taken the first step in learning to use DB2. Hope to be helpful to those who are interested in DB2.
<

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.