Technical Blog Post
Using REOPT(ONCE) option to improve performance for maximo running on DB2.
DB2 Cost Base Optimizer in AN algorithm that identifies the quickest access path to the
data based on information stored in DB2 Catalog. Maximo SQL’s are dynamic that means
that path is evaluated before execution for each stamen being executed and every time the statement
runs. So, it is time consuming and expensive ( CPU) procedure. I many cases using REOPT(ONCE)
could improve maximo performance. This option tells the Optimizer to calculate the access path
only once upon first execution of the statement.
Steps to take
On DB2 sever from a directory \DB2\SQLLIB\BND run the following command
db2 bind db2clipk.bnd collection NULLIDR1
Log in to Maximo an administrator and in the System Properties application, set mxe.db.DB2jdbcCollectionto NULLIDR1
Restart an application server.