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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved