Results 1 to 3 of 3

Thread: catalog update

  1. #1
    Join Date
    Mar 2003
    Posts
    12

    Unanswered: catalog update

    Has anyone got any SQL to remove catalog stats (as used by the optimiser) - setting them to -1 etc ? This is OS390 DB2 V5.
    TIA

  2. #2
    Join Date
    Feb 2002
    Location
    Germany
    Posts
    141
    The statistics columns in the catalog are updateble. You could just issue a SQL Statement "UPDATE your_catalog_table SET your_statistics_column = -1 (if you have the right permissions, of course).
    But, why would you do something like this??? Your optimizer NEEDS this piece of information. Without it, it cannot generate an "optimized" access path. If you are getting bad access paths, there are many other ways to improve your performance.

    HTH
    Rodney Krick

  3. #3
    Join Date
    Feb 2003
    Posts
    22
    Well I've made many things like that, because db2 optimizer seldom doesn't work,....
    But I've updated only fields like cardf or cluster....in these cases it works fine....

    Chris
    Cristiana
    Data Base Administrator
    Bologna
    Italy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •