Folks,

        Thank you all for your quick replies about getting a table space out
of "Load Pending" state last night. The load with a DEV/NULL did the trick.
But I am still having an issue with two table spaces. Hopefully you folks
can help again.

        Two table spaces went into "Restore Pending" state. I did the
restore using an ADSM backup and they then went into "Roll-Forward Pending"
state. I tried to do the Rollforward database with the table space listed
and I kept getting the SQL1272N error. I tried to do the rollforward with
one table space in the list, with both of them, and also with the tablespace
Online option and not specify the tables spaces. No matter how I do it, I
get the SQL1272N and the table spaces go back into "Restore Pending" state.

        The syntax I used was:

                rollforward db pmprod to end of logs on node (0) and
complete tablespace online              
                rollforward db pmprod to end of logs on node (0) and
complete tablespace (datas_ts)
                rollforward db pmprod to end of logs on node (0) and
complete tablespace (datas_ts, indexs_ts)


        I found an APAR IY10803 which describes the problem, but I see no
fixes.

        Once again I turn to this list for help.

Thanks in advance,

Dave Stritzinger



"The information in this email, and in any attachments,
may contain confidential information and is intended 
solely for the attention and use of the named addressee(s).
It must not be disclosed to any person without authorization.
If you are not the intended recipient, or a person responsible for
delivering it to the intended recipient, you are not authorized
to, and must not, disclose, copy, distribute, or retain this
message or any part of it."
-
:::  When replying to the list, please use 'Reply-All' and make sure
:::  a copy goes to the list ([EMAIL PROTECTED]).
***  You are subscribed to [EMAIL PROTECTED]
***  To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]

Reply via email to