Db2 8.2 on windows 2000

We have a hsitory database that is frquently accessed by a single application. Each time the application connect/disconnect DB2 close log file and opens a new one. We end up getting large number of 12K size log files. Is there a way to make DB2 close log files only when the log file size is closer to allocated size for the logfile.

Thanks in advance

Issue the following command, you will not get new log files each time the number of connections goes from 0 to 1:

db2 activate db <db-name>

This also will make your first connection faster, since when the database is activated (connections goes from 0 to 1 or explict activation), the buffer pools and some other database memory are dynamically allocated (which takes a little bit of time).

thanks very much