DB2重定向恢復失敗“水到渠成”
作者：佚名
我們今天主要向大家講述的是是DB2重定向恢復失敗(自動存儲)的實際操作，以及對其在操作過程中要用到的操作代碼的描述。
以下的文章主要向大家講述的是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重定向恢復失敗(自動存儲)的介紹，望你能有所收獲。
【編輯推薦】
責任編輯：佚名
來源：
互聯網
