Search for questions :
My Profile
Categories

jessicalogan

Open Question Bookmark and Share

DB2 error – ‘The transaction log for the database is full’. Any help?

I have got a DB2 error message while working with the JDBC in java. The error message goes like this –

java.lang.Exception caught: com.ibm.sa.admin.share.AdminException: SAWM4302E: Database
error encountered: code=-964 SQLState=57011 text="[IBM][CLI Driver][DB2/SUN] SQL0964C The transaction log for the database is full. SQLSTATE=57011"

I order to rectify the error from my side I have configured the log file as follows –
db2 update db cfg for dbname using logprimary 10
db2 update db cfg for dbname using logsecond 10
db2 update db cfg for dbname using logfilsiz 800

But I am still getting the error message. I don’t know what to do, please help me to resolve the issue. Any help or suggestions will be appreciated?

156 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

johnsharp 		Log file size might be very low that the reason why you are getting this error message. I guess 800 is not enough and also increase the secondary and primary log size as well. This might help you. Try following formula to allocate the size of the log file –

disk_space_required = logfilsiz * (logprimary + logsecond) * page_size
disk_space_required = 2500 * (10 + 10) * 4 KB = 200 MB

Also look for the DML operations on rows fitting in to the log file size and ensure that application commits frequently. By performing the above measures I hope your problem will be resolved. If the problem persists then repair the DB2 database once using DB2 Repair software. It will surely resolve your issue.

All the best!


Posted 156 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0