473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Commit the applied FixPak??

ENVIRONMENT:
============
(1) AIX 5.2 ML 8 and AIX 5.3 TL 4.
(2) DB2 ESE on some servers and DB2 Connect Enterprise Edition on
others.

QUESTION:
=========
I upgrade DB2 on some 15 Production servers using 'installFixPak -ay',
from 8.1.4 to 8.1.11.
All upgrade steps successful, goal achieved much before time, mgmt
pats my back!!

Now, I need to COMMIT the upgrade. I would not like to request another
downtime;
**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?
**** Do I require downtime to COMMIT?

Help very much appreciated...Anurag

Mar 22 '07 #1
9 3125
Anurag wrote:
ENVIRONMENT:
============
(1) AIX 5.2 ML 8 and AIX 5.3 TL 4.
(2) DB2 ESE on some servers and DB2 Connect Enterprise Edition on
others.

QUESTION:
=========
I upgrade DB2 on some 15 Production servers using 'installFixPak -ay',
from 8.1.4 to 8.1.11.
All upgrade steps successful, goal achieved much before time, mgmt
pats my back!!

Now, I need to COMMIT the upgrade. I would not like to request another
downtime;
**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?
Yes
**** Do I require downtime to COMMIT?
No
Help very much appreciated...Anurag
Please see the AIX documentation on committing with installp and/or smit
and/or smitty.
Mar 22 '07 #2
I have response from IBM (had opened a PMR) on these 2 questions.
Lemme share this with you all:
**** Can I COMMIT the upgrades without any disruption to applications / users using the existing DB2?
NO, unless it's a Client Installation.
**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)

....anurag

On Mar 22, 4:36 pm, Darin McBride
<dmcbr...@tower.to.org.no.spam.for.mewrote:
Anuragwrote:
ENVIRONMENT:
============
(1) AIX 5.2 ML 8 and AIX 5.3 TL 4.
(2) DB2 ESE on some servers and DB2 Connect Enterprise Edition on
others.
QUESTION:
=========
I upgrade DB2 on some 15 Production servers using 'installFixPak -ay',
from 8.1.4 to 8.1.11.
All upgrade steps successful, goal achieved much before time, mgmt
pats my back!!
Now, I need to COMMIT the upgrade. I would not like to request another
downtime;
**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?

Yes
**** Do I require downtime to COMMIT?

No
Help very much appreciated...Anurag

Please see the AIX documentation on committing with installp and/or smit
and/or smitty.- Hide quoted text -

- Show quoted text -
Mar 30 '07 #3
Anurag wrote:
>
On Mar 22, 4:36 pm, Darin McBride
<dmcbr...@tower.to.org.no.spam.for.mewrote:
>Anuragwrote:
>>ENVIRONMENT:
============
(1) AIX 5.2 ML 8 and AIX 5.3 TL 4.
(2) DB2 ESE on some servers and DB2 Connect Enterprise Edition on
others.
>>QUESTION:
=========
I upgrade DB2 on some 15 Production servers using 'installFixPak
-ay',
from 8.1.4 to 8.1.11.
All upgrade steps successful, goal achieved much before time, mgmt
pats my back!!
>>Now, I need to COMMIT the upgrade. I would not like to request
another
downtime;
**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?

Yes
>>**** Do I require downtime to COMMIT?

No
>>Help very much appreciated...Anurag

Please see the AIX documentation on committing with installp and/or
smit and/or smitty.

I have response from IBM (had opened a PMR) on these 2 questions.
Lemme share this with you all:
>>**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?
NO, unless it's a Client Installation.
>>**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)

...anurag
Alternatively, you could just postpone the COMMIT until you have to bring
DB2 down for some other reason.
DB2 will run just happily in APPLY mode, without COMMITing.
In case you want to do the COMMIT anyway, I did it only a couple of days
ago, and it took only 15 minutes.

--
Jeroen
Mar 30 '07 #4
Anurag wrote:
I have response from IBM (had opened a PMR) on these 2 questions.
Can you send me the PMR number? Was it against DB2 or AIX? These responses
don't make a lot of sense to me - so I'd like to pursue it.
Lemme share this with you all:
**** Can I COMMIT the upgrades without any disruption to applications /
users using the existing DB2?
NO, unless it's a Client Installation.
**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)
Of course, it never hurts to be safe rather than sorry, but, still - it'd be
nice to be able to just commit.

(Nothing in the fixpack readme talks about shutting down the server prior to
committing, which I presume would be there if DB2 developers knew of any
reason why you would need to do so.)
Mar 30 '07 #5
Darin McBride wrote:
Anurag wrote:
>I have response from IBM (had opened a PMR) on these 2 questions.

Can you send me the PMR number? Was it against DB2 or AIX? These
responses don't make a lot of sense to me - so I'd like to pursue it.
>Lemme share this with you all:
>>>**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?
NO, unless it's a Client Installation.
>>>**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)

Of course, it never hurts to be safe rather than sorry, but, still -
it'd be nice to be able to just commit.

(Nothing in the fixpack readme talks about shutting down the server
prior to committing, which I presume would be there if DB2 developers
knew of any reason why you would need to do so.)
I think you are right.
From the AIX Commands Reference (installp command):

<quote>
When a fileset update is applied to the system, the update is installed. The
current version of that software, at the time of the installation, is saved
in a special save directory on the disk so that later you can return to that
version if desired. Once a new version of a software product has been
applied to the system, that version becomes the currently active version of
the software.
<..>
When updates are committed with the -c flag, the user is making a commitment
to that version of the software product, and the saved files from all
previous versions of the software product are removed from the system,
thereby making it impossible to return to a previous version of the software
product. Software can be committed at the time of installation by using
the -ac flags. Note that committing already applied updates does not change
the currently active version of a software product. It merely removes saved
files for previous versions of the software product.
</quote>

--
Jeroen
Mar 30 '07 #6
Ian
Anurag wrote:
I have response from IBM (had opened a PMR) on these 2 questions.
Lemme share this with you all:
>>**** Can I COMMIT the upgrades without any disruption to applications / users using the existing DB2?
NO, unless it's a Client Installation.
>>**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)

I concur with Darin. This is wrong.

I have committed applied fixes with the database running more times than
I can count. And I have never had an issue.

Mar 31 '07 #7
In article <4D********************@newsfe08.phx>,
ia*****@mobileaudio.com says...
Anurag wrote:
I have response from IBM (had opened a PMR) on these 2 questions.
Lemme share this with you all:
>**** Can I COMMIT the upgrades without any disruption to applications / users using the existing DB2?
NO, unless it's a Client Installation.
>**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)

I concur with Darin. This is wrong.

I have committed applied fixes with the database running more times than
I can count. And I have never had an issue.

Then you concur with Anurag, Darin said no downtime was needed.
Mar 31 '07 #8
Gert van der Kooij wrote:
In article <4D********************@newsfe08.phx>,
ia*****@mobileaudio.com says...
>Anurag wrote:
>>I have response from IBM (had opened a PMR) on these 2 questions.
Lemme share this with you all:
**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?
NO, unless it's a Client Installation.

**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)


I concur with Darin. This is wrong.

I have committed applied fixes with the database running more times
than I can count. And I have never had an issue.


Then you concur with Anurag, Darin said no downtime was needed.
And that's what Ian is agreeing with.
I guess you mix up the meaning of 'to concur' with Dutch 'concurreren'.
http://www.m-w.com/dictionary/concur

--
Jeroen
Mar 31 '07 #9
In article <46***********************@news.xs4all.nl>,
us****@No.Spam.Please.invalid says...
Gert van der Kooij wrote:
In article <4D********************@newsfe08.phx>,
ia*****@mobileaudio.com says...
Anurag wrote:
I have response from IBM (had opened a PMR) on these 2 questions.
Lemme share this with you all:
**** Can I COMMIT the upgrades without any disruption to
applications / users using the existing DB2?
NO, unless it's a Client Installation.

**** Do I require downtime to COMMIT?
YES. You need db2stop and ipclean before COMMITing.

So, after all the accolades from management, I now have to request
downtime for COMMIT (maybe I do that over Easter weekend and nobody
makes a fuss :)

I concur with Darin. This is wrong.

I have committed applied fixes with the database running more times
than I can count. And I have never had an issue.

Then you concur with Anurag, Darin said no downtime was needed.

And that's what Ian is agreeing with.
I guess you mix up the meaning of 'to concur' with Dutch 'concurreren'.
http://www.m-w.com/dictionary/concur

I guess so :) Sorry, I withdraw my comment.
Mar 31 '07 #10

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

Similar topics

0
by: Carl Castrianni | last post by:
I have UDB ESE fixpak 2 installed on a Windows XP Pro machine. I downloaded ESE fixpak 3 (and fixpak 4) from the IBM Web site. When I run the fixpak 3 installer (or the fixpak 4 installer for...
7
by: Gandalf | last post by:
Hi all, I am connecting to DB2 8.1 on Solaris through JDBC type 4 drivers (driver: com.ibm.db2.jcc.DB2Driver). Problem is that when a cursored query is done, the resultset gets closed after...
4
by: Lennart Jonsson | last post by:
I need to do a two phase commit (a transaction over a table and a nickname). Trying to do so gives me the error SQL30090N reason = 18 The suggested action is: If multiple data sources need to...
5
by: Mary Lei | last post by:
I have problems connecting to ftp server to obtain the solaris fixpak to upgrade to DB2 8.2.1 ...
0
by: Matteo Gelosa | last post by:
I experienced (twice) a problem with db2 for aix 5 64 bits fixpak 9a. Some application was listed with the status "Commit Active" blocking the transaction log a making it full after some time. ...
9
by: mike_li | last post by:
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...
8
by: Christopher Keller | last post by:
Hello, does anyone know why on the IBM download section of the UDB Support page http://www-306.ibm.com/software/data/db2/udb/support/ FP 13, 11 and 10 are listed prominently, but not FP12. We...
1
by: aj | last post by:
I'm currently on DB2 LUW v8.1 fixpack 5 DB21085I Instance "xxxx" uses "32" bits and DB2 code release "SQL08015" with level identifier "02060106". Informational tokens are "DB2 v8.1.0.48",...
7
by: m.gelosa | last post by:
Dear all, I got a problem on db2 for aix running a high workload messaging system with more than 5,000,000 of deliveries per day. During high peak hours it happens frequently that the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.