I'm struggling a bit with Ingres 9.1.1 - specifically, I hear that
Ingres journals by default, and I can't turn this off.

CREATE TABLE ... WITH NO JOURNALING

DBD::Ingres::db do failed: E_US07D7 CREATE TABLE: 'no' is either an
invalid option or the syntax of
the WITH subclause is invalid.
The valid keywords for this type of subclause are:
[NO]DUPLICATES, [NO]JOURNALING, [NO]COMPRESSION.

I even tried NOJOURNALING, but I get the same error.

Does anyone understand what is going on...?

Thanks in anticipation
Lee

Try "CREATE TABLE ... WITH NOJOURNALING" - no space after NO.


--
Bodo

WITH NOJOURNALING should work. Can you give the full CREATE TABLE
statement?

On Oct 18, 2011, at 11:12 AM, Lee wrote:

Try one word, NOJOURNALING.

And yes, Ingres wants just one ell.

Karl

Hi Lee,

The default journaling status has been set to ON since 2.0 (IIRC). This can be altered via the configuration parameter 'default_journaling'. Simply go into CBF, access the DBMS server configuration, scroll down the list to default_journaling and hit the edit key...this will toggle the value to OFF. If you make the change then don't forget to restart the server.

I would suggest that you are better off leaving it as ON.

Martin Bowes

-----Original Message-----
From: Lee [mailto:leegee (AT) gmail (DOT) com]
Sent: 18 October 2011 16:13
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Ingres 9.1.1 - create table...with no journaling

I'm struggling a bit with Ingres 9.1.1 - specifically, I hear that
Ingres journals by default, and I can't turn this off.

CREATE TABLE ... WITH NO JOURNALING

DBD::Ingres::db do failed: E_US07D7 CREATE TABLE: 'no' is either an
invalid option or the syntax of
the WITH subclause is invalid.
The valid keywords for this type of subclause are:
[NO]DUPLICATES, [NO]JOURNALING, [NO]COMPRESSION.

I even tried NOJOURNALING, but I get the same error.

Does anyone understand what is going on...?

Thanks in anticipation
Lee
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

Wednesday, October 19, 2011, 8:34:39 AM, you wrote:

It pains me to disagree with someone of your advanced years, but I
would argue the opposite. At the very least I would say you need to
think about it.

It makes sense to default journaling ON when you create a new
database, but once you are in production almost all the tables you
create will be scratch/temporary tables that don't deserve to be
journaled.

Not that there's much cost to journaling...

Roy

--
UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.

Oh and thanks for the suggestion I was 90! BTW the card had hugs and kisses on it ... but who wrote 'yick'? I bet it was Magda! That's the sort of thing we 90 year olds remember!

It never hurts to think!

A little knowledge can be dangerous...but an absence of it can be fatal.

In my lengthy experience there is almost no such thing as a finished database...some bastard programmer is always adding in new stuff that they never tell you about. They never consider journaling or database recovery. Damn young Turks!

My approach is to leave default journaling ON. That way I can recover the database and all those critically important tables that they never told me about. Then I monitor the crap out of it to see how bad the result is. The plus side is that I occassionally get to yell at programmers...yelling at kids is something us old guys like.

I also like to crush their egos, tell them to pull their trousers up and poison their damn dogs!

Marty

Journling is useful if you want to see what was in a dropped temporary
table for debugging purposes, using auditdb.

weasel wrote:

It used to be that you couldn't auditdb a non-existent (e.g. dropped)
table. I shall have to try this out as it would be convenient
sometimes--though possibly confusing at other times! :-)

--
Roy

UK Ingres User Association Conference 2012 will be on Tuesday June 19 2012.
*NOTE THE CHANGED DATE* See www.uk-iua.org.uk

Hi ,

Yes me also
Default settings have sense !

regards.


--
magxa01