dms, index destroyed, pls help

[Hardy]

Hi, there's a db with 32 partitions. on the 22nd partition, all the index is
located on a dms device container. due to some man-made mistakes, the data
on the container is totally destroyed. then the access to the tables with
indexes all went wrong... how can I deal with it?

the whole db size is about 13T...

thanks in advance:)

[Pierre Saint-Jacques]

As best as I know, tables where the dataST be rolled forward within the
same command.
As all tablespaces must bi in RF state, I think your only resort is to
take your most recent backup (db or tablepsace), restore both the
tablespaces of the data and index and then roll both forward in the same
command to end of logs.
Restore and rollforward have been designed to take care of man-made
mistakes and are a great help to recover from acts of god!!!!
HTH, Pierre.

Hardy wrote:

Hi, there's a db with 32 partitions. on the 22nd partition, all the index is
located on a dms device container. due to some man-made mistakes, the data
on the container is totally destroyed. then the access to the tables with
indexes all went wrong... how can I deal with it?

the whole db size is about 13T...

thanks in advance:)

--
Pierre Saint-Jacques - Reply to: sescons at attglobal dot net
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.