Skip to Content
avatar image
Former Member

statistics update command for DB2 running on AIX

Hello Experts -

i am running DB2 10.05 on AIX and would need to run statistics for complete DB.

Can you please help me with the command ?

Thanks

Dev

--------------------

I ran the following but i don't see any update.

db2 REORGCHK UPDATE STATISTICS ON TABLE ALL


Doing Runstats......


After 30 minutes i found my DB was hung and SAP system went down.

Could you please suggest a query or commands.

Dev

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 16, 2015 at 01:01 AM

    Hello,

    Firstly, normally there should be no need to manually run statistics on all tables, as the auto runstats is enabled on DB level by default. Any special reason to do it?

    Secondly, we recommed to use dbacockpit function to do the reorgchk and runstats.
    dbacockpit -> Jobs -> DBA Planning Calendar -> choose the action pad accordingly.

    Lastly, for the DB hung and SAO down issue before, have to check the db2diag.log as the starting point.

    Kind regards
    Maria

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 05:18 AM

    Hello Dev

    Please check the note below may help you and provide the db2diag.log

    to investigate more .

    1942183 - DB6: When to consider a table or index reorganization

    Thanks

    Sadiq

    Add comment
    10|10000 characters needed characters exceeded