Loading a 6.4/05 database into OpenIngres

Gajendra Jain  writes:

[snip]
>3)Reloading a database from 6.4/05 to openingres.
>
>There is problem in reloading system catalogs from 6.4/05 to openingres.
>a) We need to update one of the include statement to point to 
>iiud65.scr instead of iiud64.scr.
>b) There is no drop table statement in this include file so there are a
>couple of tables where the information gets duplicated. One of them
>is ii_id tables. Because of which you cannot use vision and abf.
>Workaround is to remove row in ii_id tables with lower object_id.
>This works for time being.
>
>I have not tested further. Is anyone else facing these problems and anymore. 
>My intention of this mail is to get all the installation level error floating.
>Since the response time from CA tech support currently is a bit high, 
>maybe beacause of lots of call.

I'm not sure about this in OpenIngres, but in certain versions of Ingres
6.x, using the following sequence eliminated similar problems.

$ unloaddb cool
$ unload.ing
$ destroydb cool
$ createdb cool -f nofeclients
$ reload.ing

Does OpenIngres still support the -f nofeclients flag?  

Cheers,

|--------------------------------------------------------------------------|
| Michael Leo            | The Ingres FAQ is at ftp.adc.com, /pub/ingres.  |
| York & Associates, Inc.| Also check out /pub/ingres/utilities/NAIUA for  |
| Minneapolis, MN, USA   | the NAIUA Tool Kit.  Lastly, access all this via|
| (612) 921-8083 (voice) | WWW at http://www.adc.com/ingres/ing-top.html.  |
| mal@winternet.com      | All constructive suggestions/criticism welcome. |
|--------------------------------------------------------------------------|
Ingres Q & A
To William's Home Page
Email William