How to perform rollforward after having restored db2 v8.1 data into db2 v9.7?

[ramkoppu]

1) db2 => rollforward database emasdb stop
SQL5035N The database must be upgraded to the current release.SQLSTAT E=55001

2)[root@localhost instance]# ./db2imigr db2fenc1 db2inst1
Missing value for token[0].
Missing value for token[0].
DBI1392W The s command is deprecated. The
deprecated command is replaced by new command
s.
Please help me, please provide me steps to upgrade v8.1 data to V9.7,

V9.7 datalevel ==

[db2inst1@localh ost ~]$ db2 get dbm cfg|grep -i "release level"
Database manager configuration release level = 0x0d00

Restored data(v8.1) level is =====


[db2inst1@localh ost ramm]$ db2ckbkp -H EMASDB.0.db2ins t1.NODE0000.CAT N0000.201008312 32702.001 |grep Release
Release ID -- A00

[mreumann]

I recommend to patch your source DB to 8.2 FP15 before migrating.

[ramkoppu]

hi mreumann,
Can I directly install 8.2 FP 15 on v8.1?? will db2 v8.1 support the v8.2 FP 15 patch??

[vijay2082]

Hi,

Probably you are confused about migration( instance upgrade and database rollforward). Refer below link for complete steps in migration which involves your instance and the database migration.

** regarding database rollforward, its strongly recommended to take a full backup of DB2 V8 database and then restore it on V9.7 instance.

http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21200005

Refer below section from teh above link :

"If you are Upgrading from DB2 UDB Version 8.1 to DB2 Version 9.7, review also the DB2 UDB Version 8.2 upgrade considerations technote. In addition to the changes in Upgrading to DB2 Version 9.7, you might need to address the changes and conversions that happen when you install DB2 UDB Version 8.2 (DB2 UDB Version 8.1 FixPak 7) or a higher level on a DB2 server that already has DB2 UDB Version 8.1 installed up to FixPak 6 level. "


Cheers, Vijay