db2 version 8 migration steps

coolwinds

These steps do not include replication migration

1> Save config information
2> Set db2 diag level to 4
db2 update dbm configuration using diaglevel 4
3> Take Application & db down
Stop the DB2 license service by entering the db2licd -end command
db2 terminate
db2 force applications
db2stop
4> Take offline backup
5> Install db2 version 8 and fixpacks
6> Migrate instance
20 MB of /tmp free space needed The instance migration trace file is written to /tmp
db2ckmig command manually and resolve any problems as instance id
/usr/opt/db2_08_01/bin/db2ckmig -h -l ~/migration.log
db2imigr instx (needs root) this command dosent complete if you are in the dce directory, you need to change to the code director
sudo /usr/opt/db2_08_01/instance/db2imigr -d -a server -u <instance_id> <instance_name> 2>&1 | tee /tmp/db2imigr.out
7> Migrate db and bind
db2 migrate db <dbname>
cd sqllib/bnd
db2 "bind @db2ubind.lst blocking all grant public"
db2 "bind @db2cli.lst blocking all grant public sqlerror continue"
8> Convert indexes to type 2
db2 "select 'reorg indexes all for table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,40),'convert;'from syscat.tables where type = 'T' " >convert.out

pg convert.out |grep -e reorg >convert.ddl
db2 -stvf convert.ddl -z convert.ddl.out
9>runstats
db2 "select 'runstats on table',substr(rtrim(tabschema)||'.'||rtrim(tabname),1,40),'and indexes all shrlevel change;'from syscat.tables where type = 'T' " >runstats.out

pg runstats.out |grep -e runstats >runstats.ddl
db2 -stvf runstats.ddl -z runstats.ddl.out
10>(Revoke EXECUTE privileges on external stored procedures that contain SQL data access from PUBLIC. During database migration, EXECUTE privileges are granted to PUBLIC for all existing functions, methods, and external stored procedures.
db2undgp - r
11> Set db2 diag level to 3
12> application testing
13> Take offline backup

bpmfhu

不错 可以作为参考

diablo2

If installed fixpak later than fp10(include) , should bind db2schema.bnd

coolwinds

最初由 diablo2 发布
[B]If installed fixpak later than fp10(include) , should bind db2schema.bnd [/B]

YES, you are right !

        db2 terminate
        db2 CONNECT TO <dbname>
       db2 BIND <path>/@db2ubind.lst BLOCKING ALL GRANT PUBLIC ACTION ADD
        db2 terminate