statistics update command for DB2

[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

[hugo_amo]

Hi Dev,

This forum is for DB2 on z/OS related topics, you should have created this thread in DB2 on LUW forum instead:

In any case, in the following link you can learn how to perform a runstats:

IBM Knowledge Center

Regards,

Hugo

[Former Member]

Hello Hugo -

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

[hugo_amo]

Hi Dev,

You need to close this thread and create a new in the correct forum.

Regards,

Hugo