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

本来2006.11.28日就升级完了，可惜没有及时整理，现在补充吧，^_^

升级的过程大致如下：

[@more@]

1)要找到升级的介质，db2 fixpak13大小为936M，下载地址在

http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_aix5.html

2)上传介质 ftp上传的，必须使用二进制上传，否则uncompress的时候会报错

3)大致的升级步骤如下，具体参考db2的升级文档，在

http://www-306.ibm.com/software/data/db2/udb/support/downloadv8_aix5.html

页面的找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@root#hostname
b80
b80@root#uname -a
AIX b80 3 5 0009C4BF4C00
b80@root#

b80@root#su - 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
b80@root#su - dasusr1
[YOU HAVE NEW MAIL]
$ . $HOME/das/dasprofile
$ db2admin stop
SQL4410W The DB2 Administration Server is not active.
$ exit
b80@root#/usr/sbin/slibclean

b80@root#ps -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
b80@root#cd /usr/opt/db2_08_01/bin

b80@root#./db2fmcu -d
b80@root#su - 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

b80@root#cd /ptfs/db2/fixpak13
b80@root#ls
fixpak.s060801
b80@root#cd fixpak.s060801

b80@root#lslpp -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

b80@root#ls install*
installFixPak
b80@root#./installFixPak -y

b80@root#find / -name "db2iupdt"
/usr/opt/db2_08_01/instance/db2iupdt

b80@root#/usr/opt/db2_08_01/instance/db2iupdt db2inst1
DBI1070I Program db2iupdt completed successfully.

b80@root#

b80@root#find / -name "dasupdt"
/usr/opt/db2_08_01/instance/dasupdt

b80@root#/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

b80@root#su - 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".

$

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8861952/viewspace-903695/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8861952/viewspace-903695/