By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

The Question about REDIRECT RESTORE

P: 8
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
Share this question for a faster answer!
Share on Google+

Post your reply

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