State=Blocked Specifies a list of all unresolved distributed transactions in the blocked database. A blocked database is a database that is not committed or rolled back and is involved in an unresolved distributed transaction. The State=Blocked qualifier displays the following information about each transaction: o Process identification (PID) o Stream identification o Monitor identification o Transaction identification o Name of the recovery journal o Transaction sequence number (TSN) o Distributed transaction identifier (TID) o Name of the node on which the failure occurred o Name of the node initiating the transaction (parent node) You can use the State=Blocked qualifier only with the Users qualifier. For information on resolving unresolved transactions with the RMU Dump command, see the Oracle Rdb7 Guide to Distributed Transactions.