Query open time

Set a query open time for queries. By default, the system optimizes open requests. This optimization improves performance but may fail if a database monitor is active when a query is run more than once.

Perform psuedo-open for better performance
The system is allowed to use pseudo-open operations. Using pseudo-opens can improve your performance.

Perform full-open to analyze performance with DB2 On-Demand Performance Center
The system fully opens a table for each query.