db29.7.0.0补丁升级db29.7.0.6说明.doc

Linux下为DB2 9.7打补丁一、查看当前数据库版本db2instlocalhost $db2levelDB21085I Instance db2inst uses 32 bits and DB2 code release SQL09075with level identifier 08060107.Informational tokens are DB2 v, s111017, IP23291, and Fix Pack5.Product is installed at /opt/ibm/db2/V9.7.当前补丁包版本为5，更新至最新补丁包pack 7。二、下载并解压补丁包注意，补丁包下载并解压缩至的目录路径中不能包含任何空格。如果该目录路径中包含空格，那么安装将失败。rootlocalhost db2pack#gunzip v9.7fp7_linuxia32_server.tar.gztar -xvf v9.7fp7_linuxia32_server.tar三、停止所有DB2进程1、停止实例rootlocalhost db2pack# su - db2instdb2instlocalhost $db2 force applications all -断开所有应用程序DB20000I The FORCE APPLICATION command completed successfully.DB21024I This command is asynchronous and may not be effective immediately.db2instlocalhost $db2 terminate -断开当前与数据库连接并关闭后台进程DB20000I The TERMINATE command completed successfully.db2instlocalhost $db2stop -停止实例2012-12-04 00:24:23 0 0 SQL1064N DB2STOP processing was successful.SQL1064N DB2STOP processing was successful.db2instlocalhost bin$db2licd end -在每一个物理分区执行2、如果DB2管理服务器（DAS）属于要更新的DB2副本，则停止DASdb2instlocalhost $su dasusr1密码：cd /opt/IBM/db2/V9.7/das/bin/db2admin stopdasusrlocalhost $db2admin stop -停止DASSQL4410W The DB2 Administration Server is not active.3、可选：在AIX上，在安装前运行slibclean以从内存中卸载未使用的共享库：/usr/sbin/slibclean4、禁用故障监视器进程。DB2DIR/bin/db2fm I iname -Ddb2instlocalhost bin$db2fm -i db2inst D -停止故障监视器进程守护程序必须对DB2副本中的每个实例执行一次。5、如果启动了故障监视器协调程序（FMC），要阻止实例自动启动：db2instlocalhost bin$db2fmcu -确定是否启动了故障监视器协调程序（FMC）Warning: db2fmcu not running as root.FMC: down这里FMC没有启动，如果启动，则输出内容类似于：FMC: up: PID = 3415。如果启动了FMC，确定是否有实例被配置为在系统每次重新启动就自动启动：DB2DIR/instance/db2iset I iname allrootlocalhost instance#/opt/ibm/db2/V9.7/instance/db2isetDB2COMM=tcpipDB2AUTOSTART=YES阻止实例自动启动：db2iauto off inamerootlocalhost instance# db2iauto -off db2inst16、确保对要更新的实例清除了所有DB2进程间通信。db2instlocalhost /$ipclean -清除要更新的实例所有DB2进程间通信，在每个物理分区中执行ipclean: Removing DB2 engine and clients IPC resources for db2inst.四、安装补丁包有两种方法安装补丁包：一种是安装新的DB2数据库产品，使用db2setup命令安装处于特定补丁包级别的新DB2数据库产品。相当于安装DB2；另一种是更新现有的DB2数据库产品，即通常所说的打补丁。使用installFixPack命令。这里用第二种。rootlocalhost server#./installFixPack -b /opt/IBM/db2/V9.7五、安装后任务rootlocalhost server# db2levelDB21085I This instance or install (instance name, where applicable: db2inst)uses 32 bits and DB2 code release SQL09077 with level identifier08080107.Informational tokens are DB2 v, s121002, IP23373, and Fix Pack7.Product is installed at /opt/ibm/db2/V9.7.1、更新实例以使用新的DB2级别。安装补丁包后，必须更新该DB2副本中的所有现有实例。缺省情况下，installFixPack命令将自动更新DB2实例。但是，如果发生错误，可以手动更新：（1）、作为root用户登录。（2）、通过发出以下命令确定与DB2副本相关联的实例：rootlocalhost instance# db2ilistdb2inst（3）、如果对db2profile或db2cshrc脚本进行了任何更改，备份这些脚本或者将更改分别复制到userprofile和usercshrc脚本中。由于db2iupdt命令覆盖db2profile和db2cshrc脚本，因此此操作是必须的。它不覆盖userprofile和usercshrc脚本。（4）、对每个实例发出以下命令：DB2DIR/instance/db2iupdt inameIname表示实例名称，DB2DIR表示安装了DB2副本的位置。rootlocalhost instance# /opt/ibm/db2/V9.7/instance/db2iupdt db2inst1DBI1070I Program db2iupdt completed successfully.db2iupdt命令的作用：FUNCTION: db2iupdt - update a DB2 instance after installation/removal- of a new DB2 release (of the same version)- of additional DB2 products(eg. updating a client to a server)- of a patch/PTF（5）、如果DAS属于安装了修订包的DB2副本，要发出以下命令：DB2DIR/instance/dasupdtrootlocalhost instance# /opt/ibm/db2/V9.7/instance/dasupdtSQL4410W The DB2 Administration Server is not active.SQL4406W The DB2 Administration Server was started successfully.DBI1070I Program dasupdt completed successfully.2、可选：更新数据库中的系统目录对象以支持修订包。如果希望使用特定于修订包的功能，则强烈建议执行此任务。如果安装了修订包来创建新的安装，那么不必执行此任务，因为目前没有数据库。对于应用了修订包的DB2副本中的每个实例，执行下列操作：（1）、作为实例所有者登录。（2）、对每个数据库发出以下命令：db2updv97 d dbnamedb2instlocalhost $ db2updv97 -d sampl_ _ DB2 Service Tools _ I B M db2updv97 This tool is a service utility designed to update a DB2 Version 9.7 database to the current fixpak level. _ DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 2009Licensed Material - Program Property of IBMIBM DATABASE 2 Database update to current fix pack tooldb2updv97 completed successfully for database sampl.db2instlocalhost $ db2updv97 -d test_ _ DB2 Service Tools _ I B M db2updv97 This tool is a service utility designed to update a DB2 Version 9.7 database to the current fixpak level. _ DB2 Universal Database Version 9.7, 5622-044 (c) Copyright IBM Corp. 2009Licensed Material - Program Property of IBMIBM DATABASE 2 Database update to current fix pack tooldb2updv97 completed successfully for database test.3、重新启动实例和DAS如果安装修订包来更新现有安装，那么此步骤是必需的。如果安装了修订包来创建新安装，那么此步骤不是必需的。db2instlocalhost $ db2start -对于每个实例！12/04/2012 17:48:17 0 0 SQL1063N DB2START processing was successful.SQL1063N DB2START processing was successful.db2instlocalhost $ su - dasusr密码：dasusrlocalhost $ db2admin startSQL4409W The DB2 Administration Server is already active.4、可选。如果在安装修订包之前发出了db2iauto命令以阻止实例自动启动，对这些实例启用自动启动。db2instlocalhost $ db2iauto -on db2inst5、对绑定文件进行绑定在为服务器安装修订包过程中，将自动绑定数据库应用程序（IMPORT、EXPORT、REORG和命令行处理器）和CLI绑定文件。但是，如果在客户机上安装修订包或发生错误，那么可以手动绑定数据库实用程序和CLI绑定文件。（1）、如果在具有现成数据库的DB2数据库产品基础上安装修订包，对每个数据库执行一次下列命令：db2 terminatedb2 CONNECT TO dbname user USERID using PASSWORDdb2 BIND path/db2schema.bnd BLOCKING ALL GRANT PUBLIC SQLERROR CONTINUEdb2 BINDpath/db2ubind.lstBLOCKING ALL GRANT PUBLIC ACTION ADDdb2 BINDpath/db2cli.lstBLOCKING ALL GRANT PUBLIC ACTION ADDdb2 terminatedb2ubind.lst和db2cli.lst包含DB2数据库产品所使用的必须绑定文件列表。已绑定的程序包将返回SQL0719N错误。这是期望的行为。db2instlocalhost bnd$ db2 bind db2schema.bnd blocking all grant public sqlerror continueLINE MESSAGES FOR db2schema.bnd- -SQL0061W The binder is in progress.SQL0091N Binding was ended with 0 errors and 0 warnings.db2instlocalhost bnd$ db2 bind db2ubind.lst blocking all grant public action addLINE MESSAGES FOR db2ubind.lst- -SQL0061W The binder is in progress.LINE MESSAGES FOR db2ajgrt.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLABH02 already exists. SQLSTATE=42710LINE MESSAGES FOR db2ueiwi.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUAH19 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uigsi.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUCH05 already exists. SQLSTATE=42710LINE MESSAGES FOR db2ucktb.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUJH0A already exists. SQLSTATE=42710LINE MESSAGES FOR db2uiici.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUDH02 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uiict.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUEH01 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uexpm.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUBH05 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uimpm.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUFH13 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uImpInsUpdate.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUPH03 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uiDescribe.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUPH00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2ugtpi.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUHH03 already exists. SQLSTATE=42710LINE MESSAGES FOR db2pctsp.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLP1H02 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uredp.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUIH00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2clpcs.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLC2H23 already exists. SQLSTATE=42710LINE MESSAGES FOR db2clprr.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLC3H22 already exists. SQLSTATE=42710LINE MESSAGES FOR db2clpur.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLC4H22 already exists. SQLSTATE=42710LINE MESSAGES FOR db2clprs.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLC5H22 already exists. SQLSTATE=42710LINE MESSAGES FOR db2clpnc.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLC6H22 already exists. SQLSTATE=42710LINE MESSAGES FOR db2arxcs.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLA1H00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2arxrr.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLA2H00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2arxrs.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLA4H00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2arxnc.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLA5H00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2arxur.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLA3H00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2dropv.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLE3H01 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uimtb.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUKH08 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uqtpd.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUMH00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uqtnm.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLULH00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2ulxld.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUNH01 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uiXmlparse.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUZH00 already exists. SQLSTATE=42710LINE MESSAGES FOR db2uipkg.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.SQLUOH01 already exists. SQLSTATE=42710LINE MESSAGES FOR db2ats_sps.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.ATSH04 already exists. SQLSTATE=42710LINE MESSAGES FOR db2_adminotm.bnd- -SQL0719N Bind error for user DB2INST . PackageNULLID.AOTMH01 already exists. SQLSTATE=42710SQL0082C An error has occurred which has terminatedprocessing.SQL0092N No package was created because of previous errors.SQL0091N Binding was ended with 34 errors and 0warnings.db2instlocalhost bnd$ db2 bind db2cli.lst blcoking all grant public action addSQL0104N An unexpected token blcoking was found following . Expected tokens may include: ACTION. SQLSTATE=42601db2instlocalhost bnd$ db2 bind db2cli.lst blocking all grant public action addLINE MESSAGES FOR db2cli.lst- -SQL0061W The binder is in progress.SQL0091N Binding was ended with 0 errors and 0 warnings.（2）、如果在具有现成数据库的DB2产品基础上安装修订包，要运行REBIND或db2rbind命令来重新绑定程序包。安装修订包后，某些程序包会被标记为无效。应用程序受此使用被标记为无效的程序包时，会隐式地重新绑定这些程序包。要消除此开销并确保重新绑定操作成功，要手动重新绑定所有程序包。db2instlocalhost $ db2rbind test -l logfile allRebind done successfully for database TEST.-logfile是在程序包重新生效期间要用于记录错误的文件名。（3）、如果在具有支持空间的现有数据库的DB2数据库产品基础上安装修订包，要对每个数据库执行下列命令：