ADSM-L

Error restoring db2 tablespace

2006-07-25 23:20:49
Subject: Error restoring db2 tablespace
From: Mario Behring <mariobehring AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 25 Jul 2006 20:19:23 -0700
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:
 
 
 
 
Please advise.

Any help is appreciated.

Thanks.

Mario

<Prev in Thread] Current Thread [Next in Thread>