IBM DB2 Increase LogFileSize for Better Transaction Process

on


$ db2 "CONNECT TO DBPUBLIC"

$ db2 "SET SCHEMA APPCORE"

$ db2 "GET DB CFG"

$ db2 "TERMINATE"

$ db2 "FORCE APPLICATIONS ALL"

$ db2 "UPDATE DB CFG FOR DBPUBLIC USING LOGFILSIZ 24576"

$ db2 "FORCE APPLICATIONS ALL"

$ db2 "CONNECT TO DBPUBLIC"

$ db2 "SET SCHEMA APPCORE"


Source :

https://stackoverflow.com/questions/2599419/db2-transaction-log-is-full-how-to-flush-clear-it

Comments

Post a Comment