DB2事务日志-关闭 [英] DB2 Transaction log - OFF

问题描述

我正在运行一条delete语句，该语句会在db2数据库表中删除超过10000条记录，这时，当我执行该语句时会抛出错误，并说事务日志已满".

我的db2配置文件详细信息是，

Hi,
i am running a delete statement, which deltes more than 10000 records in my db2 database table, in that time, when i execute it throws me error, saying "transaction log is full"

my db2 config file details are,

 Group commit count                          (MINCOMMIT) = 1
Percent log file reclaimed before soft chckpt (SOFTMAX) = 520
Log retain for recovery enabled             (LOGRETAIN) = OFF
User exit for logging enabled                (USEREXIT) = OFF

如何关闭或禁用事务日志记录机制....?

谢谢，
Mani

how to turnoff or disable the transaction logging mechanism....?

thanks,
Mani

推荐答案

请参考以下线程:
http://stackoverflow.com/questions/996403/disable-transaction-log

Please refer to this thread:
http://stackoverflow.com/questions/996403/disable-transaction-log

这篇关于DB2事务日志-关闭的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！