[Info-ingres] Checking logging status of a session

[Laframboise, André (BAC/LAC)]

Turning off logging should be grounds for dismissal ......

BTW: Logging to a Canadian, involves cutting down trees ..... :)


André Laframboise

Conseiller Principal Base de Données, Direction générale de la gestion de l'information et Technologie de l'information
Bibliothèque et Archives Canada / Gouvernement du Canada
andre.laframboise at canada.ca / Tél. : 613-298-1346

Senior Database Advisor, Information Management and Information Technology Branch
Library and Archives Canada / Government of Canada
andre.laframboise at canada.ca / Tel: 613-298-1346

-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of Roy Hann
Sent: Tuesday, August 4, 2020 9:52 AM
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Checking logging status of a session

Steve wrote:

> How can I check the logging status of the current session? I thought I 
> might be able to call dbmsinfo, but I don't see an option for logging.

Logging is one of those terms (like "key") that is so overloaded with meanings that I could lead you seriously astray if I just assume I know what logging is of interest.

If you mean transaction logging: Ingres just does it. You can (if you are very bold or very careful) turn it off, but you can't turn it off by accident. Running with transaction logging turned off is potentially a catastrophe waiting to happen. If you think it's not turned on you should probably shut Ingres down till you find out who did it and send them for re-education.

If you mean journaling: HELP TABLE will tell you if a specific table is journalled. All tables are created with journalling on by default unless that default has been changed. The default can be examined (and
changed) using CBF. Sessions cannot control whether their activity is journalled; it is system-wide behaviour.

If you mean SC930/session activity logging: I don't think there is a way to ask the session. You can take a look in the configured logging location (ingprenv II_SC930_LOC if you're using Ingres 9/10.x) to see if there is an appropriately named file with a recent/changing timestamp.

But perhaps you mean another kind of logging...

Roy


_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres