Hi,

I am trying to restore a tablespace from a tablespace backup image
using following command.
db2 " restore db G2P01 tablespace ( G2P01TB37 ) online from
/db2_backups taken at 20040213070850 ".

db2 " rollforward database G2P01 to 2004-02-13-07.08.50.000000 and
stop tablespace (G2P01TB37) online "

It gives me error: SQL4906N The list of table space names specified
is an incomplete set for the rollforward operation.

Please could you help me.

Regards,
APK

APK <pranay@iiitb.ac.in> wrote:

> Hi,
>
> I am trying to restore a tablespace from a tablespace backup image
> using following command.
> db2 " restore db G2P01 tablespace ( G2P01TB37 ) online from
> /db2_backups taken at 20040213070850 ".
>
> db2 " rollforward database G2P01 to 2004-02-13-07.08.50.000000 and
> stop tablespace (G2P01TB37) online "
>
> It gives me error: SQL4906N The list of table space names specified
> is an incomplete set for the rollforward operation.

My guess would be that you violate this rule:

o For point-in-time table space recovery, a self-contained list
of table space names must be specified. The table spaces in
the list must contain all objects of every table included in
the table spaces.


Does the tablespace that you want to recover contain any tables which are
spread over multiple tablespaces, i.e. index and/or lob data does not
reside in G2P01TB37?

--
Knut Stolze
Information Integration
IBM Germany / University of Jena