RetroBBS - comp.databases.ingres - Re: How to recreate iidbdb?

Re: How to recreate iidbdb?

<e162313e-613d-4986-8533-49ebaaff4d9en@googlegroups.com>

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

copy link Newsgroups: comp.databases.ingres

X-Received: by 2002:a05:620a:13cf:b0:6b5:ed16:fc69 with SMTP id g15-20020a05620a13cf00b006b5ed16fc69mr15716032qkl.416.1658899936132;
Tue, 26 Jul 2022 22:32:16 -0700 (PDT)
X-Received: by 2002:a05:6214:cae:b0:472:faac:6694 with SMTP id
s14-20020a0562140cae00b00472faac6694mr18062539qvs.128.1658899935897; Tue, 26
Jul 2022 22:32:15 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ingres
Date: Tue, 26 Jul 2022 22:32:15 -0700 (PDT)
In-Reply-To: <3621F2A3.BF138F28@aigf.sncf.fr>#1/1>
Injection-Info: google-groups.googlegroups.com; posting-host=59.154.83.10; posting-account=yp7j2goAAAAA-Z8S8RaGYYecWJkthAkM
NNTP-Posting-Host: 59.154.83.10
References: <361DF328.DFA6BD5B@mcd.ru> <361E1D10.BBACDDA0@mcd.ru> <3621F2A3.BF138F28@aigf.sncf.fr>#1/1>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <e162313e-613d-4986-8533-49ebaaff4d9en@googlegroups.com>
Subject: Re: How to recreate iidbdb?
From: wobble7@hotmail.com (Colin Hay)
Injection-Date: Wed, 27 Jul 2022 05:32:16 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 3160

by: Colin Hay - Wed, 27 Jul 2022 05:32 UTC

On Monday, 12 October 1998 at 17:00:00 UTC+10, Bernard Royet wrote:
> Hi Nick.
> You must delete the directory iidbdb.
> It's the only thing for Ingres to say if iidbdb exists or not.
> Regards
> Dobrovolski Nick wrote:
> > Hi Bernard,
> >
> > Yes, I've tried to leave the directory itself on the position and delete all
> > files in it. But again recieved the following message from createdb:
> >
> > E_DM0124 Database already exists.
> >
> > Maybe you have any other advices?
> >
> > Thanks,
> > Nick
> >
> > Bernard Royet wrote:
> >
> > > You don't need to destroy the iidbdb database.
> > > If you want to try, just delete all the file under
> > > II_DATABASE/ingres/data/default/iidbdb and the directory iidbdb.
> > > After you can launch the createdb -S iidbdb.
> > > And if you want to recover all the databases you have, use rollforwardb to
> > > recover iidbdb.
> > >
> > > Dobrovolski Nick wrote:
> > >
> > > > Hi all,
> > > >
> > > > What should I do if there is a need to destroy and then create an iidbdb
> > > > database? I've read that while creating the iidbdb one should use -S
> > > > flag. OK. But how can I destroy it? Destroydb refuses to do this.
> > > >
> > > > For example the disk with iidbdb data, journal, dump and checkpoint
> > > > catalogs has crashed (let's imagine that they all are on the same
> > > > physical disk). I've tried to emulate the situation and moved all these
> > > > catalogs to another place. Then I've tried to create an iidbdb. There
> > > > was an error saying that iidbdb is already exists. Stopping and
> > > > restarting Ingres hesn't helped. What should I do in this situation?
> > > >
> > > > Thanks in advance,
> > > > Nick
> > >
> > > --
> > > Bernard Royet (bernar...@sncf.fr)
> > > SNCF AIGF-EM (French Railways)
> --
> Bernard Royet (bernar...@sncf.fr)
> SNCF AIGF-EM (French Railways)

You also need to delete the iidbdb database from the CKP, JNL, DMP and WRK folders for you to be able to recreate it

Re: How to recreate iidbdb?

<tbqrmk$r6u$1@gioia.aioe.org>

copy mid

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

copy link Newsgroups: comp.databases.ingres

Path: i2pn2.org!i2pn.org!aioe.org!ow2HZ3WUoSa7bUAoHqrJ8A.user.46.165.242.75.POSTED!not-for-mail
From: specially@processed.almost.meat (Roy Hann)
Newsgroups: comp.databases.ingres
Subject: Re: How to recreate iidbdb?
Date: Wed, 27 Jul 2022 08:06:44 -0000 (UTC)
Organization: Aioe.org NNTP Server
Message-ID: <tbqrmk$r6u$1@gioia.aioe.org>
References: <361DF328.DFA6BD5B@mcd.ru> <361E1D10.BBACDDA0@mcd.ru> <3621F2A3.BF138F28@aigf.sncf.fr>#1/1> <e162313e-613d-4986-8533-49ebaaff4d9en@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Injection-Info: gioia.aioe.org; logging-data="27870"; posting-host="ow2HZ3WUoSa7bUAoHqrJ8A.user.gioia.aioe.org"; mail-complaints-to="abuse@aioe.org";
User-Agent: XPN/1.2.6 (Street Spirit ; Windows)
X-Notice: Filtered by postfilter v. 0.9.2

by: Roy Hann - Wed, 27 Jul 2022 08:06 UTC

Colin Hay wrote:

> On Monday, 12 October 1998 at 17:00:00 UTC+10, Bernard Royet wrote:
>> Hi Nick.
>> You must delete the directory iidbdb.
>> It's the only thing for Ingres to say if iidbdb exists or not.
>> Regards
>> Dobrovolski

[snip]

> You also need to delete the iidbdb database from the CKP, JNL, DMP and WRK folders for you to be able to recreate it

If you'd waited just another year that could've been a quarter-century
anniversary posting. :-)

Roy

This dungeon is owned and operated by Frobozz Magic Co., Ltd.

devel / comp.databases.ingres / Re: How to recreate iidbdb?

Subject	Author
Re: How to recreate iidbdb?	Colin Hay
Re: How to recreate iidbdb?	Roy Hann