Updating Db2 instance settings

Applies to:

After you migrate or upgrade IBM OpenPages®, you need to update settings for the Db2® instance.

Procedure

Log on to the database server as the Db2 instance owner, for example db2inst1 on Linux® or db2admin on Windows.

Run the db2set command.

The command returns a list of Db2 profile variables and their values, for example:

DB2_DEFERRED_PREPARE_SEMANTICS=YES
DB2_ATS_ENABLE=YES
DB2_COMPATIBILITY_VECTOR=ORA
DB2_OPTPROFILE=YES
DB2_NUM_CKPW_DAEMONS=0
DB2_REDUCED_OPTIMIZATION=JULIE
DB2_EVALUNCOMMITTED=ON
DB2_EXTENDED_OPTIMIZATION=NO_HVCHECK_ALL,IXOR
DB2_SKIPDELETED=ON
DB2COMM=SSL,TCPIP
DB2_PARALLEL_IO=*
DB2AUTOSTART=YES

In the results from step 2, look for DB2COMPOPT, and then do one of the following steps:
- If DB2COMPOPT is not listed, run the following command to set it:
```
db2set DB2COMPOPT=NO_SCALAR2OJ_ROW
```
- Or, if DB2COMPOPT is listed, run the following command to update its value:
```
db2set DB2COMPOPT=<existing_values>,NO_SCALAR2OJ_ROW
```

Run db2set again and verify your changes to DB2COMPOPT.

For example:

DB2_DEFERRED_PREPARE_SEMANTICS=YES
DB2_ATS_ENABLE=YES
DB2_COMPATIBILITY_VECTOR=ORA
DB2_OPTPROFILE=YES
DB2_NUM_CKPW_DAEMONS=0
DB2_REDUCED_OPTIMIZATION=JULIE
DB2_EVALUNCOMMITTED=ON
DB2_EXTENDED_OPTIMIZATION=NO_HVCHECK_ALL,IXOR
DB2_SKIPDELETED=ON
DB2COMPOPT=NO_SCALAR2OJ_ROW
DB2COMM=SSL,TCPIP
DB2_PARALLEL_IO=*
DB2AUTOSTART=YES

In the results from step 4, look for DB2_EXTENDED_OPTIMIZATION, and then do one of the following steps:
- If the results show DB2_EXTENDED_OPTIMIZATION=NO_HVCHECK_ALL,IXOR, run the following command to update the variable:
```
db2set DB2_EXTENDED_OPTIMIZATION=NO_HVCHECK_ALL,IXOR,"MAX_CSE_SGSIZE 20"
```
- Or, run the following command to update the variable without overwriting its existing values:
```
db2set DB2_EXTENDED_OPTIMIZATION=<existing_values>,"MAX_CSE_SGSIZE 20"
```

Run db2set again and verify your changes to DB2_EXTENDED_OPTIMIZATION.

For example:

DB2_DEFERRED_PREPARE_SEMANTICS=YES
DB2_ATS_ENABLE=YES
DB2_COMPATIBILITY_VECTOR=ORA
DB2_OPTPROFILE=YES
DB2_NUM_CKPW_DAEMONS=0
DB2_REDUCED_OPTIMIZATION=JULIE
DB2_EVALUNCOMMITTED=ON
DB2_EXTENDED_OPTIMIZATION=NO_HVCHECK_ALL,IXOR,MAX_CSE_SGSIZE 20
DB2_SKIPDELETED=ON
DB2COMPOPT=NO_SCALAR2OJ_ROW
DB2COMM=SSL,TCPIP
DB2_PARALLEL_IO=*
DB2AUTOSTART=YES

Restart the Db2 instance. You must restart the instance tor the changes to take effect.

What to do next

Verify that you're using the following database configuration parameters:

auto_ai_maint OFF
auto_reorg OFF
auto_del_rec_obj OFF

For more information, see Configuring the Db2 database manager with configuration parameters in the Db2 documentation.