vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0260.html
Lu, Huayi e6fa411af0 DWS DEV 830.201 version 
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2024-05-16 07:24:04 +00:00

4.0 KiB
Raw Permalink Blame History

COMMIT PREPARED

Function

COMMIT PREPARED commits a prepared two-phase transaction.

Precautions

  • The function is only available in maintenance mode (when GUC parameter xc_maintenance_mode is on). Exercise caution when enabling the mode. It is used by maintenance engineers for troubleshooting. Common users should not use the mode.
  • Only the transaction creators or system administrators can run the COMMIT command. The creation and commit operations must be in different sessions.
  • The transaction function is maintained automatically by the database, and should be not visible to users.

Syntax

1
2
COMMIT PREPARED transaction_id ;
COMMIT PREPARED transaction_id WITH CSN;

Parameter Description

  • transaction_id

    Specifies the identifier of the transaction to be submitted. The identifier must be different from those for current prepared transactions.

  • CSN(commit sequence number)

    Specifies the sequence number of the transaction to be committed. It is a 64-bit, incremental, unsigned number.

Helpful Links

PREPARE TRANSACTION, ROLLBACK PREPARED

Parent topic: TCL Syntax