New User ? Sign Up  |  Sign In  |  Help
Download Best iPod Data Recovery Software
ask
answer
discover
     
Search for questions :
My Profile
Download Best iPod Data Recovery Software
Categories
Download Best iPod Data Recovery Software

elinaa

Open Question Bookmark and Share

Getting DB2 error: the transaction log for the database is full?


Download Best iPod Data Recovery Software

I am getting error in accessing DB2 database, it comes up as –

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 have configured the log files, but the error is not yet resolved.
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,

626 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)

gessyy 		Your log file size is too low; you need to increase all of them-primary, secondary and logfilsiz however it should be within the disk space.
You can make use of this formula-

Disk_space_required=logfilsiz *(logprimary + logsecond) * page_size, for determining the actual log size that is right as per your disk space.

Now try mounting and accessing database once again. If this don’t help use db2 repair software to scan database for errors and the errors fixed thereon. Also database records, tablespace, keys, triggers etc will be restored to a new one.


Posted 626 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
Download Best iPod Data Recovery Software