DB2 upgrade from V9.5 to V9.7
有个新项目要upgrade V9.5 to V9.7， OS是AIX，正好有个testing environment是linux，准备自己测试一下先。开个帖子，看看大家有没有什么建议意见，可以测试或需要注意的点。Step 1. download code binary V9.5 & V9.7 (Linux) from IBM.
DB2_ESE_V95_Linux_x86-64.tar
DB2_ESE_97_Linux_x86-64.tar.gz
-- 持续更新中
DB2_ESE_V95_Linux_x86-64.tar
DB2_ESE_97_Linux_x86-64.tar.gz
-- 持续更新中
6同行回答
OK. Update一下downgrade.
经过官方确认，downgrade from V9.7 -> V9.5，IBM没有提供官方的脚本，只能drop V9.7 instance, and then create V9.5 instance, restore the offline BACKUP which was taken before upgrade.
而downgrade from V9.5 FP10 -> V9.5 FP6这种level，可以使用db2iupdt -D。而且我也验证过了，确实可行。收起
经过官方确认，downgrade from V9.7 -> V9.5，IBM没有提供官方的脚本，只能drop V9.7 instance, and then create V9.5 instance, restore the offline BACKUP which was taken before upgrade.
而downgrade from V9.5 FP10 -> V9.5 FP6这种level，可以使用db2iupdt -D。而且我也验证过了，确实可行。收起
浏览999
Upgrade已经完成，更新一下process as below. 不过碰到一个问题在写backout plan about how to downgrade。我尝试了使用V9.5的db2iupdt -D ，不过fail了。官方文档也没有提到这个，有没有人有经验？我知道可以drop V9.7 instance, create new V9.5, 然后恢复DB，不过这样的话，还得重新配置很多CFG，是否有快速命令，因为我看到db2iupgrade有一个backup folder， SQLLIB_V95。不知是否有其他快速方法downgrade.
[BACKUP CFG before Upgrade]
[check index type 1]
[pre-check]
[Run upgrade precheck. ]
[stop DB]
[stop license]
[upgrade instance]
[upgrade DAS] - ignore
[upgrade DB]
[grant secadm perrmission]
[rebind packages]
[check tablespace type and size]
[Apply license]收起
[BACKUP CFG before Upgrade]
[check index type 1]
[pre-check]
[Run upgrade precheck. ]
[stop DB]
[stop license]
[upgrade instance]
[upgrade DAS] - ignore
[upgrade DB]
[grant secadm perrmission]
[rebind packages]
[check tablespace type and size]
[Apply license]收起
浏览1006