After connecting to the server as DB2 instance owner, you can configure the DB2 registry variables on the database server.

Make sure that you configure an IBM DB2 database user and group.

1

Open a DB2 Command window or Command Line Processor (CLP) as the DB2 instance owner.

On Microsoft Windows, select Start > IBM DB2 > DB2Copy1 > Command Line Tools > Command Window.

On Linux or UNIX, open a terminal and switch your user to the DB2 instance owner.

2

Start the DB2 instance.

db2start
3

Enable the DB2 administrative task scheduler.

db2set DB2_ATS_ENABLE=YES
4

Enable the DB2 database system to ignore uncommitted insertions.

db2set DB2_SKIPINSERTED=ON
5

Enable the table or index access scans to defer or avoid row locking until a data record is known to satisfy predicate evaluation.

db2set DB2_EVALUNCOMMITTED=ON
6

Enable the DB2 database system to skip deleted keys during index access and skip deleted rows during table access.

db2set DB2_SKIPDELETED=ON
7

Stop and restart the database instance.

db2stop force
db2start

These commands affect all databases in this instance.

All the required registry variables are set up.

Add the client instance registry variable.