RE: How to tell the logging mode of a DB
If an interactive method will suffice (the process need not be automated),
then you can just execute onmonitor and choose Logical logs-->Databases
Kevin
----------
From: ralphhalter@my-dejanews.com[SMTP:ralphhalter@my-dejanews.com]
Sent: Friday, July 17, 1998 5:23 AM
To: informix-list@iiug.org
Subject: Re: How to tell the logging mode of a DB
In article <35aee327.6033475@news>,
blkstar@singnet.com.sg (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.
>
> Thanx
> Standard Disclaimer
>
$ dbaccess sysmaster -
Database selected.
> select * from sysdatabases where name="stores7";
name stores7
partnum 5242882
owner informix
created 02/02/1998
is_logging 0
is_buff_log 0
is_ansi 0
is_nls 1
flags 16
1 row(s) retrieved.
>
Cheers.
Ralph.
-----== Posted via Deja News, The Leader in Internet Discussion
==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member
Forum