Quiesce reset on all tables doesn't reset TablsSpace from quiesce share 
Author Message
 Quiesce reset on all tables doesn't reset TablsSpace from quiesce share
i have udb 7.2.5 installed on w2k fix2 .
i issued a quiesce on one of the tables i created .
the TS on which the table exists was in share quiesce state ( as
should be).
while no connection was to the DB i assume the share quiesce will be
dissapear
but NOT .
even a quiesce reset on all tables (except system ones) didn't help
nor de\activate or restart the DB .
any suggestion ?
Thanks
Hanan Kenan


Fri, 20 May 2005 05:44:37 GMT
 Quiesce reset on all tables doesn't reset TablsSpace from quiesce share

You may try to requiesce the table/ts and retry to reset.

connect
list tablespaces show detail
quiesce ... (using what you see in list tablespaces)
quiesce ... reset.

Maybe what you have is now a phantom quiesce.

PM



Sat, 21 May 2005 01:05:58 GMT
 Quiesce reset on all tables doesn't reset TablsSpace from quiesce share

Quote:

> i have udb 7.2.5 installed on w2k fix2 .
> i issued a quiesce on one of the tables i created .
> the TS on which the table exists was in share quiesce state ( as
> should be).
> while no connection was to the DB i assume the share quiesce will be
> dissapear
> but NOT .
> even a quiesce reset on all tables (except system ones) didn't help
> nor de\activate or restart the DB .
> any suggestion ?
> Thanks
> Hanan Kenan

HI,

I think the quiesce is based on the connection. Did you use the same
connection which issue the quiesce on one of the tables to do the
reset?



Sat, 21 May 2005 01:21:53 GMT
 Quiesce reset on all tables doesn't reset TablsSpace from quiesce share

Quote:


> > i have udb 7.2.5 installed on w2k fix2 .
> > i issued a quiesce on one of the tables i created .
> > the TS on which the table exists was in share quiesce state ( as
> > should be).
> > while no connection was to the DB i assume the share quiesce will be
> > dissapear
> > but NOT .
> > even a quiesce reset on all tables (except system ones) didn't help
> > nor de\activate or restart the DB .
> > any suggestion ?
> > Thanks
> > Hanan Kenan

> HI,

> I think the quiesce is based on the connection. Did you use the same
> connection which issue the quiesce on one of the tables to do the
> reset?

thanks my friends for your help.
the solution was :
the tablespace that was in quiesce share mode has more than 1 table on
it.
in this case , in order to remove the quiesce share mode you need to
run a quiesce reset on ALL the tables on the tablespace !
thanks again.


Sat, 21 May 2005 16:22:01 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. How to force a quiesce reset on a tablespace witch state is quiesce share

2. Cant' Quiesce RepServer

3. Changing ODBC default database doesn't reset

4. Changing ODBC default database doesn't reset

5. DBCC Checkident doesn't reset to 1?

6. Dump Tran Doesn't Reset Logs?

7. Lock Table or Quiesce ?

8. Quiesce of SQL 6.5 database

9. Quiescing SQL

10. quiescing the disk and pausing SQL for backups

11. Quiesce command for SQL 2000

12. Snapshot of SQL database command (Quiesce)


 
Powered by phpBB® Forum Software