Re: How to tell the logging mode of a DB
BlackStar wrote:
>
> Is there an easy way to tell which logging mode a DB is in ~ whether
> NO LOGGING, UNBUFFERED LOGGING, BUFFERED LOGGING, or ANSI LOGGING.
Several. In onmonitor status(if informix)/databases show log status
as N/U/B/A respectively. From the sysmaster database:
select name, is_logging, is_buff_log, is_ansi
from sysdatabases
where name = "mydatabase";
Get utils2_ak from the IIUG Software Repository and compile listdb7.ec
which reports this info and much more.
Art S. Kagel