- 论坛徽章:
- 0
|
一次数据库迁移的过程记录,并请高人指教
不同管理方式的container不能做重定向!
白天做测试,刚刚做了个重定向,是DMS之间的:
源平台 :AIX4.3.3+DB2 7.2
目标平台:AIX5.2 +DB2 8.2
源库的SYSCATSPACE和TEMPSPACE都是SMS管理,USERSPACE1是DMS管理的LV,重定向库的SYSCATSPACE和TEMPSPACE都是SMS管理,USERSPACE1是DMS管理的FILE!
以下是源库情况及重定向脚本!
- CU.mymm >; db2 list tablespaces show detail
- Tablespaces for Current Database
- Tablespace ID = 0
- Name = SYSCATSPACE
- Type = System managed space
- Contents = Any data
- State = 0x0000
- Detailed explanation:
- Normal
- Total pages = 3584
- Useable pages = 3584
- Used pages = 3584
- Free pages = Not applicable
- High water mark (pages) = Not applicable
- Page size (bytes) = 4096
- Extent size (pages) = 32
- Prefetch size (pages) = 32
- Number of containers = 1
- Tablespace ID = 1
- Name = TEMPSPACE1
- Type = System managed space
- Contents = System Temporary data
- State = 0x0000
- Detailed explanation:
- Normal
- Total pages = 1
- Useable pages = 1
- Used pages = 1
- Free pages = Not applicable
- High water mark (pages) = Not applicable
- Page size (bytes) = 4096
- Extent size (pages) = 8
- Prefetch size (pages) = 32
- Number of containers = 1
- Tablespace ID = 2
- Name = USERSPACE1
- Type = Database managed space
- Contents = Any data
- State = 0x0000
- Detailed explanation:
- Normal
- Total pages = 524288
- Useable pages = 524256
- Used pages = 482304
- Free pages = 41952
- High water mark (pages) = 482304
- Page size (bytes) = 4096
- Extent size (pages) = 32
- Prefetch size (pages) = 32
- Number of containers = 1
- CU.mymm >; db2 list tablespace containers for 2 show detail
- Tablespace Containers for Tablespace 2
- Container ID = 0
- Name = /dev/rmycont00lv
- Type = Disk
- Total pages = 524288
- Useable pages = 524256
- Accessible = Yes
- CU.mymm >;
复制代码
Script:
- restore db mydbs
- newlogpath /tstdbs/myDB/log/ buffer 2048 replace existing redirect parallelism 6 without rolling forward;
- set tablespace containers for 0 using (path '/tstdbs/myDB/catalog/');
- set tablespace containers for 1 using (path '/tstdbs/myDB/tmp/');
- set tablespace containers for 2 using (file '/tstdbs/myDB/con/mycont001' 250000 , file '/tstdbs/myDB/con/mycont002' 250000 );
- restore db mydbs continue;
- terminate;
复制代码
参考一下吧! |
|