Results 1 to 3 of 3
  1. #1
    Join Date
    May 2009
    Posts
    9

    Unanswered: after quiesce,how can i get the current status of database or instance???

    db2 => quiesce database immediate
    DB20000I The QUIESCE DATABASE command completed successfully.

    after this operation

    how can i get the current status of database???


    db2 => quiesce instance db2inst1 user db2inst1 immediate


    after this operation

    how can i get the current status of instance???

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    for db:
    db2 get snapshot for database on <db name> | grep -i quiesce
    Database status = Quiesced



    for instance:
    db2 get snapshot for dbm | grep -i quiesce
    Database manager status = Quiesced

  3. #3
    Join Date
    May 2009
    Posts
    9
    thank you

    now that's OK

    db2 => get snapshot for db on mydb
    Database Snapshot

    Database name = MYDB
    Database path = /data/db2home/db2inst1/db2inst1/NODE0000/SQL00001/
    Input database alias = MYDB
    Database status = Quiesced

Posting Permissions

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