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

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

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

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.snarked.org!border2.nntp.dca1.giganews.com!nntp.giganews.com!buffer2.nntp.dca1.giganews.com!buffer1.nntp.dca1.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 29 Sep 2021 09:38:03 -0500
From: martin.b...@ndph.ox.ac.uk (Martin Bowes)
To: Karl Schendel <schendel@kbcomputer.com>,
"info-ingres@lists.planetingres.org" <info-ingres@lists.planetingres.org>
Date: Wed, 29 Sep 2021 14:36:38 +0000
References: <e784c0760f0342d2899dc962d2d1b711@ndph.ox.ac.uk>
<0B1C0DCD-50A9-4A83-8EA4-BC256471EE60@kbcomputer.com>
In-Reply-To: <0B1C0DCD-50A9-4A83-8EA4-BC256471EE60@kbcomputer.com>
Content-Language: en-US
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64
MIME-Version: 1.0
X-WatchGuard-AntiVirus: part scanned. clean action=allow
Subject: Re: [Info-ingres] The database that isn't there
X-BeenThere: info-ingres@lists.planetingres.org
X-Mailman-Version: 2.1.12
Precedence: list
List-Id: <info-ingres.lists.planetingres.org>
List-Unsubscribe: <https://lists.planetingres.org/mailman/options/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=unsubscribe>
List-Archive: <https://lists.planetingres.org/pipermail/info-ingres/>
List-Post: <mailto:info-ingres@lists.planetingres.org>
List-Help: <mailto:info-ingres-request@lists.planetingres.org?subject=help>
List-Subscribe: <https://lists.planetingres.org/mailman/listinfo/info-ingres>,
<mailto:info-ingres-request@lists.planetingres.org?subject=subscribe>
Newsgroups: comp.databases.ingres
Message-ID: <mailman.91.1632926200.1681.info-ingres@lists.planetingres.org>
Lines: 32
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-t5cmsCga+xB+4bUG12luzRSVSDBw76MgM/x/1JPeSE2FkSCaRFcnp35CnseX+NiFKbdujSi6XE+Pkka!IoKpm7yYDo0vNLuFAHogbaGJcsGfDqElRUC9gcj6l5TjC727Tw/U02b16xPONU5Fa/3+gg22OOH+!aWDugdDVQHXNEjKijU2oaA==
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 4648

by: Martin Bowes - Wed, 29 Sep 2021 14:36 UTC

Hi Karl,
Sql +Y it is then.
Thanks.
Marty
-----Original Message-----
From: Karl Schendel <schendel@kbcomputer.com>
Sent: 29 September 2021 15:30
To: info-ingres@lists.planetingres.org
Cc: Martin Bowes <martin.bowes@ndph.ox.ac.uk>
Subject: Re: [Info-ingres] The database that isn't there

> 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

You have a tendency to feel you are superior to most computers.

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

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

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