Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2006
    Posts
    105

    Unanswered: Database quiesce state

    Hi all,


    How to find whether the database is in quiesce state or in any other state..........


    Thanks and regards
    Meena.s

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Use:

    GET SNAPSHOT for DATABASE ON MyDB

    Near the top of the output is a line labeled "Database status"

    Andy

  3. #3
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    select db_status from table(snapshot_database('RAHUL',0)) as db

    chk :
    http://publib.boulder.ibm.com/infoce...oc/welcome.htm

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

Posting Permissions

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