determine current transaction buffering mode?
Hi everyone. Is there are sure way to determine the CURRENT buffering mode of
a IDS 7.4 database? Using onstat -l or perhaps onminitor?
Thanks, Will
Hi , You can see database buffering mode using onmonitor. onmonitor , Status, Databases. To change Db status, you need to have dba privilege (user informix) Regards, Nilesh
Run the following script will list all database and their logging mode
dbaccess sysmaster -<<END
select * from sysdatabases order by name;END
OUTPUT of script
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Database selected.
name stores_demo
partnum 1048799
owner jmiller
created 02/07/2008
is_logging 1
is_buff_log 0
is_ansi 0
is_nls 0
flags -12287
=
"WILL LANDSTROM" =
<willlandstrom@ya =
hoo.com> =
To
Sent by: ids@iiug.org =
ids-bounces@iiug. =
cc
org =
Subj=
ect
determine current transaction =
02/06/2008 11:12 buffering mode? [11220] =
AM =
=
=
Please respond to =
ids@iiug.org =
=
=
Hi everyone. Is there are sure way to determine the CURRENT buffering m=
ode
of
a IDS 7.4 database? Using onstat -l or perhaps onminitor?
Thanks, Will
***********************************************************************=
********
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!!
=