SEO

#1 (**permalink**) 04-19-2008, 08: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

sending to informix-list

#2 (**permalink**) 04-19-2008, 08:23 PM

Brian Minnick wrote:
> This message is in MIME format. Since your mail reader does not

Naughty.... Don't make me unleash the clown on you.... *stern look*

> onmode -s brings the server to single user mode and all that you
> asked for.

It does not allow access to the database to manipulate data and schema. It
only allows you to administer the engine spaces, configuration and state.

[Oh, and Mark, I suggested this admin mode a few days ago. Clearly grate
minds think alike ;-]

> 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.

IDS does since approx 7.2x - you can change tables to raw and back to
standard. IDS does not have the other table modes of XPS but they hardly
seem relevant to transactional applications.

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