$ db2 -tvf restore_iesxhls.sql
RESTORE DATABASE IESXH FROM /dbback TAKEN AT 20091113113945 TO /rptdb/iesxhls_sp
ace WITH 2 BUFFERS BUFFER 1024 REDIRECT WITHOUT ROLLING FORWARD WITHOUT PROMPTI
NG
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 0 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
ATH '/rptdb/iesxhls_space/SYSCATSPACE')
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 1 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
ATH '/rptdb/iesxhls_space/TEMPSPACE1')
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 2 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
ATH '/rptdb/iesxhls_space/USERSPACE1')
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 3 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
ATH /rptdb/iesxhls_space/TOOLTB)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 4 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
ATH /rptdb/iesxhls_space/SYSTOOLSTMPSPACE)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 6 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (F
ILE /rptdb/iesxhls_space/DATA_2 100000)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 7 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (F
ILE '/rptdb/iesxhls_space/rsale1' 1000000, FILE '/rptdb/iesxhls_space/rsale2' 10
00000,FILE '/rptdb/iesxhls_space/rsale3' 1000000)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
SET TABLESPACE CONTAINERS FOR 8 IGNORE ROLLFORWARD CONTAINER OPERATIONS USING (P
ATH /rptdb/iesxhls_space/TB8)
DB20000I The SET TABLESPACE CONTAINERS command completed successfully.
RESTORE DATABASE IESXH 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.
$ db2 list tablespaces
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = System managed space
Contents = All permanent data. Regular table space.
State = 0x2000100
Detailed explanation:
Restore pending
Storage may be defined
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x2000100
Detailed explanation:
Restore pending
Storage may be defined
Tablespace ID = 2
Name = USERSPACE1
Type = System managed space
Contents = All permanent data. Regular table space.
State = 0x2000100
Detailed explanation:
Restore pending
Storage may be defined