Excluding a Table from Db2’s Automatic Runstats

You may also like...

5 Responses

  1. Peter says:

    regarding the Filter condition (TABSCHEMA != ‘IBMWSSIB’ and TABNAME != ‘SIBOWNER’)

    If this a standard where clause it would eliminate all tables in schema IBMWSSIB and all tables named SIBOWNER (regardless of the schema). Is that what you wanted or is this not processed as a standard where clause?

  2. John F. says:

    Thank you for another helpful post. I didn’t know these Auto Maintenance Stored Procs existed. Where did you find the syntax for the FilterCondition attribute? I looked on IBM knowledge center but didn’t see anything.

    • Ember Crooks says:

      This article includes some good details. In particular:

      Table scope: Identifies which tables are considered for automatic statistics collection. Specification is done by completing a WHERE clause that is applied to a SELECT from SYSCAT.TABLES. For example, TABSCHEMA NOT LIKE ‘EMP%’.

  3. Wayne Zhu says:

    awesome.

    Wish Db2 can simply “lock table stats” like another big boy:)

Leave a Reply

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