Figure 8 7   Configuration parameter files

The database manager configuration file

This file is created with the DB2 instance and it affects the DB2 instance level. 

It is stored in 

db2systm

 file under the 

sqllib

 subdirectory of instance. The 

values in this file can be seen using:

bash>db2 get database manager configuration

and it can be set using:

bash>db2 update dbm cfg using DIAGLEVEL 1

The database configuration file

For each database there exists a database configuration file, which is created 

when a database is created. It resides in the directory where the database 

resides. It defines the resources and variables for the particular database. 

The values in the database configuration can be obtained using:

bash>get database configuration for itsodb2

252 

MySQL to DB2 UDB Conversion Guide