表空间信息:
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 49152
Useable pages = 49148
Used pages = 41056
Free pages = 8092
High water mark (pages) = 41056
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 16
Number of containers = 1
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 128
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 3932160
Useable pages = 3932096
Used pages = 1563520
Free pages = 2368576
High water mark (pages) = 1637792
Page size (bytes) = 8192
Extent size (pages) = 32
Prefetch size (pages) = 256
Number of containers = 2
Minimum recovery time = 2010-03-01-07.31.44.000000
重定向脚本:
RESTORE DATABASE IESDB
FROM '/dbbackup'
DBPATH ON '/iesdb/ies/NODE0000/SQL00001'
ON '/iesdb/sprot'
into sport
NEWLOGPATH '/iesdb/sprot/db2log/'
REPLACE EXISTING
REDIRECT
without rolling forward
WITHOUT PROMPTING
;
SET TABLESPACE CONTAINERS FOR 0
USING (
file '/iesdb/sprot/tbs0' 49152
);
SET TABLESPACE CONTAINERS FOR 2
USING (
file '/iesdb/sprot/tbs2' 3932160
);
报错:
RESTORE DATABASE IESDB FROM '/dbbackup' DBPATH ON '/iesdb/ies/NODE0000/SQL00001' ON '/iesdb/sprot' into sport NEWLOGPATH '/iesdb/sprot/db2log/' REPLACE EXISTING REDIRECT without rolling forward WITHOUT PROMPTING
SQL0104N An unexpected token "ON" was found following "
".
Expected tokens may include: "END-OF-STATEMENT". SQLSTATE=42601
SET TABLESPACE CONTAINERS FOR 0 USING ( file '/iesdb/sprot/tbs0' 49152 )
SQL1024N A database connection does not exist. SQLSTATE=08003
SET TABLESPACE CONTAINERS FOR 2 USING ( file '/iesdb/sprot/tbs2' 3932160 )
SQL1024N A database connection does not exist. SQLSTATE=08003收起