tablespace restore pending

[#1]

Hi, experts

While redirect restore, I didnot pay attention to the tablespace states and started the rollforward and started the sap instance.

Checked the log and found out the one of the z-tablespace was offline and it is still restore pending status.

Since the tablespace is not important to typical business transactions, I do not want to restore the whole database and start from scratch.

I am considering the tablespace restore.

What options do I have?

Thanks for the sugguestions in advance.

[paul_power]

Hi,

You can restore the particular tablespace and rollforward to bring it in line with the rest of the tablespaces.

Here is the info centre guide for v9.7, please adjust if you are using a different release:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.cmd.do...

regards,

Paul

[Former Member]

Hi, Paul

The database is already not pending status.

I can switch the tablespace to online, of course, however, how can I rollforward the tablespace ?

The URL does not explain what to do.

Maybe I cannot understand the explanation.

Can you elaborate the steps I need to take?