Changing DB2 logfile Size

Use the following procedure to increase the size of the DB2 transaction log (logfilsiz):

1. Determine the current log file size setting by issuing the command:

Unix
su - <db2instance> 
db2 list db directory # to list the database name 
db2 connect to <databaseName> 
db2 get db config for <databaseName> | grep -i logfilsiz

Example:
su - ldapdb2 
db2 connect to amdb 
db2 get db config for amdb | grep -i logfilsiz 
Windows operating system
open a DB2CMD window 
set DB2INSTANCE=<databaseName> from the ibmslapd.conf file 
db2 list db directory 
db2 connect to <databaseName> 
db2 get db config for <databaseName> 
check the value for logfilsiz 

2. Increase the size of the log file size setting by issuing the command:

db2 UPDATE db cfg for <databaseName> using LOGFILSIZ <new_value> 
Example:
db2 UPDATE db cfg for amdb using LOGFILSIZ 5000

3. Stop the ibmslapd process. 
ibmslapd -k -I <instance name> 

4. Issue the commands:

db2 force applications all 
db2stop force

5. Restart ibmslapd process.