Tuesday, September 15, 2009

Solution to DB2 log full

1. Find the current log size by running following command.
db2 get db config for db_name
2. Increase the log size. If you want log size to be 4KB, run following command.
db2 update db cfg for db_name using LOGFILSIZ 4000
3. Restart the DB2 service.
db2 connect reset

Tuesday, September 1, 2009