Results 1 to 3 of 3

Thread: Quiesce user

  1. #1
    Join Date
    Dec 2015
    Posts
    3

    Unanswered: Quiesce user

    If a tablespace in quicesed state. beacause of power failure the connection has been lost,and the database is in deactivated state and tablespace is still in quiesce execulsive state(using db2top I come to know)and in db2 list application is not listing out any uow executing for tablespace. in such case how to find out the user(quiescer) who made the quiesce request and how to reset the connection?

  2. #2
    Join Date
    Jul 2016
    Location
    Moscow
    Posts
    108
    Provided Answers: 13
    Run the following query:
    Code:
    select q.quiescer_auth_id, 'quiesce tablespaces for table "'||t.tabschema||'"."'||t.tabname||'" reset'
    from (
    select 
      quiescer_auth_id
    , case quiescer_ts_id when 65530 then quiescer_ts_id  - 65536 else quiescer_ts_id  end tbspaceid
    , case quiescer_ts_id when 65530 then quiescer_obj_id - 65536 else quiescer_obj_id end tableid
    from sysibmadm.snaptbsp_quiescer
    ) q
    join syscat.tables t on t.tbspaceid=q.tbspaceid and t.tableid=q.tableid
    Then for each row returned do the following:
    - connect to the database with the userid specified in the 1-st column
    - run the statement from the 2-nd column

    Regards,
    Mark.

  3. #3
    Join Date
    Dec 2015
    Posts
    3

    Thumbs up Thanks alot MARK

    Quote Originally Posted by mark.bb View Post
    Run the following query:
    Code:
    select q.quiescer_auth_id, 'quiesce tablespaces for table "'||t.tabschema||'"."'||t.tabname||'" reset'
    from (
    select 
      quiescer_auth_id
    , case quiescer_ts_id when 65530 then quiescer_ts_id  - 65536 else quiescer_ts_id  end tbspaceid
    , case quiescer_ts_id when 65530 then quiescer_obj_id - 65536 else quiescer_obj_id end tableid
    from sysibmadm.snaptbsp_quiescer
    ) q
    join syscat.tables t on t.tbspaceid=q.tbspaceid and t.tableid=q.tableid
    Then for each row returned do the following:
    - connect to the database with the userid specified in the 1-st column
    - run the statement from the 2-nd column

    Regards,
    Mark.


    Thanks for sharing valuable information. MARK


    Regards
    Sai Teja B

Posting Permissions

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