Fixing “The transaction log for the database is full” problem in DB2
From the blog pakzilla [IBM][CLI Driver][DB2/AIX64] SQL0964C The transaction log for the database is full. SQLSTATE=57011 The above mentioned error occured when database log file is not large enough for the application to create log files. The solution for this problem is to increase LOGFILSIZ, LOGPRIMARY and LOGSECOND parameters. When you will be going to increase the values for these parameters, you must keep in mind no to over allocate the space. Calculate the required disk space Following formula is useful for calculating the required disk space. Disk space required: logfilsiz * (logprimary + logsecond) * page_size Check DB2 settings Connect to command prompt or shell with DB2 user and issue following command, replace DBNAME with your DB2 database. db2 get db cfg for dbname My log file settinpakistanblogs.blogspot.comOpen Full Post
0 comments :
Post a Comment