Consultor Eletrônico



Kbase P26853: How can you tell which database is the coordinator when using two-phase commit?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   11/12/2008
Status: Verified

GOAL:

How can you tell which database is the coordinator when using two-phase commit?

FACT(s) (Environment):

All Supported Operating Systems
Progress/OpenEdge Product Family

FIX:

In two-phase commit, Progress assigns a coordinator for each transaction. If you use the -crd parameter, this will assign a higher priority to that database. This does not mean that it will always be the coordinator. It is only more likely to be the coordinator for a transaction.

The proper syntax is:


proutil db-name -C 2phase modify [ -crd | -tp nickname ]

db-name
Specifies the database you are using.

-crd
Switches whether or not the database can serve as a coordinator database. If you specify -crd against a database that is a candidate for coordinator database, it is no longer a candidate. If you specify -crd against a database that is not a candidate, it becomes a candidate.

-tp
Identifies a new nickname for the coordinator database.