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

Description

The cubrid killtran is used to check transactions or abort specific transaction. Only a DBA can execute this utility.

Syntax

cubrid killtran options database_name

options:

[{-i|--kill-transaction-index=}index] [--kill-user-name=id] [--kill-host-name=host] [--kill-program-name=program_name] [{-p|--dba-password=}password] [-d|--display-information] [-f|--force]

  • cubrid : An integrated utility for the CUBRID service and database management
  • killtran: A utility that manages transactions for a specified database
  • options : Some options refer to killing specified transactions; others refer to outputting active transactions. If no option is specified, -d is specified by default so all transactions are displayed on the screen. -p A value followed by the -p option is a password of the DBA, and should be entered in the prompt.
  • database_name: The name of database whose transactions are to be killed
Options

Displaying all transactions (no option)

cubrid killtran testdb 

 

Tran index      User name      Host name      Process id      Program name

-------------------------------------------------------------------------------

      1(+)            dba      myhost             664           cub_cas

      2(+)            dba      myhost            6700              csql

      3(+)            dba      myhost            2188           cub_cas

      4(+)            dba      myhost             696              csql

      5(+)         public      myhost            6944              csql

-------------------------------------------------------------------------------

Killing transactions in a specified index (-i or --kill-transation-index)

cubrid killtran -i 1 testdb

 

Ready to kill the following transactions:

 

Tran index      User name      Host name      Process id      Program name

-------------------------------------------------------------------------------

      1(+)            dba      myhost            4760              csql

-------------------------------------------------------------------------------

Do you wish to proceed ? (Y/N)y

Killing transaction associated with transaction index 1

Displaying all transactions (-d or --display)

cubrid killtran -d testdb

 

Tran index      User name      Host name      Process id      Program name

-------------------------------------------------------------------------------

      2(+)            dba      myhost            6700              csql

      3(+)            dba      myhost            2188           cub_cas

      4(+)            dba      myhost             696              csql

      5(+)         public      myhost            6944              csql

-------------------------------------------------------------------------------

Killing transactions for a specified OS user ID (--kill-user-name)

cubrid killtran --kill-user-name=os_user_id testdb

Killing transactions of a specified client host (--kill- host-name)

cubrid killtran --kill-host-name=myhost testdb

Killing transactions for a specified program (--kill-program-name)

cubrid killtran --kill-program-name=cub_cas testdb

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

cubrid killtran -f -i 1 testdb