statistics update command for DB2 running on AIX

[Former Member]

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

[former_member182505]

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

[maria_shen]

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