A MUPIP SET /JOURNAL command typically changes the database file journaling state. A MUPIP SET /REPLICATION command changes the database file replication state. Any MUPIP SET command, that uses one or more of the /JOURNAL and /REPLICATION qualifiers might change both the journaling and the replication state of the database file. There are few combinations of these qualifiers along with a combination of journal-option-list and replication-option that require exclusive (standalone) access to the database file. Any combination that can cause at least one of the following to be true requires standalone access to the database file.
the database file transitions from JOURNAL=DISABLED (NOJOURNAL) to JOURNAL=ON or =OFF
the database file transitions from JOURNAL=ON or =OFF to JOURNAL=DISABLED (NO JOURNAL)
the database file transitions from REPLICATION=OFF to REPLICATION=ON
the database file transitions from REPLICATION=ON to REPLICATION=OFF
the journal-option-list specifies a BUFFER_SIZE that is different from the current BUFFER_SIZE setting.
Any other combination of /JOURNAL and or /REPLICATION qualifiers, and their respective options do not need standalone access to the database file.