How does one install the DB2 Personal Edition under the Linux operating system?

This article mainly describes how to correctly install the DB2 Personal Edition under the Linux operating system. If you are interested in correctly implementing the installation process of the DB2 Personal Edition under the Linux operating system, you can click to view the following articles.

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

DB2 PE Introduction

DB2 Personal EditionDB2 PE) is a single-user RDBMS running on low-price commercial hardware commodity hardware. DB2 PE can be used for Windows 98, Windows ME, Windows NTSP6 or later), Windows 2000 recommended SP2), 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 Center) 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 Data Warehouse ?). DB2 PE is scalable and supports all DB2 Extender: XML is now bundled to DB2 for installation), Spatial, and Net Search. For more information, see DB2 Extender .)

Occasionally Connected users may want to use the built-in copy feature of DB2 Personal Edition and the DB2 Control Server to establish a synchronization environment, where 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 retail terminal 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. I hope to help those who are interested in the DB2 Personal Edition.

 
 

  
  
TAG: linux Linux