This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C3F270.AF8CE010
Content-Type: text/plain;
charset="iso-8859-1"
onmode -s brings the server to single user mode and all that you asked for.
I know you can create raw tables in XPS that are non-logged and bypasses all
the overhead and locking logic and will be recorded in systables. It would
be nice to have that option in IDS.
-----Original Message-----
From: Mark Denham [mailto:mkdenham@comcast.net]
Sent: Friday, February 13, 2004 3:17 PM
To: Informix List
Subject: FW: Whatcha' wanta have?????
1) An 'admin' mode for a database whereby user activity is suspended but
the administrator still has the ability to manipulate the database;
alternatively a means of taking an individual database offline [kicks
off all users, stops user reconnects, allows admin access] without
having to take down the entire server.
2) A configurable and transparent [to the users] update statistics
thread that uses 'idle' time to regenerate statistics.
sending to informix-list
------_=_NextPart_001_01C3F270.AF8CE010
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: Whatcha' wanta have?????</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>onmode -s brings the server to single user mode and all that you asked for.</FONT>
</P>
<P><FONT SIZE=2>I know you can create raw tables in XPS that are non-logged and bypasses all</FONT>
<BR><FONT SIZE=2>the overhead and locking logic and will be recorded in systables. It would</FONT>
<BR><FONT SIZE=2>be nice to have that option in IDS.</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Mark Denham [<A HREF="mailto:mkdenham@comcast.net">mailto:mkdenham @comcast.net</A>]</FONT>
<BR><FONT SIZE=2>Sent: Friday, February 13, 2004 3:17 PM</FONT>
<BR><FONT SIZE=2>To: Informix List</FONT>
<BR><FONT SIZE=2>Subject: FW: Whatcha' wanta have?????</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>1) An 'admin' mode for a database whereby user activity is suspended but</FONT>
<BR><FONT SIZE=2>the administrator still has the ability to manipulate the database;</FONT>
<BR><FONT SIZE=2>alternatively a means of taking an individual database offline [kicks</FONT>
<BR><FONT SIZE=2>off all users, stops user reconnects, allows admin access] without</FONT>
<BR><FONT SIZE=2>having to take down the entire server.</FONT>
<BR><FONT SIZE=2>2) A configurable and transparent [to the users] update statistics</FONT>
<BR><FONT SIZE=2>thread that uses 'idle' time to regenerate statistics.</FONT>
</P>
<P><FONT SIZE=2>sending to informix-list</FONT>
</P>
</BODY>
</HTML>
------_=_NextPart_001_01C3F270.AF8CE010--
sending to informix-list
sending to informix-list