Physical open of a page set of partition

To eliminate the overhead of a physical open for an SQL thread, you may want to force a physical open of a table space, index space, or partition to improve performance in a data sharing environment.

You can do this by issuing the ACCESS DATABASE MODE(OPEN) command on the data sharing member where you plan to run your applications. This command will force the physical opening of the specified pageset or partition on the local member only. This will move the overhead of the physical open from a SQL thread to the command thread.