To find status of transaction logging for a db
Srinivas Jaltaru asked whether stores_demo and other databases are logged by default and how to check. Marcus explained the four logging modes, that the demo script has a -log switch, and that status shows in onmonitor or sysmaster:sysdatabases. Art Kagel said the default is unlogged and gave a query on sysmaster:sysdatabases. Resolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi! I am currently evaluating both "Informix IDS & connect". Created a default database "stores_demo" by running the batch script that came along with the Informix - IDS trail version. stores_demo or any db is created with transaction logging capability by defau;t ? otherwise in Informix, how to find whether a db is configured/created with transaction logging. Thanks in advance. regards, Srinivas Jaltaru
Hi,
You can create a database in four different logging modes. These are: no
logging, unbuffered logging, buffered logging, ansi compatible
The demo database creation has a command line switch -log to enable
logging (unbuffered).
The logging mode can be set in the create database statement (or in
dbaccess as a menu choice).
Create database [name] [in dbspace] [with [[buffered] log] || [log mode
ansi]]
The actual logging status can easily be retrieved in the onmonitor tool
(status->databases). Alternatively, you can query sysmaster database for
the logging status. The information is in sysdatabases.
Marcus
-----Original Message-----
From: SRINIVAS JALTARU [mailto:sjaltaru@gmail.com]
Sent: Thursday, January 10, 2008 1:59 PM
To: ids@iiug.org
Subject: To find status of transaction logging for a db [10886]
Hi!
I am currently evaluating both "Informix IDS & connect".
Created a default database "stores_demo" by running the batch script
that came along with the Informix - IDS trail version.
stores_demo or any db is created with transaction logging capability by
defau;t ? otherwise in Informix, how to find whether a db is
configured/created with transaction logging.
Thanks in advance.
regards,
Srinivas Jaltaru
************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.
See you at the IIUG Informix 2008 Conference
The Power Conference for Informix Professionals
April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
http://www.iiug.org/conf
Registration Now Open!!
Thanks Marcus.
SRINIVAS JALTARU wrote:
> Hi!
>
> I am currently evaluating both "Informix IDS & connect".
>
> Created a default database "stores_demo" by running the batch script that
came
> along with the Informix - IDS trail version.
>
> stores_demo or any db is created with transaction logging capability by
> defau;t ? otherwise in Informix, how to find whether a db is
>
No. The default is unlogged (ie no multi-statement transaction
support). Determine logging status of a database:
SELECT * FROM sysmaster:sysdatabases WHERE name = 'mydatabase';
If you can't run this while connected to your database that's a good
sign it's not logged. But you can connect to sysmaster and run it anyway.
Art S. Kagel
Oninit
> configured/created with transaction logging.
>
> Thanks in advance.
>
> regards,
> Srinivas Jaltaru
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
> See you at the IIUG Informix 2008 Conference
> The Power Conference for Informix Professionals
> April 27 - 30, 2008 Marriott Overland Park (Kansas City), Kansas
> http://www.iiug.org/conf
> Registration Now Open!!
>
>