IBM Support

What are the .EXP files showing up in active log path or, overflow log path

Technical Blog Post


Abstract

What are the .EXP files showing up in active log path or, overflow log path

Body

When the database  recovery happens  DB2  retrieves the transaction log files and use those for rollforward.

If  the logs are compressed ones  then it first  DB2 uncompress those to same name except .EXP extension before using that.

In-place uncompress also possible if logs are uncompressed manually using internal log uncompress tool.

This is one reason,  the  DB2  cannot  use a compressed log in a read-only  filesystem  as it  cannot write the .EXP file  there.

[{"Business Unit":{"code":"BU029","label":"Data and AI"}, "Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11140790