Professional Web Applications Themes

configure parameter - IBM DB2

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...

  1. #1

    Default configure parameter

    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
    xixi Guest

  2. #2

    Default Re: configure parameter

    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.

    --

    Bob
    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
    Bob Guest

  3. #3

    Default Re: configure parameter

    hello ,

    i am using db2 v8.1 on windows , i have tried to change the database
    configuration parameter, but they are not updated right away. instead
    it states that it must wait after instance restart. if as you said,
    how can i ensure all the connections are off? use force application
    all? so after that , what should i do, just restart the database by
    control center? i have been do instance restart all the time and never
    do as you said, can you explain more detail? thank you
    xixi Guest

  4. #4

    Default Re: configure parameter

    You could use quiesce database. From the v8 Command Ref manual:

    "After administrative tasks are complete, use the UNQUIESCE command to
    activate the instance and database and allow other users to connect to
    the database but avoid having to shut down and perform another database
    start."

    xixi wrote:
     

    Blair Guest

Similar Threads

  1. #39589 [NEW]: Configure/compilation ignoring --with-pcre-regex=DIR parameter?
    By jordi at telematictraining dot com in forum PHP Bugs
    Replies: 3
    Last Post: November 22nd, 09:37 PM
  2. Replies: 0
    Last Post: October 10th, 03:39 PM
  3. Replies: 0
    Last Post: October 10th, 03:39 PM
  4. Replies: 0
    Last Post: October 10th, 03:09 PM
  5. Replies: 0
    Last Post: October 9th, 05:33 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139