DB2___升級DB2 8.1 for aix基本版FixPak0 到FixPak13

1)要找到升級的介質，db2 fixpak13大小為936M，下載地址在

2)上傳介質 ftp上傳的，必須使用二進位制上傳，否則uncompress的時候會報錯

3)大致的升級步驟如下，具體參考db2的升級文件，在

頁面的找fixpak information一欄的readme.html，上面的步驟非常的詳細，不用這裡多廢話了，呵呵。

大致步驟：

3.1)stop all db2 process

3.2)directory cannot contain spaces

3.3)ensure suffient system free space

3.4)uncomress fixpak installation images

3.5)intall fixpak

3.6)updating instance

3.7)update system catlog

3.8)restart instance

3.9)binding bind files

其它：

檢視當前db2安裝版本的方法：

1)lsapp -al "db2*"

2)db2level

我升級過程的具體指令碼：

b80
-a
AIX b80 3 5 0009C4BF4C00
#

- db2inst1
$ . $HOME/sqllib/db2profile
$ db2 force applications all
DB20000I The FORCE APPLICATION command completed successfully.
DB21024I This command is asynchronous and may not be effective immediately.

$ db2 terminate
DB20000I The TERMINATE command completed successfully.
$ db2stop
11-29-2006 16:40:13 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
$ db2licd -end
$ exit
- dasusr1
[YOU HAVE NEW MAIL]
$ . $HOME/das/dasprofile
$ db2admin stop
SQL4410W The DB2 Administration Server is not active.
$ exit

-ef|grep db2fm
root 38896 1 0 14:10:47 - 0:02 /usr/opt/db2_08_01/bin/db2fmcd
dasusr1 55042 1 0 16:45:47 - 0:00 /home/dasusr1/das/bin/db2fmd -i dasusr1 -m /home/dasusr1/das/lib/libdb2dasgcf.a
root 84114 34382 0 16:46:01 pts/6 0:00 grep db2fm
/usr/opt/db2_08_01/bin

b80@root#./db2fmcu -d
- db2inst1

$ ./db2fm -D
./db2fm return non-zero rc, please see log file '/home/db2inst1/sqllib/db2dump/db2diag.log'

$ $HOME/sqllib/bin/ipclean
/home/db2inst1/sqllib/bin/ipclean: Removing DB2 engine and client's IPC resources for db2inst1.
$ exit

/ptfs/db2/fixpak13

fixpak.s060801
fixpak.s060801

-al "db2_08_01.client"
Fileset Level State Description
----------------------------------------------------------------------------
Path: /usr/lib/objrepos
db2_08_01.client 8.1.1.0 COMMITTED Base Client Support

install*
installFixPak
-y

/ -name "db2iupdt"
/usr/opt/db2_08_01/instance/db2iupdt

db2inst1
DBI1070I Program db2iupdt completed successfully.

#

/ -name "dasupdt"
/usr/opt/db2_08_01/instance/dasupdt

dasusr1
[YOU HAVE NEW MAIL]
SQL4410W The DB2 Administration Server is not active.
[YOU HAVE NEW MAIL]
SQL4409W The DB2 Administration Server is already active.
DBI1070I Program dasupdt completed successfully

- db2inst1

$ db2start
11/29/2006 17:27:37 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
$ db2level
DB21085I Instance "db2inst1" uses "32" bits and DB2 code release "SQL08026"
with level identifier "03070106".
Informational tokens are "DB2 v8.1.1.120", "s060801", "U808888", and FixPak
"13".
Product is installed at "/usr/opt/db2_08_01".

$