How to Detect and Process Zombie Transactions in a DBMS on Unix Environments

摘要

The present invention relates to a method of detecting and processing a zombie transaction when there is a zombi transaction caused by abnormal termination of a process during a transaction operation in a DBMS in a UNIX environment. A first step of checking whether a means a zombie transaction, a second step of checking a next transaction entry if the check result is not a zombie transaction, and processing a latch resource if a zombie transaction is confirmed; And a fourth step of invalidating by undoing a database change portion performed by the transaction, and a fifth step of returning the transaction table entry, thereby increasing DBMS system resource utilization. Resource usage can be efficient without error It has an effect.