automatic statistics

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • hubert_s
    #1

    automatic statistics


    Hi,

    I have DB2 8.1 fixpack 7a on Win 2003 Srv,

    When I tried to enable automatic statistics I got the
    following error message:

    db2 update db cfg for SAMPLE using AUTO_STATS_PROF ON

    SQL0270N Function not supported (Reason code = "75"). SQLSTATE=42997

    What is reason code 75 here? It does not appear in Message Reference for
    8.2

    regards,

    Hubert

    Tags: None
    • Kiran
      #2
      Re: automatic statistics

      the reason code says that

      Automatic statistics collection is not supported on a
      multiple database partition system, on a system where SMP is
      enabled, or on a federated system.

      And the user response should be :

      Disable automatic statistics collection for this database by
      setting the database configuration parameters AUTO_STATS_PROF and
      AUTO_PROF_UPD to OFF.
      Or change the system to one that is on a single database
      partition, where SMP is not enabled, and that is not federated.
      Kiran Nair

        Comment

        • hubert_s
          #3
          Re: automatic statistics


          thanks,

          Hubert

            Comment

            Previous template Next
            Working...