Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2006

    Unanswered: Log files in db2 8

    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

  2. #2
    Join Date
    May 2003
    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).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Mar 2006
    thanks very much

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts