472,967 Members | 1,713 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,967 software developers and data experts.

DB2 9.5 equivilent of alternate fixpack

In version 8.2 ESE we used alternate fixpacks to allow multiple fixpack
levels for different instances, and to allow an instance to be deprecated
back to the previous fixpack (with certain limitations).

In looking at V9.5 install procedures there are no alternate fixpacks. There
is only a db2_install and a installFixPack script (not counting the db2setup
GUI program).

It looks to me like the installFixPack script is used to update (overlay) an
existing install (not add a separate set of binaries like an alternate
fixpack in 8.2) and that db2_install using a new directory should be used to
emulate the functionality of the an alternate fixpack in V8.2.

Is this interpretation correct?
Sep 19 '08 #1
6 4518
On 19 Wrz, 20:15, "Mark A" <some...@someone.comwrote:
In version 8.2 ESE we used alternate fixpacks to allow multiple fixpack
levels for different instances, and to allow an instance to be deprecated
back to the previous fixpack (with certain limitations).

In looking at V9.5 install procedures there are no alternate fixpacks. There
is only a db2_install and a installFixPack script (not counting the db2setup
GUI program).

It looks to me like the installFixPack script is used to update (overlay) an
existing install (not add a separate set of binaries like an alternate
fixpack in 8.2) and that db2_install using a new directory should be used to
emulate the functionality of the an alternate fixpack in V8.2.

Is this interpretation correct?
You can install more than one instance of DB2 9.1 or 9.5. Then you can
fixpack some of them (or install new DB2 9.5 instance by db2_install
script - fixpack for DB2 9.x is now full installer).

Marcin
Sep 20 '08 #2
"Marcin 'frodo2000' Molak" <fr*******@gmail.comwrote in message
news:de0420fb-4d35-4e3a-b08d-
You can install more than one instance of DB2 9.1 or 9.5. Then you can
fixpack some of them (or install new DB2 9.5 instance by db2_install
script - fixpack for DB2 9.x is now full installer).

Marcin
I am quite aware that in V9+ the fixpack code can be installed without any
previous GA code, but you didn't answer the question. Maybe you are not
familiar with alternate fixpacks in version 8.2.

Also, there is no such thing as installing an instance. You install the code
or a fixpack, and then create or update an instance.

Sep 20 '08 #3
I am quite aware that in V9+ the fixpack code can be installed without any
previous GA code, but you didn't answer the question. Maybe you are not
familiar with alternate fixpacks in version 8.2.

Also, there is no such thing as installing an instance. You install the code
or a fixpack, and then create or update an instance.
Does installing in a new path using db2_install not work? There should
be no need for alternate fixpacks as there can be many parallel
installations.

If you want to apply a fixpack, you have to chose the path to apply
the fixpack to (using -b or -p to ./installfixpack), so that DB2 know
which installation to update.

By the way, DB2 V9.1 didn't need a GA to install a fixpack, but when I
looked at the DB2 V9.5 FP 2 installation requirements, they did
require a DB2 V9.5 GA.
Sep 20 '08 #4
Ian
Mark A wrote:
"Marcin 'frodo2000' Molak" <fr*******@gmail.comwrote in message
news:de0420fb-4d35-4e3a-b08d-
>You can install more than one instance of DB2 9.1 or 9.5. Then you can
fixpack some of them (or install new DB2 9.5 instance by db2_install
script - fixpack for DB2 9.x is now full installer).

Marcin

I am quite aware that in V9+ the fixpack code can be installed without any
previous GA code, but you didn't answer the question. Maybe you are not
familiar with alternate fixpacks in version 8.2.
Mark,

You install the fixpack into a new location. For example, you have
/opt/IBM/db2/v9.5 with GA code, and you can install FP2 into
/opt/IBM/db2/V9.5_fp2.

Then, just use /opt/IBM/db2/V9.5_fp2/instance/db2iupdt to switch
your instance over to the FP2 code.

To switch back, use /opt/IBM/db2/V9.5/instance/db2iupdt. (And,
presumably, restore your database to the pre-FP2 image).

Sep 20 '08 #5
<w.*********@googlemail.comwrote in message
news:df**********************************@r66g2000 hsg.googlegroups.com...
By the way, DB2 V9.1 didn't need a GA to install a fixpack, but when I
looked at the DB2 V9.5 FP 2 installation requirements, they did
require a DB2 V9.5 GA.
Actually, 9.5 FP2 does not need 9.5 GA (or any previous code). That is an
error (or at least a very poorly worded) install instructions.
Sep 21 '08 #6
"Ian" <ia*****@mobileaudio.comwrote in message
news:eA******************@newsfe01.iad...
Mark,

You install the fixpack into a new location. For example, you have
/opt/IBM/db2/v9.5 with GA code, and you can install FP2 into
/opt/IBM/db2/V9.5_fp2.

Then, just use /opt/IBM/db2/V9.5_fp2/instance/db2iupdt to switch
your instance over to the FP2 code.

To switch back, use /opt/IBM/db2/V9.5/instance/db2iupdt. (And,
presumably, restore your database to the pre-FP2 image).
Yes I have figured that out now. But to do that one must use the db2_install
script, and not the installFixPack script. That is not clear from the
instructions, but I figured it out by trial and error.
Sep 21 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: alederer | last post by:
Hallo! I have the following situation: DB2 V6.1 OS/390 and DB2 V6.1 auf AIX 4.3.3 running the database servers. A windows NT machine with db2 V7.1.040 FP3 (WR21254) client. Now I have a JDBC...
6
by: cat | last post by:
Hi Folks, We are going to start a grand new project, which is DB2v7 FP10a sitting on AIX4.3.3 on M80 server. Here is my question, 1) According to Fixpack installation guide, I have to install...
1
by: John Wheeler | last post by:
Hi, We upgraded the Windows ADC V8.1 to fixpack 5 on some Windows 2000 (Dutch Version) professional machines and something strange happened. When we select decimal columns in our queries the...
1
by: Carl Draus | last post by:
I was reading the FixPackReadme.txt file in preparation for installing v8.1 Alternate FP7. The prerequisites section says that all DB2 processes must be stopped and doesn't differentiate between...
0
by: Jean-Marc Blaise | last post by:
Hi, From version 8.1.2 one can install alternate fixpacks on Unix/Linux. What is the IBM policy on alternate fixpack; is it for temporary testing or can it be permanent in Production ? If I...
4
by: pshindle | last post by:
DB2 Team - I just downloaded and unzipped the new Fixpack 9 for DB2 ESE V8 for Windows (FP9_WR21350_ESE.exe). I then burned the unzipped Fixpack files to a CD. I proceded to install this...
4
by: Mark A | last post by:
Trying to upgrade alternate FP9 to alternate FP9a on Red Hat Linux. After running the following command: ../installAltFixPak -y it says it was successful, but no new directory is created in...
1
by: Norman wong | last post by:
Can Alternate Fixpaks be used with DB2 Connect Enterprise Edition on AIX? The same regular fixpack can be used on both UDB and Connect. The website isn't quite clear. Norm
0
by: shiva359 | last post by:
Hi Looking for a quick safest way of rollback plan for fixpack (version 8 fixpack 14 ) upgraded Instance on windows from verison 8 ( no fixpack ) level . one approach is...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
3
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.