Ember’s Best Practices for Runstats and Reorgs

You may also like...

2 Responses

  1. Hi Ember! Great post, as always. A question: do you run FLUSH PACKAGE CACHE DYNAMIC after or before db2rbind? As the flush command mark all packages as invalid forcing them to be recompiled by DB2 in the next access, why use it?

    • Ember Crooks says:

      I think of it as db2rbind taking care of static SQL and the flush package cache taking care of dynamic. Perhaps it would make more sense in the other order.

Leave a Reply

Your email address will not be published. Required fields are marked *