How to reset the tablespace state to normal

[login to unmask email]

How to reset the tablespace state to normal
Hi,dear DB2 experts!
I feel some shy as a listner so long and didnot put in my two cents
once,In any case i appreciate you all these experts' speakings cause i
benifit it much.
I have a tough problem for you help to resove.it come as this:i use db2
v5.0 on NT platform,but,somebody changed one talbe's state to share,so
cause the tablespace's state which the tabe resides abnormally (share), and
i dont know who lacked which table! even all users have been reconnected
once at least! So, how to find which table has been lacked,and how to reset
the tablesapce state to normal except using roll-forward?
I have been tried to use the 'quiesce tablespaces for table ....
reset' command to reset all these tables but all of it returned the
followed messages:
"SQL3805N The state of the application or of one or more table spaces
for the table specified prohibits the loadapi action or quiescemode "09".
Reason code = "1". "
What can i do?
Appreciate your reply!



CLAUDIO MARCOS

Re: How to reset the tablespace state to normal
(in response to linlibin@MAIL.DCAC.COM)
Please, unsuscribe me of your list.

-----Mensaje original-----
De: [login to unmask email] <[login to unmask email]>
Grupos de noticias: bit.listserv.db2-l
Para: [login to unmask email] <[login to unmask email]>
Fecha: domingo 10 de octubre de 1999 7:57
Asunto: How to reset the tablespace state to normal


>Hi,dear DB2 experts!
> I feel some shy as a listner so long and didnot put in my two cents
>once,In any case i appreciate you all these experts' speakings cause i
>benifit it much.
> I have a tough problem for you help to resove.it come as this:i use db2
>v5.0 on NT platform,but,somebody changed one talbe's state to share,so
>cause the tablespace's state which the tabe resides abnormally (share), and
>i dont know who lacked which table! even all users have been reconnected
>once at least! So, how to find which table has been lacked,and how to reset
>the tablesapce state to normal except using roll-forward?
> I have been tried to use the 'quiesce tablespaces for table ....
>reset' command to reset all these tables but all of it returned the
>followed messages:
> "SQL3805N The state of the application or of one or more table spaces
>for the table specified prohibits the loadapi action or quiescemode "09".
>Reason code = "1". "
> What can i do?
> Appreciate your reply!
>
>
>