Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Question Unanswered: DB2 startup with less memory

    Running AIX and UDB 7.2. I am working on creating scripts for HACMP failover and database startup. The problem is that the failover box has less memory then the production box. When we failover, I need to reflect this in the parms. Does anyone have some good ideas on how to have two different startups depending on which server it will be run on?

    One suggestion was to use DB2_OVERRIDE_BPF All Default. I will need to look into this a little more and see how it affects all the startup parms.

    Thanks in advance.....

  2. #2
    Join Date
    Nov 2002

    Re: DB2 startup with less memory

    In your startup script for each box that HACMP runs on, have it automatically adjust those parms, have it run a file with all the parms you want to change. Then have HACMP stop/start the db 1 more time before you have what ever connecting to it.

    db2 udpate etc;

    Should only add about 1-2 mins at most to your failover.

    The override bufferpool would work, but it limits all your BP, so if you have more than 1 it would limit that too. That parm is normallly used to fix an over allocation of memory, not to run on.
    David Quigley

Posting Permissions

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