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.
