Добрый день.
У меня такая проблема:

Восстанавливаю базу с онлайнового бэкапа на другом сервере (db2 7.2):

db2 create db dbname on f:

RESTORE DATABASE dbname USE TSM TO F: INTO dbname NEWLOGPATH F:\DB WITH 2 BUFFERS BUFFER 1024 REDIRECT

SQL2523W Warning! Restoring to an existing database that is different from the database on the backup image, but have matching names. The target database will be overwritten by the backup version. The Roll-forward recovery logs associated with the target database will be deleted.

Do you want to continue ? (y/n) SQL1277N Restore has detected that one or more table space containers are

inaccessible, or has set their state to 'storage must be defined'.

DB20000I The RESTORE DATABASE command completed successfully.



SET TABLESPACE CONTAINERS FOR 0 USING ( PATH 'F:\dirname\SYSCATSPACE' )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.



SET TABLESPACE CONTAINERS FOR 1 USING ( PATH 'F:\dirname\TEMPSPACE1' )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.



SET TABLESPACE CONTAINERS FOR 3 USING ( PATH 'F:\dirname\TRANZTBLSP' )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.



SET TABLESPACE CONTAINERS FOR 4 USING ( PATH 'F:\dirname\USERSPACE1' )

DB20000I The SET TABLESPACE CONTAINERS command completed successfully.



RESTORE DATABASE dbname CONTINUE

DB20000I The RESTORE DATABASE command completed successfully.


db2 rollforward db dbname to 2007-05-14-01.00.00.000000 and stop

Выдает SQL1271W и 3-е и 4-е табличное пространства висят в rollforward pending.

Подскажите, пож-та, что делаю не так?

Заранее пасиба

[quot Mark Barinstein]Добрый день.
Дайте вывод
list tablespaces show detail
quot]

Вот :
ablespaces for Current Database



Tablespace ID = 0

Name = SYSCATSPACE

Type = System managed space

Contents = Any data

State = 0x0000

Detailed explanation:

Normal

Total pages = 27024

Useable pages = 27024

Used pages = 27024

Free pages = Not applicable

High water mark (pages) = Not applicable

Page size (bytes) = 4096

Extent size (pages) = 32

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) = 16

Number of containers = 1



Tablespace ID = 3

Name = TRANZTBLSP

Type = System managed space

Contents = Any data

State = 0x0080

Detailed explanation:

Roll forward pending

Total pages = 6965020

Useable pages = 6965020

Used pages = 6965020

Free pages = Not applicable

High water mark (pages) = Not applicable

Page size (bytes) = 4096

Extent size (pages) = 32

Prefetch size (pages) = 16

Number of containers = 1

Minimum recovery time = 2007-05-12-22.36.14.000000



Tablespace ID = 4

Name = USERSPACE1

Type = System managed space

Contents = Any data

State = 0x0080

Detailed explanation:

Roll forward pending

Total pages = 1518509

Useable pages = 1518509

Used pages = 1518509

Free pages = Not applicable

High water mark (pages) = Not applicable

Page size (bytes) = 4096

Extent size (pages) = 32

Prefetch size (pages) = 16

Number of containers = 1

Minimum recovery time = 2007-05-12-23.35.38.000000

Вот db2diag.log :

2007-05-17-17.43.45.524000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
data_protection sqlufrol Probe:100 Database:PFP01_H

Rollforward has been initiated

2007-05-17-17.43.45.618000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpForwardRecovery Probe:20 Database:PFP01_H

Invoking database rollforward forward recovery,
lowtranlsn 005117690F44 minbufflsn 0051160B4591

2007-05-17-17.43.45.711000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlprecm Probe:125 Database:PFP01_H

Using parallel recovery with 3 agents 4 QSets 28 queues and 16 chunks


String Title:Redo/undo of nonrecoverable operation.
Table object is being marked not available. PID:332489596 Node:000
Table(3:5)=.

2007-05-17-18.14.28.305000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldChangeLifeLSN Probe:739 Database:PFP01_H
DIA3806C Unexpected end of file was reached.

ZRC=0xFFFFF609

2007-05-17-18.14.28.399000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldChangeLifeLSN Probe:741 Database:PFP01_H

New Life should be:0051 29a6 5540 .Q)¦U@


2007-05-17-18.14.28.477000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldChangeLifeLSN Probe:743 Database:PFP01_H

Error changing life of object.0300 0500 0300 0500 0100 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 a700 0000 0000 0000 ........§.......
0010 0000 2000 0000 0100 0000 0300 0501 .... ...........
6801 eb2e 3000 212f h.л.0.!/


2007-05-17-18.14.28.711000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
database_utilities sqlu_change_obj_values Probe:200 Database:PFP01_H
DIA9999E An internal error occurred. Report the following error code : "".
ALERT :5

Data Title:Obj Description PID:332489596 TID:9596 Node:000
0300 0500 0300 0500 0100 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 a700 0000 0000 0000 ........§.......
0010 0000 2000 0000 0100 0000 0300 0501 .... ...........
6801 eb2e 3000 212f h.л.0.!/


2007-05-17-18.14.28.868000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
database_utilities DIAG_ERROR Probe:0 Database:PFP01_H

Error!!! -2551, 00000000, Detected in file: d:\db2bld\src\sqluvppo.c, line 1367

Data Title:first object PID:332489596 TID:9596 Node:000
0100 0000 ....


Data Title:last object PID:332489596 TID:9596 Node:000
0100 0000 ....


Data Title:Obj List PID:332489596 TID:9596 Node:000
0300 0500 0300 0500 0100 0000 0051 29a5 .............Q)Ґ
1b25 0000 0000 0000 0000 0000 0000 0000 .%..............
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........


2007-05-17-18.14.29.196000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldmrdo Probe:701 Database:PFP01_H

Tablespace 3 removed from rollforward set due to error xFFFFF609

String Title:Redo/undo of nonrecoverable operation.
Table object is being marked not available. PID:332489596 Node:000
Table(4:671)=.

2007-05-17-18.14.35.899000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldChangeLifeLSN Probe:739 Database:PFP01_H
DIA3806C Unexpected end of file was reached.

ZRC=0xFFFFF609

2007-05-17-18.14.35.946000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldChangeLifeLSN Probe:741 Database:PFP01_H

New Life should be:0051 2aae 74d6 .Q*®tЦ


2007-05-17-18.14.36.024000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldChangeLifeLSN Probe:743 Database:PFP01_H

Error changing life of object.0400 9f02 0400 9f02 0100 0000 0000 0000 ..џ...џ.........
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 a700 0000 0000 0000 ........§.......
0010 0000 2000 0000 0100 0000 0400 9f03 .... .........џ.
6801 eb2e 3000 212f h.л.0.!/


2007-05-17-18.14.36.149000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
database_utilities sqlu_change_obj_values Probe:200 Database:PFP01_H
DIA9999E An internal error occurred. Report the following error code : "".
ALERT :5

Data Title:Obj Description PID:332489596 TID:9596 Node:000
0400 9f02 0400 9f02 0100 0000 0000 0000 ..џ...џ.........
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0101 0000 a700 0000 0000 0000 ........§.......
0010 0000 2000 0000 0100 0000 0400 9f03 .... .........џ.
6801 eb2e 3000 212f h.л.0.!/


2007-05-17-18.14.36.290000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
database_utilities DIAG_ERROR Probe:0 Database:PFP01_H

Error!!! -2551, 00000000, Detected in file: d:\db2bld\src\sqluvppo.c, line 1367

Data Title:first object PID:332489596 TID:9596 Node:000
0100 0000 ....


Data Title:last object PID:332489596 TID:9596 Node:000
0100 0000 ....


Data Title:Obj List PID:332489596 TID:9596 Node:000
0400 9f02 0400 9f02 0100 0000 0051 2aaa ..џ...џ......Q*Є
bd59 0000 0000 0000 0000 0000 0000 0000 ЅY..............
0000 0000 0101 0000 2700 0000 0000 0000 ........'.......
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........


2007-05-17-18.14.36.540000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
data_management sqldmrdo Probe:701 Database:PFP01_H

Tablespace 4 removed from rollforward set due to error xFFFFF609

2007-05-17-18.36.59.930000 Instance:DB2 Node:000
PID:3324824316(db2syscs.exe) TID:24316 Appid:none
data_protection sqlpgart Probe:490

User Exit returned error when retrieving log file S0000617.LOG to F:\DB\ for database PFP01_H, error code 1

2007-05-17-18.37.00.040000 Instance:DB2 Node:000
PID:332489596(db2syscs.exe) TID:9596 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpPRecReadLog Probe:60 Database:PFP01_H
DIA3737C Error occurred while retrieving file during forward recovery.

ZRC=0xFFFFE522

2007-05-17-18.37.01.477000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
data_protection sqlufrol Probe:130 Database:PFP01_H

Rollforward iteration completed

2007-05-17-18.38.31.071000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
data_protection sqlufrol Probe:100 Database:PFP01_H

Rollforward has been initiated

2007-05-17-18.38.31.133000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpForwardRecovery Probe:20 Database:PFP01_H

Invoking database rollforward forward recovery,
lowtranlsn 0051BA3E0975 minbufflsn 0051B8DD42AC

2007-05-17-18.38.31.196000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlprecm Probe:125 Database:PFP01_H

Using parallel recovery with 3 agents 4 QSets 28 queues and 16 chunks


2007-05-17-18.38.38.915000 Instance:DB2 Node:000
PID:3324824316(db2syscs.exe) TID:24316 Appid:none
data_protection sqlpgart Probe:490

User Exit returned error when retrieving log file S0000617.LOG to F:\DB\ for database PFP01_H, error code 1

2007-05-17-18.38.39.008000 Instance:DB2 Node:000
PID:3324820156(db2syscs.exe) TID:20156 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpPRecReadLog Probe:60 Database:PFP01_H
DIA3737C Error occurred while retrieving file during forward recovery.

ZRC=0xFFFFE522

2007-05-17-18.38.39.165000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpForwardRecovery Probe:50 Database:PFP01_H

Invoking database rollforward backward recovery, nextlsn: 0051 ba3e 7ff1 .Qє>.с


2007-05-17-18.38.39.305000 Instance:DB2 Node:000
PID:3324819032(db2syscs.exe) TID:19032 Appid:none
data_protection sqlpgwlp Probe:910

Ping pong EOL. Dump will follow.
Dump File:C:\SQLLIB72\DB2\33248190.000 Data:SQLP_DBCB

2007-05-17-18.38.51.336000 Instance:DB2 Node:000
PID:3324824316(db2syscs.exe) TID:24316 Appid:none
data_protection sqlpgart Probe:490

User Exit returned error when archiving log file S0000616.LOG from F:\DB\ for database PFP01_H, error code 1

2007-05-17-18.38.51.461000 Instance:DB2 Node:000
PID:3324824316(db2syscs.exe) TID:24316 Appid:none
data_protection sqlpgart Probe:490

Error received from userexit program.
DB2 will not call userexit program for this database for 5 minutes.

2007-05-17-18.38.53.258000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpForwardRecovery Probe:10 Database:PFP01_H

Disabled tablespace: 0300 ..


2007-05-17-18.38.53.321000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
recovery_manager sqlpForwardRecovery Probe:10 Database:PFP01_H

Disabled tablespace: 0400 ..


2007-05-17-18.38.53.399000 Instance:DB2 Node:000
PID:3324827192(db2syscs.exe) TID:27192 Appid:*LOCAL.DB2.070517093518
data_protection sqlufrol Probe:130 Database:PFP01_H

Rollforward iteration completed

2007-05-17-18.38.53.461000 Instance:DB2 Node:000
PID:3324819032(db2syscs.exe) TID:19032 Appid:none
data_protection sqlpgspr Probe:2022

Error 1288 when searching message queue for archived logs. Ignore this error.