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 |