If you change a "database" configuration parameter, it affects "only" that database. All you have to do is ensure that all connections are off that database and no activation is present (assuming V7.2). If you are at V8.1 then many of the database configuration parameters are able to be changed online and immediately without restarting the database.
Now if you are changing an "instance" configuration parameter (DBM) in V7.2 you will need to restart the instance. For V8.1 there may be some DBM configuration parameters which can be changed online. See the Admin Guide for details on that.
Consulting I/T Specialist
IBM Toronto Lab
IBM Software Services for Data Management
"xixi" <com> wrote in message news:google.com...
I am not sure this is the right way to do. I have several database under one instance. So if I change one database configuration
parameter, I have to stop and restart the instance in order to take effect the update and this will affect other database under use. Is
this the way DB2 design? Thanks