DB2 Personal Edition (Linux) Installation

The db2 tutorial is: DB2 Personal Edition (Linux) installation. DB2 Personal Edition (Linux) Installation

Cowboy (zizhao_chen@yahoo.com)
The fe of swust
2003-10-23

Keywords:
Db2 linux Installation

Abstract:
This article briefly introduces the installation process of db2 pe on linux.

Directory:
DB2 PE Introduction
Or install the file
Prepare the installation environment
Complete installation
Test
Conclusion
Resources

DB2 PE Introduction

DB2 Personal Edition (DB2 PE) is a single-user RDBMS running on low-price commercial hardware (commodity hardware) desktops. DB2 PE can be used for Windows 98, Windows ME, Windows NT (SP6 or later), Windows 2000 (SP2 recommended), Windows XP, and Linux. DB2 PE will support Windows 2003 servers when Microsoft releases them. DB2 PE has all functional components of DB2 Workgroup Server Edition, except that remote clients cannot connect to databases running this DB2 version. (However, workstations with Control centers can connect to these databases for remote management .) Because "This DB2 is still DB2", the 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 and then use them in the production environment.
DB2 PE is useful no matter whether the PC is connected to the network. for users who need powerful data storage, or who need to provide database storage tools and be able to connect to a remote DB2 server, it is useful in both cases. DB2 PE also comes with the DB2 Warehouse Center, so you can experiment with business intelligence modeling functions such as extraction, conversion, and loading (see what is a data Warehouse ?). DB2 PE is scalable and supports all DB2 Extender: XML (now bundled with DB2 for installation), Spatial, and Net Search. (For more information, see DB2 Extender .)
Occasionally Connected users may want to use the built-in replication feature of DB2 and the DB2 Control Server to establish a synchronization environment, through which employees can stay in touch with the Enterprise. Of course, this is only suitable for users and certain Workstations using laptops, such as those running point-of-sale (POS) applications.

Prepare for Installation
Here, we have installed db2 pe (personal edition), which can be obtained from the ibm site. Yes :. The downloaded file is in tar format.
In my example, my installation file has been stored in an ftp in the lan. My installation environment is a newly installed redhat 7.2, which uses the default component of the Server Installation Method.
Copy the installation file to the local device:
[Root @ no18 root] # wget ftp: // 192.168.0.1/software/DB/DB2_V81_PE_LNX_32_NLV.tar
Decompress:
[Root @ no18 root] # tar xvf DB2_V81_PE_LNX_32_NLV.tar
All files that have been unlocked are stored in the pe folder in the current directory.
Start installation:
[Root @ no18 root] # pe/db2_install
After a while, the installation is complete. At this time, the main installation is complete.

Complete installation
What we need to do now is to initialize the database. This includes installing the authorization file and creating an instance and running it.
First, install the authorization file.
If the authorization file is not installed, the version will be evaluated and will expire in 90 days. The authorization file already exists in the installation package. Run the following command to install it:
[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
Start instance creation:
[Root @ no18 root] #/opt/IBM/db2/V8.1/instance/db2icrt-u db2ins1 db2ins1
In this way, we have created an instance 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 statement: the SQL statement used to create a database.
[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 has been created successfully.

Conclusion

Db2 has won many users with its ease of use, powerful functionality, and strong support. In this article, we have taken the first step in learning to use db2. We hope to help those who are interested in db2.