<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<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:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Helv;
panose-1:2 11 6 4 2 2 2 3 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@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:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link="#0563C1" vlink="#954F72">
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hi Richard,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>It’s a good idea to log a
support call to Actian. It will be helpful to know the answers to these questions:<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Errors in usermod log?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Any sudden outages in that
period? <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Have you reviewed errlog.log?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Review dmfrcp.log for
information about automatic recovery after sudden outage.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Does the table have compression
enabled?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>MVC enabled for the database?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Suggest run auditdb DBNAME –table=XXXXX.
Look for inserts/updates hitting this range of values.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Do you still have a copy of the
checkpoint and journals for the period before the maintenance and after the
corruption?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>You will be able to extract a
copy of the table and indexes for review.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Hopefully all tables are journaled.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Paul<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt;color:#1F497D'>&<br>
Shift Seven Solutions<br>
</span><span lang=EN-US style='font-size:10.0pt;color:#1F497D'>www.shift7solutions.com.au<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> info-ingres-bounces@lists.planetingres.org
[mailto:info-ingres-bounces@lists.planetingres.org] <b>On Behalf Of </b>Zinndorf,
Richard<br>
<b>Sent:</b> Tuesday, 6 March 2018 8:30 PM<br>
<b>To:</b> Info-ingres@lists.planetingres.org<br>
<b>Subject:</b> [Info-ingres] B-Tree corrupt<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=DE>Hello, <o:p></o:p></span></p>
<p class=MsoNormal><span lang=DE><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>a customer had the following problem with
II 10.2.0 (a64.lnx/100) 15031:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>“</span><span lang=EN-US style='font-size:
10.0pt;font-family:"Arial","sans-serif"'>the table xxxxxx seems to have been
corrupted (especially the btree on field group_code)</span><span lang=EN-US
style='font-size:10.0pt'> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:10.0pt'><br>
</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>data
could be retrieved with following query </span><span lang=EN-US
style='font-size:10.0pt'><br>
</span><i><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>
select * from xxxxxx where group_code</span></i><b><i><span
lang=EN-US style='font-size:18.0pt;font-family:"Arial","sans-serif"'> > </span></i></b><i><span
lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'> 5093690
</span></i><span lang=EN-US style='font-size:10.0pt'><br>
</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
but it was not possible to access them directly with the individual values
</span><span lang=EN-US style='font-size:10.0pt'> </span><span
lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
</span><span lang=EN-US style='font-size:10.0pt'> </span><i><span
lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
select * from xxxxxx where
group_code </span></i><i><span lang=EN-US style='font-size:13.5pt;
font-family:"Arial","sans-serif"'>= </span></i><i><span lang=EN-US
style='font-size:10.0pt;font-family:"Arial","sans-serif"'>5093691 <br>
or select * from xxxxxx where group_code </span></i><i><span
lang=EN-US style='font-size:13.5pt;font-family:"Arial","sans-serif"'>= </span></i><i><span
lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'> 5093692</span></i><span
lang=EN-US style='font-size:10.0pt'> <br>
</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
For those which were before group-code 5093691 the following query
was working fine </span><span lang=EN-US style='font-size:10.0pt'><br>
</span><i><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
select * from xxxxxx where
group_code = 5093690 </span></i><span lang=EN-US style='font-size:
10.0pt'><br>
</span><span lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
After recreation of the table with copydb the application is working fine
again ..</span><span lang=EN-US style='font-size:10.0pt'> </span><span
lang=EN-US>”<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>The problem occurred last Monday. The day
before the following maintenance tasks had been performed:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=DE>usermod db<o:p></o:p></span></p>
<p class=MsoNormal><span lang=DE>optimizedb -zk -uuser db<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>sysmod db<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Does anyone have an idea </span><span
lang=EN-US style='font-size:10.0pt;font-family:"Arial","sans-serif"'>how it is
possible and how to avoid such issue?</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>I would be grateful for any hint..<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=DE>Mit freundlichen Grüßen / Regards<o:p></o:p></span></p>
<p class=MsoNormal><span lang=DE style='font-size:10.0pt;font-family:"Helv","sans-serif";
color:black'>RICHARD ZINNDORF<br>
</span><span lang=DE style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>DXC Technology</span><span lang=DE style='font-size:10.0pt;
font-family:"Helv","sans-serif";color:black'><br>
<br>
Neustadter Str. 62, 68309 Mannheim, Germany<br>
Enhanced Technical Support MSS | p: +49.621.7001.0635 | f: +49.621.7001.6262 |
m: +49.173.340.2127 | </span><span lang=EN-US style='font-size:10.0pt;
font-family:"Helv","sans-serif";color:black'><a href="mailto:rzinndorf@csc.com"><span
lang=DE>rzinndorf@csc.com</span></a></span><span lang=DE style='font-size:10.0pt;
font-family:"Helv","sans-serif";color:black'> | <a href="http://www.csc.com/de">www.csc.com/de</a>
<br>
</span><u><span lang=DE style='font-size:10.0pt;font-family:"Helv","sans-serif";
color:blue'><br>
<a href="http://twitter.com/CSC_DE">Twitter</a></span></u><span lang=DE
style='font-size:10.0pt;font-family:"Helv","sans-serif";color:black'> | <a
href="http://www.slideshare.net/CSCDeutschland">Slideshare</a> <br>
<br>
CSC • This is a PRIVATE message. </span><span lang=EN-US style='font-size:10.0pt;
font-family:"Helv","sans-serif";color:black'>If you are not the intended
recipient, please delete without copying and kindly advise us by e-mail of the
mistake in delivery. NOTE: Regardless of content, this e-mail shall not
operate to bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose • CSC Deutschland GmbH • Registered Office:
Abraham-Lincoln-Park 1, 65189 Wiesbaden, Germany • Board of Directors: Claus
Schünemann (Chairman), Josef Ranner • Chairman of the Supervisory Board:
William L. Deckelman • Registered in Germany: HRB 11307</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=DE style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>
CSC Deutschland GmbH - Registered Office: Hewlett-Packard-Str. 1, 61352 Bad
Homburg, Germany - Board of Directors: Claus Schunemann (Chairman), Josef
Ranner - Chairman of the Supervisory Board: William L. Deckelman - Registered
in Wiesbaden: HRB 11307 <br>
DXC Technology Company -- This message is transmitted to you by or on behalf of
DXC Technology Company or one of its affiliates. It is intended exclusively for
the addressee. The substance of this message, along with any attachments, may
contain proprietary, confidential or privileged information or information that
is otherwise legally exempt from disclosure. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended recipient
of this message, you are not authorized to read, print, retain, copy or
disseminate any part of this message. If you have received this message in
error, please destroy and delete all copies and notify the sender by return
e-mail. Regardless of content, this e-mail shall not operate to bind DXC
Technology Company or any of its affiliates to any order or other contract
unless pursuant to explicit written agreement or government initiative
expressly permitting the use of e-mail for such purpose. <o:p></o:p></span></p>
</div>
</body>
</html>