环境说明

迁移步骤

查询生产库DIDB对应的表空间及容器

[sale_db@/home/db2inst1]db2 list tablespaces show detail | egrep -i 'id|name|total'
 Tablespace ID                        = 0
 Name                                 = SYSCATSPACE
 Total pages                          = 16384
 Tablespace ID                        = 1
 Name                                 = TEMPSPACE1
 Total pages                          = 1
 Tablespace ID                        = 2
 Name                                 = USERSPACE1
 Total pages                          = 9428992
 Tablespace ID                        = 3
 Name                                 = SYSTOOLSPACE
 Total pages                          = 333
 Tablespace ID                        = 4
 Name                                 = TEMPSPACE2
 Total pages                          = 1
 Tablespace ID                        = 5
 Name                                 = USERSPACE2
 Total pages                          = 359
 Tablespace ID                        = 6
 Name                                 = USERTMPNAME1
 Total pages                          = 1
 Tablespace ID                        = 7
 Name                                 = SYSTOOLSTMPSPACE
 Total pages                          = 1
[sale_db@/home/db2inst1]for i in 0 1 2 3 4 5 6 7;do db2 list tablespace containers for $i; done
 
            Tablespace Containers for Tablespace 0
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000000/C0000000.CAT
 Type                                 = File
 
 
 
            Tablespace Containers for Tablespace 1
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000001/C0000000.TMP
 Type                                 = Path
 
 
 
            Tablespace Containers for Tablespace 2
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000002/C0000000.LRG
 Type                                 = File
 
 
 
            Tablespace Containers for Tablespace 3
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000003
 Type                                 = Path
 
 
 
            Tablespace Containers for Tablespace 4
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000004
 Type                                 = Path
 
 
 
            Tablespace Containers for Tablespace 5
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000005
 Type                                 = Path
 
 
 
            Tablespace Containers for Tablespace 6
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000006
 Type                                 = Path
 
 
 
            Tablespace Containers for Tablespace 7
 
 Container ID                         = 0
 Name                                 = /home/webdb/bidb/db2inst1/NODE0000/BIDB/T0000007
 Type                                 = Path
 

备机创建相应容器目录

mkdir /db2_data_inst2/BIDB 只需要到这个目录 子目录会自动创建

restore数据库

db2inst2@/db2_data_inst2 $>db2 "RESTORE DATABASE BIDB FROM '/db2_data_inst2' TAKEN AT 20150311174015 on '/db2_data_inst2/BIDB' INTO BIDB REDIRECT"
SQL1277W  A redirected restore operation is being performed.  Table space 
configuration can now be viewed and table spaces that do not use automatic 
storage can have their containers reconfigured.
DB20000I  The RESTORE DATABASE command completed successfully.

重定向原path目录

db2 "set tablespace containers for 0 using (file '/db2_data_inst2/BIDB/SYSCATSPACE' 16384)"
db2 "set tablespace containers for 1 using (path '/db2_data_inst2/BIDB/TEMPSPACE1' )" 
db2 "set tablespace containers for 2 using (file '/db2_data_inst2/BIDB/USERSPACE1' 9428992)"
db2 "set tablespace containers for 3 using (path '/db2_data_inst2/BIDB/SYSTOOLSPACE' )"
db2 "set tablespace containers for 4 using (path '/db2_data_inst2/BIDB/TEMPSPACE2' )"
db2 "set tablespace containers for 5 using (path '/db2_data_inst2/BIDB/USERSPACE2' )"
db2 "set tablespace containers for 6 using (path '/db2_data_inst2/BIDB/USERTMPNAME1' )"
db2 "set tablespace containers for 7 using (path '/db2_data_inst2/BIDB/SYSTOOLSTMPSPACE' )"
 
 
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 0 using (file '/db2_data_inst2/BIDB/SYSCATSPACE' 16384)"
SQL20319N  The SET TABLESPACE CONTAINERS command is not allowed on an 
automatic storage table space.  SQLSTATE=55061
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 1 using (path '/db2_data_inst2/BIDB/TEMPSPACE1' )" 
SQL20319N  The SET TABLESPACE CONTAINERS command is not allowed on an 
automatic storage table space.  SQLSTATE=55061
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 2 using (file '/db2_data_inst2/BIDB/USERSPACE1' 9428992)"
SQL20319N  The SET TABLESPACE CONTAINERS command is not allowed on an 
automatic storage table space.  SQLSTATE=55061
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 3 using (path '/db2_data_inst2/BIDB/SYSTOOLSPACE' )"
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 4 using (path '/db2_data_inst2/BIDB/TEMPSPACE2' )"
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 5 using (path '/db2_data_inst2/BIDB/USERSPACE2' )"
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 6 using (path '/db2_data_inst2/BIDB/USERTMPNAME1' )"
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.
db2inst2@/db2_data_inst2 $>db2 "set tablespace containers for 7 using (path '/db2_data_inst2/BIDB/SYSTOOLSTMPSPACE' )"
DB20000I  The SET TABLESPACE CONTAINERS command completed successfully.   

执行恢复

db2inst2@/db2_tag_inst2/db2inst2 $>db2 "restore db BIDB continue"
SQL2555I  The database was restored and then successfully upgraded to the 
current DB2 release where you issued the RESTORE DATABASE command.

创建归档路径

root@/ #>mkdir /db2_arch_inst1/log_BIDB/
root@/ #>chown db2inst2:db2grp1 /db2_arch_inst1/log_BIDB/

更新归档路径

db2inst2@/db2_tag_inst2/db2inst2 $>db2 update db cfg for BIDB using logarchmeth1 'disk:/db2_arch_inst1/log_BIDB/'
DB20000I  The UPDATE DATABASE CONFIGURATION command completed successfully.

升级数据库

db2inst2@/db2_tag_inst2/db2inst2 $>db2 migrate db BIDB
SQL1103W  The UPGRADE DATABASE command was completed successfully.
db2inst2@/db2_tag_inst2/db2inst2 $>db2 connect to BIDB
 
   Database Connection Information
 
 Database server        = DB2/AIX64 9.7.0
 SQL authorization ID   = DB2INST2
 Local database alias   = BIDB

切换归档

db2inst2@/db2_tag_inst2/db2inst2 $>db2 terminate
DB20000I  The TERMINATE command completed successfully.
db2inst2@/db2_tag_inst2/db2inst2 $>db2 archive log for db BIDB 
DB20000I  The ARCHIVE LOG command completed successfully.
db2inst2@/db2_tag_inst2/db2inst2 $>db2 archive log for db BIDB   
DB20000I  The ARCHIVE LOG command completed successfully.
db2inst2@/db2_tag_inst2/db2inst2 $>