Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Question of dostats

    Posted Mon April 22, 2024 11:24 AM

     Hi, Art,


    We use Dostats to update stats daily.

    The basic steps of the cronjob are,



    Step 1)  update statistics low drop distributions

     

    Step 2 ) dostats -d mydatabase


    Question,

    Is step 1 (drop distribution) needed  before running  dostats?


    Thanks

    Frank




  • 2.  RE: Question of dostats

    Posted Mon April 22, 2024 01:52 PM

    No. It is not necessary to do an UODATE STAUSTUCS LOW... before running dostats. It handles that for you in different ways.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Question of dostats

    Posted Mon April 22, 2024 02:02 PM

    OH, and there is no reason to drop distributions either. If you disable auto stat mode then dostats will update all tables for all pertinent columns. If you have auto stats enabled, just add the --force option to dostats to override the auto mode. 

    I usually set up my clients to leave auto stats enabled but run dostats without --force daily during the week and with --force over the weekend. That will minimize runtime during the week while generating fresh stats for highly active tables once or twice during the week when needed, but force fresh stats weekly for every table.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 4.  RE: Question of dostats

    Posted Mon April 22, 2024 05:03 PM
    Thanks Art.
    Another question,
    Is TCP connection preferred to other type of connection (e.g, shm, ssl, ....) for running dostats ?

    Thanks
    Frank



    Original Message


  • 5.  RE: Question of dostats

    Posted Wed April 24, 2024 09:14 PM

    Yes. Many dostats rune used two connections egging you cannot do over a shared memory connection.  There is an option to use a shared memory connection but then you can only process one database per run.

    Art



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


Related Content