In-place alter
Hello Everybody,
Env: 9.30uc3 AIX 5.1. (plan to upgrade 9.40 FC4 AIX 5.2).
(this is reference to the oncheck -pT output for current/oldest pages)
We have 2 huge tables with in-place alter, do we have to bring all the pages
to the
current pages before the upgrade, one table is small so I can run the fake
update
to make all the pages current but another table is huge, any
suggestions/recommendations...
What happens if I go for upgrade without clearing the old pages.
Thanks in advance,
Sushil...
--0__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60
Content-type: multipart/alternative;
Boundary="1__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60"
--1__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Upgrade is not a problem for in-place-alters ..its only when you want t=
o
downgrade it'll stop u from doing it ...
Thanx much,
Rajib Sarkar
Advisory Software Engineer
DB2/UDB Regional Advanced Support
IBM Data Management Group
If we all did the things we are capable of doing, we would literally
astound ourselves. -- T. Edison
=
"Sushil Shir...." =
<sushilps@hotmail =
.com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
In-place alter [3397] =
09/08/2004 07:03 =
AM =
=
=
=
=
Hello Everybody,
Env: 9.30uc3 AIX 5.1. (plan to upgrade 9.40 FC4 AIX 5.2).
(this is reference to the oncheck -pT output for current/oldest pages)
We have 2 huge tables with in-place alter, do we have to bring all the
pages
to the
current pages before the upgrade, one table is small so I can run the f=
ake
update
to make all the pages current but another table is huge, any
suggestions/recommendations...
What happens if I go for upgrade without clearing the old pages.
Thanks in advance,
Sushil...
=
--1__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Upgrade is not a problem for in-place-alters ..its only when you wan=
t to downgrade it'll stop u from doing it ...<br>
<br>
<br>
<br>
Thanx much,<br>
<br>
Rajib Sarkar<br>
Advisory Software Engineer<br>
DB2/UDB Regional Advanced Support<br>
IBM Data Management Group<br>
<br>
<br>
If we all did the things we are capable of doing, we would literally as=
tound ourselves. -- T. Edison<br>
<br>
<img src=3D"cid:10__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "Sushil Shir..=
.." <sushilps@hotmail.com>">"Sushil Shir...." <=
sushilps@hotmail.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE59=
ADFC08D608f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"Sushil Shir...." <sushilps@hotmai=
l.com></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">09/08/2004 07:03 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D88BBE59ADFC08D608f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">In-place alter [3397]</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE59ADFC0=
8D608f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE59ADFC08D608f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hello Everybody,<br>
<br>
Env: 9.30uc3 AIX 5.1. (plan to upgrade 9.40 FC4 AIX 5.2).<br>
<br>
(this is reference to the oncheck -pT output for current/oldest pages)<=
br>
<br>
We have 2 huge tables with in-place alter, do we have to bring all the =
pages <br>
to the<br>
current pages before the upgrade, one table is small so I can run the f=
ake <br>
update<br>
to make all the pages current but another table is huge, any <br>
suggestions/recommendations...<br>
<br>
What happens if I go for upgrade without clearing the old pages.<br>
<br>
Thanks in advance,<br>
Sushil...<br>
<br>
<br>
<br>
</tt><br>
</body></html>=
--1__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60--
--0__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=88BBE59ADFC08D608f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=88BBE59ADFC08D608f9e8a93df938690918c88BBE59ADFC08D60
Content-type: image/gif;
name="pic22832.gif"
Content-Disposition: inline; filename="pic22832.gif"
Content-ID: <20__=88BBE59ADFC08D608f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8
Sushil Shir.... said:
> Hello Everybody,
>
> Env: 9.30uc3 AIX 5.1. (plan to upgrade 9.40 FC4 AIX 5.2).
>
> (this is reference to the oncheck -pT output for current/oldest pages)
>
> We have 2 huge tables with in-place alter, do we have to bring all the
> pages
> to the
> current pages before the upgrade, one table is small so I can run the fake
> update
> to make all the pages current but another table is huge, any
> suggestions/recommendations...
>
> What happens if I go for upgrade without clearing the old pages.
Nothing. But you might run into problems if you need to revert. Check the
migration guide.
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
Thanks guys for your input.
Sushil...
Sushil Shir.... said:
>Hello Everybody,
>
>Env: 9.30uc3 AIX 5.1. (plan to upgrade 9.40 FC4 AIX 5.2).
>
>(this is reference to the oncheck -pT output for
current/oldest pages)
>
>We have 2 huge tables with in-place alter, do we have to bring
all the
>pages
>to the
>current pages before the upgrade, one table is small so I can
run the fake
>update
>to make all the pages current but another table is huge, any
>suggestions/recommendations...
>
>What happens if I go for upgrade without clearing the old
pages.
Nothing. But you might run into problems if you need to revert.
Check the
migration guide.
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa
gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up
my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
>From: Rajib Sarkar <rsarkar@us.ibm.com>
>To: "Sushil Shir...." <sushilps@hotmail.com>
>CC: forum.subscriber@iiug.org, ids@iiug.org
>Subject: Re: In-place alter [3397]
>Date: Wed, 8 Sep 2004 08:07:42 -0700
>MIME-Version: 1.0
>Received: from e33.co.us.ibm.com ([32.97.110.131]) by mc11-f15.hotmail.com
>with Microsoft SMTPSVC(5.0.2195.6824); Wed, 8 Sep 2004 08:22:06 -0700
>Received: from westrelay02.boulder.ibm.com (westrelay02.boulder.ibm.com
>[9.17.195.11])by e33.co.us.ibm.com (8.12.10/8.12.9) with ESMTP id
>i88FKiDD423986;Wed, 8 Sep 2004 11:20:46 -0400
>Received: from d03nm131.boulder.ibm.com (d03av04.boulder.ibm.com
>[9.17.195.170])by westrelay02.boulder.ibm.com (8.12.10/NCO/VER6.6) with
>ESMTP id i88FKcr4064772;Wed, 8 Sep 2004 09:20:39 -0600
>X-Message-Info: JGTYoYF78jHRwWphIqcivSdOO8SIj+NY
>In-Reply-To: <200409081403.i88E3SbH007324@ace.iiug.org>
>X-Mailer: Lotus Notes Release 6.0.2CF1 June 9, 2003
>Message-ID:
><OF581EE912.10D0E2E0-ON07256F09.00530BF0-07256F09.00531A3F@us.ibm.com>
>X-MIMETrack: Serialize by Router on D03NM131/03/M/IBM(Release 6.51HF338 |
>June 21, 2004) at 09/08/2004 09:20:38
>Return-Path: rsarkar@us.ibm.com
>X-OriginalArrivalTime: 08 Sep 2004 15:22:06.0737 (UTC)
>FILETIME=[99EF5810:01C495B7]
>
>
>
>
>
>
>Upgrade is not a problem for in-place-alters ..its only when you want to
>downgrade it'll stop u from doing it ...
>
>
>
>Thanx much,
>
>Rajib Sarkar
>Advisory Software Engineer
>DB2/UDB Regional Advanced Support
>IBM Data Management Group
>
>
>If we all did the things we are capable of doing, we would literally
>astound ourselves. -- T. Edison
>
>
>
>
> "Sushil Shir...."
> <sushilps@hotmail
> .com> To
> Sent by: ids@iiug.org
> forum.subscriber@ cc
> iiug.org
> Subject
> In-place alter [3397]
> 09/08/2004 07:03
> AM
>
>
>
>
>
>
>
>
>Hello Everybody,
>
>Env: 9.30uc3 AIX 5.1. (plan to upgrade 9.40 FC4 AIX 5.2).
>
>(this is reference to the oncheck -pT output for current/oldest pages)
>
>We have 2 huge tables with in-place alter, do we have to bring all the
>pages
>to the
>current pages before the upgrade, one table is small so I can run the fake
>update
>to make all the pages current but another table is huge, any
>suggestions/recommendations...
>
>What happens if I go for upgrade without clearing the old pages.
>
>Thanks in advance,
>Sushil...
>
>
>