db2修改环境变量 db2更新实例

转载

mob64ca1418736f 2024-05-11 09:35:46

文章标签 db2修改环境变量数据库新版本 V9 文章分类 数据仓库大数据

测试：把9.7.0.2的db2实例数据库升级到新版本10.5.0.0
参考升级步骤，官方文档：
https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0007200.html

升级之前要做好检查，看是否满足升级的要求(重点关注表空间等):

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0007187.html

升级前要做好各种备份: db backup/db cfg/dbm cfg/db2support/db2look等，以便在升级失败的情况下能快速恢复db进行回退。

Db29.7-10.5升级大致步骤:
1. 升级之前要做好检查，看是否满足升级的要求(重点关注表空间等)
 2. 做好备份(db backup/db cfg/dbm cfg/db2support/db2look等)
 3. 安装新版本10.5.0.0检查安装先决条件是否符合(db2prereqcheck )
 4. 安装高版本DB2软件(10.5)
 5. 升级实例
 6. 升级数据库
 7. 重新rebind package详细步骤:
1.查看当前系统安装的所有db2版本
[root@test instance]# db2ls
Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID 
 ---------------------------------------------------------------------------------------------------------------------
 /opt/ibm/db2/V9.7                9.7.0.11       11                            Wed May  8 00:17:22 2019 CST             0 2.安装新版本10.5.0.0检查安装先决条件是否符合
[root@test universal]# pwd
 /my_DB2_10.5/universal                                                  #该路径为我放上去解压的DB2 10.5的软件存放的路径
 ./db2prereqcheck -v 10.5.0.03.安装10.5.0.0到新的路径,且成功
 [root@localhost ese]# ./db2_install -b /opt/ibm/db2/V10.5[root@test universal]# db2ls
Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID 
 ---------------------------------------------------------------------------------------------------------------------
 /opt/ibm/db2/V9.7                9.7.0.11       11                            Wed May  8 00:17:22 2019 CST             0 
 /opt/ibm/db2/V10.5              10.5.0.10       10                            Sun Jan 12 14:11:15 2020 CST             0 4.su - db2inst1到实例下，检查实例数据库是否可以升级
[db2inst1@test universal]$ ./db2ckupgrade testdb -l /tmp/db2ckupgrade.log                       # [-u db2inst1 -p mypass]
 DBT5508I  The db2ckupgrade utility completed successfully. The database or databases can be upgraded.如果检查失败报“ the database is in an inconsistent state”错误，可以db2 force applications all  / db2 termiante然后再试
5.升级之前务必做好数据库备份
 db2 backup db testdb 6.升级实例：
 1>升级之前查看实例版本信息：
 [db2inst1@test ~]$ db2level
 DB21085I  This instance or install (instance name, where applicable: 
 "db2inst1") uses "64" bits and DB2 code release "SQL0907B" with level 
 identifier "080C0107".
 Informational tokens are "DB2 v9.7.0.11", "s150922", "IP23944", and Fix Pack 
 "11".
 Product is installed at "/opt/ibm/db2/V9.7". 2>先停止实例db2stop force
 3>再用root用户，cd到10.5.0.0的安装目录下执行升级实例：
 [root@test instance]# pwd
 /opt/ibm/db2/V10.5/instance然后执行升级实例命令:
./db2iupgrade  db2inst1
或:
./db2iupgrade  -u db2fenc1 db2inst1 
db2fenc1 为fence用户，db2pd -fmp|grep fenc或 grep fenc /etc/passwd可以找到。
[root@test instance]# ./db2iupgrade  db2inst1 
 DBI1446I  The db2iupgrade command is running. DB2 installation is being initialized.
 Total number of tasks to be performed: 4 
 Total estimated time for all tasks to be performed: 309 second(s) Task #1 start
 Description: Setting default global profile registry variables 
 Estimated time 1 second(s) 
 Task #1 end Task #2 start
 Description: Initializing instance list 
 Estimated time 5 second(s) 
 Task #2 end Task #3 start
 Description: Configuring DB2 instances 
 Estimated time 300 second(s) 
 Task #3 end Task #4 start
 Description: Updating global profile registry 
 Estimated time 3 second(s) 
 Task #4 end The execution completed successfully.
For more information see the DB2 installation log at
 "/tmp/db2iupgrade.log.57960".
 DBI1070I  Program db2iupgrade completed successfully. 4>实例升级成功：[db2inst1@test ~]$ db2level
 DB21085I  This instance or install (instance name, where applicable: 
 "db2inst1") uses "64" bits and DB2 code release "SQL1005A" with level 
 identifier "060B010E".
 Informational tokens are "DB2 v10.5.0.10", "s180615", "IP24053", and Fix Pack 
 "10".
 Product is installed at "/opt/ibm/db2/V10.5". 
5>su - db2inst1，重启实例db2start   , 启动失败。
[root@test instance]# su - db2inst1
 Last login: Sun Jan 12 14:58:46 CST 2020 on pts/0
 [db2inst1@test ~]$ db2start
 01/12/2020 14:59:51     0   0   SQL6048N  A communication error occurred during START or STOP DATABASE MANAGER processing.
 SQL1032N  No start database manager command was issued.  SQLSTATE=57019启动实例失败。经检查发现/etc/hosts里的IP配置错了，做了修改，然后重启成功。
[db2inst1@test ~]$ db2start
 SQL8007W  There are "89" day(s) left in the evaluation period for the product 
 "DB2 Advanced Enterprise Server Edition". For evaluation license terms and 
 conditions, refer to the License Agreement document located in the license 
 directory in the installation path of this product. If you have licensed this 
 product, ensure the license key is properly registered. You can register the 
 license by using the db2licm command line utility. The license key can be 
 obtained from your licensed product CD.
 01/12/2020 22:25:39     0   0   SQL1063N  DB2START processing was successful.
 SQL1063N  DB2START processing was successful. 
 
7.升级数据库
 1>升级实例后尝试连接库失败：
 [db2inst1@test ~]$ db2 connect to testdb
 SQL5035N  The database must be upgraded to the current release.  
 SQLSTATE=55001
 2>升级数据库
 db2 UPGRADE DATABASE <dbname> USER <user> USING <password>
 [db2inst1@test ~]$ db2 UPGRADE DATABASE testdb                           # [ USER db2inst1 USING passd ]
 DB20000I  The UPGRADE DATABASE command completed successfully.
 3>升级后重建连接数据库，显示新版本，至此升级成功[db2inst1@test ~]$ db2 connect to testdb
   Database Connection Information
 Database server        = DB2/LINUXX8664 10.5.10
  SQL authorization ID   = DB2INST1
  Local database alias   = TESTDB[db2inst1@test ~]$ db2ls
Install Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID 
 ---------------------------------------------------------------------------------------------------------------------
 /opt/ibm/db2/V9.7                9.7.0.11       11                            Wed May  8 00:17:22 2019 CST             0 
 /opt/ibm/db2/V10.5              10.5.0.10       10                            Sun Jan 12 14:11:15 2020 CST             0 
 [db2inst1@test ~]$ db2level
 DB21085I  This instance or install (instance name, where applicable: 
 "db2inst1") uses "64" bits and DB2 code release "SQL1005A" with level 
 identifier "060B010E".
 Informational tokens are "DB2 v10.5.0.10", "s180615", "IP24053", and Fix Pack 
 "10".
 Product is installed at "/opt/ibm/db2/V10.5".[db2inst1@test ~]$ db2 "select count(*) from syscat.tables"
1          
 -----------
         428  1 record(s) selected.

8.升级之后任务，重新rebind package等：

1>找出需要rebind的package:

db2 "select count(*) from syscat.packages where valid <>'Y'"

2>rebind这些package：select 'db2 rebind package '||trim(PKGSCHEMA)||'.'||trim(PKGNAME) from syscat.packages where valid <>'Y' with ur;

或者全部rebind:

db2rbind testdb -l testdb.log all

https://www.ibm.com/support/knowledgecenter/zh/SSEPGG_10.5.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0050543.html