RetroBBS - comp.databases.ingres - Re: [Info-ingres] The database that isn't there

Re: [Info-ingres] The database that isn't there

<mailman.90.1632925790.1681.info-ingres@lists.planetingres.org>

https://www.rocksolidbbs.com/devel/article-flat.php?id=121&group=comp.databases.ingres#121

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!4.us.feeder.erje.net!2.eu.feeder.erje.net!feeder.erje.net!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!tr1.eu1.usenetexpress.com!feeder.usenetexpress.com!tr3.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!buffer2.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 29 Sep 2021 09:30:04 -0500
Content-Type: text/plain; charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\))
From: schendel@kbcomputer.com (Karl Schendel)
In-Reply-To: <e784c0760f0342d2899dc962d2d1b711@ndph.ox.ac.uk>
Date: Wed, 29 Sep 2021 10:29:46 -0400
Content-Transfer-Encoding: quoted-printable
References: <e784c0760f0342d2899dc962d2d1b711@ndph.ox.ac.uk>
To: "info-ingres@lists.planetingres.org" <info-ingres@lists.planetingres.org>
Cc: Martin Bowes <martin.bowes@ndph.ox.ac.uk>
Subject: Re: [Info-ingres] The database that isn't there
Precedence: list
Newsgroups: comp.databases.ingres
Message-ID: <mailman.90.1632925790.1681.info-ingres@lists.planetingres.org>
Lines: 43

by: Karl Schendel - Wed, 29 Sep 2021 14:29 UTC

> On Sep 29, 2021, at 10:09 AM, Martin Bowes <martin.bowes@ndph.ox.ac.uk> wrote:
>
> Hi All
>
> I have a database which is listed in my iidatabase catalog, but it isn’t on the disk system. There is no trace of this database whatsoever under any location.
>
> I could remove it from the catalogs using an sql iidbdb +Y connection.

Right.

> But I was wondering if it was possible to copy the aaaaaaaa.ext from another database , edit it to reflect the database of interest, rebuild a stub config file from that and then hopefully perform the destroydb that we have all come to know and love.

I don't think you can reconstruct an entire .cnf file from an ext file. You can reset the database locations, but
the rest of the cnf file has to be valid. You might be able to copy an existing cnf file AND ext file, and
go from there.

Or, you could do it the easy way with sql +Y iidbdb...

>
> I ask this as I’m vaguely sure I saw something somewhere that suggested that it was possible to rebuild/edit a config file using the ..ext file.

It used to be an alterdb comment, but I think that got changed to an ii_sync_config() builtin DB procedure.
ii_sync_config(database='dbname', mode=mode, operation='operation')
operation of interest would be 'sync_extents' and possibly 'sync_consistent'
mode appears to be 'run' or 'report'
I'd guess that the sync-config can be run in an iidbdb session but I've never tried it, use at your own risk!

Karl

BREAKFAST.COM Halted... Cereal Port Not Responding.

devel / comp.databases.ingres / Re: [Info-ingres] The database that isn't there

Subject	Author
Re: [Info-ingres] The database that isn't there	Karl Schendel