473,796 Members | 2,515 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4559
On 19 Wrz, 20:15, "Mark A" <some...@someon e.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*******@gmai l.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*******@gmai l.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.*********@go oglemail.comwro te in message
news:df******** *************** ***********@r66 g2000hsg.google groups.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*****@mobile audio.comwrote in message
news:eA******** **********@news fe01.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
1769
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 application which crashes when it tries to find out the primary keys of a table on the AIX db server using getPrimaryKeys on tables with primary keys (it don't crash with tables without primary keys!).
6
8621
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 Fixpack1(Pre-request of Fixpack 3 installation), Fixpack 3(Pre-request of Fixpack 10a) in order to successful install Fixpack 10a.Question is do I have to follow this sequence or there is a way jump to fixpack 10a.
1
2411
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 decimal separator of the decimal columns has become a comma while it was a dot. Example resultset : Before Fixpack 5:
1
1356
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 regular an alternate fixpacks. I was hoping the alternate fixpack would help to avoid downtime. Do you really need to stop all DB2 process for alternate fixpack installations? -- Carl Draus
0
1511
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 open a PMR about an alternate fixpack problem, do I have the same service than on the GA+Fixpack code ? Can I get a special build, in case ... ?
4
3522
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 Fixpack on a test machine running ESE but encountered a serious error during the install. It started 'copying new files' but then stopped cold and displayed a dialog box asking me to "Please insert disk 1". (It all fit on one CD!) I clicked OK...
4
2067
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 /opt/IBM/db2 Assuming that maybe fixpack 9a updates the existing /opt/IBM/db2/V8.FP9 directory, I ran db2iupdt on the instance (using root), but db2level still shows the signature for fixpack 9 (not 9a). "DB2 v8.1.0.88", "s050422"
1
1286
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
1689
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 take ixf dumps using db2move
0
9529
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10457
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10176
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9054
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7550
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6792
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5443
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5576
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2927
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.