Professional Web Applications Themes

downgrade from 9.3 to 7.3 question - Informix

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 ...

  1. #1

    Default downgrade from 9.3 to 7.3 question


    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.
    [url]http://server1.msn.co.in/sp03/gprs/index.asp[/url] On your mobile!

    sending to informix-list
    Chavan Koya Guest

  2. #2

    Default RE: downgrade from 9.3 to 7.3 question


    Hi, Chavan,

    Primary, foreign and unique constraints create
    Indexes implicitly.

    You should drop (not disable!!!) constraints and then,
    May be, drop proper indexes.

    ------------------------------------------
    Alexey Sonkin
    Senior Database Administrator

    > -----Original Message-----
    > From: Chavan Koya [mailto:chavankoya189hotmail.com]
    > Sent: Friday, August 15, 2003 4:12 PM
    > To: [email]informix-listiiug.org[/email]
    > Subject: downgrade from 9.3 to 7.3 question
    >
    > 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.
    > [url]http://server1.msn.co.in/sp03/gprs/index.asp[/url] On your mobile!
    >
    > sending to informix-list
    sending to informix-list
    Alexey Sonkin Guest

Similar Threads

  1. Downgrade from MX 7 to MX 6?
    By Leeesher in forum Coldfusion Server Administration
    Replies: 1
    Last Post: August 7th, 10:22 AM
  2. How to downgrade perl from 5.8.6 to 5.8.5?
    By Todd Suits in forum FreeBSD
    Replies: 1
    Last Post: February 26th, 09:23 PM
  3. Flash MX 2004 seems like a downgrade
    By Trond Gulbrandsen in forum Macromedia Flash
    Replies: 7
    Last Post: September 27th, 08:30 AM
  4. Using Version 5.05 to downgrade PDF 1.5 to PDF 1.4 or 1.3
    By Sam_M._Gerber@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 2
    Last Post: April 12th, 08:42 PM
  5. Can I do a license downgrade from CS to 10?
    By Kim_Sommer@adobeforums.com in forum Adobe Illustrator Macintosh
    Replies: 4
    Last Post: February 10th, 12:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139