Skip to Content
0

DB2 fixpak on a HADR/SAMP setup

Mar 20, 2017 at 06:00 AM

143

avatar image
Former Member

Hi DB2 experts

We are running DB2 10.5 in a HADR/SAMP cluster setup.

Now I need to update the fixpak from fp7 to fp8

According to the SAMP guide ( which is quite limited ), the procedure is :

1. stop DB

2. disable SAMP

3. Apply Fixpak on both nodes

4. Update the HA policy

There is this statement --

For DB2 V9.5 and higher, you need not update the HA policy because it is automatically updated by db2setup

-- Is this also relevant when using InstallFixpack command ?

Further there are steps to remove /usr/sbin/rsct/sapolicies/db2/*

and update with new policy files

This seems to conflict with the above statement about not updating the HA policy

5. Enable SAMP

6. start DB

Please confirm if the above steps are correct ? especially about the policy files

Secondly: Is there any change in SAMP for this fixpak ?

If not can I install the fixpak with NOSAMP option ?

What will be the required steps if I chose this option ?

Please advise

Warren

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

8 Answers

Juan Reyes
Mar 21, 2017 at 09:53 AM
0

Hi Warren,

I always update the policies, its no harm and guarantees the latest files are in place.

Simply rename the old policy directory as backup and copy the latest policy from the installation directory.

Regarding you SAMP question, you need to check the documentation regarding changes but usually SAMP is updated as part of the fix pack, I never had an issue with 10.5 SAMP (Now 9.7 was awful)

Beside that the only additional steps I recommend is to invoke manual mode for the cluster once you have deactivated both primary and standby and before the upgrade

samctrl –M T

and enable before starting the databases

samctrl –M F

And execute the update scripts for the db and the client

Regards, JP

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 22, 2017 at 02:15 AM
0

Hi Juan

Thanks for your response.

The fixpak documentation doesnot mention any fixes to SAMP portion, but I noticed some of the SAMP scripts have changed in the new fp8

when I applied the fixpak in my Dev database

I am just cautious about replacing the SAMP policies because there is no time to do any extensive testing on SAMP failover on the live production system, and I dont have a similar test environment to ensure that the SAMP works correctly after the fixpak update.

Have you encountered such a situation ? Or I guess we have to trust that the new policy and scripts will work as expected

Thanks

Warren

Share
10 |10000 characters needed characters left characters exceeded
Juan Reyes
Mar 22, 2017 at 12:26 PM
0

Hi Warren,

As I mentioned, I have not found any problems with SAMP on 10.5 yet... I do have a HADR test system though and I conducted several failovers both manual and hostile before moving to prod.

Regards, JP

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 24, 2017 at 03:04 AM
0

Hi Juan

That is reassuring.

Thanks again

Regards, Warren

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 28, 2017 at 03:56 AM
0

Hi Juan

I have another query regarding the license

After a fixpak update , do we need to reinstall the SA MP license ?

samlicm -i sam32.lic

Regards

Warren

Share
10 |10000 characters needed characters left characters exceeded
Juan Reyes
Mar 29, 2017 at 08:01 AM
0

Hi Warren,

Only if you are doing a version upgrade (from 9 to 10), not for fixpacks

Regards, JP

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Mar 29, 2017 at 09:10 AM
0

Thankyou Juan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 22, 2017 at 06:55 AM
0

Hi Juan

Regarding the commands : samctrl -MT and samctrl -MF

are they equivalent to db2haicu commands to disable / enable ?

Reason is that I need to use root ID for samctrl , while I can use db2<sid> for db2haicu commands

Due to security concerns, I may not have access to root ID.

So will I be able to control the cluster using 'db2haicu - disable' to switch to Manual mode when patching / reebooting instead of samctrl -MT?

Appreciate your advice

Regards

Warren

Share
10 |10000 characters needed characters left characters exceeded