Enabling the REOPT(ONCE) bind option

To help the query optimizer select an efficient access plan, specify the REOPT(ONCE) bind option when you run queries. When the REOPT(ONCE) bind option is used, the query optimizer selects the access plan the first time that the query is run. Each subsequent time that the query is run, the access plan is reused.

Procedure

  1. On the DB2® server, log in as the database instance owner.
  2. In the bnd directory for DB2, for example C:\DB2\SQLLIB\bnd, run the following command:
    db2 bind db2clipk.bnd collection NULLIDR1
  3. Log in to Maximo® Asset Management as an administrator with the authority to perform system configuration tasks.
  4. In the System Properties application, open the details for the mxe.db.DB2jdbcCollection system property.
  5. In the Global Properties Details section, in the Global Value field, specify NULLIDR1.
  6. Select the Live Refresh action, and then click OK. The new property value, NULLIDR1, is shown in the Global Value field and the Current Value field.


Feedback