Install DB2 v9.7 on SLES 11 SP2

準備檔案:

• DB2_AESE_97_Linux_x86-64.tar.gz (DB2 Server 主程式)
• DB2_AESE_CPU_QS_Activation_97.zip (License 檔案)
• v9.7fp8_linuxx64_universal_fixpack.tar.gz (更新檔 fixpack)

主程式安裝

檔案名稱: DB2_AESE_97_Linux_x86-64.tar.gz

tar xzf DB2_AESE_97_Linux_x86-64.tar.gz
cd aese/
./db2prereqcheck
./db2_install 

Default directory for installation of products - /opt/ibm/db2/V9.7

***********************************************************
Do you want to choose a different directory to install [yes/no] ?
no

Specify one of the following keywords to install DB2 products.

  AESE
  CLIENT
  RTCL

Enter "help" to redisplay product names.

Enter "quit" to exit.

***********************************************************
AESE

更新檔 fixpack 安裝

檔案名稱: v9.7fp8_linuxx64_universal_fixpack.tar.gz

tar xzf v9.7fp8_linuxx64_universal_fixpack.tar.gz
cd universal/
./db2prereqcheck

如果出現錯誤:
DBT3534W  The db2prereqcheck utility determined that ASLR is set to ON and that this could cause issues with some tools.

解決: 編輯 /etc/sysctl.conf, 加上這一行
kernel.randomize_va_space = 0
執行  echo 0 > /proc/sys/kernel/randomize_va_space

./installFixPack

Enter full path name for the install directory -

------------------------------------------------
/opt/ibm/db2/V9.7 <== 輸入 DB2 主程式安裝目錄

建立 DB Instance 用的 User & Group

User: db2inst
Group: db2adm

新增 DB Instance

編輯 /etc/services，最底下加上這幾行

#
DB2_db2inst      60000/tcp
DB2_db2inst_1    60001/tcp
DB2_db2inst_2    60002/tcp
DB2_db2inst_END  60003/tcp

新增 DB Instance

cd /opt/ibm/db2/V9.7/instance/
./db2icrt -s ese -u db2inst db2inst

db2icrt -s <Inst-Type> -u <Inst-username> <Inst-name>

建立 DB Instance 的 .profile

su - db2inst
cp sqllib/db2profile .profile 
exit

建立 Instance

變更 yast 的背景樣式

編輯 /etc/sysconfig/yast2

## Type: string(linux,xterm,rxvt,mono,braille)
## Default: ""
# Color theme for YaST ncurses UI
# xterm: blue-white-red
# linux: blue-white-yellow
# rxvt: black-yellow-red
# mono: white-black
# braille: for visually impaired
Y2NCURSES_COLOR_THEME="rxvt"

如何增加一個 LUN 到現有的 VG

• LUN Disk = /dev/xvdc
• VG = /dev/vg1
• 指令: yast disk

Warning:........ > 左邊選單 [Volume Management] > 選擇 VG [/dev/vg1] > 功能: Resize