Install and configure the DB2 10.1 database in linux
DB2 is a relational database system developed by IBM. DB2 is mainly used in large-scale application systems and has good scalability. It can support from the mainframe to the single-user environment and be applied to OS/2, Windows, and other platforms. DB2 provides high-level data availability, integrity, security, recoverability, and execution capabilities for small-scale to large-scale applications. It has basic platform-independent functions and SQL commands. DB2 uses data classification technology to easily download mainframe data to the LAN Database Server, so that client/server users and LAN-based applications can access mainframe data, and make the database localization and remote connection transparent. It is famous for having a very complete query optimizer. Its external connection improves the query performance and supports multi-task parallel query. DB2 has excellent network support capabilities. Each subsystem can connect to tens of thousands of distributed users and activate thousands of active threads at the same time. This is especially suitable for large-scale distributed application systems.
1. Download DB2
IBM http://www.ibm.com/developerworks/cn/downloads/im/udbexp/
For the first download, You need to log on to the account and password. Click "OK" and the download page will be displayed. Here I select http download
Click Download now. You can also use tools such as thunder to download the email.
2. Install DB2
After the download is complete, the installation package, db2_v101_linuxx64_expc.tar.gz
Decompress tar zxvf db2_v101_linuxx64_expc.tar.gz
The specific content of an expc is as follows:
There are two ways to install DB2: command and graphical interface. Graphical interface installation (which can be operated by the root user)
Run./db2_install when installing the character interface (this method is not officially recommended)
Run./db2setup directly on the GUI.
Click to install the product
Go to the product installation page
Click Next
Click to accept the license agreement
In the lower-right corner, you can click to view the features. By default, you can select classic installation and custom installation.
Install the response file here select to install DB2 on this computer
Select the installation directory. You can click the button next to the installation directory to customize the location.
Set the db2 management user. The password must be entered
Select create instance for instance settings, and next step
Set the instance owner. You must enter the same password.
It is not absolutely required to set the development user. Generally, it is created. Next Step
The usage and difference of the three created users are described as follows:
-- The user of db2inst1 is the instance owner and has the same name as the instance.
The command line format is as follows:
# Useradd db2inst1
# Groupadd db2iadm1
-- Db2fenc1 is used for application development. It is not absolutely required, but is generally created
The command line format is as follows:
# Groupadd db2fadm1
# Useradd db2fenc1
-- DB2 Management Server user, used to manage multiple instances
The command line format is as follows:
# Useradd dasuser1
# Useradd dasadm1
Summary: Click Finish to install DB2 on the system. you may need to provide a Language Pack image during the installation process. After downloading the Language Pack and decompressing it, specify the image directory as the extracted directory.