By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,728 Members | 2,414 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,728 IT Pros & Developers. It's quick & easy.

update from V8.1 Fixpak 8 to Fixpak 9

P: n/a
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.

Jan 24 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a
mike_li wrote:
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 ?
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?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 24 '06 #2

P: n/a
Thanks for your response.

They are phyiscal nodes, 4 separate servers.

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


Knut Stolze wrote:
mike_li wrote:
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 ?


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?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


Jan 24 '06 #3

P: n/a
mike_li wrote:
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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Jan 24 '06 #4

P: n/a
mike_li wrote:
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

--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 24 '06 #5

P: n/a
mike_li wrote:
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?
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.
Jan 25 '06 #6

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

Mike

Darin McBride wrote:
mike_li wrote:
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?


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.


Jan 25 '06 #7

P: n/a
mike_li wrote:
There are many online books on upgrade , but not specific on upgrading
instances with DPF.
Could you give a link? Thanks.

Mike

Darin McBride wrote:
mike_li wrote:
[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/infoce.../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.
Jan 26 '06 #8

P: n/a
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.
Darin McBride wrote:
mike_li wrote:
There are many online books on upgrade , but not specific on upgrading
instances with DPF.
Could you give a link? Thanks.

Mike

Darin McBride wrote:
mike_li wrote:
[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/infoce.../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.


Jan 26 '06 #9

P: n/a
mike_li wrote:
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:

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.


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

Jan 26 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.