RE: Whatcha' wanta have?????

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

This is a multi-part message in MIME format.

------=_NextPart_000_0126_01C3F24B.1503B7A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Onmode -s impacts the entire server. An instance may contain many
databases. I don't want to take them all out of service to perform
maintenance on one of them.

-----Original Message-----
From: owner-informix-list@iiug.org [mailto

wner-informix-list@iiug.org]
On Behalf Of Brian Minnick
Sent: Friday, February 13, 2004 3:34 PM
To: 'mkdenham@comcast.net'; Informix List
Subject: RE: Whatcha' wanta have?????

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_000_0126_01C3F24B.1503B7A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html xmlns

=3D"urn:schemas-microsoft-com

ffice

ffice" =
xmlns:w=3D"urn:schemas-microsoft-com

ffice:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 10">
<meta name=3DOriginator content=3D"Microsoft Word 10">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C3F24B.14B2B170">
<title>RE: Whatcha' wanta have?????</title>
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o

oNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w

ocumentKind>DocumentEmail</w

ocumentKind>
<w:EnvelopeVis/>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:1627421319 -2147483648 8 0 66047 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;
text-underline:single;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type

ersonal-reply;
mso-style-noshow:yes;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;
font-family:Arial;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:navy;}
span.SpellE
{mso-style-name:"";
mso-spl-e:yes;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dblue style=3D'tab-interval:.5in'>

<div class=3DSection1>

Onmode</fo=
nt> –s impacts the entire server. An instance may contain =
many
databases. I don’t want to take them all out of service to perform
maintenance on one of them.<o

></o

>

<o

> </o

>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0in 0in =
0in 4.0pt'>

-----Original Message----- 
From: =
owner-informix-list@iiug.org
[mailto

wner-informix-list@iiug.org] On
Behalf Of Brian Minnick 
Sent: Friday, February =
13, 2004
3:34 PM 
To: =
'mkdenham@comcast.net';
Informix List 
Subject: RE: Whatcha' =
wanta
have?????

<o

> </o

>

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

></o

>

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

></o

>

-----Original
Message----- 
From: Mark Denham [<a
href=3D"mailto:mkdenham@comcast.net">mailto:mkdenh am@comcast.net</a>]</sp=
an>
 
Sent: Friday, February =
13, 2004
3:17 PM 
To: Informix =
List 
Subject: FW: Whatcha' =
wanta
have????? <o

></o

>

<o

> </o

>

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

></o

>

sending
to informix-list <o

></o

>

</div>

</div>

</body>

</html>

------=_NextPart_000_0126_01C3F24B.1503B7A0--

sending to informix-list

sending to informix-list

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