DB2 Database for Linux, UNIX, and Windows best practices

The vast majority of configuration settings for DB2 Database for Linux, UNIX, and Windows will remain unchanged. However, you may want to adhere to the following suggestions for best performance.

Install the appropriate DB2 JDBC driver on your application server to enable communication between the database and your NexJ application.

The following setting are required for a production environment:

  • In a production environment, database users should only be members of the njdbuser database role, which provides create, read, update and delete (CRUD) access to the data contained in NexJ tables. No other database roles are required.
The following settings are recommended for a production environment:
  • Set the amount of table spaces for each database partition under 1000. Too many data partitions or table spaces can increase overhead and decrease performance.
  • Limit the amount of data partitions for each table to a few hundred per database partition. Thousands of data partitions increase overhead, which can negatively impact performance.
Note: Documentation for IBM DB2 for Linux, UNIX, and Windows can be found here: http://www-947.ibm.com/support/entry/portal/product/information_management/db2_for_linux,_unix_and_windows.