DB2小版本补丁升级
1、查看版本信息$oslevel -s 查看AIX系统版本，发布号及技术级别
$oslevel -s
6100-06-05-1115
$db2level查看db2的版本信息以及补丁信息
$db2level
DB21085IInstance "db2inst1" uses "64" bits and DB2 code release "SQL09076"
with level identifier "08070107".
Informational tokens are "DB2 v9.7.0.6", "s120516", "IP23321", and Fix Pack
"6".
Product is installed at "/opt/IBM/db2/V9.7".
$ps -ef | grep db2 查看db2数据库启用的相关进程信息
$ps -ef | grep db2
root 44892380 1 0 Nov 08 -0:00 db2wdog 0
db2fenc1 50790532 44892380 0 Nov 26 -0:00 db2fmp (idle) 0
db2inst1 53543064 12452118 0 Nov 07 -0:00 sh
db2inst1 60031146 17498538 0 Oct 12 -2:19 /home/db2inst1/sqllib/bin/db2
db2inst1 61276160 48103868 0 Nov 08 -0:00 db2vend (PD Vendor Process - 258)
db2inst1 64487654 1 0 Nov 08 - 26:23 /opt/IBM/ITM/aix526/ud/bin/kuddb2 credit_db2inst1
db2inst15570916 53543064 0 Nov 07 -2:29 /opt/bmc/Patrol3/AIX6.1-64/bin/db2kmchan64.v9 -E DB2INSTANCE=db2inst1
db2inst17405962 1 0 Oct 12 -6:17 /home/db2inst1/sqllib/bin/db2bp 17498538A208 5 A
db2inst1 13435152 35782942 0 15:15:25pts/10:00 -ksh
db2fenc1 14090642 44892380 0 03:37:56 -0:02 db2fmp (C) 0
db2inst1 17498538 12452118 0 Oct 12 -0:00 /usr/bin/ksh -c . /home/db2inst1/sqllib/db2profile && /home/db2inst1/sqllib/bin/db2 && ""
db2inst1 19726734 13435152 5 15:31:43pts/10:00 ps -ef
dasusr1 24117718 1 0 Sep 07 -0:04 /home/dasusr1/das/adm/db2dasrrm
root 27001284 48103868 1 Nov 08 -0:05 db2ckpwd 0
db2inst1 29425982 13435152 0 15:31:43pts/10:00 grep db2
db2inst1 31326698 44892380 0 Nov 08 -5:11 db2acd 0
db2inst1 32243990 34341154 0 Oct 12 -0:00 /opt/bmc/Patrol3/AIX6.1-64/bin/db2kmchan64.v9 -E DB2INSTANCE=db2inst1
db2inst1 34341154 12452118 0 Oct 12 -0:00 sh
root 40042914 48103868 0 Nov 08 -0:05 db2ckpwd 0
root 42336652 48103868 0 Nov 08 -0:05 db2ckpwd 0
db2inst1 48103868 44892380 125 Nov 08 - 407:10 db2sysc 0
$ps -ef | grep db2sysc 查看启用数据库实例的用户
$ps -ef | grep db2sysc
db2inst1 48103868 44892380 120 Nov 08 - 407:34 db2sysc 0
$db2ilist 对照以上启用实例用户
$db2ilist
db2inst1
2、关闭所有数据库实例，安装补丁包
$su -
#su - db2inst1
$db2stop (db2stop force) 停止实例
$cd /INSTALL_DB2_DIR
$exit
#./installFixPack -b DB2_DIR
3、检查db2版本信息
#su - db2inst1
$db2level
$db2start
$exit
#exit
$exit
页:
[1]