Using REOPT(ONCE) option to improve performance for maximo running on DB2.

Body

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.