RE: Complete in-place alters
I'd written a script long back to do exactly that .. i.e. to avoid using
oncheck -pT .. it'll use onstat to get the info .. and also create a scriptwith the update statements for the tables which require an update.
Attached is the script ..
(See attached file: README.inplacealter.txt)(See attached file:
inplacealter.ksh.txt)
Rajib Sarkar
SWG Client Support - Software
Sr. Technical Analyst
DB2 Advanced Problem Diagnostics Team ( Level 3
Support)
Phone: 1-602-217-2100 Internal: 667-2100
rsarkar@us.ibm.com
|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|"Habichtsberg, Reinhard" <RHabichtsberg@arz-emmendingen.de> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|informix-list@iiug.org |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|10/30/2008 11:45 PM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|RE: Complete in-place alters |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
Fernando Nunes wrote
>
> Habichtsberg, Reinhard wrote:
> > Hi all,
> >
> > In preperation for migration from IDS 9.40 to 11.5 we have
> to complete all
> > in-place alters. We have tables up to a billion rows with
> many pending
> > in-place alters. The amount of data adds up to some TB.
>
> Why do you "have to"? Is that in IDS 11.50 documentation?
> I know that this question can turn this into an hot topic...
> I browsed through
> the documentation very quickly and I think that step is not there...
>
> Note that if you need to revert you should not have pending
> in-place alter tables.
In Migration Guide chapter 1: Overview of Dynamic Server Migration page 1.3
and 1.4 topics: Upgrading Dynamic Server (In-place Migration) and Migrating
Dynamic Server (Non-in-place Migration): 1. Prepare your system. That
includes removing outstanding in-place alters, ...
May be the reason is the reverting issue as you an OTC pointed out. Anyway
it seems to be no mistake to the job. What I'm looking for is some advice
to
do it well...
Any further suggestions?
--
Regards,
Reinhard.
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list