Shulou(Shulou.com)06/01 Report--

Anyone who has installed the oracle database knows that oracle installation is still troublesome, but the corresponding information is also more. Recently, if you want to re-systematically learn DB2, you will inevitably build an environmental practice.

The brief installation steps are as follows for reference.

One: install the configuration environment

Operating system version: Red Hat Enterprise Linux Server release 6.5 (Santiago)

Database version: DB2/LINUXX8664 11.1.2.2

[root@host02 ~] # uname-r

2.6.32-431.el6.x86_64

Second, install software and create database

1. Upload v11.1_linuxx64_server_t.tar.gz to the host

two。 Decompress tar-xzvf v11.1_linuxx64_server_t.tar.gz

A server_t file is generated.

3. Check before installation:

/ u01/server_t

[root@host02 server_t] #. / db2prereqcheck

Validating "/ lib/libpam.so*"...

DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/ lib/libpam.so*".

WARNING: Requirement not matched.

Requirement not matched for DB2 database "Server" with pureScale feature. Version: "9.8.0.2".

Summary of prerequisites that are not met on the current system:

DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "/ lib/libpam.so*".

DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.5".

The above error will occur in the check.

The above error report IBM gives the following explanation:

DBT3514W

The db2prereqcheck utility failed to find the following 32-bit library file: library-file-name.

Explanation

You can verify installation prerequisites for DB2 database using the db2prereqcheck utility.

This message is returned when the db2prereqcheck utility cannot find the 32-bit version of a required library file. If the named file is missing, 32-bit database applications might not function properly.

User response

Respond to this message in one of the following ways:

1 > If you do not intend to use 32-bit applications with DB2 database, then no response is required.

2 > If you do intend to use 32-bit applications with DB2 database, ensure that the named 32-bit library file exists on the system before installing DB2 database.

Currently, the platform does not intend to use 32bit applications, so the above warning messages can be ignored.

4. Install softwar

[root@host02 server_t] # ls

Db2 db2checkCOL_readme.txt db2checkCOL.tar.gz db2ckupgrade db2_deinstall db2_install db2ls db2prereqcheck db2setup ibm_im installFixPack nlpack

[root@host02 server_t] #. / db2_install

…… .

Install into default directory (/ opt/ibm/db2/V10.5)? [yes/no]-Select the installation directory here and select the recommended directory (you can modify the directory if you do not modify / reserve the size to 6G)

Yes

Enter "help" to redisplay product names. -Select the type of product to install. Select SERVER here.

Do you want to install the DB2 pureScale Feature? [yes/no]-choose whether to install the pureScale feature, and choose not to install it here

Generate the following directory

/ opt/ibm/db2/V11.1

5. Configure DB2 Instance

Create users and groups

User usage user name user group

Instance owner db2inst1 db2iadm1

Protected user db2fenc1 db2fadm1

DB2 Management Server user dasusr1 dasadm1 Note: the instance owner home directory is the location where the DB2 instance will be created; the protected user is used to run user-defined functions (UDF) and stored procedures outside the address space used by the DB2 database; and the user identity of the DB2 management server user is used to run the DB2 management server on the system.

Root@host02 ~] # groupadd db2iadm1

[root@host02 ~] # groupadd db2fadm1

[root@host02 ~] # groupadd dasadm1

[root@host02] # useradd-u 600-g db2iadm1-m-d / home/db2inst1 db2inst1

[root@host02] # useradd-u 601-g db2fadm1-m-d / home/db2fenc1 db2fenc1

[root@host02] # useradd-u 602-g dasadm1-m-d / home/dasusr1 dasusr1

Create DAS

/ opt/ibm/db2/V11.1/instance

[root@host02 instance] #. / dascrt-u dasusr1

Create DB2 Instance

[root@host02 instance] #. / db2icrt-u db2fenc1 db2inst1

DBI1446I The db2icrt command is running

6. Configure TCP/IP communication for the DB2 server

[root@host02 ~] # su-db2inst1

[db2inst1@host02 ~] $db2set-all

[i] DB2AUTOSTART=NO

[g] DB2SYSTEM=host02

[g] DB2INSTDEF=db2inst1

[g] DB2ADMINSERVER=dasusr1

[db2inst1@host02 ~] $db2set DB2COMM=tcpip

[db2inst1@host02 ~] $db2set-all

Update the services file on the server

Cat / etc/services | grep DB2

Update server database management files

Db2 update dbm cfg using SVCENAME 60006

[db2inst1@host02 ~] $netstat-an | grep 60006

Tcp 00 0.0.0.0 60006 0.0.0.0 LISTEN

7. Create a database

[db2inst1@host02 ~] $db2 create db erpdb using codeset UTF-8 territory CN pagesize 8192

DB20000I The CREATE DATABASE command completed successfully.

At this point, the DB2 installation is complete. It still looks simpler than the oracle installation steps.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.