The cubrid killtran is used to check transactions or abort specific transaction. Only a DBA can execute this utility.
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]
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