ITPub博客

首页 > 数据库 > 数据库开发技术 > DB2 V9.7 install special fixpack steps

DB2 V9.7 install special fixpack steps

原创 数据库开发技术 作者:vectorT 时间:2016-03-09 18:03:05 0 删除 编辑

                                
1. log on to the target server & sudo to db2 instance ID
sudo su – db2fin

2. backup the related cfg files
cd /db2home/db2fin/update_script_vector/CH10383566
db2 get dbm cfg >>db2_dbm_cfg.log
./backup_db_cfg.ksh
db2set -all >>db2_info_db2set.log

3. Online backup the Dbs to the local disk
./local_backup_db.ksh

4. Stop all the process related to DB2
Stop the application
Stop the WAS  ---confirmed with was team, will inform them to restart the was when the change completed

5. Stop DB2 service
. $HOME/sqllib/db2profile
db2 force applications all
db2 terminate
db2stop
##db2licd -end      # run at each physical partition
exit

6. Sudo to ROOT to stop the service as follow
/usr/sbin/slibclean
/opt/xxx/db2/V9.7/bin/db2fm -i db2fin -D

7. Disable the db2fm
/opt/xxx/db2/V9.7/instance/db2iset -i db2fin -all
/opt/xxx/db2/V9.7/instance/db2iauto -off db2fin

8. Running under instance owner
sudo su – db2fin
$HOME/sqllib/bin/ipclean

9. Copy the sqllib to make sure the sqllib is save if update failed
cd /db2/db2fin/
cp sqllib sqllib_bkp_vector

10. Install the fixpack under ROOT
sudu su - root
cd /tempdb2/CH10383566/universal
./installFixPack -b /opt/xxx/db2/V9.7

11. Post installation
/opt/xxx/db2/V9.7/instance/db2iupdt db2fin

12. Update the database
sudo su – db2fin
db2updv97 -d dbname (all the databases)

13. Restart the instance
db2start
DB2DIR/instance/db2iauto -on db2fin

14. Rebind the packages for each Dbs
cd /db2home/db2fin/update_script_vector/CH10383566 ./db2_bind_pkg.ksh

15. Find the Rebind cmds from the above output
cat db2_bind_pkg_detail.log

16. Go to the Bnd directory to execute the cmds below this folder
cd /db2home/db2fin/sqllib/bnd


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

请登录后发表评论 登录
全部评论

注册时间:2014-08-29

  • 博文量
    24
  • 访问量
    60303