[prev in list] [next in list] [prev in thread] [next in thread]
List: aix-l
Subject: Re: Informix
From: "Ousterhout, Darryl" <D.Ousterhout () LABSAFETY ! COM>
Date: 2010-02-23 13:55:26
Message-ID: 332CD46A0C1F6E40BAE99F59528CF1C016A775C479 () PREXMB02 ! campus ! grainger ! com
[Download RAW message or body]
Great, thanks for the information Jerry. I'll take a look at what they have to \
offer.
Regards,
Darryl Ousterhout
Unix Systems Administrator
Lab Safety Supply | PO Box 1368 | Janesville, WI 53547-1368
Direct: 608.757.4954
Email: d.ousterhout@labsafety.com<mailto:d.ousterhout@labsafety.com>
________________________________
From: IBM AIX Discussion List [mailto:aix-l@Princeton.EDU] On Behalf Of Gerald \
Gelaude
Sent: Monday, February 22, 2010 3:41 PM
To: aix-l@Princeton.EDU
Subject: Re: Informix
Darryl,
I have been an admin on PICK/D3 systems and if Informix does their database like \
PICK/ D3 did in older versions, you could be looking at a virtual environment. Break \
the virtual disk space and you will have to completely rebuild the disk space in the \
same format as a core configuration file looked at. The following are my suggestions \
on how to proceed.
Look at the following site and join the International Informix Users Group. Give as \
many details as you prudently can without disclosing confidential information and my \
guess is that you will find the advice that you need.
http://www.iiug.org
1. Gather all pertinent information (version level of Informix) and the version and \
point level of AIX and also the server and card microcode levels. 2. If there is a \
VAR somewhere in the chain consult them even if the company has to cough up a \
consulting fee. In addition IBM most likely will have a professional services person \
(costly but better than failure) to help you resolve your issues. Good Luck
Jerry
After taking a brief glance at the following Red Book and searching on the term \
virtual, there are numerous entries referring to Virtual Processors, Virtual tables \
and Virtual Memory.
http://www.iiug.org/library/ids_11/technical/sg247465.pdf
--- On Fri, 2/19/10, Ousterhout, Darryl <D.Ousterhout@LABSAFETY.COM> wrote:
From: Ousterhout, Darryl <D.Ousterhout@LABSAFETY.COM>
Subject: Informix
To: aix-l@Princeton.EDU
Date: Friday, February 19, 2010, 8:00 AM
Admins,
I know this may be a little off subject, but I just inherited some P55's in Mexico \
that run Informix. The disk layout makes me want to cry. IFXVG is spanned over \
internal SCSI (striped and mirrored) and external SAN in increments of 4.5GB LV 's on \
25 - 33GB LUNs. The total amount of storage is around 1 TB and the database is about \
100GB. Apparently Informix considers disk as RAW even in a VG with LV 's, which is \
what I have to work with. Do any of you guys run Informix, and if so, can you point \
me to some "Best Disk Layout Practices" information?
Thanks in advance,
Darryl Ousterhout
Unix Systems Administrator
Lab Safety Supply | PO Box 1368 | Janesville , WI 53547-1368
Direct: 608.757.4954
Email: d.ousterhout@labsafety.com</mc/compose?to=d.ousterhout@labsafety.com>
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:st1="urn:schemas-microsoft-com:office:smarttags" \
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
_filtered #yiv603403575 {margin:1.0in 1.25in 1.0in 1.25in;}
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.emailstyle171
{font-family:Arial;
color:windowtext;}
span.emailstyle181
{font-family:Arial;
color:navy;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:1345664761;
mso-list-template-ids:1617720678;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link="#000000" vlink="#000000">
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Great, thanks for the information Jerry. \
I’ll take a look at what they have to offer.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Regards,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><st1:PersonName w:st="on"><font size=2 color=navy
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Darryl
Ousterhout</span></font></st1:PersonName><font color=navy><span
style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Unix Systems Administrator</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=navy face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:navy'>Lab Safety Supply | <st1:address \
w:st="on"><st1:Street w:st="on">PO Box</st1:Street> 1368</st1:address> | <st1:place \
w:st="on"><st1:City w:st="on">Janesville</st1:City>, <st1:State \
w:st="on">WI</st1:State> <st1:PostalCode \
w:st="on">53547-1368</st1:PostalCode></st1:place></span></font><font color=navy><span \
style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=navy face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:navy'>Direct: 608.757.4954</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=1 color=navy face=Arial><span style='font-size:
7.5pt;font-family:Arial;color:navy'>Email: </span></font><font color=navy><span
style='color:navy'><a href="mailto:d.ousterhout@labsafety.com"><font size=1
color=black face=Arial><span style='font-size:7.5pt;font-family:Arial;
color:black'>d.ousterhout@labsafety.com</span></font></a></span></font><o:p></o:p></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> <st1:PersonName
w:st="on">IBM AIX Discussion List</st1:PersonName> [mailto:aix-l@Princeton.EDU]
<b><span style='font-weight:bold'>On Behalf Of </span></b>Gerald Gelaude<br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, February 22, 2010
3:41 PM<br>
<b><span style='font-weight:bold'>To:</span></b> aix-l@Princeton.EDU<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: \
Informix</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Darryl,<br>
I have been an admin on PICK/D3 systems and if Informix does their
database like PICK/ D3 did in older versions, you could be looking at a
virtual environment. Break the virtual disk space and you will have to
completely rebuild the disk space in the same format as a core configuration
file looked at. The following are my suggestions on how to proceed.<br>
<br>
Look at the following site and join the International Informix Users
Group. Give as many details as you prudently can without disclosing
confidential information and my guess is that you will find the advice that
you need.<br>
<br>
http://www.iiug.org<o:p></o:p></span></font></p>
<ol start=1 type=1>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Gather all pertinent information (version level
of Informix) and the version and point level of AIX and also the server
and card microcode levels.<o:p></o:p></span></font></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:
auto;mso-list:l0 level1 lfo1'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>If there is a VAR somewhere in the chain
consult them even if the company has to cough up a consulting fee.
In addition IBM most likely will have a professional services person
(costly but better than failure) to help you resolve your issues. \
<o:p></o:p></span></font></li> </ol>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Good Luck<br>
Jerry<br>
<br>
After taking a brief glance at the following Red Book and searching on the
term virtual, there are numerous entries referring to Virtual Processors,
Virtual tables and Virtual Memory.<br>
<br>
http://www.iiug.org/library/ids_11/technical/sg247465.pdf<br>
<br>
--- On <b><span style='font-weight:bold'>Fri, 2/19/10, Ousterhout, Darryl <i><span
style='font-style:italic'><D.Ousterhout@LABSAFETY.COM></span></i></span></b>
wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
From: Ousterhout, Darryl <D.Ousterhout@LABSAFETY.COM><br>
Subject: Informix<br>
To: aix-l@Princeton.EDU<br>
Date: Friday, February 19, 2010, 8:00 AM<o:p></o:p></span></font></p>
<div id=yiv603403575>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>A</span></font><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>dmins,</span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span \
style='font-size:10.0pt;font-family:Arial'> </span></font><o:p></o:p></p> <p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font \
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>I know this may \
be a little off subject, but I just inherited some P55’s in <st1:country-region \
w:st="on"><st1:place w:st="on">Mexico</st1:place></st1:country-region> that run \
Informix. The disk layout makes me want to cry. IFXVG is spanned over internal SCSI \
(striped and mirrored) <b><i><span style='font-weight:bold; \
font-style:italic'>and</span></i></b> external SAN in increments of 4.5GB <st1:City \
w:st="on"><st1:place w:st="on">LV</st1:place></st1:City> ’s on 25 – 33GB \
LUNs. The total amount of storage is around 1 TB and the database is about 100GB. \
Apparently Informix considers disk as RAW even in a VG with <st1:City \
w:st="on"><st1:place w:st="on">LV</st1:place></st1:City> ’s, which is what I \
have to work with. Do any of you guys run Informix, and if so, can you point me to \
some “Best Disk Layout Practices” information? \
</span></font><o:p></o:p></p> <p class=MsoNormal \
style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font size=2 \
face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thanks in
advance,</span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span \
style='font-size:10.0pt;font-family:Arial'> </span></font><o:p></o:p></p> <p \
class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><st1:PersonName
w:st="on"><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'>Darryl Ousterhout</span></font></st1:PersonName><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Unix
Systems Administrator</span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 face=Arial><span style='font-size:7.5pt;font-family:Arial'>Lab Safety
Supply | <st1:address w:st="on"><st1:Street w:st="on">PO Box</st1:Street>
1368</st1:address> | <st1:place w:st="on"><st1:City \
w:st="on">Janesville</st1:City> , <st1:State w:st="on">WI</st1:State> \
<st1:PostalCode w:st="on">53547-1368</st1:PostalCode></st1:place></span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 face=Arial><span \
style='font-size:7.5pt;font-family:Arial'>Direct: 608.757.4954</span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 face=Arial><span style='font-size:7.5pt;font-family:Arial'>Email: \
</span></font><a href="/mc/compose?to=d.ousterhout@labsafety.com" target="_blank"
ymailto="mailto:d.ousterhout@labsafety.com"><u><font size=1 color=black
face=Arial><span style='font-size:7.5pt;font-family:Arial;color:black'>d.ousterhout@labsafety.com</span></font></u></a><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span \
style='font-size:12.0pt'> <o:p></o:p></span></font></p> </div>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic