Workspaces performance tuning

Workspaces use database views instead of tables to retrieve data. Retrieval of underlying data might be more time-consuming because of the complexity of SQL statements that are used in workspace view definitions. Data retrieval from a single workspace view is unlikely to have a significant a performance impact. However, joining (inner or outer join) multiple workspace views can decrease performance.
  1. Run the following command:
    db2set DB2_UNION_OPTIMIZATION=ENABLE_NESQ_PD_THRU_UA=YES
  2. Restart the DB2 database manager for the settings to take effect.