以下的文章主要向大家讲述的是DB2重定向恢复失败(自动存储)的实际操作，其中包括对表空间信息，重定向脚本以及报错等相关内容的描述，以下就是对DB2重定向恢复失败(自动存储)的实际操作的具体描述。
自动, 失败
表空间信息：
- 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 "<character-string>".
- 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
以上的相关内容就是对DB2重定向恢复失败(自动存储)的介绍，望你能有所收获。
【编辑推荐】
