How long does DB2 take to release secondary logs after a commit.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jopydo
    New Member
    • Sep 2012
    • 1

    #1

    How long does DB2 take to release secondary logs after a commit.

    About releasing secondary logs, the documentation states :
    Over time as the database manager determines they will no longer be required.

    I'd like to know what the maximum time before DB2 frees the secondary logs can be. I have some mass updates or deletes to do. I can see DB2 takes about 1 hour after commit to free the secondary logs that have been allocated during the execution of the application.
  • zmbd
    Recognized Expert Moderator Expert
    • Mar 2012
    • 5501

    #2
    After reading thru several texts I have and some of the other forums out there for DB2, there doesn't seem to be any clear cut answer... it appears to be dependent on the configuration of the database, the server, the client, the number of secondary logs and how they are configured, and the amount of data.

    Comment

    Working...