467,209 Members | 1,352 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

The Question about REDIRECT RESTORE

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\NODE0000\DB200\T0000000\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,
Aug 16 '07 #1
  • viewed: 3604
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Tsai Li Ming | last post: by
11 posts views Thread by Chris | last post: by
3 posts views Thread by jclark0731 | last post: by
2 posts views Thread by vj_dba | last post: by
1 post views Thread by Greg Nash | last post: by
3 posts views Thread by sharon.zhang.ca@gmail.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.