3.1.4.3.2.1.1.14 CommitTransaction

The CommitTransaction command commits a transaction on the current session.

   <xsd:complexType name="CommitTransaction">
     <xsd:all>
       <xsd:element name="DurabilityGuarantee" minOccurs="0">
         <xsd:simpleType>
           <xsd:restriction base="xsd:string" >
             <xsd:enumeration value="LocalDisk" />
             <xsd:enumeration value="Full" />
           </xsd:restriction>
         </xsd:simpleType>
       </xsd:element>
     </xsd:all>
   </xsd:complexType>

Element

Default value

Description

DurabilityGuarantee<370>

Full

The durability guarantee of the committed transaction. The following values are allowed:

  • LocalDisk – Data is committed on the local disk of the machine. This has relevance in cloud systems. However, specifying this setting does not guarantee durability in reliable persistent storage (RPS). In case of a node crash, the data might be lost.

  • Full – In cloud systems, data is fully committed in RPS. In on-premises systems, data is committed to the local disk.

The return result type for the CommitTransaction command is xmla-e:emptyresult.