Install DB2 manually in Linux and upgrade DB2

Source: Internet
Author: User
Test environment: slse11.2, 10.4, RedHat5.3, CentOS5 decompress the compressed package gavin: oracledesktar-xzvfdb2exc_975_lnx_x86.tar.gz cdoraclespec

Test environment: slse11.2, 10.4, RedHat5.3, CentOS5 decompress the compressed package gavin:/Oracle # tar-xzvf db2exc_975_LNX_x86.tar.gz cd/oracle/spec

Test environment: slse11.2, 10.4, RedHat5.3, CentOS5

Decompress the package

Gavin:/Oracle # tar-xzvf db2exc_975_LNX_x86.tar.gz
Cd/oracle/special_27924_linuxia32_expc/
Graphical interface Installation
./Db2setup
Manually install db
./Db2_install [default path:/opt/ibm/db2/V9.7]
If you need to upgrade to the decompressed upgrade package, execute
./InstallFixPack-f level-B/opt/ibm/db2/V9.7
Register
/Opt/ibm/db2/V9.7/adm/db2licm-a/oracle/special_27924_linuxia32_expc/db2/license/db2ee. lic
Db2 does not have an independent user management system and must use OS users to provide security authentication.
Create three management user groups, namely the das Management Group, instance group, and protected group.
Groupadd-g 900 db2agrp
Groupadd-g 901 db2igrp
Groupadd-g 902 db2fgrp
Add User
Useradd-m-d/home/db2das-g db2agrp-u 803 db2das
Useradd-m-d/home/db2inst1-g db2igrp-u 801 db2inst1
Useradd-m-d/home/db2fenc1-g db2fgrp-u 802 db2fenc1
Set Password
Passwd db2inst1
Passwd db2fenc1
Passwd db2das
Check whether the creation is successful
Cat/etc/passwd | grep db2
Cat/etc/group | grep db2
To create an instance, you must have a db2 user to manage DB2.
/Opt/ibm/db2/V9.7/instance #./dascrt-u db2das
./Db2icrt-a server-u db2inst1 db2inst1
Generally, the Instance name is the same as the management user name.
Start the db2admin Manager
Su-db2das
Db2admin start
Start an instance
Su-db2inst1
Db2start
Set to automatically start the database on linux
./Db2iauto-on db2inst1
Modify the service port of db2 50001. The default port is 50000.
Db2 update dbm cfg using SVCENAME 50001
View instance configuration information
Db2 get dbm cfg
Change the database connection method to TCPIP
Db2set DB2COMM = TCPIP
Disable an instance
Db2stop

,

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.