Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question