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