Click here to Skip to main content
15,890,186 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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


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

thanks,
Mani
Posted
Updated 11-Dec-11 20:17pm
v2

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900