Improving concurrency for real-time statistics data

You can specify certain options to prevent timeouts and deadlocks when you work with data in real-time statistics tables.

Procedure

To reduce the risk of timeouts and deadlocks:

  • When you run COPY, RUNSTATS, or REORG on the real-time statistics objects, use SHRLEVEL CHANGE.
  • When you execute SQL statements to query the real-time statistics tables, use uncommitted read isolation.