Error restoring db2 tablespace
2006-07-26 09:29:09
!-- DIV {margin:0px;}-->Hi list,
I am getting the following error when trying to restore a particular tablespace
using the "point in time recovery" using the command line:
db2 => RESTORE db TJ tablespace ( TS4K_ADM_01 ) use tsm taken at 20060724024813
SQL2542N No match for a database image file was found based on the source
database alias "TJ" and timestamp "20060724024813" provided.
I've tried many different timestamps with the same result, even the ones that
show a successful backup.
Checking the "list history" command output I've noticed the following error:
----------------------------------------------------------------------------
Comment: RESTORE TJ NO RF
Start Time: 20060725173903
End Time: 20060725173904
----------------------------------------------------------------------------
00044 Location:
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -2542 sqlerrml: 17
sqlerrmc: TJÿ20060724024813
sqlerrp : sqludMRR
sqlerrd : (1) 0 (2) 0 (3) 0
(4) 0 (5) 0 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
The environment is TSM Server 5.2.2 running on AIX. DB2 also on AIX.
Please advise.
Any help is appreciated.
Thanks.
Mario
|
|
|