1、DB2數(shù)據(jù)庫的安裝
一、將DB2的安裝介質(zhì)上傳至/home目錄，并解壓：
?? tar –zxvf v9.5fp3_linuxx64_server.tar.gz
二、執(zhí)行LANG=C
三、進入解壓后的server目錄（cd server/），執(zhí)行./db2setup,步驟如下：
# cd /home
# tar -zxvf v9.7_linuxx64_server.tar.gz
# cd server/
# ./db2setup
?
?
請額外注意：這里選擇 Do not create a DB2 instance。因為這樣選擇才能把db2軟件裝在本地。
輸入主機名
安裝完成。
2、在數(shù)據(jù)庫服務(wù)器上創(chuàng)建用戶和組
創(chuàng)建組db2iadm1（實例管理組）,db2fgrp1（DB2 fencing管理組）和dasadm1（數(shù)據(jù)庫管理員用戶組），其中dasadm1組在安裝數(shù)據(jù)庫時已經(jīng)創(chuàng)建，我們只需要創(chuàng)建db2iadm1和db2fgrp組：
# groupadd -g 206 db2iadm1
# groupadd -g 203 db2fgrp1
創(chuàng)建用戶db2inst1(實例管理用戶)、db2fenc1(DB2 fencing 管理用戶)和dasusr1(數(shù)據(jù)庫管理員用戶)，其中dasusr1用戶在安裝數(shù)據(jù)庫時已經(jīng)創(chuàng)建，我們只需要創(chuàng)建db2inst1和db2fenc用戶
# useradd -g db2iadm1 -u 209 -d /home/db2inst1 db2inst1
# useradd -g db2fgrp1 -u 210 -d /home/db2fenc1 db2fenc1
3、在數(shù)據(jù)庫服務(wù)器上更改目錄權(quán)限
# mkdir /db2data
# chown -R db2inst1:db2iadm1 /home/db2inst1
# chown -R db2fenc1:db2fgrp1 /home/db2fenc1
# chown -R db2inst1:db2iadm1 /home
# chown -R db2inst1:db2iadm1 /db2data
4、在數(shù)據(jù)庫服務(wù)器上創(chuàng)建實例db2inst1
# cd /opt/ibm/db2/V9.7/instance
??? # ./db2icrt -u db2fenc1 db2inst1
DBI1070I? Program db2icrt completed successfully.
5、在數(shù)據(jù)庫服務(wù)器上創(chuàng)建數(shù)據(jù)庫（test）
# su - db2inst1
$ db2start
01/14/2019 09:48:57? 0 0? SQL1063N? DB2START processing was successful.
$ db2 create database test using codeset UTF-8 territory zh_cn
DB20000I? The CREATE DATABASE command completed successfully.
修改數(shù)據(jù)庫配置參數(shù)
$ db2 update db cfg for test using LOGFILSIZ 78600
$ db2 update db cfg for test using LOGPRIMARY 100
$ db2 update db cfg for test using LOGSECOND 30
修改完成后重啟實例
$ db2stop force
2017-08-23 16:40:40??? 0? 0? SQL1064N DB2STOPprocessing was successful.
SQL1064N DB2STOP processing was successful.
$ db2start
08/23/2017 16:40:44? 0? 0? SQL1063N DB2STARTprocessing was successful.
SQL1063N DB2START processing was successful.
檢查相關(guān)參數(shù)
$ db2set –all
連接數(shù)據(jù)庫
$ db2 connect to test
?Database Connection Information
?Database server??????? = DB2/LINUXX8664 9.7.0
?SQL authorization ID?? = DB2INST1
?Local database alias?? = TEST
在test數(shù)據(jù)庫里創(chuàng)建test表并插入數(shù)據(jù)
$db2 "create? table test(NAME VARCHAR(20) NOT NULL , BIRTHDAY DATE)"
DB20000I? The SQL command completed successfully.
$ db2 "INSERT INTO test (NAME,BIRTHDAY) VALUES ('張三','2000-1-1')"?
DB20000I? The SQL command completed successfully.
$ db2 "INSERT INTO test (NAME,BIRTHDAY) VALUES ('李四','2000-1-1')"?
DB20000I? The SQL command completed successfully.
$ db2 "INSERT INTO test (NAME,BIRTHDAY) VALUES ('王五','2000-1-1')"
DB20000I? The SQL command completed successfully.
附：
1、開啟數(shù)據(jù)庫歸檔模式：
$ db2 update db cfg for test using logretain on
DB20000I? The UPDATE DATABASE CONFIGURATION command completed successfully.
2、啟用增量備份功能：
$ db2 update db cfg for test using trackmod on
DB20000I? The UPDATE DATABASE CONFIGURATION command completed successfully.
3、創(chuàng)建備份目錄并進行一次備份操作
$ cd /home/db2inst1
$ mkdir backup
$ db2 backup db test to /home/db2inst1/backup
Backup successful. The timestamp for this backup image is : 2019011409591
注意：如果原來是非歸檔模式， 手工開啟歸檔模式之后，需要配置一定的歸檔清 理策略，保證歸檔可以被定期清理， 清理歸檔時最好能保留 3- 7天的歸檔，以保證歸檔HVR在一定延遲或者其他原因 沒有及時抽取在線日志時，可以在歸檔中抽取數(shù)據(jù)變化。 如果用戶部署了備份軟件或者歸檔清理計劃，也要對備份或清理計劃 進行修改，保留3- 7天的歸檔。
設(shè)置完畢，大體情況如下：
$ db2 get db cfg for sample |grep -i log
Log retain for recovery status???????? = RECOVERY
First log archive method???? (LOGARCHMETH1) = DISK:/archive/
4、打開 表的 補充日志文章來源：http://www.zghlxwxcb.cn/news/detail-475114.html
alter table table_name data capture changes include longvar columns。文章來源地址http://www.zghlxwxcb.cn/news/detail-475114.html
到了這里，關(guān)于Linux系統(tǒng)安裝DB2數(shù)據(jù)庫的詳細步驟的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
