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
- On the DB2® server,
log in as the database instance owner.
- In the bnd directory for DB2,
for example C:\DB2\SQLLIB\bnd, run the following
command:
db2 bind db2clipk.bnd collection
NULLIDR1
- Log in to Maximo® Asset Management as
an administrator with the authority to perform system configuration
tasks.
- In the System Properties application, open the details
for the mxe.db.DB2jdbcCollection system property.
- In the Global Properties Details section, in the Global
Value field, specify NULLIDR1.
- 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.