Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: Tablespace In QUIESCE shared

    Hi all,

    Can someone help me

    on one tablespace is in 0x0001 state.

    Some one seems to try QUIESCE but not sure.

    I must bring it bac to normal.


    Please help

    DB2 V8.1.5

    Thanks
    DBFinder

  2. #2
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    The tablespace is in Quiesced Share state. Kindly check whether this has been done deliberately.

    A table space is in this state when both the application that invokes the table space quiesce function and concurrent applications have read (but not write) access to the table space. You can put a table space in Quiesced Share state explicitly by issuing the QUIESCE TABLESPACES FOR TABLE command.
    IBM Certified Database Associate, DB2 9 for LUW

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Not Really,

    The dev team works with that DB and they did not do it.

    Probably I did by mistake ; don't remember.

    It is back on again to Normal.

    The reason may be because too many users were logged on.
    Db2Stop Force - restart -- and QUIESCE RESET.

    But I did not understand why it did not work before Restart.

    Any Idea


    Thanks

    DBFinder

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •