Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.2.1 |  CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Killing Database Transactions

The cubrid killtran utility is used to kill transactions from a specific database based on the option specified.

Syntax

cubrid killtran options  database_name

options : [{-i|--kill-transaction-index=}index]  [--kill-user-name=id]  [--kill-host-name=host]

             [--kill-program-name=name]  [--kill-program-name=name] [{-p|--dba-password=}password]

             [-d|--display-information]  [-f|--force]

  • cubrid : An integrated utility for the CUBRID service and database management.
  • killtran : Kills transactions from a specific database based on the option specified.
  • options : Specifies the transactions to be killed. If no option is specified, all transactions in the given database are killed. You must enter the password of DBA after the -p option; if not, a prompt will enter it.
  • database_name : The name of the database whose transactions are to be killed.
Options
  • Viewing all transactions in the testdb database

cubrid killtran testdb

  • Killing transactions in the specified index (-i or --kill-transaction-index)

cubrid killtran -i test_index testdb

  • Killing transactions for the specified user ID (--kill-user-name)

cubrid killtran --kill-user-name myuser testdb

  • Killing transactions for the specified client host (--kill- host-name)

cubrid killtran --kill-host-name myhost testdb

  • Killing transactions for the specified program (--kill-program-name)

cubrid killtran --kill-program-name my_test_program testdb

  • Displaying information about active transactions (-d or --display)

cubrid killtran -d testdb

  • Omitting a prompt to check transactions to be stopped (-f or --force)

cubrid killtran -f -i 1 testdb