Re: downgrade from 9.3 to 7.3 question
Hi Chavan,
There was a bug found in 9.3 which would render your table unavailable
after reversion if
a) your table is fragmented and you've added/detached fragments in the
table after migration to 9.3
b) you have created a new constraint on the table in 9.3
The only way out from this bug is to
a) detach all the new fragments to new tables and then re-attach the new
tables as fragments when the reversion is completed
b) drop constraints and then re-create constraints when reversion is
completed.
HTH
P.S: Bug#156528
Thanx much,
Rajib Sarkar
Advisory Software Engineer (RAS)
IBM Data Management Group
Ph : (602)-217-2100
Fax: (602)-217-2100
T/L : 667-2100
As long as you derive inner help and comfort from anything, keep it --
Mahatma Gandhi
"Chavan Koya"
<chavankoya189@hot To: informix-list@iiug.org
mail.com> cc:
Sent by: Subject: downgrade from 9.3 to 7.3 question
owner-informix-lis
t@iiug3.org
08/15/2003 01:12
PM
Hello All,
I am trying to do reversion process from 9.3to 7.3 version as you
said before. I did drop all the indexes after having the backup of all the
create index statements.
When i try to use the command "onmode -b 7.3 ". i was getting the
following messages
Then i looked into the dbschema out put of the table, there was no indexes,
these (375_810) are constraints.
If i disable constraints, will i be able to do the reversion process or
should i do some thing else ?
any comments suggestions are welcome and Thanks in Advance.
FYI : The table has been fragmented.
>onmode -b 7.3
This will make all necessary modifications to disk structures
so that the Informix Dynamic Server 2000 space will be compatible with
INFORMIX-OnLine Version 7.3
Do you wish to continue (y/n)? y
Beginning process of reverting system to 7.3 ...
Table/Index 'database:"owner". 375_810 on table table name'
must be dropped or altered before using Version 7 because ...
There is a semi-detached index in this table, which cannot be reverted.
Drop indexes of this type, and retry reversion.
_________________________________________________________________
Polyphonic ringtones. Latest movie trailors.
http://server1.msn.co.in/sp03/gprs/index.asp On your mobile!
sending to informix-list
sending to informix-list