update from V8.1 Fixpak 8 to Fixpak 9

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mike_li - 24 Jan 2006 16:44 GMT

We are considering to update from V8.1 Fixpak 8 to Fixpak 9.

Operating System Information:
OSName: AIX
NodeName: mdxxx01, mdxxx02, mdxxx03, mdxxx04
Version: 5
Release: 2

64 bits and DB2 code release SQL08021 with level identifier 03020106
Informational tokens are DB2 v8.1.1.80, special_13100, U800400_13100,
FixPak 8.

With DPF: 4 nodes with 16 partitions.
With 4 instances.

My concern:
--do i need to install Fixpak binary code FixPak9 on four nodes
individually?
-- do i need to update each instance on 4 nodes ?
--Where can i find documentation on update DB2 with DPF in a cluster
server?

Thank you.

Reply to this Message

Knut Stolze - 24 Jan 2006 19:51 GMT

> We are considering to update from V8.1 Fixpak 8 to Fixpak 9.
>
[quoted text clipped - 15 lines]
> individually?
> -- do i need to update each instance on 4 nodes ?

I would do both to be on the safe side.

Are these logical or physical nodes? For logical nodes, you just update all
the machines where DB2 runs on and then all instances involved in your
setup.

> --Where can i find documentation on update DB2 with DPF in a cluster
> server?

Have you looked at the README file that comes with each FP?

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

mike_li - 24 Jan 2006 21:17 GMT

Thanks for your response.

They are phyiscal nodes, 4 separate servers.

So we need to install the binary codes on 4 servers.

> > We are considering to update from V8.1 Fixpak 8 to Fixpak 9.
> >
[quoted text clipped - 31 lines]
> DB2 Information Integration Development
> IBM Germany

Reply to this Message

Knut Stolze - 24 Jan 2006 21:26 GMT

> Thanks for your response.
>
> They are phyiscal nodes, 4 separate servers.
>
> So we need to install the binary codes on 4 servers.

I have never done this myself (just worked with logical nodes so far), but
given that each server is independent of the others, yes, you will have to
install the FP on each one of them.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message

Serge Rielau - 24 Jan 2006 22:42 GMT

> Thanks for your response.
>
> They are phyiscal nodes, 4 separate servers.
>
> So we need to install the binary codes on 4 servers.

Well.. depends if the filesystem for the binary code is cross mounted
then only one install of course.

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab

Reply to this Message

Darin McBride - 25 Jan 2006 02:35 GMT

> We are considering to update from V8.1 Fixpak 8 to Fixpak 9.
>
[quoted text clipped - 14 lines]
> --do i need to install Fixpak binary code FixPak9 on four nodes
> individually?

Yes.

> -- do i need to update each instance on 4 nodes ?

No. The instance-owning node (aka the one where the instance is "local" -
the rest of the nodes should have the first node's home directory mounted,
usually via NFS) only.

> --Where can i find documentation on update DB2 with DPF in a cluster
> server?

There should be plenty of documentation in the online books.

Reply to this Message

mike_li - 25 Jan 2006 16:51 GMT

There are many online books on upgrade , but not specific on upgrading
instances with DPF.
Could you give a link? Thanks.

Mike

> > We are considering to update from V8.1 Fixpak 8 to Fixpak 9.
> >
[quoted text clipped - 27 lines]
>
> There should be plenty of documentation in the online books.

Reply to this Message

Darin McBride - 26 Jan 2006 15:56 GMT

> There are many online books on upgrade , but not specific on upgrading
> instances with DPF.
> Could you give a link? Thanks.
>
> Mike

[snip]

>> > --Where can i find documentation on update DB2 with DPF in a cluster
>> > server?
>>
>> There should be plenty of documentation in the online books.

http://publib.boulder.ibm.com/infocenter/db2luw/v8//index.jsp

-> Installing
-> Database systems
-> DB2 servers
-> DB2 UDB Enterprise Server Edition (partitioned)
-> AIX

After you've opened up all the twisties to this point, you should see plenty
of information on setting up a partitioned cluster. This should help
explain the set up of DPF - the only question left is whether applying a
fixpak to a single node applies it to all nodes. That information should
be in the fixpak readme. However, even without reading the fixpak readme,
the implication is that if you need to install to all nodes, you need to
apply a fixpak to all nodes. And since you only run db2icrt on a single
node, you only need to run db2iupdt on a single node. Those implications
are, in fact, true.

I hope that helps.

Reply to this Message

mike_li - 26 Jan 2006 16:36 GMT

Thank you very much, Darin. Really appreciate that.

I think the steps I am going to take is:
--download Fixpak 9 on the 4 physical servers
--install the Fixkpak 9 on the 4 servers
--issue db2iupdt on 4 servers respectively ( from logical port 0 on
each server)

db2nodes.cfg looks like:

0 xxxxx01-svc 0 xxxxx01
1 xxxxx01-svc 1 xxxxx01
2 xxxxx01-svc 2 xxxxx01
3 xxxxx01-svc 3 xxxxx01
4 xxxxx01-svc 4 xxxxx01
5 xxxxx02-svc 0 xxxxx02
6 xxxxx02-svc 1 xxxxx02
7 xxxxx02-svc 2 xxxxx02
8 xxxxx02-svc 3 xxxxx02
9 xxxxx03-svc 0 xxxxx03
10 xxxxx03-svc 1 xxxxx03
11 xxxxx03-svc 2 xxxxx03
12 xxxxx03-svc 3 xxxxx03
13 xxxxx04-svc 0 xxxxx04
14 xxxxx04-svc 1 xxxxx04
15 xxxxx04-svc 2 xxxxx04
16 xxxxx04-svc 3 xxxxx04

16 partitions on 4 physical server.

> > There are many online books on upgrade , but not specific on upgrading
> > instances with DPF.
[quoted text clipped - 28 lines]
>
> I hope that helps.

Reply to this Message

Darin McBride - 26 Jan 2006 20:13 GMT

> Thank you very much, Darin. Really appreciate that.
>
> I think the steps I am going to take is:
> --download Fixpak 9 on the 4 physical servers

If you download it into your instance's home directory, it'll be immediately
accessible on all machines. Just a little trick I've learned. (Normally
the instance's home directory is cross-mounted, although you technically
only need the sqllib to be cross-mounted (makes things a bit harder
though), if that's your setup, just put it inside the sqllib somewhere
temporarily.)

> --install the Fixkpak 9 on the 4 servers

Correct.

> --issue db2iupdt on 4 servers respectively ( from logical port 0 on
> each server)

This is not needed. You only need to update on a single node - my
recommendation is whichever node has the instance running locally (where
the home directory physically resides rather than being NFS mounted). If
no node has the instance locally (e.g., it's physically on a NAS or SAN),
then any node will do.

That said, it doesn't hurt anything except waste time, bandwidth, and
unnecessary hard disk activity.

> db2nodes.cfg looks like:
>
[quoted text clipped - 17 lines]
>
> 16 partitions on 4 physical server.

That would be 17 partitions. ;-) The 01 server has 5 partitions (0-4).

Reply to this Message