RE: Whatcha' wanta have?????

#1 (**permalink**) 04-19-2008, 09:23 PM

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>

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 [<A HREF="mailto:mkdenham@comcast.net">mailto:mkdenham @comcast.net</A>]
 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


</BODY>
</HTML>
------_=_NextPart_001_01C3F270.AF8CE010--
sending to informix-list

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode