You can view and update statistics for data objects, such as tables and views. Not all objects and target servers are supported for statistics.
| Server | Object type | RUNSTATS option |
|---|---|---|
| DB2® for Linux®, UNIX®, and Windows® or DB2 for z/OS® | Table | On the selected table, for all columns and indexes |
| DB2 for Linux, UNIX, and Windows or DB2 for z/OS | Materialized query tables (MQTs) | For the selected MQT |
| DB2 for Linux, UNIX, and Windows or DB2 for z/OS | Index | For the selected index |
| DB2 for Linux, UNIX, and Windows or DB2 for z/OS | Column | For the selected column |
| DB2 for Linux, UNIX, and Windows | Routine (stored procedure or user-defined function) | For the selected routine |
| DB2 for Linux, UNIX, and Windows, Version 9.1 and higher | Nickname | For the selected nickname |
| DB2 for z/OS | Storage group | For the selected storage group |
| DB2 for z/OS | Table space | On the selected table space, for all tables and indexes |