I tried to test this process on my personal laptop. Could you help me to take a look where is the problem as below?
1. I created a source database, name: db100 <-- db2 create db db100
2. Collect the source database tablespace containers’ information <-- db2 list tablespace containers for 0 show detail
Then I got as below
Tablespace Containers for Tablespace 0
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000000 \C0000000.CAT
Type = File
Total pages = 16384
Useable pages = 16380
Accessible = Yes
Tablespace Containers for Tablespace 1
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000001 \C0000000.TMP
Type = Path
Total pages = 1
Useable pages = 1
Accessible = Yes
Tablespace Containers for Tablespace 2
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000002 \C0000000.LRG
Type = File
Total pages = 8192
Useable pages = 8160
Accessible = Yes
Tablespace Containers for Tablespace 3
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000003 \C0000000.LRG
Type = File
Total pages = 8192
Useable pages = 8188
Accessible = Yes
Tablespace Containers for Tablespace 4
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000004 \C0000000.UTM
Type = Path
Total pages = 1
Useable pages = 1
Accessible = Yes
3. I have db100 backup file in C:/DB2/BACKUP
4. I plan to use db100 backup to restore a non-exist database, names db200. I follow the process as below
(1) db2 “restore db db100 incremental automatic from C:/DB2/BACKUP/ taken at 20070914143003 into db200 with 4 buffers redirect”
(Message)
SQL1227W A redirected restore operation is being performed. Table space configuration can now be viewed and table space that
do not use automatic storage can have their containers reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.
(2) db2 “set tablespace containers for 0 using (file ‘C:\DB2\NODE000 0\DB200\T000000 0\C0000000.CAT’ 20000)”
(Message)
SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 <-- Here is where I stopped.
What's the problem on 4(2)? How can I correct my command? Where is possibly I missed? Do you have suggestion?
Thanks so much. I am very appreciated.
Cheers,
1. I created a source database, name: db100 <-- db2 create db db100
2. Collect the source database tablespace containers’ information <-- db2 list tablespace containers for 0 show detail
Then I got as below
Tablespace Containers for Tablespace 0
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000000 \C0000000.CAT
Type = File
Total pages = 16384
Useable pages = 16380
Accessible = Yes
Tablespace Containers for Tablespace 1
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000001 \C0000000.TMP
Type = Path
Total pages = 1
Useable pages = 1
Accessible = Yes
Tablespace Containers for Tablespace 2
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000002 \C0000000.LRG
Type = File
Total pages = 8192
Useable pages = 8160
Accessible = Yes
Tablespace Containers for Tablespace 3
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000003 \C0000000.LRG
Type = File
Total pages = 8192
Useable pages = 8188
Accessible = Yes
Tablespace Containers for Tablespace 4
Container ID = 0
Name = C:\DB2\NODE0000 \DB100\T0000004 \C0000000.UTM
Type = Path
Total pages = 1
Useable pages = 1
Accessible = Yes
3. I have db100 backup file in C:/DB2/BACKUP
4. I plan to use db100 backup to restore a non-exist database, names db200. I follow the process as below
(1) db2 “restore db db100 incremental automatic from C:/DB2/BACKUP/ taken at 20070914143003 into db200 with 4 buffers redirect”
(Message)
SQL1227W A redirected restore operation is being performed. Table space configuration can now be viewed and table space that
do not use automatic storage can have their containers reconfigured.
DB20000I The RESTORE DATABASE command completed successfully.
(2) db2 “set tablespace containers for 0 using (file ‘C:\DB2\NODE000 0\DB200\T000000 0\C0000000.CAT’ 20000)”
(Message)
SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an automatic storage table space. SQLSTATE=55061 <-- Here is where I stopped.
What's the problem on 4(2)? How can I correct my command? Where is possibly I missed? Do you have suggestion?
Thanks so much. I am very appreciated.
Cheers,