I am trying to restore a DB2 9.1 fp2 backup to another DB2 9.1 fp2 machine, both are on Windows.
Expand|Select|Wrap|Line Numbers
- C:\Program Files\IBM\SQLLIB\BIN>db2 -tvf C:\db2_data\test.db2
- UPDATE COMMAND OPTIONS USING S ON Z ON MYDB_NODE0000.out V ON
- DB20000I The UPDATE COMMAND OPTIONS command completed successfully.
- SET CLIENT ATTACH_DBPARTITIONNUM 0
- DB20000I The SET CLIENT command completed successfully.
- SET CLIENT CONNECT_DBPARTITIONNUM 0
- DB20000I The SET CLIENT command completed successfully.
- RESTORE DATABASE mydb FROM 'C:\' TAKEN AT 20080310154100 INTO mydb REDIRECT WITHOU
- T ROLLING FORWARD
- 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.
- SET TABLESPACE CONTAINERS FOR 2 USING ( FILE 'C:\db2_data\userspace1'
- 256000 )
- DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
- SET TABLESPACE CONTAINERS FOR 3 USING ( FILE 'C:\db2_data\regtbs'
- 768000 )
- DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
- SET TABLESPACE CONTAINERS FOR 4 USING ( FILE 'C:\db2_data\idxtbs'
- 128000 )
- DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
- SET TABLESPACE CONTAINERS FOR 5 USING ( FILE 'C:\db2_data\lobtbs'
- 512000 )
- DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
- SET TABLESPACE CONTAINERS FOR 6 USING ( PATH 'C:\db2_data\testspace' )
- DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
- RESTORE DATABASE mydb CONTINUE
- 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.
1. The script is generated by db2
2. I manually run the above commands too, got the same problem
3. There are 0~7 tablespace containers, but 0, 1, and 7 are automatic storage tablespace,
e.g.
Expand|Select|Wrap|Line Numbers
- db2 => set tablespace containers for 7 using (file "C:\db2_data\C0000000.LRG" 32)
- SQL20319N The SET TABLESPACE CONTAINERS command is not allowed on an
- automatic storage table space. SQLSTATE=55061
Any suggestion/help is appreciated!