Re: varyonvg -b -u how to tell state?

From: Dohhhh (whynot_at_verizon.net)
Date: 06/15/05

  • Next message: jthomp1515_at_yahoo.com: "Re: varyonvg -b -u how to tell state?" 
    Date: Wed, 15 Jun 2005 01:13:36 GMT

    jthomp1515@yahoo.com wrote:
    > anybody know what to query to determine the state of the locks on a
    > volume group? I need something to run behind my admins to verify
    > when they have finished LVM synching on an HACMP cluster. (AIX 5.2
    > HA5.1)
    >
    > I have seen cases lately where lsvg -o shows a VG apparently active
    > on both nodes and I assume this is a result of running the varyons on
    > the wrong node at the wrong time.
    >

    Ummm...(as I learned back in one of my classes) "it depends"...could be
    you have concurrent capable VGS and/or (HACMP RGs) - whether that's what
    is intended or not <G>. What does "lspv" on all nodes show? What does
    "/usr/es/sbin/cluster/utilities/clfindres" show (the path to clfindres
    might be a bit off <G>). Did you remember to "chvg -a n" then varyoffvg
    (on ALL nodes) BEFORE finishing cluster config and/or sync...questions,
    questions, questions ("inquiring minds wanna know" <G>).

    Paul

  • Next message: jthomp1515_at_yahoo.com: "Re: varyonvg -b -u how to tell state?"

    Relevant Pages

    • Re: Back end database lock-up
      ... Default Record Locking: No Locks ... - i checked and double checked that the query and form are set to no- ... The locking file is not created until a user updates the data via ...
      (comp.databases.ms-access)
    • Re: advanced question - xlock hint on record not locking select * from table
      ... The first query locks one ... index and the second query data using another index. ... I also tried to replace my rowlocks by paglocks, by the first script locks ... > So these two transaction do not interfere and you are getting ...
      (microsoft.public.sqlserver.server)
    • Re: advanced question - xlock hint on record not locking select * from table
      ... You could do this in your first script: ... "Serializability requires that any query executed during a transaction must ... That is what happening with your scripts. ... The first query locks one ...
      (microsoft.public.sqlserver.server)
    • Re: DMW locks
      ... - Server activity ... In query statistics I can see CPU, wait times, .... ... Is it possible to include here also query statistics of locks. ...
      (microsoft.public.sqlserver.programming)
    • Re: simple query locking too much data
      ... Locks will be released when the query completes and/or the transaction is ... You can check a given spid for an open transaction with DBCC OPENTRAN. ... This procedure holds locks a LOT ... >>> We have a table that consists of a user name and their password hash. ...
      (microsoft.public.sqlserver.programming)