To:
info-ingres@lists.planetingres.org (
info-ingres@lists.planetingres.org)
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@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@canada.ca / Tel: 613-298-1346
-----Original Message-----
From:
info-ingres-bounces@lists.planetingres.org <
info-ingres-bounces@lists.planetingres.org> On Behalf Of Roy Hann
Sent: Tuesday, August 4, 2020 9:52 AM
To:
info-ingres@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@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)