IBM Support

Why do I see auto maintenance messages in the db2diag.log outside of policy windows ?

Technical Blog Post


Abstract

Why do I see auto maintenance messages in the db2diag.log outside of policy windows ?

Body

The auto maintenance messages  with evaluation of  reorg, runstats  are logged in the db2diag.log every two hours.  These are part of auto maintenance setup in the database.

Policy defined  to run  reorg or runstats  during a certain maintenance window supposed to run  reorg,  runstats only during those time windows  defined by the policies.

The real   reorg or,  runstats will follow the guideline defined by the auto maintenance policies. But, the evaluation  of the same are not controlled by the policy definitions.  

So,  it's expected  to find the evaluation messages showing up  in the db2diag.log   outside of the maintenance windows defined by the policies.  But, the real reorg or  runstats  will only  run during the time windows  defined by the policies.
 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11140850